Click here to send this to a colleague or friend.

Microsoft Access

Learn how to manipulate data and create reports on Microsoft 2007 and 2010

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 2007 and 2010 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.

All Front Foot Microsoft workshop presenters are Certified Master Microsoft Application Specialists.
shadow

shadow
Register now for this workshop
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.
Event Information:
Date: 15th and 16th February 2012 at Benvenuto Conference Centre in Randburg

19th and 20th March 2012 at Benvenuto Conference Centre in Randburg

28th and 29th May 2012 at Benvenuto Conference Centre in Randburg

30th and 31st July 2012 at Benvenuto Conference Centre in Randburg

17th and 18th September 2012 at Benvenuto Conference Centre in Randburg
Time: 09:00 AM
Venue: Benvenuto Conference Centre in Randburg
Map: View map
Duration: 2 Days
Cost: R4 700.00 excl VAT
R5 358.00 incl VAT
Surcharge: R50 (incl VAT) per delegate, per day for Strict Halaal and Kosher Meals

Upcoming Events:
Visit our events calendar for more information.

Upcoming Workshops:
Visit our workshops calendar for more information.
shadow
Discount:
Group Bookings:
Group Bookings of 2 or more delegates from the same company qualify for a 10% discount
shadow
Out-of-town Delegates:
If you attending from out-of-town, we will give you a 15% discount on the cost of the workshop.
Contact us to find out more
shadow

Bookings:

Contact Adele on
011 880 4808 or email for
Bookings and Enquiries
Website | Email
Screenshot: http://www.frontfoot.co.za
shadow
Microsoft workshop presenters are Certified Microsoft Office Specialists; We offer on-going email support after attending any Microsoft workshop for an unlimited period of time; Workbooks and workshops are aligned to the prevailing Unit Standard; Front Foot provide business training to business people; Training is held at premium training venues.
© Copyright Frontfoot & The Decision Makers Database 2011. All rights reserved.
Confidentiality Note: This message is for the sole use of the intended recipient(s) and may contain confidential and legally privileged information. Any unauthorised review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by replying and destroy all copies of the original message.