Click here to send this to a colleague or friend.

Microsoft Access

Microsoft Office version 2010, 2013 and 2016

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.

shadow

Accreditation:

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

shadow
shadow
Register now for this workshop


Contact Adele on 011 867-7299

or email adele@frontfoot.com
WHAT WILL BE COVERED ON THIS TWO-DAY WORKSHOP?

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
shadow

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.

shadow
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: 29th & 30th January 2019 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

19th & 20th February 2019 at Benvenuto Conference Centre in Randburg

5th & 6th March 2019 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

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.
shadow
Discount:
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