Microsoft Access 2010 Training (Intermediate Level)

Other levels, years and dates are available upon request

Overview

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

 

    Switchboard/Security

  • 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.