Exam 8: Access

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

When editing a record, what key can you use to navigate to the next record?

The Patients table and the Visits table have a one-to-many relationship, with the Patients table being the parent table.Which of the following would you use the Find Unmatched Records Wizard to find?

Which of the following fields are good candidates for a multivalue lookup field? Select all the options that apply.

When you delete a control from a form, you also delete the data it contains.

Which of the following are built-in Access functions? Select all the options that apply.

Unsecure databases automatically enable all content, so they do not present the Enable Content message when they open.box.

If a combo box has two columns of 1.5" each, what should you set as the List Width property to display all of the data in the list?

A front-end database contains _____ to the tables in the back-end database.

A(n) < u>data macro is a collection of actions within a single macro object.

Report Design View gives you full control of all aspects of a report.

What are you changing when you change the background of a report label?

Table Design view shows how each table relates to other tables in the database.

To query for records with no values in a particular field, use _____ as the criterion.

To perform calculations on field values in Table Datasheet view, you click the Totals button in the Records group on the Home tab.

Using an Append query, you can append a Short Text field from one table to a Number field in another table.

Create a Top Values query to find the highest values in set of unsorted records.

In Form Layout view, you can edit labels but not data.

To set the properties for an entire table, open the table's property sheet in Table Design view.

The Caution action displays a warning or informational message.