Exam 1: Access 2019

You use a subdatasheet to modify a field's properties.

Carrie entered 10/16/21 as the date in a field with the Date/Time data type and the default format. How does Access format the year in the date after Carrie moves to a new field?

You can select a particular form, such as a Navigation form, to display when Access starts.

A(n) _____ is an instruction that initiates each command or keystroke within a macro.

In which object can you rename a field?

Using the Report Wizard, you can select the _____ for the report.

To delete a record in Table Datasheet view, you first click the _____ and then click the Delete button.

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

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

Class modules are stored in an individual form or report.

Query Design view presents the fields you can use for a query in small windows called field _____.

Ben wants to move a label in a report so it appears at the top of each page as a column heading. Where should he move the label?

A validation rule is a list that relates field values to the records that contain those field values.

To resize a control in Report Layout view, you format an edge of the selected control.

To close a report in Print Preview and keep Access running, you _____.

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

Which report section is most commonly used for dates and page numbers?

Which argument of the MessageBox macro action determines the text in the title bar of the message dialog box?

You can create an Access report by selecting fields from one or more tables or _____.

The Validation Rule and _____ properties help prevent users from entering unreasonable data in the database.