Exam 1: Access-2019

Which Access tool studies the structure and size of a database and recommends how to improve its speed?

What is the most efficient way to navigate to the last record in a table containing 100 records?

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 _____.

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

One way to _____ a macro is to single step through the macro.

When you click the Delete button in the Query Type group, Access adds the Update row to the query design grid.

Which of the following file formats can you import into Access?

Unsecure databases automatically enable all content, so they do not present the Enable Content message when they open. box.

A _____ is a grid that displays fields as columns and records as rows.

A style is a predefined format such as a set of fonts, colors, and alignment, that you can apply to reports and forms.

Which of the following statements creates a function named Bonus with an argument named Salary?

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

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

When you _____ a macro, you determine why it is not running correctly.

If you want to export records to another Access database, create a Top Values query.

Which control provides consistent descriptive text as you navigate from record to record in a form?

Tab order refers to the order you added tabbed pages to a tab control.

In large datasheets, you can ____ certain fields so that they remain on the screen at all times.

_____ passwords are longer than eight characters and use the entire keyboard, including uppercase and lowercase letters, numbers, and symbols.

To move a field in Table Datasheet view, you select the column and then _____.