Tutorial 3

Autosort

1

?

1 after

Calculated Field

A field that displays the results of an expression

Secondary sort field; Primary sort field

A second field that determines the order of records that are already sorted by the ____

Filter

A set of restrictions you place on the records in an open datasheet or form to temporarily isolate a subset of the records

Nonunique

A sort field ____ if more than one record can have the same value for the sort field

Unique

A sort field is ___ if the value in the sort field for each record is different

10

Access lets you select up to ____ different sort fields

Navigation Mode

Access selects an entire field value

*

All characters after

Unhide Fields

Allows you to redisplay any hidden fields

Hide Fields

Allows you to remove the display of one or more fields

Find Command

Allows you to search a table or query datasheet, or a form, to locate a specific field value or part of a field value

Expression Builder

An Access tool that makes it easy for you to create an expression

Running

Answering the query

Object Type

Arranges objects by type

Comparison operator

Asks Access to compare the value in a field to the condition value and to select all the records for which the condition is true

Editing Mode

Can insert or delete characters in a field value based on the location of the insertion point

Reports

Cannot update records in ____

Filter by Form

Changes your datasheet to display blank fields

Field List

Contains the fields for the table you are querying

Query capabilities

Display selected fields and records from a table; sort records; perform calculations; generate data for forms, reports, and other queries; update data in the tables in a database; find and display data from two or more tables

All Access Objects

Displays all objects in the database

Group by operator

Divides the selected records into groups based on the values in the specified field

AutoFilter

Enables you to quickly sort and display field values in various ways

Query by example

Give Access an example of the information you are requesting

Design Grid

Include the fields and record selection criteria for the information you want to see

<---

Left one field value at a time

Home

Left to the first field value in the record

Filter by selection

Lets you select all or part of a field value in a datasheet or form, and then display only those records that contain the selected value in the field. Lightning bolt

Like

Matches a pattern that includes wildcards

Logical operators

Multiple conditions require you to use ___ to combine two or more conditions

Select query

One in which you specify the fields and records you want Access to select

Aggregated functions

Perform arithmetic operations on selected records in a database

Sorting

Process of rearranging records in a specified order or sequence

Query Wizard

Prompts you for information by asking a series of questions and then creates the appropriate query based on your answers

Criteria

Question

Recordset

Result of a query

--->

Right one field value at a time

Tab or Enter

Right one field value at a time

End

Right to the last field value in the record

Sort Field

The field used to determine the order of records in the datasheet

Updating

The process of adding, modifying, and deleting records in database tables to keep them current and accurate

Current record

To modify the field values in a record, you must first make the record the _____

expression

To perform a calculation, you define a ___ containing a combination of database fields, constants, and operators

Ctrl + Home

To the first field value in the first record

Ctrl + End

To the last field value in the last record

F2 key

Toggle that you use to switch between navigation mode and editing mode

^ or l l v

Up or down one record at a time

Or logical operator

When you place conditions in different Criteria rows

And logical operator

When you want a record selected only if two or more conditions are met

Left; right; primary sort field

You must arrange the fields you want to sort from ____ to ____ in the design grid, with the ____ being the leftmost

Between....and...

between two values

In ()

in a list of values