Exam 1: Access 2019

You can collapse all actions in a macro to hide its details.

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

You switch to Report Layout view to display the entire report as it will appear when printed.

What would you use to quickly create an Issues table and related forms?

In what part of the Access window do you rename a form?

One reason to split a database is to improve performance .

Trusting a database means to verify the authenticity of a database with a digital signature.

To total the values in a SalesPrice field in Table Datasheet view, you click the Total cell in the SalesPrice column, click the arrow, and then click _____.

You can create a mail merge in Word using name and address data stored in Access.

To remove scroll bars on small forms, set the Scroll Bars property to As Needed.

You can add a Total row to a query datasheet to calculate statistics such as Sum, Average, or Count.

When you add fields to a table in Table Design view, the _____ is optional.

You can create a table in Table Datasheet view or Table Design view.

Suppose you rename a field in Table Design view. What must you do before you can view the data in the table?

What could you do to clarify that the TaxRate field in a report contains percentages?

Class modules are stored in an individual form or report.

Before you can rename a field, you must change its data type.

What could you do to clarify that the MonthlyRent field in a report contains dollar amounts?

A query is a temporary view of the data that is removed when you close the query in Query Design view.

When you _____ a database, you make more storage space available and enhance the performance of the database.