MS Access Database, Intermediate, in-depth, queries course

MS Access Database Intermediate Course, Private 1-to-1

Course summary

This intensive session concentrates mostly on creative queries, to extract data from large data sets to get insight from your data and report it. This private style tuition helps to maximise the value you get from the day.

Course Outline

Tables, Referential Integrity , Relationships

Revision:

Select Queries, selecting columns and using where clauses Multiple table queries, joining tables using query design In null, is not null Wildcards Totals Queries Expression queries

Action queries:

Make Table : Queries to create new queries from existing query or tables, inserting queries to insert new records

Append queries,

Update queries

Delete queries

Data Importing

Data Exporting

Data Linking Data

Creating Advanced Forms

Creating forms, Form wizards Creating a Navigation Form

Reports

Creating Advanced reports

Macros and Menus

Macros and menu buttons,

creating a menu system

MS Access Intermediate Course Certificate

MS Access Intermediate Course notes

1 free online questions session after the course.