Database Reference
In-Depth Information
Key points
▪
The Access user interface provides intuitive access to all the tools you need to create
and maintain a database.
▪
A database is the computer equivalent of an organized list of information.
▪
Tables are the core database objects. They organize data in columns and rows, called
fields,
and
records
.
▪
In a relational database, tables can be related based on common fields, enabling the
retrieval of information from more than one table at the same time.
▪
The purpose of the other database objects—forms, reports, queries, macros, and
modules—is to interact with one or more tables.
▪
Every database object has two or more views. For example, you view data in a table in
Datasheet view and define how the data is structured in Design view.
▪
If you want to print a database object, be sure the information you need is visible on
the screen before you print.
1