Question 1

The _____ property creates an easy-to-use visual guide to help users enter accurate data.

Accepted Answer

A)  Phone Number 
B)  Pattern 
C)  Input Mask 
D)  Default Value 
A)  Phone Number 
B)  Pattern 
C)  Input Mask 
D)  Default Value C

Question 2

In the criterion 8/*/2021,the asterisk (*)is called a wildcard.

Accepted Answer

A) True 
 B)False  True

Question 3

To set the Validation Text property for a table in Table Design view,you use the _____.

Accepted Answer

A)  Validation Text property for any field in the table 
B)  Object dialog box 
C)  Expression dialog box 
D)  property sheet for the table 
A)  Validation Text property for any field in the table 
B)  Object dialog box 
C)  Expression dialog box 
D)  property sheet for the table D

Question 4

Which of the following are settings you specify in the Crosstab row of the query design grid when you create a crosstab query? Select all the options that apply.

Accepted Answer

A)  Row heading 
B)  Value 
C)  Sort order 
D)  Column heading 
A)  Row heading 
B)  Value 
C)  Sort order 
D)  Column heading

Question 5

Dynaset is the default value of the _____ property in a query; it lets you update data in the query recordset.

Accepted Answer

A)  Snapshot 
B)  Recordset Type 
C)  Description 
D)  Caption 
A)  Snapshot 
B)  Recordset Type 
C)  Description 
D)  Caption

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

If you select 25 in the Top Values list,Access displays _____ in the query results.

Accepted Answer

A)  the top 25% of the records 
B)  25 randomly selected records 
C)  25 fields 
D)  the top 25 records 
A)  the top 25% of the records 
B)  25 randomly selected records 
C)  25 fields 
D)  the top 25 records

Question 8

In Query Design view,how can you add a field to the query design grid?

Accepted Answer

A)  Right-click the query design grid,and then click the field's name. 
B)  Double-click the field in the field list. 
C)  Click the field in the field list,and then click the Add to Grid button. 
D)  Double-click the first available field in the query design grid. 
A)  Right-click the query design grid,and then click the field's name. 
B)  Double-click the field in the field list. 
C)  Click the field in the field list,and then click the Add to Grid button. 
D)  Double-click the first available field in the query design grid.

Question 9

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 10

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 11

The only way to create a Crosstab query is to use the Crosstab Query Wizard.

Accepted Answer

A) True 
 B)False

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

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 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

For a Date/Time field,use the _____ property to display the date 1/17/2017 as January 17,2017.

Accepted Answer

A)  Input Mask 
B)  Caption 
C)  Lookup 
D)  Format 
A)  Input Mask 
B)  Caption 
C)  Lookup 
D)  Format

Question 16

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 17

If you do not enter a Caption property for a field,Access uses the field name to label the field.

Accepted Answer

A) True 
 B)False

Question 18

In Query Design view,use the COUNT aggregate function when you want to find the number of values in a field.

Accepted Answer

A) True 
 B)False

Question 19

In Query Design view,you enter parameter criteria within curly brackets,as in {Enter department:}.

Accepted Answer

A) True 
 B)False

Question 20

If you set the Caption property of a form,where does the caption text appear?

Accepted Answer

A)  in the Navigation Pane 
B)  in the form header 
C)  on the form tab in Form view 
D)  in the Details section in Form Design view 
A)  in the Navigation Pane 
B)  in the form header 
C)  on the form tab in Form view 
D)  in the Details section in Form Design view

The _____ property creates an easy-to-use visual guide to help users enter accurate data.

In the criterion 8//2021,the asterisk ()is called a wildcard.

To set the Validation Text property for a table in Table Design view,you use the _____.

Which of the following are settings you specify in the Crosstab row of the query design grid when you create a crosstab query? Select all the options that apply.

Dynaset is the default value of the _____ property in a query; it lets you update data in the query recordset.

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

If you select 25 in the Top Values list,Access displays _____ in the query results.

In Query Design view,how can you add a field to the query design grid?

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

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

The only way to create a Crosstab query is to use the Crosstab Query Wizard.

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

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

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

For a Date/Time field,use the _____ property to display the date 1/17/2017 as January 17,2017.

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

If you do not enter a Caption property for a field,Access uses the field name to label the field.

In Query Design view,use the COUNT aggregate function when you want to find the number of values in a field.

In Query Design view,you enter parameter criteria within curly brackets,as in {Enter department:}.

If you set the Caption property of a form,where does the caption text appear?

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 _____ property creates an easy-to-use visual guide to help users enter accurate data.

In the criterion 8/*/2021,the asterisk (*)is called a wildcard.

To set the Validation Text property for a table in Table Design view,you use the _____.

Which of the following are settings you specify in the Crosstab row of the query design grid when you create a crosstab query? Select all the options that apply.

Dynaset is the default value of the _____ property in a query; it lets you update data in the query recordset.

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

If you select 25 in the Top Values list,Access displays _____ in the query results.

In Query Design view,how can you add a field to the query design grid?

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

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

The only way to create a Crosstab query is to use the Crosstab Query Wizard.

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

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

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

For a Date/Time field,use the _____ property to display the date 1/17/2017 as January 17,2017.

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

If you do not enter a Caption property for a field,Access uses the field name to label the field.

In Query Design view,use the COUNT aggregate function when you want to find the number of values in a field.

In Query Design view,you enter parameter criteria within curly brackets,as in {Enter department:}.

If you set the Caption property of a form,where does the caption text appear?

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

In the criterion 8//2021,the asterisk ()is called a wildcard.