Access is a relational database, meaning that data is stored in various
'tables' which can relate to one another. For example a table that stores
customer information can relate to a table that stores order information by
using a field in one table as an identifier for the other table; for example
'customer id' in the customers table can relate to a field called 'customer
id' in the orders table. In this fashion you only need to store customer
information in one place (the customers table) instead of having to enter
customer name, address, etc. for each order.
It is possible that the design of your database requires only a single
table. In that case you would be using Access as a flat file application.
