How can we help?

You can also find more resources in our Help Center.

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.