Exam 1: Access 2019

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

Tyler created a table with an AutoNumber primary key field, and then entered 10 records in alphabetic order by the values in the LastName field. When he closes and then reopens the table, how are the records ordered?

Andrew wants to create a query that prompts users to enter a state name to display only records for that state. What type of query should he create?

Each item on a form is called a _____.

If a field named Price displays values with three decimal places, what should you do to display the values accurately?

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

If you want to find records in the table on the "one" side of a one-to-many relationship that do not have related records in the "many" side, which join do you use?

To align the edges of multiple controls in Form Design view, you use the Align button on the _____ tab.

You use Query Design view to add _____ to determine which records are shown in the resulting datasheet.

An aggregate function is _____.

You reference a submacro in a macro list using the command Submacro().

To create a function in a standard module, what button do you select on the Create tab?

When you select a control on a form or report, the large handle in the control's upper-left corner is its _____.

Which of the following form controls would you use to display a border around other controls?

When you create a table with a Make-Table query, you can store the new table _____.

When you enter a record in a table, you are working in navigation mode.

The text you specify for the Application Title property appears in the title bar instead of the database filename.

You can create a comment by starting the statement with _____.

The outer join is the default join operation in Access.

An action query adds, changes, or deletes multiple table records at one time.