Access Ch. 1
Relational Database
Sophisticated database that stores multiple collections of data that are related to one another.
Table
The database object that stores the data and is the foundation of a database.
Primary key
The field that uniquely identifies a record in a table.
Report
The object that displays fields and records from a table or query in printable format.
Query
The object that retrieves specific data and then displays only that data
Normalization
The process of applying design rules and principles to ensure the database performs as expected
Structure
The underlying design of a table
Object Window
The window area that displays each object on its own tab.
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
Database
An organized collection of facts about people places or things
Objects
Basic parts of a database including tables, queries, forms, and reports.
Field Properties
Characteristics of a field that control how the field displays and how data is entered
Information
Data that is organized in a useful manner
Autonumber
Data type that describes a unique sequential or random number assigned by Access
Currency
Data type that describes monetary value
Short text
Data type that is a combination of text and numbers
Property sheet
Precise changes to the characteristics of selected items
Redundant
Repeated information
Data type
The characteristic that defines the kind of data you can store in a field.
Common field
A field in one or more tables that stores the same data
Record
A table row that contains all of the categories of data relating to one person place or thing
Flat database
A simple database file that is not related or linked to any other collection of data.
Field
A single piece of information that is stored in every record and represented by a column in a table.
Daya
Facts about people places or things
Data sheet view
The Access view that displays data in columns and rows.
Populate
The action of filling a database with records
Record selector box
The box at the left in Datasheet View that allows you to select an entire record