Exam 1: Access 2019

Before closing a report in Print Preview, you must remove any conditional formatting from the report.

Abby is updating a Jobs database that lists employers and their job openings. She wants to list all employers that have no positions in the Positions table. What type of query can she create?

To apply the last filter you selected to a datasheet, you click the _____ button.

Which dialog box do you use to change the column layout in a report?

To select records in the Sales table that have no related records in the Customers table, create a(n) _____ join.

If you do not enter a Caption property for a field, Access uses the field name to label the field.

When working in the Visual Basic window, you can use the _____ to test an individual line of VBA code.

Access provides four types of action queries: _____, Append, Delete, and Update.

You must use the correct _____, or rules, when creating a VBA statement.

If you set the _____ property for a field that is often used for sorting, you improve database performance.

When you click the Collapse button next to a macro action in Macro Design View, you hide the action's arguments.

Clicking the expand indicator in a datasheet displays related records from other tables in the database.

What happens when you apply a theme to a form?

When you click the Date and Time button on the Design tab in Report Design view, the date appears in the Report Footer section.

The lower pane of a split form displays a(n) datasheet view.

Which of the following file types is the most well suited to exchanging data between programs?

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

Which chart type is used to show the relationship or proportion of parts to a whole using only one data series?

You cannot modify the Field Size property of a Short Text field.

Melissa is working in Report Layout view and wants to change the field values for an Amount column. She wants to display comma separators and two decimal places, but no dollar signs. Which Format property should she select for the Amount field?