• Understanding the MS Access database
• Using existing MS Access databases
• Find, sort and filter records
• Querying data
• Working with reports
• Data types
• The primary key
• Creating and amending forms
• Creating a filter
• Using report wizards
• Creating a simple MS Access database

Who is it for? This course is for delegates who need to build, use or change their own simple MS Access database or need to understand how a MS Access database is used.

An Access database is used to hold data about things that exist in the real world, for example people in a personnel system. This course will equip you with the necessary understanding and hands-on skills to build a simple MS Access database.

You will learn how to set up tables to hold your data and how to link these tables together in a meaningful manner. You will then learn how to use filters and queries to retrieve useful data from your tables.