MS Access Intermediate Course

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.

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 5: MS Access Forms

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

Session 6: MS Access Reports

• Brief overview of Creating and viewing MS Access reports