23 terms

Microsoft Access

STUDY
PLAY
Database file
The file that contains all objects of your database.
Navigation Pane
The listing of all the objects in the database.
Object
A table, form, query, report, or other item used to store and manage data in a database.
Datasheet view
The view of a table that shows you the data in each record. Like a spreadsheet, the datasheet shows rows (records) and columns (fields).
Field Edit Mode
A mode in which the insertion point displays in a selected field.
Navigation Mode
A mode in which the entire field entry is highlighted in a selected field.
Sort
To arrange a list of words or numbers in ascending or descending order.
Ascending
To sort from the smallest to the largest (from A to Z and from 0 to 9).
Descending
To sort from the largest to the smallest (from Z to A and from 9 to 0).
Table
A collection of database fields designed to be used together.
Datasheet
A grid showing the data in a table, with the field names as column headings and the records in rows beneath them.
Form
A window showing the data in a table with one record's fields appearing at a time in individually labeled boxes.
Dialog box launcher
A button in the bottom-right corner of a group on a tab of the Ribbon, which when clicked opens a dialog box or task pane.
Preview
To produce a screen view of what a printed page will look like.
Primary Key
A field that uniquely identifies a record in a table.
Blank Database
A database file that does not yet contain any objects (that is, tables, queries, reports, and so on).
Template
A predefined group of settings for creating a new database, including what tables will be included, what fields will be used.
Table Design View
A view in which you can add, edit, and delete fields from the table, change field types and descriptions, set a primary key, and more.
Data Type
The type of data that a particular field is designed to hold. Common types in include Text, Number, Date and Memo
Field Description
An optional brief comment of explanation of a field. The field description appears in the status bar at the bottom of the window when its field is selected.
Field properties
Characteristics of a field that determine how long an entry can be, how it is formatted, and whether there should be a default entry.
Primary key
A field that uniquely identifies a record in a table.
Composite key
Two or more fields that collectively define the primary key by unique combinations of their values.