Create an account
A _____ value is a value that Access will display on the screen in a particular field before the user begins adding a record.
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.
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 _____.
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
Relationships are created by clicking the _____ check box in the Edit Relationships dialog box.
enforce Referential Integrity
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?
Please allow access to your computer’s microphone to use Voice Recording.
Having trouble? Click here for help.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!Reload
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Please upgrade Flash or install Chrome
to use Voice Recording.
For more help, see our troubleshooting page.
Your microphone is muted
For help fixing this issue, see this FAQ.
Star this term
You can study starred terms together