MS Access Intermediate Course

From £290 - FAQ's - Included - Course outline - Bespoke Course

MS Access Database Intermediate Course
- Data Analysis with Access Queries, Private 1-to-1

Course summary

Course 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.

Course Outline

Referential Integrity
Table Relationships Queries
Select Queries, selecting columns and using where clauses
Multiple table queries, joining tables using query design
In null, is not null
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 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.

Is this the course for you? Book today and start preparing for the course

PCWorkshops specialises in Coding Courses, Database Courses and MS Project Courses.

Free Examples and Tips