Database

record

A collection of related fields that contains all information for an entry in a database such as a customer, item or business.

sort

A command tha

query

A database object that extracts data from one or more tables in a database according to set criteria

form

A database object that is used to enter, edit, or display records in a database one at a time.

simple database

A database that contains just one table.

relational database

A database that contains multiple tables that are related to each other and can share information.

objects

A graphic or other item or set of items that can be moved and re-sized as a single unit.

fields

A specific category of information in a database such as name, address, or phone number.

report

A summary of database information designed specifically for printing.

Datasheet view

A view in Access that displays records in a grid format, making records easy to compare, sort, and edit.

database

An organized collection of data related to a particular topic or purpose and stored electronically in a file.

navigation bar

Bar containing buttons of the access programming windows that let you move among records.

Column separator

In Access in Datasheet view, the border between two field names that you can drag or double-click to adjust the width of the column.

tables

In Access, a collection of related records.

AutoNumber

In Access, a data type that assigns a unique sequential number to each record.

primary key field

In Access, a field that ensures that each record is unique in a table.

Caption property

In Access, a label that appears in a form, report, or in Datasheet view in place of the actual field name.

Navigation Pane

In Access, a pane to the left of the database window that displays all the objects in the database.

form controls

In Access, elements in a form that makes it possible to enter data; such as text boxes, scroll bars, or check boxes.

Field properties

In Access, settings and characteristic that determines the way data is stored, displayed, or manipulated in a field, such as the length of a text

field value

In Access, the data entered in a field for a particular record.

row selector

In Access, the small box to the left of each record that when clicked selects selects the entire record.

field description

In a database table in Access, a descriptive comment that explains the purpose of a field, to help the person entering data into it.

field names

In an Access table, column headings in a table that indicate the type of information entered for each field value text box.