An organized collection of information about a subject.

A piece of data stored about each record in a table.

A view of a table or query's data, designed for lookup or input of records.

The field that uniquely identities each record in a table.

A specification that describes how a set of records should be sorted, filtered, calculated, or presented.

The stored information about one particular instance, such as one person'd data in an address book.

A field for which each records must contain an entry.

A field for which each record must contian a unique entry.

To add protection to a file so others cannot read it.

A mode in which only one user at a time can work with a file.

A spreadsheet-like view of a table in which each record is a row and each field is a column.

Database management system

A computer program that includes both the stored database and the tools requred to use the database.

A database that contains (or can contain) multiple tables with relationships between them.

To set a field so that it always remains onscreen, in the left-most position, as you scroll left-to-right.

To order copies of a multipage doucment so that complete sets are together.

A series of dialog boxes that guide you step-by-step through a process.

Alternate text that appears instead of a field's actual name in datasheets, forms, and tables.

Two or more fields that collectively define the primary key by unique combinations of their values.

An optional brief comment or explanation of a field.

In Table Design view, the gray rectangle to the left of the field name.

A database that contains formattin, styles, and sample text that you can use to create new databases.

Help

Options

focusNode

Didn't know it?
click below

Knew it?
click below

Don't Know

Remaining cards (0)

Know

retry

shuffle

restart

0:00

Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

Normal Size Small Size show me how

Access - Chapter 1

Chapter 1 Vocabulary

Question	Answer
Database	An organized collection of information about a subject.
Field	A piece of data stored about each record in a table.
Form	A view of a table or query's data, designed for lookup or input of records.
Primary key	The field that uniquely identities each record in a table.
Query	A specification that describes how a set of records should be sorted, filtered, calculated, or presented.
Record	The stored information about one particular instance, such as one person'd data in an address book.
Required Field	A field for which each records must contain an entry.
Unique Field	A field for which each record must contian a unique entry.
Append	To add to the end of.
Encrypt	To add protection to a file so others cannot read it.
Exclusive mode	A mode in which only one user at a time can work with a file.
Datasheet view	A spreadsheet-like view of a table in which each record is a row and each field is a column.
Database management system	A computer program that includes both the stored database and the tools requred to use the database.
Relational database	A database that contains (or can contain) multiple tables with relationships between them.
Freeze	To set a field so that it always remains onscreen, in the left-most position, as you scroll left-to-right.
Collate	To order copies of a multipage doucment so that complete sets are together.
Wizard	A series of dialog boxes that guide you step-by-step through a process.
Caption	Alternate text that appears instead of a field's actual name in datasheets, forms, and tables.
Composite key	Two or more fields that collectively define the primary key by unique combinations of their values.
Field description	An optional brief comment or explanation of a field.
Field properties	Characteristics of a field.
Field selector	In Table Design view, the gray rectangle to the left of the field name.
Template	A database that contains formattin, styles, and sample text that you can use to create new databases.

Created by: jmoyer

"Know" box contains:
Time elapsed:
Retries: