Introduction to Microsoft Access

Duration: 2 Days


This course is designed for new users of Microsoft Access. By the end of the course, delegates will be able to: create tables, enter and change data; sort, and query data using criteria; create basic forms and reports; review and print data from queries, forms and reports.


Delegates need no prior Access experience but should be familiar with the Windows environment. It is also helpful for those attending to have a clear idea of the basic structure of the database system they plan to build after training.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

Introduction to Databases

  • Relational database concepts and terminology
  • Creating a database
  • Displaying object properties

Creating a Table

  • Defining the table structure
  • Defining field types and properties; creating a primary key

Editing Table Data

  • Entering and editing records
  • Table navigation techniques
  • Customising table layout
  • Previewing and printing data; scaling the preview window

Querying Data

  • Creating ‘Select’, ‘Action’ and Parameter and Crosstab queries
  • Entering criteria
  • Creating calculated fields
  • Querying multiple tables


  • Creating forms using Form Wizards
  • Changing the design of forms
  • Creating list and combo boxes for data entry
  • Creating calculated fields


  • Creating reports using Report Wizards
  • Changing the design of reports
  • Sorting and grouping data

Restructuring a Table/Object Management

  • Inserting and deleting fields; renaming and re-arranging fields
  • Changing data types and field properties
  • Renaming, deleting, and copying objects

Opening, Converting and Saving Databases

  • Opening and Converting databases in previous versions
  • Saving databases in previous version

This course is available as a private or customised course. Contact us for further information and to customise this course to your exact requirements:

Phone us: 0208 269 4260Book Now

Related Courses

"Lovely surroundings, easy-going people, interesting learning- brilliant, first time I’ve enjoyed editing!"

Southwest Screen

"Concepts were explained clearly - very much so. What a great instructor! "

Jason Mather

"I just wanted to say a big thank you for yesterday. I really enjoyed the training and we got a lot done. The database looks really amazing, specially with the starter page and the logo. Thanks to Megan & Debra for sorting out the admin side and looking after me. "

Paresh Dudhaiya

© Transmedia . 85 Tottenham Court Road, London, W1T 4TQ  UK . 0208 269 4260       Privacy Policy