Exam 1: Microsoft Access Basics

A(n) ____________________ is a special kind of form that has both a main form control and subform controls automatically built in.

Click a control to select it, and then use the options in the Text Formatting group on the ____ tab to change the text's font, size, and style.

FIGURE AC 1-1 Referring to Figure AC 1-1 above, if you sorted the database on Last Name, you would be sorting on a ____.

FIGURE AC 3-1 To access the dialog box shown in Figure AC 3-1 above, you first have to access the ____.

The message " Block cipher is incompatible with row level locking and so row level locking will be ignored" ensures that ____ will be encrypted.

To start Access, click the Start button on the taskbar, click ____, click Microsoft Office, and then click Microsoft Access 2010.

If you click the Encrypt with Password button and the database is not opened in the Exclusive mode, ____.

Describe the differences between the three action queries that may be used to make changes to the records in a table.

A(n) ____________________ displays a message box for you to enter parameter data each time you run the query.

Case AC 11-1 The Accounting department manually runs queries every Monday morning to verify the reconciliation of salesperson salary. They have asked the Information Technology (IT) department for some assistance in saving time with this repetitive task. Because the report involves salary and private personnel information, security is an utmost priority. As the senior IT database analyst, you volunteer to help out with this request. You explain that you will create a macro as part of the solution because ____.

A control text box displays the actual data from the table.

The primary objects comprising a database are ____.

A workbook is a database object that displays data from one or more tables or queries in a format that has a similar appearance to a paper form.

The ____ operator selects records that match at least one of two or more conditions in a query.

A matching field is also called a mirror field because it is common in both tables involved in the relationship.

To prevent users from changing or modifying the design of your database, you can ____.

You select the database open options using the ____ dialog box.

The input mask places the symbols in the data automatically when it is entered.