Microsoft Access is a very powerful relational database application designed to save time and make creating databases easier.
A flat file database is a type of database that stores all the data in a single table or list. Flat files can contain many fields and often contain duplicate data, an Excel list is a good example of a flat file database.
A relational database has multiple tables – each table should only include the data relevant to one subject, such as customer, orders, or items. This means that each table is smaller more efficient and easier to manage. The tables can then be joined or related, each table will share at least one its fields with another table in the database, using one of the following relationships one-to-one, one-to-many, or many-to-many.
When Access tables are related you can analyse and retrieve information from any field in any related table, without the need to duplicate data. Microsoft Access allows you to build tables, forms, queries and reports from the data stored in your related tables.
The course outlines below, will help you to select the correct course for you – or we can can create you a customised course if you prefer!