Question 1

You use the _____ property of a query to document the purpose or author of the query.

Accepted Answer

A)  Purpose 
B)  Object 
C)  Miscellaneous 
D)  Description 
A)  Purpose 
B)  Object 
C)  Miscellaneous 
D)  Description

Question 2

Which of the following are properties you can set for a query? Select all the options that apply.

Accepted Answer

A)  Description 
B)  Recordset Type 
C)  Default View 
D)  Field Size 
A)  Description 
B)  Recordset Type 
C)  Default View 
D)  Field Size

Question 3

When you set a _____ for a table, you create an expression that restricts the values that users can enter into a record.

Accepted Answer

A)  criterion 
B)  data type 
C)  validation rule 
D)  relationship 
A)  criterion 
B)  data type 
C)  validation rule 
D)  relationship

Question 4

To display the contents of a text box in more than one font size or color, set the _____ property of the text box to RTF.

Accepted Answer

A)  HTML 
B)  Font Tags 
C)  Text Format 
D)  CSS 
A)  HTML 
B)  Font Tags 
C)  Text Format 
D)  CSS

Question 5

How can you display "Product Description" in a table datasheet for a field named "ProdDesc" without renaming the field?

Accepted Answer

A)  Enter "Product Description" in the Caption property for the field. 
B)  Edit the column heading in Table Layout view. 
C)  Change the Format property to Separate Words. 
D)  Change the Default Value property to "Production Description". 
A)  Enter "Product Description" in the Caption property for the field. 
B)  Edit the column heading in Table Layout view. 
C)  Change the Format property to Separate Words. 
D)  Change the Default Value property to "Production Description".

Question 6

In a Date/Time field named HireDate, the validation rule expression >#7/1/21# means _____.

Accepted Answer

A)  the date must be after 7/1/21 
B)  the date must be before 7/1/21 
C)  the date must be in July of 2021 
D)  the date must be 7/1/21 
A)  the date must be after 7/1/21 
B)  the date must be before 7/1/21 
C)  the date must be in July of 2021 
D)  the date must be 7/1/21

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

Create a Top Values query to find the highest values in set of unsorted records.

Accepted Answer

A) True 
 B)False

Question 9

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 10

To change the field name displayed for a field in a query datasheet, you set the Display property for the field in Query Design view.

Accepted Answer

False - Ca

Question 11

To create a single-value lookup field in Table Design view, you use the _____ in the Field Properties pane.

Accepted Answer

A)  Lookup tab 
B)  Input Mask property 
C)  Lookup button 
D)  List property 
A)  Lookup tab 
B)  Input Mask property 
C)  Lookup button 
D)  List property

Question 12

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

Question 13

(999)000-000;1;_ would be a possible entry for which field property?

Accepted Answer

A)  Input Mask 
B)  Format 
C)  Required 
D)  Field Size 
A)  Input Mask 
B)  Format 
C)  Required 
D)  Field Size

Question 14

After you freeze a field in a query datasheet, you must run the query again before you can unfreeze the field.

Accepted Answer

A) True 
 B)False

Question 15

To set the properties for an entire table, open the table's property sheet in Table Design view.

Accepted Answer

A) True 
 B)False

Question 16

In which of the following ways can you change the arrangement of a control layout? Select all the options that apply.

Accepted Answer

A)  Insert a column. 
B)  Apply a cell style. 
C)  Remove a control. 
D)  Merge cells. 
A)  Insert a column. 
B)  Apply a cell style. 
C)  Remove a control. 
D)  Merge cells.

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

What criterion should you use in the Bedrooms field to select records of houses for sale with exactly four bedrooms?

Accepted Answer

A)  4 
B)  >=4 
C)  4 
D)  "Is 4" 
A)  4 
B)  >=4 
C)  4 
D)  "Is 4"

Question 19

In Table Design view, "State must be AZ or CO" is an example of integrity text.

Accepted Answer

False - validation
F

Question 20

Which of the following describes the Caption property? Select all the options that apply.

Accepted Answer

A)  It must match the field name. 
B)  It is used as the default field name in labels that describe fields on forms and reports. 
C)  It is an optional property. 
D)  It is used as the default field name at the top of the field column in datasheets. 
A)  It must match the field name. 
B)  It is used as the default field name in labels that describe fields on forms and reports. 
C)  It is an optional property. 
D)  It is used as the default field name at the top of the field column in datasheets.

You use the _____ property of a query to document the purpose or author of the query.

Which of the following are properties you can set for a query? Select all the options that apply.

When you set a _____ for a table, you create an expression that restricts the values that users can enter into a record.

To display the contents of a text box in more than one font size or color, set the _____ property of the text box to RTF.

How can you display "Product Description" in a table datasheet for a field named "ProdDesc" without renaming the field?

In a Date/Time field named HireDate, the validation rule expression >#7/1/21# means _____.

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

Create a Top Values query to find the highest values in set of unsorted records.

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

To change the field name displayed for a field in a query datasheet, you set the Display property for the field in Query Design view.

To create a single-value lookup field in Table Design view, you use the _____ in the Field Properties pane.

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

(999)000-000;1;_ would be a possible entry for which field property?

After you freeze a field in a query datasheet, you must run the query again before you can unfreeze the field.

To set the properties for an entire table, open the table's property sheet in Table Design view.

In which of the following ways can you change the arrangement of a control layout? Select all the options that apply.

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

What criterion should you use in the Bedrooms field to select records of houses for sale with exactly four bedrooms?

In Table Design view, "State must be AZ or CO" is an example of integrity text.

Which of the following describes the Caption property? Select all the options that apply.

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

You use the _____ property of a query to document the purpose or author of the query.

Which of the following are properties you can set for a query? Select all the options that apply.

When you set a _____ for a table, you create an expression that restricts the values that users can enter into a record.

To display the contents of a text box in more than one font size or color, set the _____ property of the text box to RTF.

How can you display "Product Description" in a table datasheet for a field named "ProdDesc" without renaming the field?

In a Date/Time field named HireDate, the validation rule expression >#7/1/21# means _____.

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

Create a Top Values query to find the highest values in set of unsorted records.

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

To change the field name displayed for a field in a query datasheet, you set the Display property for the field in Query Design view.

To create a single-value lookup field in Table Design view, you use the _____ in the Field Properties pane.

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

(999)000-000;1;_ would be a possible entry for which field property?

After you freeze a field in a query datasheet, you must run the query again before you can unfreeze the field.

To set the properties for an entire table, open the table's property sheet in Table Design view.

In which of the following ways can you change the arrangement of a control layout? Select all the options that apply.

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

What criterion should you use in the Bedrooms field to select records of houses for sale with exactly four bedrooms?

In Table Design view, "State must be AZ or CO" is an example of integrity text.

Which of the following describes the Caption property? Select all the options that apply.

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.