Exam 1: Access 2019

You typically increase the decimal places from 1 to 2 for a(n) _____ field.

_____ change depending on the macro action you choose.

When you create a form using the Form Wizard, the Record Source property is blank.

A(n) event is a procedure that returns a value.

What are you changing when you change the background of a report label?

To import data from Excel to Access, you would begin by clicking the ____.

An Access template is a diagram showing the structure of a database.

What is the most efficient way to navigate to the last record in a table containing 100 records?

Compared to forms and datasheets, ____ give you more control over how data is arranged when printed.

Which of the following templates lets you create a database from scratch?

What could you use to display the amount of a 25% discount on a form?

What data type should you assign to a CourseHours field that stores the hours required to complete a course?

If you set a database _____, all users must enter that combination of characters before they are allowed to open the database.

What button do you use on the Query Tools Design tab to add a field list to a query?

On a form, text box controls display data from an underlying record source.

The join line between the Appointments and Treatments tables has an arrow pointing to the Treatments table. What join type does this indicate?

Unsecure databases automatically enable all content, so they do not present the Enable Content message when they open. box.

When designing a form for navigational purposes, it's best to set form properties such as Navigation Buttons, Record Selectors, and Control Box to No.

You can trust a database or a folder using the features in the _____ category of the Access Options dialog box.

How is the font set for a table in Table Datasheet view?