Advertisement Upgrade to remove ads

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.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set