MS Access Advanced Course

MS Access Advanced Course summary

This MS Access Advanced Course mostly covering creating advanced MS Access Reports, forms and macros.
Create and amend Advanced Forms and Advanced Reports. Macro buttons.
This assists you to build user friendly forms to facilitate effective navigation, effective data capture and effective viewing and querying data
This course will help you to structure MS Access tables, import and manage your data effectively.

Our private style tuition helps to maximise the value that each delegate gets from the day.

MS Access versions 2007 and later, Mac & PC.

MS Access Advanced Course Desciption

Session 1: Database Concepts

Database design: planning the database and its purpose
Referential Integrity
Creating tables, datatypes, primary keys
Table Relationships
Importing data, and the planning of data migration

Session 2: MS Access Queries

Brief Query revision

Session 3: MS Access Forms

Forms
Using MS Access Subforms
Creating a Navigation Form
Restricting Form Entries - controlling input
Exporting a Form
Other Form Tasks

Session 4: MS Access Reports

Creating MS Access reports
Microsoft Access Macros
Creating command buttons, create menu systems

What is included in the MS Access Advanced Courses:
  • MS Access Advanced Course Certificate on completion (assessment based)
  • MS Access Advanced Course notes
  • Practical MS Access Advanced Course exercises, MS Access Advanced Course Homework / MS Access Advanced Course Revision work
  • Tea, coffees, but no lunch
  • To assist after the course, 1 free session for questions online MS Access Advanced Course via Skype or Teamviewer.
  • Max group size on this MS Access Advanced 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.