Exam 5: Access: Maintaining a Database

Figure 3-3 In the type of relationship between the Recruiter and Client tables illustrated in the accompanying figure, the infinity symbol indicates that one recruiter is related to _________________________ clients.

Figure 3-1 To move to the first record using the form shown in the accompanying figure, click the ____ button on the Navigation bar.

When a database is damaged, you must return the database to a correct state. This process is called ____.

When an update query is created, a(n)_________________________ row displays in the design grid.

To add a field to a table structure, click the row selector for the field that will follow the new field, and then press the INSERT key to insert a blank row.

When the Recruiter table is related to the Client table, it is possible to view the clients of a given recruiter when you are viewing the datasheet for the Recruiter table. The clients for the recruiter will appear below the recruiter in a subdatasheet .

To filter records using complex criteria, click the ____ button on the Home tab and then click Advanced Filter/Sort on the menu that appears.

To use Filter By Form to filter records, click the ____ button on the Home tab and then click Filter By Form.

When you use Advanced Filter/Sort to filter records using complex criteria, create the filter and then click the ____ button on the Home tab to view the results.

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.

To resize a column in a datasheet, you can double-click the right boundary selector of the field to be resized or you can right-click the field name and then click ____.

A secondary key is a field in one table whose values are required to match the primary key of another table.

If you plan to move your data to SQL Server at a later date, do not use multivalued fields.

To include totals and other statistics at the bottom of a datasheet, click the ____ button on the Home tab to include the Total row in the datasheet.

To check for dependent objects, select the object that you want to check, click Database Tools on the Ribbon, and then click the ____ button on the Database Tools tab.

To delete a table or other object, right-click the object and then click ____ on the shortcut menu.

To delete a field in a table, the table must be opened in ____________________ view.

To close a database without exiting Access, click the Office Button and then click ____ on the Office Button menu.

A change in outside regulations could cause changes to the structure of a table.