Question 1

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

Accepted Answer

The answer of A(n) ____________________ is a special kind of...

Question 2

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.

Accepted Answer

A)  Format 
B)  Layout 
C)  Home 
D)  Data

Question 3

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 ____.

Accepted Answer

A)  field selector 
B)  database selector 
C)  row selector 
D)  datasheet selector

Question 4

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

Accepted Answer

A)  Simple Query menu 
B)  New Query dialog box 
C)  Simple Query gallery 
D)  New Query Datasheet

Question 5

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

Accepted Answer

A)  the selected column 
B)  a block 
C)  the entire database 
D)  the entire field

Question 6

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

Accepted Answer

A)  All Programs 
B)  Microsoft Programs 
C)  Open Database 
D)  Navigation Pane

Question 7

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

Accepted Answer

A)  the button goes dim 
B)  the Set Database Password dialog box opens 
C)  you will receive an error message 
D)  you will be given a chance to open the database in Exclusive mode

Question 8

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

Accepted Answer

The answer of Describe the differences between the three action...

Question 9

Match between columns
                        Premises: Wording that is used in VBA

Accepted Answer

The Answer of syntax and period (.) and comment and is...

Question 10

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

Accepted Answer

The answer of A(n) ____________________ displays a message box for...

Question 11

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 ____.

Accepted Answer

A)  viruses cannot infect macros 
B)  macros cannot be disabled 
C)  macros automate repetitive tasks, such as running queries 
D)  links to the database records make the macro query run faster

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The primary objects comprising a database are ____.

Accepted Answer

A)  tables, indexes, and forms 
B)  forms, charts, and reports 
C)  tables, keys, and reports 
D)  tables, forms, and reports

Question 14

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.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A)  Or 
B)  And 
C)  Plus 
D)  Either

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)  define locks on the ribbon 
B)  define locks on the user 
C)  restrict the Ribbon pane 
D)  restrict the Ribbon tabs

Question 18

Match between columns
                        Premises: Used to personalize a splash screen.

Accepted Answer

The Answer of AutoExec macro and lower-level navigation form and is...

Question 19

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

Accepted Answer

A)  Database 
B)  Open 
C)  Open Database Mode 
D)  Open Database

Question 20

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

Accepted Answer

A) True 
 B)False

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.

Identify the letter of the choice that best matches the phrase or definition.

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

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 ____.

Identify the letter of the choice that best matches the phrase or definition.

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

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