Question 1

You must be in Design view to add controls such as lines, rectangles, and labels to a form.

Accepted Answer

A) True 
 B)False

Question 2

Case AC 9-1 Sandy is the owner of a bakery specializing in healthy baked goods. As a new service for her customers, Sandy has decided to provide a public, interactive customer kiosk within her store that will allow all customers to gain information about her products. Sandy will use an Access database and present various forms on the kiosk window from which customers can select information. Due to your extensive knowledge in Access database form creation, Sandy has asked for your help in developing the forms. As you begin designing Sandy's kiosk forms, what is an initial design feature to consider before deciding on a theme?

Accepted Answer

A)  field organization 
B)  error prevention 
C)  form layout 
D)  all of the above 
A)  field organization 
B)  error prevention 
C)  form layout 
D)  all of the above

Question 3

Match between columns
                        Premises: A complete set of data.

Accepted Answer

The Answer of field value and field selector and field is...

Question 4

Comments in the VBA window appear in ____.

Accepted Answer

A)  yellow 
B)  green 
C)  red 
D)  blue 
A)  yellow 
B)  green 
C)  red 
D)  blue

Question 5

When you want to display more of the open object, you can close the Navigation Pane by clicking the Shutter Bar Open/Close Button at the top of the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 6

The ____ symbol next to a field name in a field list indicates the table's primary key.

Accepted Answer

A)  plus sign 
B)  lock 
C)  number 1 
D)  key 
A)  plus sign 
B)  lock 
C)  number 1 
D)  key

Question 7

In Access, the Object Documenter produces a report of selected objects or every object in a database.

Accepted Answer

A) True 
 B)False

Question 8

When you import data from a Word document, it is usually best to store it in a Word ____.

Accepted Answer

A)  column 
B)  table 
C)  diagram 
D)  chart 
A)  column 
B)  table 
C)  diagram 
D)  chart

Question 9

FIGURE AC 4-1   Referring to Figure AC 4-1 above, to create this type of form, click the More Forms button in the Forms group on the ____ tab.

Accepted Answer

A)  File 
B)  Create 
C)  Home 
D)  Format 
A)  File 
B)  Create 
C)  Home 
D)  Format

Question 10

When creating an AutoExec macro, you add the ____________________ action so you can open a form when the macro runs.

Accepted Answer

The answer of When creating an AutoExec macro, you add...

Question 11

Within the Run Macro dialog box, click the ____ appearing next to the Macro Name text box to provide a list of all the macros in the database.

Accepted Answer

A)  arrow 
B)  open button 
C)  list box 
D)  control field 
A)  arrow 
B)  open button 
C)  list box 
D)  control field

Question 12

If you want to hide the dots and gridlines on your form in Design view, ____-click in the section where they are, and then click Grid from the shortcut menu.

Accepted Answer

A)  left 
B)  right 
C)  double 
D)  triple 
A)  left 
B)  right 
C)  double 
D)  triple

Question 13

Case AC 6-2 Ross is exporting Access data into Word. After the file is exported into Word, what file format will it be in?

Accepted Answer

A)  .doc 
B)  .docx 
C)  .rtf 
D)  .htm 
A)  .doc 
B)  .docx 
C)  .rtf 
D)  .htm

Question 14

Match between columns
                        Premises: A statement that does not perform an action

Accepted Answer

The Answer of comment and variable name and syntax and is...

Question 15

An Access Database backup file uses ____ for the file extension.

Accepted Answer

A)  .accdb 
B)  .bkup 
C)  .adbkf 
D)  .accbk 
A)  .accdb 
B)  .bkup 
C)  .adbkf 
D)  .accbk

Question 16

FIGURE AC 14-11   In Figure 14-11 above, Item 1 points to the tabs that show various parts of the ____.

Accepted Answer

A)  log 
B)  backup file 
C)  database 
D)  database log 
A)  log 
B)  backup file 
C)  database 
D)  database log

Question 17

Match between columns
                        Premises: Appears at the top of each column in a table and contains the field name.

Accepted Answer

The Answer of fields and field selector and field name is...

Question 18

If the Field List pane opens when you change to Layout view, click the Add Existing Fields button in the Tools group on the ____ tab to close it.

Accepted Answer

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

Question 19

When you run a parameter query, it displays a ____.

Accepted Answer

A)  message box 
B)  pop up 
C)  ScreenTip 
D)  new window 
A)  message box 
B)  pop up 
C)  ScreenTip 
D)  new window

Question 20

A record is an incomplete set of data.

Accepted Answer

A) True 
 B)False

You must be in Design view to add controls such as lines, rectangles, and labels to a form.

Comments in the VBA window appear in ____.

When you want to display more of the open object, you can close the Navigation Pane by clicking the Shutter Bar Open/Close Button at the top of the Navigation Pane.

The ____ symbol next to a field name in a field list indicates the table's primary key.

In Access, the Object Documenter produces a report of selected objects or every object in a database.

When you import data from a Word document, it is usually best to store it in a Word ____.

FIGURE AC 4-1 Referring to Figure AC 4-1 above, to create this type of form, click the More Forms button in the Forms group on the ____ tab.

When creating an AutoExec macro, you add the ____________________ action so you can open a form when the macro runs.

Within the Run Macro dialog box, click the ____ appearing next to the Macro Name text box to provide a list of all the macros in the database.

If you want to hide the dots and gridlines on your form in Design view, ____-click in the section where they are, and then click Grid from the shortcut menu.

Case AC 6-2 Ross is exporting Access data into Word. After the file is exported into Word, what file format will it be in?

An Access Database backup file uses ____ for the file extension.

FIGURE AC 14-11 In Figure 14-11 above, Item 1 points to the tabs that show various parts of the ____.

If the Field List pane opens when you change to Layout view, click the Add Existing Fields button in the Tools group on the ____ tab to close it.

When you run a parameter query, it displays a ____.

A record is an incomplete set of data.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 1: Microsoft Access Basics

You must be in Design view to add controls such as lines, rectangles, and labels to a form.

Comments in the VBA window appear in ____.

When you want to display more of the open object, you can close the Navigation Pane by clicking the Shutter Bar Open/Close Button at the top of the Navigation Pane.

The ____ symbol next to a field name in a field list indicates the table's primary key.

In Access, the Object Documenter produces a report of selected objects or every object in a database.

When you import data from a Word document, it is usually best to store it in a Word ____.

FIGURE AC 4-1 Referring to Figure AC 4-1 above, to create this type of form, click the More Forms button in the Forms group on the ____ tab.

When creating an AutoExec macro, you add the ____________________ action so you can open a form when the macro runs.

Within the Run Macro dialog box, click the ____ appearing next to the Macro Name text box to provide a list of all the macros in the database.

If you want to hide the dots and gridlines on your form in Design view, ____-click in the section where they are, and then click Grid from the shortcut menu.

Case AC 6-2 Ross is exporting Access data into Word. After the file is exported into Word, what file format will it be in?

An Access Database backup file uses ____ for the file extension.

FIGURE AC 14-11 In Figure 14-11 above, Item 1 points to the tabs that show various parts of the ____.

If the Field List pane opens when you change to Layout view, click the Add Existing Fields button in the Tools group on the ____ tab to close it.

When you run a parameter query, it displays a ____.

A record is an incomplete set of data.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters