Exam 1: Access 2019

When you use the Or logical operator with query criteria, the number of records returned by the query is _____ the number of records when using the And logical operator with the same criteria.

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

How can you list the records in a query datasheet in A-Z order by CustomerName?

You can create a(n) _____ to let users select a value from a list of possible values.

Amanda is creating a report and wants to include page numbers that appear as Page 1, Page 2, and so on. Which option should she select in the Page Numbers dialog box?

The Performance Analyzer recommends how you can improve database performance.

When you single step a macro, you _____.

A parameter query displays a dialog box that prompts you for field criteria.

If you move the City column in a table datasheet, _____.

Which data type stores only one of two values?

If you want to add records from one table to a backup table, create a(n) Append query.

Hiding a column in Table Datasheet view removes the field from Table Design view.

To learn more about a data type, you can enter the name of the data type in the Tell Me box.

____ makes a duplicate copy of the data in the Access database.

Which of the following report controls can you format in bold?

You can change the margins of a report using the Margins button on the Print Preview tab.

In the _____, Access lists each object in the open database.

Which of the following pages numbers is displayed in the "Page N of M" format?

A _____ is a set of controls grouped together in a form or report so you can manipulate them as a single control.

What happens if you delete a field from a table that contains data?