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.
Tables
Referential Integrity
Table Relationships
Queries 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
Creating Advanced reports
Macros and menu buttons, creating a menu system
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.
Venue:
PCWorkshops at Regus
Golden Cross House 8 Duncannon Street London, WC2N 4JF
Dates