Trusted Training Partners

Quick Look Course Summary:Microsoft Access 2010 Intermediate Course
  • Next Public Course Date:

  • Length: 1 day(s)

  • Price (at your venue): 1 Person R 4,811 EX VAT 3 Person R 3,654 EX VAT 10 Person R 2,719 EX VAT

  • Certification Type:Accredited

  • Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.

Get Free & personalised
Training Advice

    Accredited programme. This course is aligned to SAQA unit standard(s) US116936 (NQF3) and US117927 (NQF4) – Use a GUI-based database application under the National Certificate: Information Technology – End User Computing (SAQA ID 61591), registered for new enrolment until 30 June 2026. Complete the accredited assessment to earn the unit-standard credits.

    Microsoft Access 2010 Intermediate Course

    Course Introduction

    In the intermediate Access course we teach students the more advanced functions of Access. At the end of the course students will understand how to maintain data integrity, how to create custom forms, successfully create queries and create custom reports.

    Course Outline

    1. Maintaining Data Integrity
    Type of Data
    Restricting the Amount of Data
    Data Formatting
    Validation Rules
    Restricting Data to Values in Lists
    Restricting Data to Values in Other Tables

    2. Creating Custom Forms
    Customising Wizard created Forms
    Adding Controls
    Adding Sub forms
    Using E-Mail forms to Collect Data

    3. Creating Queries
    Creating Queries using Wizard
    Creating Queries Manually
    Summarising Data from Queries
    Performing Calculations from Queries
    Updating Records from Queries
    Deleting Records Using Queries

    4. Creating Custom Reports
    Creating Reports Manually
    Customising Report Content
    Adding Sub-Reports

    Course Duration

    1 day/s

    Who should attend

    This course is intended for intermediate users of Microsoft Access.

    **Quote does not include Any Exam Fees (if applicable)

    IMPORTANT ACTION: Do Not Wait To Improve Your Skills.  

    Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal

    Frequently Asked Questions

    Is this course accredited?

    BOTI offers a mix of SETA-accredited, internationally-certified (VMEdu) and non-accredited skills-programme courses. Please confirm a specific course's accreditation status with us when you enquire. All delegates receive a certificate of completion.

    Can this course be delivered in-house at our premises?

    Yes. Every BOTI course can be delivered on-site at your offices anywhere in South Africa, or at a scheduled public venue, and can be customised to your team and industry.

    How do I book or get a quote?

    Use the enquiry form on this page for a tailored quote, or call 011 882 8853 / email [email protected]. The course length and next public course date are shown in the Quick Look summary.

    Can this training count towards our B-BBEE scorecard?

    Yes - skills development training can contribute to your B-BBEE scorecard, and where learnerships apply you may also access SETA grants and the Section 12H tax allowance. Ask us how to structure it for maximum points.

    Do you tailor the training to our industry?

    Yes. Our training is built around your business, using practical, real-world examples relevant to your team and sector.

    Realize incredible savings by sending more delegates

    Do you want to save costs by doing training at your premises?

    Save costs by providing own laptop

    Region *

    Please Contact Us Now - We Will Respond in 15 Minutes


      Administrative Contracting Accredited

      Software & IT Accredited

      Accredited Courses Unit Standard

      Leadership & Management Accredited

      Process Improvement Accredited

      Soft Skills Non-Accredited

      Leadership & Management Non-Accredited

      Software & IT Non-Accredited

      Top Rated

      Business Optimization Training Institute (Pty) Ltd · 97 Greenlands Crescent, Sunningdale, 2192, Johannesburg · Reg 2017/286086/07 · VAT 4770208033 · Level 1 B-BBEE Contributor · 011 882 8853 · Facebook · LinkedIn
      © 2026 Business Optimization Training Institute. All rights reserved. · Privacy Policy