Access Session 3

What is a select query?

A general query in which you specify the fields records you want access to select.

What is the default category for the display of objects in the Navigation Pane?

All Access Objects

The ________________ operator divides selected records into groups based on the values in a field.

Group by Operator

In Datasheet view, what is the difference between navigation mode and editing mode?

In navigation mode, the entire field value is selected, and anything you type replaces the field value. In editing mode, you can insert/delete characters in a field value based on the location of the insertion point.

For a Date/Time field, how do the records appear when sorted in ascending order?

Oldest to most recent

Describe the field list and the design grid in the Query window in Design view.

The field list contains the table name and the top of the list and the tables fields listed in the order in which they appear in the table. The design grid displays columns that contain specifications about a field you'll use in query.

How are a table datasheet and a query datasheet similar? How are they different?

They look the same appearing in datasheet view and can be used to update data in a database. A table datasheet shows the permanent data i the table and a query datasheet is temporary.

When you define multiple sort fields in Design view, describe how the sort fields must be positioned in the design grid.

They must be positioned from left to right.

What command can you use in Datasheet view to remove the display of one or more fields from the datasheet?

When you are viewing a table or query datasheet in Datasheet view, you might want to temporarily remove certain fields from the displayed datasheet, making it easier to focus on the data you're interested in viewing. The Hide Fields command allows you to remove the display of one or more fields, and the Unhide Fields command allows you to redisplay any hidden fields. Hiding fields can be especially useful in a table with many fields.

In the design grid, where do you place the conditions for two different fields when you use the And logical operator, and where do you place them when you use the Or logical operator?

and-separate fields in the same criteria row or-in different criteria rows

A(n) ________________ is a criterion, or rule, that determines which records are selected fr a query datasheet.

condition

To perform a calculation in a query, you define a(n) _____________ containing a combination of database fields, constants, and operators.

expression

Which Access tool do you use to create an expression for a calculated field in a query?

expression builder

A(n) _______________ is a set of restrictions you place on the records in an open datasheet or form to isolate a subset of records temporarily.

filter

What is an aggregate function?

perform arithmetic operations on selected records in a database