Question 1

A(n) _____ chart typically shows cumulative totals, such as combined sales totals for store locations.

Accepted Answer

A)  pie 
B)  line 
C)  area 
D)  column 
A)  pie 
B)  line 
C)  area 
D)  column

Question 2

Which of the following form controls would you use to display a border around other controls?

Accepted Answer

A)  box 
B)  rectangle 
C)  tab control 
D)  label 
A)  box 
B)  rectangle 
C)  tab control 
D)  label

Question 3

In Report Design view, you remove a control layout from a report using the Control Padding button.

Accepted Answer

A) True 
 B)False

Question 4

What can you add to a macro to test logical conditions and execute statements only if the conditions are true?

Accepted Answer

A)  Submacro program flow 
B)  MessageBox action 
C)  If program flow 
D)  RunCode action 
A)  Submacro program flow 
B)  MessageBox action 
C)  If program flow 
D)  RunCode action

Question 5

A combo box is a combination of a text box and command button.

Accepted Answer

A) True 
 B)False

Question 6

What happens if you display a form in Form Design View, and then click the Visual Basic button on the Database Tools tab?

Accepted Answer

A)  You create a new module for the form. 
B)  Any modules attached to the form begin to run. 
C)  You display the VBA code for the form. 
D)  You add a standard module to the form. 
A)  You create a new module for the form. 
B)  Any modules attached to the form begin to run. 
C)  You display the VBA code for the form. 
D)  You add a standard module to the form.

Question 7

How do you display the results of a query listed in the Navigation Pane?

Accepted Answer

A)  Right-click the query, and then click Design View on the shortcut menu. 
B)  Right-click the query, and then click Run on the shortcut menu. 
C)  Double-click the query. 
D)  Click the query, and then click the Open button in the Navigation Pane. 
A)  Right-click the query, and then click Design View on the shortcut menu. 
B)  Right-click the query, and then click Run on the shortcut menu. 
C)  Double-click the query. 
D)  Click the query, and then click the Open button in the Navigation Pane.

Question 8

Which of the following templates lets you create a database from scratch?

Accepted Answer

A)  Custom desktop database 
B)  Blank desktop database 
C)  Personal database 
D)  Application database 
A)  Custom desktop database 
B)  Blank desktop database 
C)  Personal database 
D)  Application database

Question 9

Which of the following are event procedures you can assign to a report? Select all the options that apply.

Accepted Answer

A)  On Open 
B)  On Close 
C)  On Click 
D)  On Page Break 
A)  On Open 
B)  On Close 
C)  On Click 
D)  On Page Break

Question 10

Which of the following criteria selects records for customers except those who live in New York, even if the City field is blank?

Accepted Answer

A)  Null OR Not "New York" 
B)  Is Not Null OR "New York" 
C)  Not "New York" 
D)  Is Null OR Not "New York" 
A)  Null OR Not "New York" 
B)  Is Not Null OR "New York" 
C)  Not "New York" 
D)  Is Null OR Not "New York"

Question 11

Which of the following features can the Format Painter apply to a label control in Form Layout view? Select all the options that apply.

Accepted Answer

A)  underlining 
B)  text in the label 
C)  outline color and style 
D)  background color 
A)  underlining 
B)  text in the label 
C)  outline color and style 
D)  background color

Question 12

What property would you set for a field with a Yes/No data type that usually stores a Yes value?

Accepted Answer

A)  Field Size 
B)  Default Value 
C)  Caption 
D)  Required 
A)  Field Size 
B)  Default Value 
C)  Caption 
D)  Required

Question 13

If you want users to enter a positive Currency value in a Price field, enter _____ as the validation rule expression.

Accepted Answer

A)   0 
C)  '+ 1 
D)  "Positive" 
A)   0 
C)  '+ 1 
D)  "Positive"

Question 14

When can you rename a table?

Accepted Answer

A)  immediately after you open the table 
B)  after you close the table 
C)  when you open the table in Datasheet view 
D)  when you open the table in Design view 
A)  immediately after you open the table 
B)  after you close the table 
C)  when you open the table in Datasheet view 
D)  when you open the table in Design view

Question 15

The Allow Value List Edits property determines whether users can change the items in a lookup list.

Accepted Answer

A) True 
 B)False

Question 16

If you edit data in the upper half of a split form, you must make the same changes in the lower half.

Accepted Answer

A) True 
 B)False

Question 17

You can trust a database or a folder using the features in the _____ category of the Access Options dialog box.

Accepted Answer

A)  Current Database 
B)  Trust Center 
C)  Client Settings 
D)  General 
A)  Current Database 
B)  Trust Center 
C)  Client Settings 
D)  General

Question 18

In Access macros, you can use conditional expressions in If statements.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following are options you can select in the Top Values list for a query? Select all the options that apply.

Accepted Answer

A)  5 
B)  None 
C)  25% 
D)  All 
A)  5 
B)  None 
C)  25% 
D)  All

Question 20

You can copy and paste any object in Access except for tables.

Accepted Answer

A) True 
 B)False

A(n) _____ chart typically shows cumulative totals, such as combined sales totals for store locations.

Which of the following form controls would you use to display a border around other controls?

In Report Design view, you remove a control layout from a report using the Control Padding button.

What can you add to a macro to test logical conditions and execute statements only if the conditions are true?

A combo box is a combination of a text box and command button.

What happens if you display a form in Form Design View, and then click the Visual Basic button on the Database Tools tab?

How do you display the results of a query listed in the Navigation Pane?

Which of the following templates lets you create a database from scratch?

Which of the following are event procedures you can assign to a report? Select all the options that apply.

Which of the following criteria selects records for customers except those who live in New York, even if the City field is blank?

Which of the following features can the Format Painter apply to a label control in Form Layout view? Select all the options that apply.

What property would you set for a field with a Yes/No data type that usually stores a Yes value?

If you want users to enter a positive Currency value in a Price field, enter _____ as the validation rule expression.

When can you rename a table?

The Allow Value List Edits property determines whether users can change the items in a lookup list.

If you edit data in the upper half of a split form, you must make the same changes in the lower half.

You can trust a database or a folder using the features in the _____ category of the Access Options dialog box.

In Access macros, you can use conditional expressions in If statements.

Which of the following are options you can select in the Top Values list for a query? Select all the options that apply.

You can copy and paste any object in Access except for tables.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters

Exam 8: Access

A(n) _____ chart typically shows cumulative totals, such as combined sales totals for store locations.

Which of the following form controls would you use to display a border around other controls?

In Report Design view, you remove a control layout from a report using the Control Padding button.

What can you add to a macro to test logical conditions and execute statements only if the conditions are true?

A combo box is a combination of a text box and command button.

What happens if you display a form in Form Design View, and then click the Visual Basic button on the Database Tools tab?

How do you display the results of a query listed in the Navigation Pane?

Which of the following templates lets you create a database from scratch?

Which of the following are event procedures you can assign to a report? Select all the options that apply.

Which of the following criteria selects records for customers except those who live in New York, even if the City field is blank?

Which of the following features can the Format Painter apply to a label control in Form Layout view? Select all the options that apply.

What property would you set for a field with a Yes/No data type that usually stores a Yes value?

If you want users to enter a positive Currency value in a Price field, enter _____ as the validation rule expression.

When can you rename a table?

The Allow Value List Edits property determines whether users can change the items in a lookup list.

If you edit data in the upper half of a split form, you must make the same changes in the lower half.

You can trust a database or a folder using the features in the _____ category of the Access Options dialog box.

In Access macros, you can use conditional expressions in If statements.

Which of the following are options you can select in the Top Values list for a query? Select all the options that apply.

You can copy and paste any object in Access except for tables.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters