Live Virtual Classroom

MS Access Intermediate Course

Data Analysis with Access Queries, Private 1-to-1.

This Access Course concentrates on using creative queries, to extract data from large data sets to get insight from your data and report it.
Learn and explore various query techniques from where clauses, to aggregation, joins and more.
This private style tuition helps to maximise the value you get from the day.

Who Should Attend:
People who need to do in-depth data analysis.

Microsoft Access 2010 and later.

MS Access Intermediate Course description

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 Reports

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
  • MS Access Intermediate Course notes
  • Practical MS Access Intermediate Course exercises, MS Access Intermediate Code Samples/ MS Access Intermediate Course Revision work
  • After the course, 1 free session for questions online MS Access Intermediate Course via Gotomeeting.com.
  • Max group size, online and in classroom, on this MS Access Intermediate Course is 4.
Special Offers
PCWorkshops London
Special Offer on the 'Visual Data with Power BI' Webinar
Read More
PCWorkshops Manchester
Special Offer: Python 3-weeks online Boot Camp
Read More
PCWorkshops Birmingham
Special Offer on the 'SQL Queries in 1-Day' webinar
Read More
PCWorkshops Southend-on-Sea
Special Offer on the 'Java Cross-Over for Coders' Webinar
Read More

Request a Free Webinar Demo

Try a 30 minutes webinar free. Choose you own topic from our course list.