Exam 1: Access 2019

What happens in a table if you change the font color of the primary key field for the first record to red?

Hiding a column in Table Datasheet view is that same as freezing the column.

Which Short Text field property should you use to indicate users must enter a value in the field?

How can you identify a linked table in a database?

When you export a query as an HTML document, you are exporting the _____.

To add a title to a report in Report Layout view, you click the _____ button on the Design tab.

Mail fields are codes that Word replaces with field values when processing a mail merge.

How do you align the right edges of selected controls in Form Design view?

To remove retired employees from an Employee table, create a(n) _____ query.

An Access chart displays data in rows and columns, similar to a spreadsheet.

Field properties appear on the General tab in the lower half of _____ view.

To close an Access module, you must close the Visual Basic Editor.

If you want to increase the price of products in a particular category by 10%, use a(n) Append query.

You add the Calculation row to the query design grid to specify how you want to group records and perform calculations on them.

A _____ allows you to work with records related to the record in the main form.

You can use the arrow keys to move a selected control in Report Design view.

A common place to use the Input Mask property is for a FirstName field.

To rename a field in Table Datasheet view, you change the text in the _____.

AutoType is a data type that numbers each record automatically.

To query for records with no values in a particular field, use _____ as the criterion.