Tables Each Access database must contain at least one table. Access can be used as a very simple database with one table, but more often two or more tables are required to store information. If you use several tables, some or all of them can be linked together by creating a relationship. Tables consist of fields and records containing information. A field is represented as a column in a table.
Fields are small items of information such as the surname or the date of birth of a person.
The same field can appear in more than one table in a database which then enables those tables to be linked. Records are represented as a row in a table. A record is a set of information about one particular item. For example one record about a person could contain their title, initials, last name, address, city, postcode and date of birth. Viewing data in a table - This view shows all the information entered into all the fields in the table.