Question 1

When you create a command button with an embedded macro, you can view the event and the embedded macro using the ____ Sheet.

Accepted Answer

A)  Command 
B)  Macro Embed 
C)  Property 
D)  Event 
A)  Command 
B)  Macro Embed 
C)  Property 
D)  Event

Question 2

Once set, Current Database options cannot be bypassed.

Accepted Answer

A) True 
 B)False

Question 3

To change the style of a selected line, click the ____ Outline button, point to Line Type, and then click one of the line styles.

Accepted Answer

A)  Symbol 
B)  Character 
C)  Shape 
D)  Line 
A)  Symbol 
B)  Character 
C)  Shape 
D)  Line

Question 4

When dragging the header bar, the mouse pointer appears as a(n) ____.

Accepted Answer

A)  crosshair 
B)  ellipse 
C)  lightening bolt 
D)  double-headed arrow 
A)  crosshair 
B)  ellipse 
C)  lightening bolt 
D)  double-headed arrow

Question 5

Match between columns
                        Premises: Uses functions to see trends in data.

Accepted Answer

The Answer of summary report and currency format and chart is...

Question 6

Case AC 10-2 Stella Maroon owns the Stellar boutique in Malibu. Every month she must reconcile her inventory and take note of customer purchasing trends. One of her Paris suppliers is insisting that a blue cashmere shawl is going to be the latest trend over the next three months. Stella has some doubts, and would like to see some additional boutique sales reports to see if her clients are indeed trending towards shawls. She asks if you could assist her in creating these reports. What is a valid option selection for Stella's new report?

Accepted Answer

A)  Stella can only select the Avg function. 
B)  The Min and Max functions cannot be selected simultaneously. 
C)  Stella can select the Avg, Sum, Min and Max functions simultaneously. 
D)  If Stella selects the Avg function, she must also select the Sum function. 
A)  Stella can only select the Avg function. 
B)  The Min and Max functions cannot be selected simultaneously. 
C)  Stella can select the Avg, Sum, Min and Max functions simultaneously. 
D)  If Stella selects the Avg function, she must also select the Sum function.

Question 7

You can use a wildcard character with letters or numbers in any order.

Accepted Answer

A) True 
 B)False

Question 8

You can create a new table in a database by clicking the ____________________ tab on the Ribbon, and then clicking the Table button in the Tables group.

Accepted Answer

The answer of You can create a new table in...

Question 9

You can press the ____ key to accept the text that automatically appears as you type.

Accepted Answer

A)  TAB 
B)  ENTER 
C)  CTRL 
D)  SHIFT 
A)  TAB 
B)  ENTER 
C)  CTRL 
D)  SHIFT

Question 10

You can set lookup properties in the ____ tab in the Field Properties pane.

Accepted Answer

A)  Field 
B)  Lookup 
C)  Modify 
D)  Insert 
A)  Field 
B)  Lookup 
C)  Modify 
D)  Insert

Question 11

Case AC 11-2 Craig has responsibility for updating the frozen food inventory for the Frosty Freeze Snack Shop each night. On Sunday evenings, Craig wants to print five forms displaying weekly summary inventory results that he provides to his five different suppliers and his manager the next morning. He does not want the form to remain open after it is printed. As Shelly is a part-time employee working at the Frosty Freeze Snack Shop to help pay her way through college, Craig asks Shelly if she can write the macro to open and print the report. As Shelly starts writing the macro she decides to include multiple actions starting with the print action. Craig expresses some concern as he recalls from his Advanced Access 2010 class that ____.

Accepted Answer

A)  if he does not have a printer connected to his computer, the macro will not run 
B)  when recording a macro, Access can only support single actions 
C)  if you want to print a report, you will probably want to select an action that first opens the report and then select the action to print the report 
D)  Shelly should first be making the report open in a Read Only mode 
A)  if he does not have a printer connected to his computer, the macro will not run 
B)  when recording a macro, Access can only support single actions 
C)  if you want to print a report, you will probably want to select an action that first opens the report and then select the action to print the report 
D)  Shelly should first be making the report open in a Read Only mode

Question 12

Match between columns
                        Premises: You can change the default font size, color, and style of the title text using the buttons in the Font group on the ____ tab.

Accepted Answer

The Answer of Format and Home and New and Tools is...

Question 13

If a procedure is working correctly, the results of the procedure will show accurate results.

Accepted Answer

A) True 
 B)False

Question 14

Match between columns
                        Premises: To print all records in the form, click the ____ tab, click Print on the navigation bar, and then click Print to open the Print dialog box.

Accepted Answer

The Answer of File and Home and New and Format is...

Question 15

To move a control in Design view, you can select the control, press and hold the ____ key, and then press the arrow keys to move the control right, left, up, or down.

Accepted Answer

A)  CTRL 
B)  TAB 
C)  SHIFT 
D)  ALT 
A)  CTRL 
B)  TAB 
C)  SHIFT 
D)  ALT

Question 16

To create a macro, you open the ____________________ window by clicking the Create tab and then clicking the Macro button in the Macros & Code group.

Accepted Answer

The answer of To create a macro, you open the...

Question 17

Once applied, you cannot remove a password and database encryption.

Accepted Answer

A) True 
 B)False

Question 18

To which of the following items is an input mask commonly applied?

Accepted Answer

A)  last name 
B)  street address 
C)  city 
D)  ZIP code 
A)  last name 
B)  street address 
C)  city 
D)  ZIP code

Question 19

When fields appear in a form, they appear in ____.

Accepted Answer

A)  ascending order 
B)  commands 
C)  controls 
D)  lists 
A)  ascending order 
B)  commands 
C)  controls 
D)  lists

Question 20

To create a parameter query, you enter a "prompt" in the Criteria cell of the desired field.

Accepted Answer

A) True 
 B)False

When you create a command button with an embedded macro, you can view the event and the embedded macro using the ____ Sheet.

Once set, Current Database options cannot be bypassed.

To change the style of a selected line, click the ____ Outline button, point to Line Type, and then click one of the line styles.

When dragging the header bar, the mouse pointer appears as a(n) ____.

You can use a wildcard character with letters or numbers in any order.

You can create a new table in a database by clicking the ____________________ tab on the Ribbon, and then clicking the Table button in the Tables group.

You can press the ____ key to accept the text that automatically appears as you type.

You can set lookup properties in the ____ tab in the Field Properties pane.

If a procedure is working correctly, the results of the procedure will show accurate results.

To move a control in Design view, you can select the control, press and hold the ____ key, and then press the arrow keys to move the control right, left, up, or down.

To create a macro, you open the ____________________ window by clicking the Create tab and then clicking the Macro button in the Macros & Code group.

Once applied, you cannot remove a password and database encryption.

To which of the following items is an input mask commonly applied?

When fields appear in a form, they appear in ____.

To create a parameter query, you enter a "prompt" in the Criteria cell of the desired field.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 1: Microsoft Access Basics

When you create a command button with an embedded macro, you can view the event and the embedded macro using the ____ Sheet.

Once set, Current Database options cannot be bypassed.

To change the style of a selected line, click the ____ Outline button, point to Line Type, and then click one of the line styles.

When dragging the header bar, the mouse pointer appears as a(n) ____.

You can use a wildcard character with letters or numbers in any order.

You can create a new table in a database by clicking the ____________________ tab on the Ribbon, and then clicking the Table button in the Tables group.

You can press the ____ key to accept the text that automatically appears as you type.

You can set lookup properties in the ____ tab in the Field Properties pane.

If a procedure is working correctly, the results of the procedure will show accurate results.

To move a control in Design view, you can select the control, press and hold the ____ key, and then press the arrow keys to move the control right, left, up, or down.

To create a macro, you open the ____________________ window by clicking the Create tab and then clicking the Macro button in the Macros & Code group.

Once applied, you cannot remove a password and database encryption.

To which of the following items is an input mask commonly applied?

When fields appear in a form, they appear in ____.

To create a parameter query, you enter a "prompt" in the Criteria cell of the desired field.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters