Exam 1: Access-2019

In a SaleDate field, you can display dates as 03-Jan-21, for example, by selecting Medium Date as the _____ property.

Before you close a query datasheet, you must save your changes to the data.

To link the data from one table to another in an Access relational database, a(n) ____ must be common to each table.

Table Design view shows how each table relates to other tables in the database.

You can _____ an Access database into a back-end database and front-end database.

To modify the number of items displayed in a combo box, use the List Rows property.

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

To delete a field from a query in Query Design view, click the _____ for the field, and then press DELETE.

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

In Form Layout view, you can edit labels but not data.

The _____ property creates an easy-to-use visual guide to help users enter accurate data.

A chart is a visual representation of numeric data that helps users see comparisons, patterns, and trends in the data.

You click the _____ button to close the Filter by Form grid.

Standard modules contain _____.

The _____ property displays a value that is automatically entered in the field for

Tables contain and execute class modules.

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

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

If you want to find records in the table on the "one" side of a one-to-many relationship that do not have related records in the "many" side, which join do you use?

What is the first step to convert a report's macros to VBA code?