Question 1

Until the correct password is entered, no objects in an encrypted database can be viewed.

Accepted Answer

A) True 
 B)False

Question 2

When you add a control to only one of these sections, the Form Header and Form Footer sections are added to the form ____.

Accepted Answer

A)  individually 
B)  as a pair 
C)  either a. or b. 
D)  neither a. nor b. 
A)  individually 
B)  as a pair 
C)  either a. or b. 
D)  neither a. nor b.

Question 3

Access can only create pie charts.

Accepted Answer

A) True 
 B)False

Question 4

When you select controls in a report, you ____ to select the control.

Accepted Answer

A)  click 
B)  double-click 
C)  right-click 
D)  triple-click 
A)  click 
B)  double-click 
C)  right-click 
D)  triple-click

Question 5

To open a database without the specified startup options, you press and hold the ____.

Accepted Answer

A)  DEL key 
B)  SHIFT key 
C)  CTRL + SHIFT keys 
D)  CTRL + DEL keys 
A)  DEL key 
B)  SHIFT key 
C)  CTRL + SHIFT keys 
D)  CTRL + DEL keys

Question 6

The Form Footer section displays information at the top of each form.

Accepted Answer

A) True 
 B)False

Question 7

When resizing a logo, you place the mouse pointer over the lower-right corner of the logo and then when the mouse pointer becomes a ____ arrow, click and drag down and to the right to increase the size of the logo.

Accepted Answer

A)  double-sided horizontal 
B)  four-sided horizontal 
C)  double-sided diagonal 
D)  four-sided diagonal 
A)  double-sided horizontal 
B)  four-sided horizontal 
C)  double-sided diagonal 
D)  four-sided diagonal

Question 8

When a macro is being ____, all of the selections you make are translated into code.

Accepted Answer

A)  created 
B)  recorded 
C)  compiled 
D)  run 
A)  created 
B)  recorded 
C)  compiled 
D)  run

Question 9

Using the ____ button, you can apply formats to more than one object, such as several labels.

Accepted Answer

A)  Format Painter 
B)  Format 
C)  Painter 
D)  Paint 
A)  Format Painter 
B)  Format 
C)  Painter 
D)  Paint

Question 10

Macro settings can be viewed by clicking the View tab on the Ribbon, and then clicking the Macro Security button in the Code group.

Accepted Answer

A) True 
 B)False

Question 11

To create a chart, you use the ____ Wizard option.

Accepted Answer

A)  Graph 
B)  Report 
C)  Chart 
D)  Presentation 
A)  Graph 
B)  Report 
C)  Chart 
D)  Presentation

Question 12

For an action query, records may not be added correctly if the ____ in the two tables do not match.

Accepted Answer

A)  rows 
B)  columns 
C)  fields 
D)  cells 
A)  rows 
B)  columns 
C)  fields 
D)  cells

Question 13

When you need to create a form to match a paper form that you are already using-or when you need to create a form that doesn't match the appearance of a form that you can create with a form tool or the Form Wizard-you can create a blank form in Query view.

Accepted Answer

A) True 
 B)False

Question 14

Case AC 10-1 John is working on the annual sales report for the Rain Flower Media Corporation. After adding the currency format to the total sales field, John runs the report and directs the results to his monitor. To his dismay, the total sales column displays pound signs (#) instead of his sales total figures. The report is due tomorrow and he desperately needs your assistance. What would you recommend John do to correct the problem with the pound signs(#) displaying?

Accepted Answer

A)  Increase the width of the Sales text box. 
B)  Correct his calculating formula. 
C)  Use a wide-screen monitor. 
D)  Send the report to a printer. 
A)  Increase the width of the Sales text box. 
B)  Correct his calculating formula. 
C)  Use a wide-screen monitor. 
D)  Send the report to a printer.

Question 15

All of these values are also good candidates to use as a table's primary key field EXCEPT ____.

Accepted Answer

A)  student identification numbers 
B)  employee numbers 
C)  Social security numbers 
D)  birthdates 
A)  student identification numbers 
B)  employee numbers 
C)  Social security numbers 
D)  birthdates

Question 16

To edit a macro, you work in the Macro window.

Accepted Answer

A) True 
 B)False

Question 17

