Exam 1: Access 2019

To apply a combination of formatting options to a control in a form or report, use the _____ gallery.

Which of the following formatting changes can you make to a datasheet?

To set a password for a database, you must open the database with Read-Only access.

When you split an Access database, what do you call the database containing all the tables?

The commands and keystrokes a macro performs as it runs are called _____.

Access sets the number of decimal places in a Number field, and you cannot change it.

In Query Design view, you enter parameter criteria within curly brackets, as in {Enter department:}.

OpenForm is an Access macro _____.

Which chart type uses vertical bars to compare values?

What Access tool should you use if the path to the back-end database changes and you need to reconnect the front-end and back-end databases?

In a Date/Time field named HireDate, the validation rule expression >#7/1/21# means _____.

Sorting records in ascending order based on a Short Text field arranges them in alphabetic order from Z to A.

The Import Spreadsheet Wizard helps you import Excel data into Access.

A(n) _____ document contains tags and other instructions that a web browser processes and displays as a webpage.

To navigate to the first record in a form, first switch to Form Design view.

You can copy and paste any object in Access except for tables.

A macro is an Access object that stores Visual Basic for Applications (VBA) programming code.

In a datasheet, what do you click to select a record for deletion?

Which Access feature asks you a series of questions and then creates a report based on your answers?

A field's Required property determines whether users must enter a value in the field.