MS Access Intermediate Course

MS Access Intermediate Course summary

Intensive session concentrating mostly on creative queries, to extract data from large data sets to get insight from your data and report it.
The course concentrates on variations and details of creating and running queries using MS Access.
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.

Microsoft Access 2010 and later.

MS Access Intermediate Course Desciption

Session 1: Database Concepts

Tables
Referential Integrity
Table Relationships

Session 2: MS Access Queries

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

Session 3: MS Access Queries

Expression queries
Action queries:
Make Table Queries to create new queries from existing query or tables,
Queries to insert new records
Append queries,
Update queries,
Delete queries.

Session 4: MS Access Importing Data

Importing Data
Exporting Data
Linking Data

Session 4: MS Access Forms

Linking Data Creating Forms
Creating forms, Form wizards
Creating a Navigation Form

Session 4: MS Access Reprts

Brief overview of Creating and viewing MS Access reports

What is included in the MS Access Intermediate Courses:
  • 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.
  • Max group size on this MS Access Intermediate Course is 4.
LOCATIONS
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More
PCWorkshops Manchester
MANCHESTER: 53 Fountain Street, Manchester, M2 2AN
Read More
PCWorkshops Birmingham
BIRMINGHAM: One Victoria Square, Birmingham, B1 1BD
Read More
PCWorkshops Southend-on-Sea
SOUTHEND-ON-SEA: The Forum, Elmer Square, Southend-on-Sea SS1 1NS
Read More
PCWorkshops Milton Keynes
MILTON KEYNES: Exchange House, 494 Midsummer Boulevard, Milton Keynes, MK9 2EA
Read More
PCWorkshops PORTSMOUTH
PORTSMOUTH: Building 1000, Lakeside North Harbour, Western Road, Portsmouth, PO6 3EZ
Read More
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More

Subscribe our Newsletter

Sign up to receive lessons, tips, examples, quizzes and other training materials.