A _____ field is a field that contains more than one value.
A _____ value is a value that Access will display on the screen in a particular field before the user begins adding a record.
Changing a column width changes the _____, or design, of a table.
A _____ key is a field in one table whose values are required to match the primary ke of another table.
To create a simple form, select the table in the Navigation Pane, click Create on the Ribbon and then click the _____ button on the Create tab.
To delete a field from the table, open the table in _____ view, click the row selector for the field to be deleted and then press the DELETE key.
A ____ field allows the user to select from a list of values.
To create a multivalued field, create a _____ field being sure to check the Allow Multiple Values check box.
To create an update query, create a new query and then click the ____ button on the Design tab.
To update records using an update query, enter the field to be updated in the design grid, enter any necessary criterion, and then click the _____ button to update the records.
To specify that entries in the Amount Paid field must be between $0.00 and $100,000.00, enter _____ in the Validation Rule property box.
>=0 and <=100000
To indicate that the only allowable values for the Client Type field are MED, DNT, and LAB, enter _____ in the Validation Rule property box.
=MED or =DNT or =LAB
If the Client Number field in a record always should display the two characters in the client number in uppercase, then the correct format for this field is _____.
To create a Lookup field, select _____ from the menu of available data types.
A(n) _____ query adds, deletes, or changes data in a table.
When an update query is created, a(n) _____ row displays in the design grid.
The property that the value in a foreign key must match another table's primary key is called _____.
When specifying referential integrity, one way to handle deletions is to _____; that is, have Access allow the deletion but then automatically delete any related records in other tables.
cascade the delete
When specifying referential integrity, one way to handle the update of a primary key is to _____; that is, have Access allow the update but then automatically make the corresponding change in any related records in other tables.
cascade the update
To open the Relationships window, click the _____ button on the Database Tools tab.
The infinity symbol indicates that one recruiter is related to _____ clients.
Relationships are created by clicking the _____ check box in the Edit Relationships dialog box.
enforce Referential Integrity
To print a copy of a relationship, click the _____ button.
JSP would like to make sure that if an employee enters the letters co in the State field that it displays in the database as CO. What property do you need to change and what would you enter in the property box?
Because most clients that JSP services are located in Colorado, management would like to minimize any data entry in this field. What property do you need to change and what would you enter in the property box?