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

"Probably the best course I have been on. Very thorough and entertaining."

Cancer Research UK

"The best two days training I have ever had. Would definitely recommend and use again."

Surrey Heath Borough Council

"Very helpful, knowledgeable and responsive trainer."

Westminster University

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