Exam 1: Microsoft Access Basics

To add a picture to a report, click the Insert ____ button in the Controls group on the Design tab.

As a best practice, you should set the security level in Access to Disable all macros with notification or Disable all macros except digitally signed macros.

When saving a backup database file, the date is added after the filename.

Controls in reports are not grouped in control layouts like they are in forms.

The ____ button starts the Input Mask Wizard dialog box.

The ____ section displays information at the bottom of each form.

Clicking Close Print Preview takes you into ____ view.

Update queries let you change ____________________ values in a table.

To delete a control from a form, click the control to select it, and then press ____________________.

AC Case 12-2 Jennifer has designed a new Salary database. She would like to hide the Navigation pane and the Ribbon. Jennifer also wants to make sure that only authorized users, such as the database manager, can work with tables and other objects in Design view. She asks for your assistance. You suggest Jennifer add ____ options.

You can add new controls to a report by using the tools in the Query group.

Navigation forms in a database typically appear in a linear format.

To remove the password and encryption from a database, you first need to open the database in the Open Read-Only mode.

The ____________________ database template creates a database with an empty table in it.

The Expression Wizard is where you type, or build, an expression.

A(n) ____________________ query makes changes to the records in a table.

A(n) ____________________ allows you to have one or more actions automatically execute when the database is opened.

When you need to sort data first based on the values in one field, and then by the values in a second field, you can set the sort orders for the two fields using the ____ in the design grid.