Question 1

A ____ match selects records with a value for the selected field that matches the pattern of the simple condition value.

Accepted Answer

A) design 
B) pattern 
C) value 
D) select 
A) design 
B) pattern 
C) value 
D) select

Question 2

If you convert an Access database to SQL Server your select queries will most likely not work.

Accepted Answer

A) True 
 B)False

Question 3

Click the Queries option button in the View section of the Crosstab Query Wizard to display the list of queries in the database.

Accepted Answer

A) True 
 B)False

Question 4

The ____ property value will be displayed in a dialog box if the user enters an invalid value.

Accepted Answer

A) Data-Entry 
B) Validation Text 
C) Validation Rule 
D) Datasheet 
A) Data-Entry 
B) Validation Text 
C) Validation Rule 
D) Datasheet

Question 5

Match between columns
                        Premises: Exists between two objects when a change to the properties of data in one object affects the properties of data in the other object

Accepted Answer

The Answer of field validation rule and property propagation and is...

Question 6

Which of the following commands is used to keep selected columns visible no matter where you scroll in the datasheet?

Accepted Answer

A) Keep Visible 
B) No Scroll 
C) Display Columns 
D) Freeze 
A) Keep Visible 
B) No Scroll 
C) Display Columns 
D) Freeze

Question 7

If you want to display all customers who have not placed orders you would use a(n)find unmatched query.

Accepted Answer

A) True 
 B)False

Question 8

The aggregate function ____________________ returns the variance of the field values in a selection of records.

Accepted Answer

The answer of The aggregate function ____________________ returns the variance...

Question 9

Of the aggregate functions shown in the above figure the ____ function returns the average of the field values in a selection of records.

Accepted Answer

A) Count 
B) Avg 
C) Var 
D) StDev 
A) Count 
B) Avg 
C) Var 
D) StDev

Question 10

Which of the following input mask characters represents a digit or space that can be entered; however entry is not required?

Accepted Answer

A) 0 
B) ;; 
C) ! 
D) 9 
A) 0 
B) ;; 
C) ! 
D) 9

Question 11

The Create tab allows you to switch to Design view.

Accepted Answer

A) True 
 B)False

Question 12

With a text list-of-values match you enclose each value in ____.

Accepted Answer

A) brackets 
B) quotation marks 
C) braces 
D) parentheses 
A) brackets 
B) quotation marks 
C) braces 
D) parentheses

Question 13

The ____ represents any single character.

Accepted Answer

A) * 
B) (?) 
C) # 
D) @ 
A) * 
B) (?) 
C) # 
D) @

Question 14

The input mask character ____ indicates that a digit or space can be entered.

Accepted Answer

A) ! 
B) @ 
C) 0 
D) 9 
A) ! 
B) @ 
C) 0 
D) 9

Question 15

The input mask character ____ causes the input mask to display from right to left.

Accepted Answer

A) ! 
B) 9 
C) 0 
D) ; 
A) ! 
B) 9 
C) 0 
D) ;

Question 16

For the ____________________ property you enter either an integer or a percentage to determine how many records display.

Accepted Answer

The answer of For the ____________________ property you enter either...

Question 17

Match between columns
                        Premises: Property value that will be displayed in a dialog box if the user enters an invalid value

Accepted Answer

The Answer of table validation rule and crosstab query and is...

A ____ match selects records with a value for the selected field that matches the pattern of the simple condition value.

If you convert an Access database to SQL Server your select queries will most likely not work.

Click the Queries option button in the View section of the Crosstab Query Wizard to display the list of queries in the database.

The ____ property value will be displayed in a dialog box if the user enters an invalid value.

Which of the following commands is used to keep selected columns visible no matter where you scroll in the datasheet?

If you want to display all customers who have not placed orders you would use a(n)find unmatched query.

The aggregate function ____________________ returns the variance of the field values in a selection of records.

Of the aggregate functions shown in the above figure the ____ function returns the average of the field values in a selection of records.

Which of the following input mask characters represents a digit or space that can be entered; however entry is not required?

The Create tab allows you to switch to Design view.

With a text list-of-values match you enclose each value in ____.

The ____ represents any single character.

The input mask character ____ indicates that a digit or space can be entered.

The input mask character ____ causes the input mask to display from right to left.

For the ____________________ property you enter either an integer or a percentage to determine how many records display.

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing Integrating and Analyzing Data

Exce: Working With Excel Tables Pivottables and Pivotcharts

Excel: Managing Multiple Worksheets and Workbooks

Excel: Using Advanced Functions Conditional Formatting and Filtering

Excel: Developing an Excel Application

Powerpoint: Adding Special Effects to a Presentation

Powerpoint: Integrating Powerpoint With Other Programs and Collaborating With Workgroups

Word: Working With Templates and Outlines

Word: Using Mail Merge

Word: Collaborating With Others and Creating Web Pages

Filters

Exam 1: Access: Creating Advanced Queries and Enhancing Table Design

A ____ match selects records with a value for the selected field that matches the pattern of the simple condition value.

If you convert an Access database to SQL Server your select queries will most likely not work.

Click the Queries option button in the View section of the Crosstab Query Wizard to display the list of queries in the database.

The ____ property value will be displayed in a dialog box if the user enters an invalid value.

Which of the following commands is used to keep selected columns visible no matter where you scroll in the datasheet?

If you want to display all customers who have not placed orders you would use a(n)find unmatched query.

The aggregate function ____________________ returns the variance of the field values in a selection of records.

Of the aggregate functions shown in the above figure the ____ function returns the average of the field values in a selection of records.

Which of the following input mask characters represents a digit or space that can be entered; however entry is not required?

The Create tab allows you to switch to Design view.

With a text list-of-values match you enclose each value in ____.

The ____ represents any single character.

The input mask character ____ indicates that a digit or space can be entered.

The input mask character ____ causes the input mask to display from right to left.

For the ____________________ property you enter either an integer or a percentage to determine how many records display.

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing Integrating and Analyzing Data

Exce: Working With Excel Tables Pivottables and Pivotcharts

Excel: Managing Multiple Worksheets and Workbooks

Excel: Using Advanced Functions Conditional Formatting and Filtering

Excel: Developing an Excel Application

Powerpoint: Adding Special Effects to a Presentation

Powerpoint: Integrating Powerpoint With Other Programs and Collaborating With Workgroups

Word: Working With Templates and Outlines

Word: Using Mail Merge

Word: Collaborating With Others and Creating Web Pages

Filters