Get Access Course prices, dates and book
MS Access Database Intermediate Course
- Data Analysis with Access Queries, Private 1-to-1
Course summaryCourse Aims (Access 2010 and later) Intensive session concentrating 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.
Who Should Attend People who need to do creative and in-depth queries of datases.
Table Relationships Queries
Select Queries, selecting columns and using where clauses
Multiple table queries, joining tables using query design
In null, is not null
Make Table Queries to create new queries from existing query or tables,
Inserting queries to insert new records
Delete queries Data
Linking Data Creating Forms
Creating forms, Form wizards
Creating a Navigation Form Creating reports
Also included with MS Access Intermediate:
MS Access Intermediate Course Certificate on completion (assessment based)
MS Access Intermediate Course notes
Practical MS Access Intermediate Course exercises, MS Access Intermediate Course Homework / MS Access Intermediate Course Revision work
Tea, coffees, but no lunch
To assist after the course, 1 free session for questions online MS Access Intermediate Course via Skype or Teamviewer.