Exam 1: Access-2019

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

A _____ query in a real estate database could list property types as row headings, number of bedrooms as column headings, and the count of each property type as values.

Access provides four types of action queries: _____, Append, Delete, and Update.

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

Set the Locked property of a form control to Yes if you want to prevent users from entering data in the control.

To create a banded rows effect in a report, you _____.

For a table, the _____ produces a report listing the field names, property values for each field, and table relationships.

To determine whether a control appears or is hidden on a form, set the _____ property for the control.

When you export a query as an HTML document, you are exporting the _____.

In Report Design view, you can remove a control from a control layout by selecting the control and then _____.

Entering an expression such as =[Price]*[Quantity] in a text box creates a calculated control.

Which action query would you use if you wanted to add records from one table to a backup table?

To enter data in a table, open it in Table Datasheet view.

You set the opening Display Form for a database using the Access Preferences dialog box.

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

Although Access saves the queries you create in Structured Query Language (SQL), you cannot view the SQL code from within Access.

Which Action Catalog category contains the Comment, Group, If, and Submacro components?

To expand an action in a macro, click the action name in the Action Catalog.

How can you quickly add the date and time to a report in Report Design view?

In Form Layout view, what happens when you select a text box and then click the Align Right button on the Home tab?