Question 1

A pattern match selects records whose values for the designated field matches one of two or more simple condition values.

Accepted Answer

A) True 
 B)False

Question 2

A standard language used in querying,updating,and managing relational databases is ____________________.

Accepted Answer

SQL (Struc

Question 3

The aggregate function which returns the number of nonnull field values is the ____ function.

Accepted Answer

A) Max 
B) Sum 
C) Avg 
D) Count 
A) Max 
B) Sum 
C) Avg 
D) Count

Question 4

Which comparison operator defines a condition with a list of two or more values for a field and includes records when the field matches one value from the list in the query results?

Accepted Answer

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

Question 5

A nonnull field is a field that contains any data at all,including a single space.

Accepted Answer

A) True 
 B)False

Question 6

An input mask with a 0 character indicates that only a digit can be entered as the value and that the entry is optional.____________________

Accepted Answer

A) True 
 B)False

Question 7

A value of true will be returned if a field is empty when the IsNull function is used.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following examples shows an input mask for a telephone number with the first three digits optional and dashes separating the parts of the telephone number?

Accepted Answer

A) 999\-000\-0000 
B) 999-000-9999 
C) 999\000\0000 
D) 000\-999\-9999 
A) 999\-000\-0000 
B) 999-000-9999 
C) 999\000\0000 
D) 000\-999\-9999

Question 9

Which type of query would show results indicating two different student ID numbers have been assigned to the same student?

Accepted Answer

A) simple query 
B) find unmatched query 
C) find duplicates query 
D) crosstab query 
A) simple query 
B) find unmatched query 
C) find duplicates query 
D) crosstab query

Question 10

The format field command freezes a field (column)in a datasheet so that the field stays visible when the user scrolls to the right while viewing the datasheet.____________________

Accepted Answer

A) True 
 B)False

Question 11

The ____________________ aggregate function returns the average of the field values.

Accepted Answer

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

Question 12

Selects records for the designated field when the value matches one of two or more condition values.

Accepted Answer

A)  	find unmatched query 
B) SQL (Structured Query Language) 
C) list-of-values match 
D) table validation rule 
E) Long Text
F)lookup field
G)pattern match
H)Validation Rule
I)find duplicates query
J)property propagation 
A)  	find unmatched query 
B) SQL (Structured Query Language) 
C) list-of-values match 
D) table validation rule 
E) Long Text
F)lookup field
G)pattern match
H)Validation Rule
I)find duplicates query
J)property propagation

Question 13

Valid values that may be entered in a field are specified using the ____________________ propoerty.

Accepted Answer

The answer of Valid values that may be entered in...

Question 14

A standard query language used in querying,updating,and managing relational databases.

Accepted Answer

A)  	find unmatched query 
B) SQL (Structured Query Language) 
C) list-of-values match 
D) table validation rule 
E) Long Text
F)lookup field
G)pattern match
H)Validation Rule
I)find duplicates query
J)property propagation 
A)  	find unmatched query 
B) SQL (Structured Query Language) 
C) list-of-values match 
D) table validation rule 
E) Long Text
F)lookup field
G)pattern match
H)Validation Rule
I)find duplicates query
J)property propagation

Question 15

Rich text formatting available for Long Text fields includes ____.

Accepted Answer

A) paragraph styles 
B) font options 
C) themes 
D) borders 
A) paragraph styles 
B) font options 
C) themes 
D) borders

A pattern match selects records whose values for the designated field matches one of two or more simple condition values.

A standard language used in querying,updating,and managing relational databases is ____________________.

The aggregate function which returns the number of nonnull field values is the ____ function.

Which comparison operator defines a condition with a list of two or more values for a field and includes records when the field matches one value from the list in the query results?

A nonnull field is a field that contains any data at all,including a single space.

An input mask with a 0 character indicates that only a digit can be entered as the value and that the entry is optional.____________________

A value of true will be returned if a field is empty when the IsNull function is used.

Which of the following examples shows an input mask for a telephone number with the first three digits optional and dashes separating the parts of the telephone number?

Which type of query would show results indicating two different student ID numbers have been assigned to the same student?

The format field command freezes a field (column)in a datasheet so that the field stays visible when the user scrolls to the right while viewing the datasheet.____________________

The ____________________ aggregate function returns the average of the field values.

Selects records for the designated field when the value matches one of two or more condition values.

Valid values that may be entered in a field are specified using the ____________________ propoerty.

A standard query language used in querying,updating,and managing relational databases.

Rich text formatting available for Long Text fields includes ____.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 5: Creating Advanced Queries and Enhancing Table Design

A pattern match selects records whose values for the designated field matches one of two or more simple condition values.

A standard language used in querying,updating,and managing relational databases is ____________________.

The aggregate function which returns the number of nonnull field values is the ____ function.

Which comparison operator defines a condition with a list of two or more values for a field and includes records when the field matches one value from the list in the query results?

A nonnull field is a field that contains any data at all,including a single space.

An input mask with a 0 character indicates that only a digit can be entered as the value and that the entry is optional.____________________

A value of true will be returned if a field is empty when the IsNull function is used.

Which of the following examples shows an input mask for a telephone number with the first three digits optional and dashes separating the parts of the telephone number?

Which type of query would show results indicating two different student ID numbers have been assigned to the same student?

The format field command freezes a field (column)in a datasheet so that the field stays visible when the user scrolls to the right while viewing the datasheet.____________________

The ____________________ aggregate function returns the average of the field values.

Selects records for the designated field when the value matches one of two or more condition values.

Valid values that may be entered in a field are specified using the ____________________ propoerty.

A standard query language used in querying,updating,and managing relational databases.

Rich text formatting available for Long Text fields includes ____.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters