Access Vocabulary

Foreign Key

A field in one table whose vaules are required to match the primary key of another table.

Required field

A field in which the user actually must enter the data

Calculated Field

A field that can be computer from other fields.

Aggregate Function

A function that performs some mathematical function against a group of records.

List

A labled series of rows in which each row contains the same type of data

Join Line

A line between matching fields in the tow tables indicating that the tables are related.

Relationship line

A line joining two related fields

Menu

A list of commands.

Update Query

A query that makes the same change to all the records satisfying a creiterion.

Parameter Query

A query that prompts for input whenever it is run.

Delete Query

A query that will delete all the records satifying the criteria entered in the query.

Query

A question represented in a way that Access can understand.

Task Pane

A separate window that enables users to carry out some Access tasks more efficiently.

Datasheet

A set of tables

Snapshot

A special file that contains the report exactly as it appears when printed

Database Window

A special window that allows you to access easily and rapidly a variety of objects such as tables, queries, forms, and reports

Primary key

A unique identifier is also known as this

Default Value

A value that access will display on the screen in a particular default value.

Property sheet

A window containing the various properties of the object

Description

Access allows you to enter a detailed description of the field.

Append Query

Adds a group of records from one table to the end of another table.

Full Menu

All the commands associated with a menu.

Top-values query

Allow you to quantify the results

Lookup Field

Allows the user to select from a list of values

Find Duplicates Query Wizard

Allows you to find duplicate reocrds

Find Unmatched Query Wizard

Allows you to find unmatched records.

Single-field Index

An index whose key is a single field.

Taskbar

At the bottom of the screen displays the start button, any active windows, and the current time.

Navigation buttons

Buttons used to move within a table, found near the lower-left corner of the screen.

Crosstab Query

Calculates a statistic for data that is grouped by tow different types of information`

Restructuring the database

Change the databse structure.

Resizing

Changing the size of a column

Page Header

Contains a custom title.

Field

Contains a specific piece of information within a record

Toolbar

Contains buttons that allow you to perform certain tasks more quickly than using the menu bar.

Index

Contains important words or phrases or items of interest

Records

Contains information about a given person, product, or event.

Status Bar

Contains special information that is appropriate for the task on which you are working.

AutoCorrect

Corrects common mistakes when you complete a text entry in a cell.

Grouping

Creating groups of records that share some common characteristic.

Multiple-field Indexes

Indexes whose key is a combination of fields, involves a different proccess from creating single-field indexes.

Structure

Indicate the names, types, and sizes of all the fields.

Data Type

Indicates to Access the type of data the fill will contain.

Minimized

It is displayed on the Windows taskbar.

Restored

It is displayed somewhere in the Access window

Short Menu

Lists the most recently used commands.

Searching

Looking for records that satisfy some criteria.

Backing Up

Making a copy of a database

Backup Copy/Save Copy

Making a copy of the database

Shortcut Menus

Menus that display the actions available for a particular item.

Maintaining the database

Modifying the data to keep it up-to-date, such as adding new records, changing the data for existing records, and deleting records

Compound Criterion

More than one criterion that the data for which you are searching must satisfy.

One-to-many relationship

One record in the first table is related to (matches) many records in the second table, but each record in a the second tbale is related to only one record in the first.

Sort

Order the record in the answer to a query in a particular way.

Pane

Portion of the screen where you define field properties.

Queries

Questions, the answers to which are in the database.

Recover

Recovering the database

Delete the Records

Remove them from the table

Repair

Repairing the database in case of problems

Asterisk (*)

Represents any collection of characters.

Question Mark

Represents any individual character.

Validation Rules

Rules atht a user must follow when entering the data.

Minor Key/Secondary Sort Key

The less important field.

Detail Lines

The lines that are printed for each record contain only those fields you specify and in the order you specify.

Validation Text

The message that will appear if a user violates the validation rule

Landscape Orientation

The printout is across the length of the page

Portrait Orientation

The printout is across the width of the page.

Hidden

You do not see it on the screen.

Filter by selection

You must give Access an example of the data you want by selecting the data within the table.

Form View

You see data contained in a form.

Live Database

If a problem occures, you correct the problem by copying this backup copy over the actual database called this.

Format Symbol

To used a format with a Text Field, you enter a special symbol.

OR Criterion

True provided either individual criterion is true

Form View

Update the data in a table.

Make-Table query

Used to add the records to a new table

Importing

Uses Import Wizard (Converts data to an Access database)

Range of Values

Validation rules can make sure a user's entry lies withing a range of values, For example, that the vaules in the Amount Paid field are between $0.00 and $90,000.00

Join

records in two tables that have identical values in the matching fields.

Subdatasheet

(+)Includes extra information in a particular table.

Dimmed Commands

(Appear Gray) - Indicates that they are not available for the current selection.

Best Fit

(Double Click), in which Access will determine the best fit for the column

Database Management System

(Ex: Access) - A software tool that allows you to use a computer to create a database; add, change, and delete data in the database; sort the data in the database; retrieve data in the database; and create forms and reports using the data in the database.

Field Selector

(The line in the column heading immediately to the right of the name of the column to be resized)

Comparison Operator

> (greater than), (less than), >= (greater than or equal to), <= (less than or equal to), and NOT (not equal to).

Database

A collection of data organized in a manner that allows access, retrieval, and use of that data.

Criterion

A condition that the records to be included must satisfy.

Text Data

Data in a field whose data type is Text.

Icon

Depicting its function.

Menu Bar

Displayed below the title bar. Displays the menu names.

Submenu

Displayed from which you can choose a command.

Hidden Command

Does not display on a short menu.

Identical Rows

Duplicate rows

Field Name

Each field in the table must have a unique name.

AND Criterion

Each individual criterion must be true in order for the compound criterion to be true.

Select Query Window

Entries placed in a special window.

Legal Values

For the Client Type fields are EDU, MAN, and SER

Cascade the delete

Have Access Allow the deletion but then automatically delete any clients related to the deleted trainer

Cascade the update

Have Access allow the update but them atutomatically make the corresponding change for any client whose trainer number was 42. it will now be 62

Filter by form

Specify multiple creiteria.

Redundancy

Storing the same fact in more than one place.

Wildcards

Symbols that represent any character or combination of characters.

Database Design

The arrangement of data into tables and fields.

Insert Mode

The characters typed will be inserted at the appropiate position

Currency

The field can contain only monetary data. The values will appear with currency symbols, such as dollar signs, commas, decimal points, and with two digits following the decimal point.

Number

The field containing only numbers.

Index Key

The field or fields on which the index is built

Sort Key

The field or fields on which the records are sorted

Text

The field that contains any characters.

Join Properties

The properties that indicate which records appear in a join.

Row Selector

The small box or bar that, when you click it, selects the entire row, indicates the field you currently are describing.

Datasheet View

The table is represented as a collection of rows and columns called a datasheet.

Import Spreadsheet Wizard

This wizard takes you through basic steps, asking a few simple questions. After you have answered the questinos, the wizard will perform the conversion, creating an apporpiate table in the database and filling it with the data from the worksheet

ScreenTip

Tips displayed in a bar.

Format

To affect the way data appears in a field

Advance Filter/Sort

To filter records using complex criteria.

Filter

To have only the record or records that satisfy the criterion appear

Compact

To remove the wasted space from the database.

Unique Identifier

given client number will appear only in a single record in a table

Overtype Mode

the letters OVR will appeart near the bottom right edge of the status bar

Major Key/Primary Sort Key

the more important field. (Trainer Number)

Referential Intergrity

the property that ensures tha the value in a foreign key must match that of another table's primary key.

Title Bar

top bar in the Microsoft Access window. Includes the title of the application.