Exam 1: Access 2019

In a database with a Products table and Orders table, you want to see which products have not been ordered. What type of query should you create?

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

Mitch created a form in Form Layout view that arranges controls in rows and columns like a spreadsheet, with labels across the top. This arrangement is called a(n) _____.

How do you add an If statement to a macro in Macro Design view?

To filter for comparative data, use the _____ feature.

A category of data such as a customer's name, city, state, or phone number is called a _____.

Using the Report Wizard, you can select the _____ for the report.

To arrange form controls in a layout of rows and columns like a spreadsheet, select the controls to group together, and then click the _____ button on the Form Layout Tools Arrange tab.

In Access, you create a macro by recording a series of steps you want the macro to perform.

If you _____ in the Form Wizard, you can create a form with a subform.

A new blank desktop database includes one table named Table1.

The Name property for a form determines the text to display in the form's tab.

What data type should you assign to a field that stores postal codes?

The part of an If statement that is evaluated as either true or false is called a(n) _____.

When exporting to XML, Access creates an _____ helper file that contains a description of the data's characteristics.

To remove the navigation bar from a form, set the _____ property to No.

Which argument of the OpenReport macro action determines the report to open?

Which argument of the MessageBox macro action determines the icon in the message dialog box?

In a datasheet, you can find data, but not replace it.

You can _____ an Access database into a back-end database and front-end database.