Access chapter 1

Database

A collection of data organized as meaningful information that can be accessed, managed, stored, queried, sorted, and reported.

Relationship

A connection between two tables using a common field.

Selection filter

A filtering method that displays only records that match selected criteria.

Filter by Form

A filtering method that displays records based on multiple criteria.

Datasheet view

A grid that enables you to add, edit, and delete the records of a table.

Object

A main component that is created and used to make a database function, such as a table or form.

Sort

A method of listing records in a specific sequence (such as alphabetically).

Field

A piece of information stored in a table, such as a company name or city.

Template

A predefined database that includes professionally designed tables, forms, reports, and other objects.

Query

A question you ask about the data in your database.

Application part

A set of common Access components that can be added to an existing database.

Database Management System

A software system that provides the tools needed to create, maintain, and use a database

Navigation Pane

An Access interface element that organizes and lists database objects in a database.

Form

An Access object that simplifies entering, modifying, and deleting table data.

Report

An object that contains professional-looking formatted information from underlying tables or queries.

Table

An object used to store data, organizing data into columns and rows.

Record

Complete set of all the fields about one person, place, event, or concept.

Filter

Enables you to specify conditions to display only those records that meet certain conditions.

Primary key

The field (or combination of fields) that uniquely identifies each record in a table.

Design view

View that enables you to create and modify a table design.