Course overview
Course Aims (Access 2003, 2007, 2010, 2013, 2016 and Mac)
This course is offered one-to-one, for individual attention to your requirements. This private style tuition helps to maximise the value that each delegate gets from the day.
This course will help you to structure, import, manage and query your data effectively. Advanced forms. Macro buttons, linking forms and Menu systems. Power Queries.
Study method
- Online
- Blended
- In-class

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.
Enrol in a course today to unlock exclusive deals.
Duration study load
- 2 Days
Course features
- MS Access Advanced course certificate on completion (assessment based)
- MS Access Advanced course notes
- Practical MS Access Advanced course exercises, MS Access Advanced course homework/MS Access Advanced course revision work
- To assist after the course, 1 free session for questions online MS Access Advanced course via Skype or Teamviewer
Subjects
- Database Design: Planning the Database and its Purpose
- Referential Integrity
- Creating Tables, Data Types, Primary Keys
- Table Relationships
- Importing Data, and the Planning of Data Migration
- An Introduction to SQL
- Brief Query Revision
- Using Subforms
- Creating a Navigation Form
- Restricting Form Entries – Controlling Input
- Exporting a Form
- Other Form Tasks
- Understanding SQL
- Using the SELECT Statement
- Using Subqueries
- Using SQL Joins
About PCWorkshops
PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.
We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.
Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.