Access Ch. 2 Test Prep

The most common type of query​ is:

To display only certain records

There are two ways to add more tables to the Relationships grid.

You can use wildcards in the Find What text box if you don't know the exact​ spelling, but do know some characters

To create an action​ query, begin with a regular select query.

You can open a query in Design​ view, make​ changes, and then save the query with a different name.

It is possible to delete an existing relationship between tables.

A relationship report is a​ hard-copy printout of the relationships between the tables in the database.

A type of operation to be performed in the calculation

When using​ text-based criteria in a​ query:

A symbol that represents math operations such as​ + (addition) or​ * (multiplication)

Queries CANNOT be used as a basis for reports or forms.

Specify multiple values for a field that will all be included in the filter

An alias is an alternate name for a field.

Filtering specifications that determine what records will be included in a query are called criteria.

A view in which you can define the structure of the query​ is:

You CANNOT sort records by fields that​ have:

The asterisk​ (*) wildcard can replace any number of characters.

To filter based on the data in the selected record and field

Click Toggle Filter to filter the data OR to remove the filter.

A​ second-level sort applies only in the event of a duplicate value in the​ first-level sort field.

A value such as​ True, False, and Null

Sorting rearranges records in order by one or more fields.

The name of the table you are working with

When starting a​ query, first add the tables in Design​ view, then:

The question mark​ (?) wildcard is a substitute for an unknown single character.

With a multiple​ sort, the two​ (or more) fields that you sort by do NOT need to be next to each other on the datasheet.

Query criteria can be​ text-based, numeric, or logical.

To use a form that enables you to enter criteria for the filter

Query results appear in Datasheet view

Replace means​ to:

When a record in a parent table is​ deleted, & Access deletes all the related records from the child table this is​:

A calculated field can perform a math operation on only one field.

You can remove all sorts in a table with the Remove Sort command on the Home tab.

You can use fields from a MAXIMUM of two tables in a query.

Null is the word that Access uses to describe a field that is empty.

Sorting from A to Z or 1 to 9 is called decending order.

You can have only one parameter in a single query.