Question 1

Match between columns
                        Premises: Object used to enter new records into the database.
Database object that is based upon a specific question you ask about the data in the database.
Used to find and work with data that meets certain criteria or a specific set of records.
Data arranged alphabetically, numerically, or chronologically.
Formatted display or printout of the contents of one or more tables in a database.

Accepted Answer

The Answer of query and sort and form and filter is...

Question 2

To see how a report will look when printed, you can display it in the ____________________ window to make sure it looks the way you want.

Accepted Answer

The answer of To see how a report will look...

Question 3

Using ____________________ view, you can view, enter, or edit data, but cannot change the layout or design of the form.

Accepted Answer

The answer of Using ____________________ view, you can view, enter,...

Question 4

When you ____________________ a query, you perform the query with the most recent data, and give instructions to display the records and fields in your original query design.

Accepted Answer

The answer of When you ____________________ a query, you perform...

Question 5

What is the purpose of a filter? Give examples of when a filter would be useful. When would you want to use a filter to display certain records instead of a query? When might you need to use a type of filter other than an AutoFilter? Give an example.

Accepted Answer

The answer of What is the purpose of a filter?...

Question 6

When you choose to sort in ____________________ order, text is sorted from A to Z, numbers are sorted from 0 to 9, and dates are sorted from earliest to latest.

Accepted Answer

The answer of When you choose to sort in ____________________...

Quiz 2: Access Lesson 2: Creating Queries, Forms, and Reports

Identify the letter of the choice that best matches the phrase or definition.

To see how a report will look when printed, you can display it in the ____________________ window to make sure it looks the way you want.

Using ____________________ view, you can view, enter, or edit data, but cannot change the layout or design of the form.

When you ____________________ a query, you perform the query with the most recent data, and give instructions to display the records and fields in your original query design.

What is the purpose of a filter? Give examples of when a filter would be useful. When would you want to use a filter to display certain records instead of a query? When might you need to use a type of filter other than an AutoFilter? Give an example.

When you choose to sort in ____________________ order, text is sorted from A to Z, numbers are sorted from 0 to 9, and dates are sorted from earliest to latest.