Click here to send this to a colleague or friend.

Microsoft Access

Microsoft Office version 2013, 2016 & Office 365

Learn how to manipulate data and create reports

Attend this exciting workshop and discover how Microsoft Access can make anything you do with databases child's play; and uncover the many practical features of Access that can be incorporated into your everyday work enviroment. Access data files more simply than ever before

Whether you're processing client records, stock items, or any other information you need, Microsoft Access will allow you to access data files more simply than ever before.

Learn how to create and work with databases

With emphasis on the creation of queries and reports, you will learn everything you need to know to manipulate records – in fact everything you need to know to master the uses of Microsoft Access.



Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the South African Qualification Authority Act.

Our Microsoft workshop presenters are Microsoft Certified Trainers and Microsoft Certified Technology Specialists

Front Foot is a Majority Black-Owned Level 2 EME – 125% Recognition

Register now for this workshop

Contact Adele on 011 867-7299

or email

Day One

  • Module One
    • Understand RDBMS
    • Tour Access
  • Module Two
    • Access Forms
    • Add and Delete Records
    • Sort Records
    • Display Record sets
    • Update Records
    • Run a Report
  • Module Three
    • Table Relationships
    • Primary and Foreign keys
    • Subdata sheets
  • Module Four
    • Create select queries
    • Add criteria to queries – comparison and conditional operators
    • Calculated fields
    • Record Grouping and Calculations
  • Module Five
    • AutoForm
    • Form Wizards
    • Modify the design of forms
  • Module Six
    • Auto reports
    • Reports wizard
    • Calculated fields
    • Auto Format
    • Report Width

Day Two

  • Module One
    • Plan a database
    • Normalization
  • Module Two
    • Database templates and wizards
    • Table wizard
    • Table relationships (1-1 and 1- many)
  • Module Three
    • Field properties
    • Input masks
    • Input masks
  • Module Four
    • Table filters
    • Query joins (inner and outer joins)
    • Calculated fields
    • Unrelated tables
    • Self join
shadow shadow

Who should attend?

  • Financial Managers
  • Database Managers
  • Office Administrators
  • Personal Assistants
  • Marketing Managers
  • Anyone who needs to keep a list – such as of clients, telephone lists, stock items, inventories, catalogue of products – or any other data that needs to be stored and retrieved quickly and efficiently using their own criteria, will find this course extremely interesting

Training approach

Our courses use interactive tools that allow learners to learn by doing.

The experience for learners is fun, rewarding, lasting and integrative, whilst employers are assured of a high return on investment in training.

Front Foot courses are compiled and presented by subject matter experts
and industry specialists to ensure the highest and most current standard of excellence in all our workshops and training
Event Information:
Date: 3rd & 4th November 2020 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

1st & 2nd December 2020 at Benvenuto Conference Centre in Randburg

18th & 19th January 2021 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

10th & 11th February 2021 at Benvenuto Conference Centre in Randburg

Map: View map
Duration: 2 Days
Cost: R4 700.00 excl VAT
R5 405.00 incl VAT
Surcharge: Strict Halaal and Kosher meals carry an additional surcharge

Upcoming Events:
Visit our events calendar for more information.

Upcoming Workshops:
Visit our workshops calendar for more information.
10% discount for two or more delegates
10% discount if you attend two or more workshops
15% discount for four or more delegates

In-house at your offices
25% discount for 5 or more delegates
30% discount for 8 or more delegates
35% discount for 10 or more delegates

We provide laptops for in-house computer-based training sessions