Microsoft Access 2010 Training (Intermediate Level)

Other levels, years and dates are available upon request


This course is designed for delegates who are already aware of the basic features of Microsoft Access, but wish to expand their knowledge to incorporate some of the more beneficial points.


Key Topics

    Recap On Basics

  • Creating a Basic Database, Query, Form, Report 

    Table Relationships

  • Creating Additional Tables

  • Quick Links Via Queries

  • Permanent Relationships

  • Types of Links

  • Referential Integrity

  • Created Linked Queries/Forms/Sub Forms/Reports


    Forms Section

  • Creating a Simple Form

  • Adding Text Boxes/Labels

  • Drawing Lines/Squares

  • Inserting Page/Form Headers/Footers

  • Inserting Dates

  • Using Combo Boxes/Scroll Bars/Pages/Command Buttons

    Query Section

  • Example Criteria

  • Creating/Editing  a Simple Query

  • Using Parameters/Calculations

  • Action/Crosstab Queries

  • Find Duplicate/Unmatched Queries


    Reports Section

  • Printing Tables & Forms Using Reports

  • Auto Reports

  • Modifying Reports

  • Using Mailing Labels

  • Sorting & Grouping

  • Using Calculations


    Importing/Exporting Data

  • Importing/Exporting/Linking Data into Access/Word/Excel/Mail Merges



  • Creating/Making a Switchboard “Go Live”

  • Setting a Password


  • Price: £225.00
  • Duration: 1 Day
  • Start Time: 9.30am
  • End Time: 4.30pm

Dates available upon request.