Exam 1: Access 2019

What Access tool should you use if the path to the back-end database changes and you need to reconnect the front-end and back-end databases?

Each item on a form is called a _____.

The _____ property determines whether users can add or edit the list of items in a lookup field.

What are you doing when you enter data into a subdatasheet?

The Crosstab Query Wizard asks you to select fields for the _____, column headings, and values.

Use the New (blank) record button to move the focus to the first record in a table.

When you import data from Excel, you can create a new table or add the records to an existing table.

To move a field in Query Design view, you drag the field by its field selector .

Marie wants to move and format the report controls in the Page Footer section. To work with all the controls at the same time, she selects the controls, clicks the Size/Space button on the Arrange tab, and then clicks _____.

A relational database can best be described as a collection of related _____ designed to minimize redundant data.

You use the Header button to add a title to a report in Report Design view.

You can drag a report from the Navigation Pane to an [Add New] button to add the report to the navigation form in Form Layout view.

To add, delete, or change fields in a query, you use Query Design view.

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

The Performance Analyzer recommends how you can improve database performance.

A join line is also called a _____ line.

To back up a database, you use the _____ command.

Which of the following is a difference between Table Design view and Table Datasheet view?

Standard modules contain _____.

In a datasheet, what do you click to select a record for deletion?