How can we help?

You can also find more resources in our Help Center.

Microsoft Access Chapter 3 worksheet/study guide

Microsoft Access
STUDY
PLAY
A _____ field is a field that contains more than one value.
multivalued
A _____ value is a value that Access will display on the screen in a particular field before the user begins adding a record.
default
Changing a column width changes the _____, or design, of a table.
layout
A _____ key is a field in one table whose values are required to match the primary ke of another table.
foreign
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.
form
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.
design
A ____ field allows the user to select from a list of values.
lookup
To create a multivalued field, create a _____ field being sure to check the Allow Multiple Values check box.
lookup
To create an update query, create a new query and then click the ____ button on the Design tab.
update
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.
run
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.
lookup wizard
A(n) _____ query adds, deletes, or changes data in a table.
action
When an update query is created, a(n) _____ row displays in the design grid.
update to
The property that the value in a foreign key must match another table's primary key is called _____.
referential integrity
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.
relationships
The infinity symbol indicates that one recruiter is related to _____ clients.
many
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.
relationship report
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?
format, >
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?
default value, CO