Exam 1: Access 2019

If you are creating a query using fields from two related tables, the join line Identifies which fields establish a relationship between the tables.

If the Quantity field has "

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

In Query Design view, you enter parameter criteria within curly brackets, as in {Enter department:}.

When you start Access, the first screen that appears is one showing a blank database.

In Report Layout view, you use the Format Painter to change the theme of a report.

Adam is creating a table with an AmtSold field for storing the number of items sold. He should assign the Currency data type to the AmtSold field.

To find employee records that do not contain an entry in the Email field, use the _____ criterion in the Email field.

How can you send an Access object as an email attachment when you are working in an Access database ?

How do you create a macro in Access?

The _____ organizes all the arguments for an action in a rectangle with a gray background.

To create a single-value lookup field in Table Design view, you use the _____ in the Field Properties pane.

A delimited text file such as a CSV file stores one _____ on each line.

You can use a function created in a standard module in any query in the database.

In a macro's conditional expression, you refer to a value of a form control using the following syntax: ____.

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

When using the Chart Wizard, you can drag a Number field to the Data area of a chart to have the wizard automatically _____ the values in the field.

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

The report source is the table or query that contains the fields and records displayed in the report.

Set the Database Title property of a database to change the text displayed in the title bar.