Exam 2: Access 2: Building and Using Queries

To add, delete, or change fields in a query, you use Query Design View.

Deleting a field from a query also deletes it from the underlying table.

Critical Thinking Questions Case 2-1 Daniel Arno owns a lawn and landscape business with many customers. Occasionally, he wants to filter the data about his customers in various ways. Daniel wants to make even more use of wildcard characters. Which operator is he most apt to use in these searches?

In Access, the Save As command allows you to save either the entire database or the current object with a new name.​

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

To find numbers greater than or equal to 500, use which comparison operator?

A(n) ____ is a saved object within the datasheet.

The ____________________ button provides filter features such as Filter By Form, and Clear All Filters.​

To filter for comparative data, use the Filter By Selection feature.

Query criteria are not case sensitive.

A(n) ____________________ answers a question about the information in the database.

The asterisk (*) is the wildcard used to represent one and only one character in criteria.

To make a page wider than it is tall, use landscape orientation. _________________________

Which of the following comparison operators means "greater than"?

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.

One way to create a new query is with the ____________________, which prompts you for the information it needs to create a new query.

Which of the following comparison operators means "not equal to"?

Explain the difference between AND and OR criteria.