Question 1

The figure above shows a(n)____ match selection criterion.

Accepted Answer

A) exact 
B) range 
C) integer 
D) pattern 
A) exact 
B) range 
C) integer 
D) pattern

Question 2

Any form or report that uses fields from a query is directly dependent on the query and on any tables that provide data to the query.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

To make sure that a user enters a value in one table field that is chronologically earlier for example than the value in another field in the same record you can set Validation Rule and Validation Text properties for the ____________________ instead for an individual field.

Accepted Answer

The answer of To make sure that a user enters...

Question 5

The aggregate function Final returns the last field value in a selection of records.

Accepted Answer

A) True 
 B)False

Question 6

Displaying just the first 10 records of query results is an example of the use of the First Records property for a query.

Accepted Answer

A) True 
 B)False

Question 7

Match between columns
                        Premises: Performs aggregate function calculations on the values of one database field and displays the results in a spreadsheet format

Accepted Answer

The Answer of object dependency and literal display and field is...

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

When you use the ____ comparison operator if a record's field value matches one value from the list of defined values then Access selects and includes that record in the query results.

Accepted Answer

A) As 
B) Like 
C) In 
D) Or 
A) As 
B) Like 
C) In 
D) Or

Question 10

Users are required to type literal display characters when doing data entry.

Accepted Answer

A) True 
 B)False

Question 11

What is the default phone number input mask?

Accepted Answer

A) !(999)000-0000;;_ 
B) (999)000-0000;;_ 
C) (999)000.0000;;_ 
D) !999-000-0000;_ 
A) !(999)000-0000;;_ 
B) (999)000-0000;;_ 
C) (999)000.0000;;_ 
D) !999-000-0000;_

Question 12

A find ____ query is a select query that finds all records in a table or query that have no related records in a second table or query.

Accepted Answer

A) unrelated 
B) unmatched 
C) free 
D) empty 
A) unrelated 
B) unmatched 
C) free 
D) empty

Question 13

The ____ property value specifies the valid values that users can enter in a field.

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 14

SQL Server and Oracle do not permit spaces in object and field names.

Accepted Answer

A) True 
 B)False

Question 15

Put the following steps for creating a find unmatched query with the Query Wizard in order. 1. In the Other group on the Create tab click the Query Wizard button. 2. Complete the Wizard dialog boxes to select the table or query on which to base the new query. 3. Click Find Unmatched Query Wizard and then click the OK button. 4. Select the table or query that contains the related records specify the common field in each table or query select the additional fields to include in the query results enter a name for the query. 5. Click the Finish button.

Accepted Answer

A) 1 2 3 4 5 
B) 1 3 2 4 5 
C) 2 1 3 5 4 
D) 2 3 2 5 4 
A) 1 2 3 4 5 
B) 1 3 2 4 5 
C) 2 1 3 5 4 
D) 2 3 2 5 4

Question 16

Access detects ____ validation rule violations immediately after you finish your field entry and advance to another field.

Accepted Answer

A) table 
B) record 
C) field 
D) row 
A) table 
B) record 
C) field 
D) row

Question 17

The input mask character ____ determines whether to store in the database the literal display characters such as the hyphen and parentheses.

Accepted Answer

A) -- 
B) ++ 
C) :: 
D) ;; 
A) -- 
B) ++ 
C) :: 
D) ;;

Question 18

Using a match like the one shown in the above figure is similar to using an exact match except that an exact match includes wildcard characters.

Accepted Answer

A) True 
 B)False

Question 19

In a list-of-values match you use ____ to separate the values.

Accepted Answer

A) periods 
B) commas 
C) quotation marks 
D) ampersands 
A) periods 
B) commas 
C) quotation marks 
D) ampersands

Question 20

When you click or select text in many Access text boxes Access displays a list arrow which you can click to display a list box with options.

Accepted Answer

A) True 
 B)False

The figure above shows a(n)____ match selection criterion.

Any form or report that uses fields from a query is directly dependent on the query and on any tables that provide data to the query.

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

To make sure that a user enters a value in one table field that is chronologically earlier for example than the value in another field in the same record you can set Validation Rule and Validation Text properties for the ____________________ instead for an individual field.

The aggregate function Final returns the last field value in a selection of records.

Displaying just the first 10 records of query results is an example of the use of the First Records property for a query.

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

When you use the ____ comparison operator if a record's field value matches one value from the list of defined values then Access selects and includes that record in the query results.

Users are required to type literal display characters when doing data entry.

What is the default phone number input mask?

A find ____ query is a select query that finds all records in a table or query that have no related records in a second table or query.

The ____ property value specifies the valid values that users can enter in a field.

SQL Server and Oracle do not permit spaces in object and field names.

Access detects ____ validation rule violations immediately after you finish your field entry and advance to another field.

The input mask character ____ determines whether to store in the database the literal display characters such as the hyphen and parentheses.

Using a match like the one shown in the above figure is similar to using an exact match except that an exact match includes wildcard characters.

In a list-of-values match you use ____ to separate the values.

When you click or select text in many Access text boxes Access displays a list arrow which you can click to display a list box with options.

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

The figure above shows a(n)____ match selection criterion.

Any form or report that uses fields from a query is directly dependent on the query and on any tables that provide data to the query.

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

To make sure that a user enters a value in one table field that is chronologically earlier for example than the value in another field in the same record you can set Validation Rule and Validation Text properties for the ____________________ instead for an individual field.

The aggregate function Final returns the last field value in a selection of records.

Displaying just the first 10 records of query results is an example of the use of the First Records property for a query.

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

When you use the ____ comparison operator if a record's field value matches one value from the list of defined values then Access selects and includes that record in the query results.

Users are required to type literal display characters when doing data entry.

What is the default phone number input mask?

A find ____ query is a select query that finds all records in a table or query that have no related records in a second table or query.

The ____ property value specifies the valid values that users can enter in a field.

SQL Server and Oracle do not permit spaces in object and field names.

Access detects ____ validation rule violations immediately after you finish your field entry and advance to another field.

The input mask character ____ determines whether to store in the database the literal display characters such as the hyphen and parentheses.

Using a match like the one shown in the above figure is similar to using an exact match except that an exact match includes wildcard characters.

In a list-of-values match you use ____ to separate the values.

When you click or select text in many Access text boxes Access displays a list arrow which you can click to display a list box with options.

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