::
Introduction
::
Database principles
::
Tables
::
Queries
::
Data security
::
Glossary
::
Resources
::
Student Files
:: Contact
:: Back to Main Site
:: Site
Map |
Microsoft Access - Class 1 - Part VII
|
>
Back |
All data is stored in tables, which consist of columns with rows
of data.
Most business problems involve data stored in multiple tables,
joined through keys :
| Primary keys |
data that uniquely identifies each row of the
table (Access calls this KEY) |
| |
|
| Concatenated keys |
keys that use more than one column to gain uniqueness |
| |
|
| Secondary keys |
non-unique data used to sort or improve record
retrieval (Access calls this INDEX) |
| |
|
| Foreign keys |
designate data that is foreign to the table, but
necessary to establish a relationship |
Print this page
|
