Exam 1: Access 2019

A _____ section usually displays the group name and sort field for the group.

If you want to manage lists of data about customers and the products they order, use _____ software.

To add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane.

In Form Design view, you can make design changes while displaying the data.

You can navigate form records using the same keyboard shortcuts as you use to navigate report records.

You use the Find Unmatched Query Wizard to find records in one table that do not have related records in another table.

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

Which view can you use to add a new record to a table?

In Query Design view, the _____ shows you the field names, sort orders, and criteria used with a query.

_____ change depending on the macro action you choose.

Form Layout view provides the most options for creating forms and positioning controls.

In a CSV text file, a comma often separates each field value from another field value.

Brenda wants to contact the 10 clients who have the highest past due amounts. What type of query is the best for providing this information?

If you move a text box in Form Design view, you _____.+

You can import table data from _____.

_____ is the default name for a new table in an Access database.

What can you use to test logical conditions and execute statements only if the conditions are true?

Jocelyn is working with a datasheet that displays client information, including the client's state. She wants to display only clients from Ohio (OH). After clicking the State field, how can she use Filter By Selection to display only clients from Ohio (OH)?

You must specify arguments for each action in a macro.

The goal of building one-to-many relationships between tables is to minimize _____ data.