Access Chapter 1
Table
The database object that stores the data, and which is the foundation of an Access database.
Primary key
The field that uniquely identifies a record in a table is known as the:
Report
The object that displays fields and records from a table or query in a printable format is a:
Query
The object that retrieves specific data and then displays only the data that you specify is a:
Structure
The underlying design of a table is referred to as the:
Navigation Pane
The window area that organizes the database objects and from which you open objects.
Append
To add on to the end of an object, such as to add records to the end of an existing table, is to:
Database
An organized collection of facts about people, events, things, or ideas related to a specific topic.
Field properties
Characteristics of a field that control how the field displays and how data is entered are:
Information
Data that is organized in a useful manner.
Field
A single piece of information that is stored in every record and represented by a column in a table.
Record
A table row that contains all of the categories of data pertaining to one person, place, thing, event, or idea.
Data
Facts about people, events, things, or ideas.
Redundant
Information repeated in a database in a manner that indicates poor design is said to be:
Datasheet view
The Access view that displays data in columns and rows like an Excel worksheet is:
Populate
The action of filling a database with records.
Objects
The basic parts of a database; for example tables, forms, queries, and reports.
Data type
The characteristic that defines the kind of data you can enter into a field is the: