Question 1

To add a label to a splash screen, you use the ____ view within the Design tab.

Accepted Answer

A)  Layout 
B)  Design 
C)  Form 
D)  Datasheet 
A)  Layout 
B)  Design 
C)  Form 
D)  Datasheet A

Question 2

Selecting the Back Up Database option alerts Access that when you click ____, you want to create a backup of the database.

Accepted Answer

A)  Close 
B)  Exit 
C)  Save As 
D)  Save 
A)  Close 
B)  Exit 
C)  Save As 
D)  Save C

Question 3

____ buttons aid in record navigation and record operation.

Accepted Answer

A)  Control 
B)  Combo 
C)  Command 
D)  Calculate 
A)  Control 
B)  Combo 
C)  Command 
D)  Calculate C

Question 4

You can print a datasheet by clicking the File tab, clicking Print in the navigation bar, and then clicking ____ to print the datasheet using the default printer and the default print.

Accepted Answer

A)  Quick Access 
B)  Print Now 
C)  Office Button 
D)  Quick Print 
A)  Quick Access 
B)  Print Now 
C)  Office Button 
D)  Quick Print

Question 5

Which of the following causes a message similar to " Block cipher is incompatible with row level locking and so row level locking will be ignored" ?

Accepted Answer

A)  Encrypting a database with row level locking turned off. 
B)  Encrypting a database with row level locking turned on. 
C)  Encrypting a database with block cipher locking turned off. 
D)  Encrypting a database with block cipher locking turned on. 
A)  Encrypting a database with row level locking turned off. 
B)  Encrypting a database with row level locking turned on. 
C)  Encrypting a database with block cipher locking turned off. 
D)  Encrypting a database with block cipher locking turned on.

Question 6

You can undo changes made with an update action query.

Accepted Answer

A) True 
 B)False

Question 7

Embedded macros have queries that run the macro, such as On Click.

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: Displays the actual information from the table.

Accepted Answer

The Answer of form title and fields and form label is...

Question 9

The data source for a form letter can be a(n) ____.

Accepted Answer

A)  Word document 
B)  Excel workbook 
C)  Access database 
D)  any of the above 
A)  Word document 
B)  Excel workbook 
C)  Access database 
D)  any of the above

Question 10

You can see the position of objects in Design view as you are moving them, and you can position controls precisely by looking at the horizontal and vertical ____ that appear on the top and left sides of the form.

Accepted Answer

A)  grids 
B)  rulers 
C)  guides 
D)  rows 
A)  grids 
B)  rulers 
C)  guides 
D)  rows

Question 11

What steps do you take to add a picture to a report? Name a situation where you would want to add a picture to a report.

Accepted Answer

Steps to add a picture to a report: 
- T

Question 12

Case AC 4-1 Jessica wants to find and replace some data in her database. If Jessica types S in the Find What list box, and then selects the Any Part of Field option in the Match menu, she'll find values that ____.

Accepted Answer

A)  contain the letter S anywhere in the value 
B)  contain only the letter S 
C)  begin with the letter S 
D)  none of the above 
A)  contain the letter S anywhere in the value 
B)  contain only the letter S 
C)  begin with the letter S 
D)  none of the above

Question 13

Case AC 5-2 Eddie is working on a report, and when he switched to Print Preview he received an error message saying that his report contained blank pages. Eddie wants to see the control's width in characters and size the control exactly. This information appears ____.

Accepted Answer

A)  on the status bar 
B)  in the Quick Access Toolbar 
C)  in the Window footer 
D)  in the right-hand navigation pane 
A)  on the status bar 
B)  in the Quick Access Toolbar 
C)  in the Window footer 
D)  in the right-hand navigation pane

Question 14

FIGURE AC 5-1   Referring to the figure above, in this report, ____ appear in controls.

Accepted Answer

A)  the Teacher ID label 
B)  the records shown below the Teacher ID label 
C)  both a. and b. 
D)  neither a. nor b. 
A)  the Teacher ID label 
B)  the records shown below the Teacher ID label 
C)  both a. and b. 
D)  neither a. nor b.

Question 15

The _____________________ field stores unique values for each record in a table.

Accepted Answer

The answer of The _____________________ field stores unique values for...

Question 16

You run a query by right-clicking the query in the Navigation pane.

Accepted Answer

A) True 
 B)False

Question 17

After opening a database, the Navigation Pane opens on the left side of the screen.

Accepted Answer

A) True 
 B)False

Question 18

____________________ are preset designs that include borders, background colors, shading, and graphic effects.

Accepted Answer

The answer of ____________________ are preset designs that include borders,...

Question 19

You can use the Undo button on the Quick Access Toolbar to restore a deleted field value, but deleting a record permanently deletes it from the record source.

Accepted Answer

A) True 
 B)False

Question 20

To select several controls, you press and hold ____________________ and then click on each control you want to select.

Accepted Answer

The answer of To select several controls, you press and...

To add a label to a splash screen, you use the ____ view within the Design tab.

Selecting the Back Up Database option alerts Access that when you click ____, you want to create a backup of the database.

____ buttons aid in record navigation and record operation.

You can print a datasheet by clicking the File tab, clicking Print in the navigation bar, and then clicking ____ to print the datasheet using the default printer and the default print.

Which of the following causes a message similar to " Block cipher is incompatible with row level locking and so row level locking will be ignored" ?

You can undo changes made with an update action query.

Embedded macros have queries that run the macro, such as On Click.

The data source for a form letter can be a(n) ____.

You can see the position of objects in Design view as you are moving them, and you can position controls precisely by looking at the horizontal and vertical ____ that appear on the top and left sides of the form.

What steps do you take to add a picture to a report? Name a situation where you would want to add a picture to a report.

Case AC 4-1 Jessica wants to find and replace some data in her database. If Jessica types S in the Find What list box, and then selects the Any Part of Field option in the Match menu, she'll find values that ____.

Case AC 5-2 Eddie is working on a report, and when he switched to Print Preview he received an error message saying that his report contained blank pages. Eddie wants to see the control's width in characters and size the control exactly. This information appears ____.

FIGURE AC 5-1 Referring to the figure above, in this report, ____ appear in controls.

The _____________________ field stores unique values for each record in a table.

You run a query by right-clicking the query in the Navigation pane.

After opening a database, the Navigation Pane opens on the left side of the screen.

____________________ are preset designs that include borders, background colors, shading, and graphic effects.

You can use the Undo button on the Quick Access Toolbar to restore a deleted field value, but deleting a record permanently deletes it from the record source.

To select several controls, you press and hold ____________________ and then click on each control you want to select.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 1: Microsoft Access Basics

To add a label to a splash screen, you use the ____ view within the Design tab.

Selecting the Back Up Database option alerts Access that when you click ____, you want to create a backup of the database.

____ buttons aid in record navigation and record operation.

You can print a datasheet by clicking the File tab, clicking Print in the navigation bar, and then clicking ____ to print the datasheet using the default printer and the default print.

Which of the following causes a message similar to " Block cipher is incompatible with row level locking and so row level locking will be ignored" ?

You can undo changes made with an update action query.

Embedded macros have queries that run the macro, such as On Click.

The data source for a form letter can be a(n) ____.

You can see the position of objects in Design view as you are moving them, and you can position controls precisely by looking at the horizontal and vertical ____ that appear on the top and left sides of the form.

What steps do you take to add a picture to a report? Name a situation where you would want to add a picture to a report.

Case AC 4-1 Jessica wants to find and replace some data in her database. If Jessica types S in the Find What list box, and then selects the Any Part of Field option in the Match menu, she'll find values that ____.

Case AC 5-2 Eddie is working on a report, and when he switched to Print Preview he received an error message saying that his report contained blank pages. Eddie wants to see the control's width in characters and size the control exactly. This information appears ____.

FIGURE AC 5-1 Referring to the figure above, in this report, ____ appear in controls.

The _____________________ field stores unique values for each record in a table.

You run a query by right-clicking the query in the Navigation pane.

After opening a database, the Navigation Pane opens on the left side of the screen.

____________________ are preset designs that include borders, background colors, shading, and graphic effects.

You can use the Undo button on the Quick Access Toolbar to restore a deleted field value, but deleting a record permanently deletes it from the record source.

To select several controls, you press and hold ____________________ and then click on each control you want to select.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters