Exam 1: Access 2019

You can copy and paste any object in Access except for tables.

You use the Insert Rows button on the Query Tools Design tab to _____.

The report's _____ property identifies the table or query that provides the fields and records for a report.

To delete a field from a query in Query Design view, click the _____ for the field, and then press DELETE.

Create a(n) _____ query to change the name of a supervisor in an Employee table.

The _____ property controls how many characters can be entered into the field.

The upper pane of _____ view shows field names and data types.

The purpose of a Delete query is to _____.

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

To create a report in Report Layout view, click the Blank Report button on the Create tab.

In a calculated control, expressions must start with what character?

If the focus in a form moves from left to right and you want the focus to move from top to bottom, change the _____.

What can you add to a query datasheet to display statistics for a group of records?

A(n) _____ chart best illustrates the contribution of three products to total company sales in a year.

Where do you set the Allow Multiple Values property of a field in Table Design view?

A _____ chart typically shows trends over time.

If the _____ property for a form control is set to No, the control cannot have the focus in Form view.

A mail merge combines data from an Access table or form into a Word form letter.

You click the _____ button to execute the selected Access macro.

In a Navigation form, you reorder tabs by dragging them to a new location on the form.