Exam 1: Access 2019

Which chart type uses vertical bars to compare values?

_____ is the default name for a new table in an Access database.

The On _____ event occurs when focus moves from one record to another.

When you clone a database, you create a back-end database and a front-end database.

When using the Report Wizard, you can click the Back button to review previous dialog boxes.

A typical report in landscape orientation is 11 inches wide and 8.5 inches tall.

When you import Excel data into an existing Access table, you relate the data to the table.

You can manage default startup options using features in the _____ category of the Access Options dialog box.

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

When you use the Combo Box Wizard, you can have the combo box list the values from a table or query or you can _____.

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

When you delete a control from a form, you also delete the data it contains.

Set the _____ Form startup option to specify which form opens when the database opens.

The _____ button creates a new, blank report in Report Design view.

Where can you set a field's Default Value in Table Design view?

Which Recordset Type property value should you set for a query to prevent data from being updated?

For a Date/Time field, use the _____ property to display the date 1/17/2017 as January 17, 2017.

What is the advantage of grouping controls on a form?

If a field named Price displays values with three decimal places, what should you do to display the values accurately?

Which Access object contains all of the data in the database?