Tables are the fundamental feature of a database, they are where all the information is stored and therefore where all the information can be accessed and changed accordingly by the user. Tables are simple to create and can vary between 1 field to 100 fields. A table contain fields which are what the user fills in under the relevant record what information needs to be included in that table. All tables are saved under one project. Also records are what the user uses to identify what sort of information needs to be inputted into the fields of that record, the technical word for a row in a table is called a tuple but we wont confuse you any further. A project is a collection of tables, forms and queries which the user wants to store all in one place. An example project can be found below:
• Ref: From Week 20 lecture – Database development. Yang He, Accessed 20/03/11