A control layout is a "container" that groups together the controls in a form so that you can change them as a group.

Accepted Answer

A) True 
 B)False

Question 18

The main menu appears when the splash screen ____________________.

Accepted Answer

The answer of The main menu appears when the splash...

Question 19

A(n) ____________________ is a database object that displays data from one or more tables or queries in a format that has an appearance similar to a printed report

Accepted Answer

The answer of A(n) ____________________ is a database object that...

Question 20

Case AC 3-2 Eric is learning how to create calculated fields. Eric is typing one of his expressions and notices that Excel only displays the first 20 characters. What can Eric do to display the entire field?

Accepted Answer

A)  Click the empty Field box in the design grid, and then click Zoom on the shortcut menu. 
B)  Click the empty Field box in the design grid, and then click Show All on the Ribbon. 
C)  Either a. or b. 
D)  Neither a. nor b. 
A)  Click the empty Field box in the design grid, and then click Zoom on the shortcut menu. 
B)  Click the empty Field box in the design grid, and then click Show All on the Ribbon. 
C)  Either a. or b. 
D)  Neither a. nor b.

Until the correct password is entered, no objects in an encrypted database can be viewed.

When you add a control to only one of these sections, the Form Header and Form Footer sections are added to the form ____.

Access can only create pie charts.

When you select controls in a report, you ____ to select the control.

To open a database without the specified startup options, you press and hold the ____.

The Form Footer section displays information at the top of each form.

When resizing a logo, you place the mouse pointer over the lower-right corner of the logo and then when the mouse pointer becomes a ____ arrow, click and drag down and to the right to increase the size of the logo.

When a macro is being ____, all of the selections you make are translated into code.

Using the ____ button, you can apply formats to more than one object, such as several labels.

Macro settings can be viewed by clicking the View tab on the Ribbon, and then clicking the Macro Security button in the Code group.

To create a chart, you use the ____ Wizard option.

For an action query, records may not be added correctly if the ____ in the two tables do not match.

When you need to create a form to match a paper form that you are already using-or when you need to create a form that doesn't match the appearance of a form that you can create with a form tool or the Form Wizard-you can create a blank form in Query view.

All of these values are also good candidates to use as a table's primary key field EXCEPT ____.

To edit a macro, you work in the Macro window.

A control layout is a "container" that groups together the controls in a form so that you can change them as a group.

The main menu appears when the splash screen ____________________.

A(n) ____________________ is a database object that displays data from one or more tables or queries in a format that has an appearance similar to a printed report

Case AC 3-2 Eric is learning how to create calculated fields. Eric is typing one of his expressions and notices that Excel only displays the first 20 characters. What can Eric do to display the entire field?

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 1: Microsoft Access Basics

Until the correct password is entered, no objects in an encrypted database can be viewed.

When you add a control to only one of these sections, the Form Header and Form Footer sections are added to the form ____.

Access can only create pie charts.

When you select controls in a report, you ____ to select the control.

To open a database without the specified startup options, you press and hold the ____.

The Form Footer section displays information at the top of each form.

When resizing a logo, you place the mouse pointer over the lower-right corner of the logo and then when the mouse pointer becomes a ____ arrow, click and drag down and to the right to increase the size of the logo.

When a macro is being ____, all of the selections you make are translated into code.

Using the ____ button, you can apply formats to more than one object, such as several labels.

Macro settings can be viewed by clicking the View tab on the Ribbon, and then clicking the Macro Security button in the Code group.

To create a chart, you use the ____ Wizard option.

For an action query, records may not be added correctly if the ____ in the two tables do not match.

When you need to create a form to match a paper form that you are already using-or when you need to create a form that doesn't match the appearance of a form that you can create with a form tool or the Form Wizard-you can create a blank form in Query view.

All of these values are also good candidates to use as a table's primary key field EXCEPT ____.

To edit a macro, you work in the Macro window.

A control layout is a "container" that groups together the controls in a form so that you can change them as a group.

The main menu appears when the splash screen ____________________.

A(n) ____________________ is a database object that displays data from one or more tables or queries in a format that has an appearance similar to a printed report

Case AC 3-2 Eric is learning how to create calculated fields. Eric is typing one of his expressions and notices that Excel only displays the first 20 characters. What can Eric do to display the entire field?

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters