Question 1

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 2

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 3

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

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

Accepted Answer

A) True 
 B)False

Question 5

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

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

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

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

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

Which of the following are properties you can set for a query? 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

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

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

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

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

Which of the following are properties you can set for a query? 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