Queries Used to ask questions about the data. Reports A printout of the data in a customised format. 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.