Question 1

The Validation Rule and _____ properties help prevent users from entering unreasonable data in the database.

Accepted Answer

A)  Validation Text 
B)  Format 
C)  Caption 
D)  Validation Error 
A)  Validation Text 
B)  Format 
C)  Caption 
D)  Validation Error

Question 2

How do you enter a value in a lookup field in Table Datasheet view?

Accepted Answer

A)  Click the arrow in the column heading, and then click an option. 
B)  Press an arrow key 
C)  Click the Lookup arrow on the Home tab. 
D)  Click the arrow in the field, and then click an item on the list. 
A)  Click the arrow in the column heading, and then click an option. 
B)  Press an arrow key 
C)  Click the Lookup arrow on the Home tab. 
D)  Click the arrow in the field, and then click an item on the list.

Question 3

Which of the following could you use as a criterion in a Number field? Select all the options that apply.

Accepted Answer

A)  >0 
B)   
A)  >0 
B)

Question 4

Use a Long Text field when you need to store more than 256 characters in a field, such as for comments, reviews, or notes.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following statements apply to Long Text fields? Select all the options that apply.

Accepted Answer

A)  Set the Append Only property to let users add but not change data in a Long Text field. 
B)  Use Long Text fields when you need to store more than 256 characters in a field. 
C)  Set the Indexed property of Long Text fields to Yes because they are often used for sorting. 
D)  Fields that store comments, reviews, or notes are good candidates for Long Text fields. 
A)  Set the Append Only property to let users add but not change data in a Long Text field. 
B)  Use Long Text fields when you need to store more than 256 characters in a field. 
C)  Set the Indexed property of Long Text fields to Yes because they are often used for sorting. 
D)  Fields that store comments, reviews, or notes are good candidates for Long Text fields.

Question 6

The Recordset Type property determines whether Access locks or allows updates to records displayed by a query.

Accepted Answer

A) True 
 B)False

Question 7

You use the _____ to create a query that finds records in one table that do not have related records in another table.

Accepted Answer

A)  Find Duplicates Query Wizard 
B)  Find Unmatched Query Wizard 
C)  Crosstab Query Wizard 
D)  Select Orphans Query Wizard 
A)  Find Duplicates Query Wizard 
B)  Find Unmatched Query Wizard 
C)  Crosstab Query Wizard 
D)  Select Orphans Query Wizard

Question 8

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 9

For a field that contains more than 256 characters of comments or notes, use the _____ data type.

Accepted Answer

A)  Short Text 
B)  Lookup 
C)  Long Text 
D)  Hyperlink 
A)  Short Text 
B)  Lookup 
C)  Long Text 
D)  Hyperlink

Question 10

The _____ is the wildcard character that stands for any single character in criteria.

Accepted Answer

A)  question mark (?) 
B)  asterisk (*) 
C)  quotation mark (") 
D)  exclamation mark (!) 
A)  question mark (?) 
B)  asterisk (*) 
C)  quotation mark (") 
D)  exclamation mark (!)

Question 11

To use HTML tags to format text in a text box, first set the Text Format property of the text box to _____.

Accepted Answer

A)  RTF 
B)  HTML 
C)  Plain Text 
D)  Enhanced Text 
A)  RTF 
B)  HTML 
C)  Plain Text 
D)  Enhanced Text

Question 12

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 13

To change the _____ displayed in a query datasheet, you modify the field's Caption property in Query Design view.

Accepted Answer

A)  record number 
B)  field description 
C)  field name 
D)  criterion 
A)  record number 
B)  field description 
C)  field name 
D)  criterion

Question 14

You use the Explanation property to display a message when a user tries to enter data that break the validation rule.

Accepted Answer

A) True 
 B)False

Question 15

A parameter query displays a dialog box that prompts you for field criteria.

Accepted Answer

A) True 
 B)False

Question 16

You can freeze one or more fields in a datasheet so they remain visible at all times.

Accepted Answer

A) True 
 B)False

Question 17

To display field values as Currency or Percent values, use the Data Type box in Table Datasheet view.

Accepted Answer

False - Fo

Question 18

When you double-click a field in a field list in Query Design view, you _____.

Accepted Answer

A)  add the field to the query design grid 
B)  delete the field from the query 
C)  sort the query based on that field 
D)  set the field as the primary key 
A)  add the field to the query design grid 
B)  delete the field from the query 
C)  sort the query based on that field 
D)  set the field as the primary key

Question 19

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

Accepted Answer

A)  Input Mask 
B)  Format 
C)  Visual Guide 
D)  Caption 
A)  Input Mask 
B)  Format 
C)  Visual Guide 
D)  Caption

Question 20

A common place to use the Input Mask property is for a FirstName field.

Accepted Answer

A) True 
 B)False

The Validation Rule and _____ properties help prevent users from entering unreasonable data in the database.

How do you enter a value in a lookup field in Table Datasheet view?

Which of the following could you use as a criterion in a Number field? Select all the options that apply.

Use a Long Text field when you need to store more than 256 characters in a field, such as for comments, reviews, or notes.

Which of the following statements apply to Long Text fields? Select all the options that apply.

The Recordset Type property determines whether Access locks or allows updates to records displayed by a query.

You use the _____ to create a query that finds records in one table that do not have related records in another table.

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

For a field that contains more than 256 characters of comments or notes, use the _____ data type.

The _____ is the wildcard character that stands for any single character in criteria.

To use HTML tags to format text in a text box, first set the Text Format property of the text box to _____.

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

To change the _____ displayed in a query datasheet, you modify the field's Caption property in Query Design view.

You use the Explanation property to display a message when a user tries to enter data that break the validation rule.

A parameter query displays a dialog box that prompts you for field criteria.

You can freeze one or more fields in a datasheet so they remain visible at all times.

To display field values as Currency or Percent values, use the Data Type box in Table Datasheet view.

When you double-click a field in a field list in Query Design view, you _____.

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

A common place to use the Input Mask property is for a FirstName field.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters

Exam 5: Generating Reports From Multiple Worksheets and Workbooks

The Validation Rule and _____ properties help prevent users from entering unreasonable data in the database.

How do you enter a value in a lookup field in Table Datasheet view?

Which of the following could you use as a criterion in a Number field? Select all the options that apply.

Use a Long Text field when you need to store more than 256 characters in a field, such as for comments, reviews, or notes.

Which of the following statements apply to Long Text fields? Select all the options that apply.

The Recordset Type property determines whether Access locks or allows updates to records displayed by a query.

You use the _____ to create a query that finds records in one table that do not have related records in another table.

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

For a field that contains more than 256 characters of comments or notes, use the _____ data type.

The _____ is the wildcard character that stands for any single character in criteria.

To use HTML tags to format text in a text box, first set the Text Format property of the text box to _____.

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

To change the _____ displayed in a query datasheet, you modify the field's Caption property in Query Design view.

You use the Explanation property to display a message when a user tries to enter data that break the validation rule.

A parameter query displays a dialog box that prompts you for field criteria.

You can freeze one or more fields in a datasheet so they remain visible at all times.

To display field values as Currency or Percent values, use the Data Type box in Table Datasheet view.

When you double-click a field in a field list in Query Design view, you _____.

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

A common place to use the Input Mask property is for a FirstName field.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters