Exam 1: Access 2019

To delete the Discount column from the query grid in Query Design view, click the Discount field in the field list and then press DEL.

You can display page numbers on a report in a "Page 1 of 2" format.

To add a background image to a report in Report Layout view, you use the _____ button.

You can recover a forgotten database password by opening the database in Exclusive mode.

When you remove a control layout from a report, Access _____.

Which of the following statements creates a function named Bonus with an argument named Salary?

Which of the following Access options provides a way to set security, macro, and other privacy settings?

You use the Explanation property to display a message when a user tries to enter data that break the validation rule.

After running a Delete query, you cannot _____.

The On Current event of a form is triggered when you navigate through records.

What should you do when you are finished working with a database?

When you add a new field to a form, two controls are usually created: a(n) caption and a text box.

The Database Documenter provides step-by-step help for using an Access database.

The Alternate Background Color command changes the background color of alternate records in a selected section.

You can use the _____ to apply the same formatting to multiple controls in a report.

The _____ property indicates which field serves the link between the main form and subform.

If you want to manage lists of data about customers and the products they order, use _____ software.

In Report Layout view, you can edit data but not labels.

When working in Table Datasheet view, which button on the Table Tools Fields tab can you use to change the expression in a calculated field?

If you create a blank form, you must set the _____ property to display data on the form.