Question 1

You can create a query that combines both the AND and OR operators.

Accepted Answer

A) True 
 B)False  True

Question 2

Which of the following symbols must you use when defining a parameter query?

Accepted Answer

A) ( ) 
B) [ ] 
C) { } 
D) / / 
A) ( ) 
B) [ ] 
C) { } 
D) / / B

Question 3

You will most likely use the Zoom box or Expression Builder to enter a parameter query that contains wildcards due to the length of the expression.

Accepted Answer

A) True 
 B)False  True

Question 4

Explain what you know about using wildcards in a parameter query.

Accepted Answer

You can use the Like comparison operator

Question 5

Use the "Is Null" value in a criterion expression to find records where the field contains a value.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following properties directs Access to only display records that don't include duplicated values?

Accepted Answer

A) Unique Records 
B) Unique Values 
C) Null Records 
D) Null Values 
A) Unique Records 
B) Unique Values 
C) Null Records 
D) Null Values

Question 7

In the Design grid,what must you delete in order to delete a field?

Accepted Answer

A) a column 
B) a row 
C) a table 
D) none of the above 
A) a column 
B) a row 
C) a table 
D) none of the above

Question 8

A summary query uses a Total row that is added into the Design grid of the query.

Accepted Answer

A) True 
 B)False

Question 9

Access refers to formulas as criterion.

Accepted Answer

A) True 
 B)False

Question 10

What is a calculated field? Where are calculated fields stored?

Accepted Answer

A calculated field is a field that gets

Question 11

To create a new query,use the Create tab.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following finds data in your database by allowing you to ask a question?

Accepted Answer

A) calculated field 
B) compound criteria 
C) query 
D) parameter 
A) calculated field 
B) compound criteria 
C) query 
D) parameter

Question 13

What is the difference between creating a query using the Query Design Wizard or Query Design?

Accepted Answer

While the Simple Query Wizard is useful

Question 14

Which symbol must be used to specify criterion for the Date/ Time data type?

Accepted Answer

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

Question 15

In what view do query results display?

Accepted Answer

A) Design view 
B) Datasheet view 
C) Form view 
D) Report view 
A) Design view 
B) Datasheet view 
C) Form view 
D) Report view

Question 16

Which of the following logical operators requires a record to meet at least one of the individual conditions specified to be included in the results?

Accepted Answer

A) AND 
B) OR 
C) NOT 
D) NULL 
A) AND 
B) OR 
C) NOT 
D) NULL

Question 17

Which of the following represents the correct order of operations?

Accepted Answer

A) (),^,/ ,*,-,+ 
B) (),^,*,/ ,+,- 
C) (),^,*,/ ,-,+ 
D) ^,(),*,/ ,-,+ 
A) (),^,/ ,*,-,+ 
B) (),^,*,/ ,+,- 
C) (),^,*,/ ,-,+ 
D) ^,(),*,/ ,-,+

Question 18

Which of the following wildcard characters matches any single character in a specific position?

Accepted Answer

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

Question 19

Which of the following should you add to a query to search for records that meet a specific value?

Accepted Answer

A) criterion 
B) Like comparison 
C) wildcard symbols 
D) expression 
A) criterion 
B) Like comparison 
C) wildcard symbols 
D) expression

Question 20

When might you want to create a query based on multiple tables? What should you be careful of when creating a creating based on multiple tables?

Accepted Answer

The vast majority of databases contain m

You can create a query that combines both the AND and OR operators.

Which of the following symbols must you use when defining a parameter query?

You will most likely use the Zoom box or Expression Builder to enter a parameter query that contains wildcards due to the length of the expression.

Explain what you know about using wildcards in a parameter query.

Use the "Is Null" value in a criterion expression to find records where the field contains a value.

Which of the following properties directs Access to only display records that don't include duplicated values?

In the Design grid,what must you delete in order to delete a field?

A summary query uses a Total row that is added into the Design grid of the query.

Access refers to formulas as criterion.

What is a calculated field? Where are calculated fields stored?

To create a new query,use the Create tab.

Which of the following finds data in your database by allowing you to ask a question?

What is the difference between creating a query using the Query Design Wizard or Query Design?

Which symbol must be used to specify criterion for the Date/ Time data type?

In what view do query results display?

Which of the following logical operators requires a record to meet at least one of the individual conditions specified to be included in the results?

Which of the following represents the correct order of operations?

Which of the following wildcard characters matches any single character in a specific position?

Which of the following should you add to a query to search for records that meet a specific value?

When might you want to create a query based on multiple tables? What should you be careful of when creating a creating based on multiple tables?

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters

Exam 8: Integrating Applications

You can create a query that combines both the AND and OR operators.

Which of the following symbols must you use when defining a parameter query?

You will most likely use the Zoom box or Expression Builder to enter a parameter query that contains wildcards due to the length of the expression.

Explain what you know about using wildcards in a parameter query.

Use the "Is Null" value in a criterion expression to find records where the field contains a value.

Which of the following properties directs Access to only display records that don't include duplicated values?

In the Design grid,what must you delete in order to delete a field?

A summary query uses a Total row that is added into the Design grid of the query.

Access refers to formulas as criterion.

What is a calculated field? Where are calculated fields stored?

To create a new query,use the Create tab.

Which of the following finds data in your database by allowing you to ask a question?

What is the difference between creating a query using the Query Design Wizard or Query Design?

Which symbol must be used to specify criterion for the Date/ Time data type?

In what view do query results display?

Which of the following logical operators requires a record to meet at least one of the individual conditions specified to be included in the results?

Which of the following represents the correct order of operations?

Which of the following wildcard characters matches any single character in a specific position?

Which of the following should you add to a query to search for records that meet a specific value?

When might you want to create a query based on multiple tables? What should you be careful of when creating a creating based on multiple tables?

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters