ACCESS is an aplication that we can use to manage big sets of organized data; in fact, ACCESS is a DATA BASE MANAGER SYSTEM. Using this aplication, we are going to create some objects. The most important are:
TABLES (related tables)
FORMS (to enter data using a friendly interface)
REPORTS (to show data an get a printout)
QUERIES (to look for specific or partial information from one or more related tables)
Tables
A table is a set of rows and columns. Each row is called RECORD (a set of fields for a particular entity), and each column is called field (information item contained into a record).
The relationships between tables can only be ONE TO MANY or MANY TO ONE, never can be many to many.
For example:
