Microsoft Access  

Beginner : This course is designed for people who want to keep track of their customer’s names and addresses, events, products etc. It is for anyone who has never used a database programme.

Course Content Available Dates
  • Introduction


  • Basic Concepts & Database Terminology


  • Introduction to Microsoft Access


  • Tables


  • Finding & Editing Records


  • Filtering and Sorting Records


  • Create a Table using the Table Wizard


  • Create a Table in Design View


  • Queries


  • Creating Select Queries


  • Specifying Criteria


  • Sorting Forms


  • Creating Forms using AutoForm


  • Creating Forms using Wizard


  • Reports


  • Creating Reports using AutoReport


  • Creating Reports using Wizard


  • Summary
  • September 19th 2006
  • October 17th 2006
  • November 21st 2006
  • December 19th 2006
  • January 16th 2007
  • February 20th 2007
  • March 20th 2007
  • April 17th 2007
  • May 22nd 2007
  • June 19th 2007
  • July 17th 2007

  • For Bookings and Enquiries Tel:0115 978 4513
    • enquiries@accordia.org.uk

  • Duration: 1 Day

Intermediate: This course is designed for people who have some basic knowledge of Microsoft Access but wish to improve their knowledge and skills.

Course Content Available Dates
  • Introduction


  • Tables


  • Modifying Table Design


  • Understanding Field Types


  • Modifying Field Properties


  • Primary Keys


  • Queries


  • Creating Parameter Queries


  • Creating Action Queries


  • Summarising Groups of Records


  • Adding Calculated Fields to Query Forms


  • Creating Forms


  • Modifying Forms


  • Modifying Properties


  • Changing Tab Order Reports


  • Creating Reports


  • Modifying Reports


  • Modifying Properties


  • Adding Summary and Calculated Fields


  • Summary
  • September 20th 2006
  • October 18th 2006
  • November 22nd 2006
  • December 20th 2006
  • January 17th 2007
  • February 21st 2007
  • March 21st 2007
  • April 18th 2007
  • May 23rd 2007
  • June 20th 2007
  • July 18th 2007
  • For Bookings and Enquiries Tel:0115 978 4513
    • enquiries@accordia.org.uk

  • Duration: 1 Day

Advance: This course is designed for people who have been using the Access Database programme, but wish to improve their knowledge and skills in order that they can maximise the benefits of the Microsoft Access programme.

Course Content Available Dates
  • Set up Database
     
  • Create a Help Table
     
  • Calculations
     
  • Adding Fields
     
  • Specify the Format of a Field
     
  • Enter Data
     
  • Relationships and joining tables
     
  • Adding a sub form
     
  • Cross tab query
     
  • Assigning a macro to a key stroke
     
  • Using conditional functions
     
  • Program Database to Restrict Information
     
  • Using Global Update Facility
     
  • Increase Field Width
     
  • Print a Report and Evaluate your work
     
  • Understanding relational databases
     
  • Normalising data
     
  • Referential integrity
     
  • Assigning a macro to a control
     
  • Changing data source

 

  • September 21st 2006
  • October 19th 2006
  • November 23rd 2006
  • December 21st 2006
  • January 18th 2007
  • February 22nd 2007
  • March 22nd 2007
  • April 19th 2007
  • May 24th 2007
  • June 21st 2007
  • July 19th 2007

  • For Bookings and Enquiries Tel:0115 978 4513
    • enquiries@accordia.org.uk

  • Duration: 1 Day