Information Technology
 
Access Introduction

>>DESIGNED FOR
This one day introduction to Access is designed for people who will be using databases designed and set up by others, and do not need to create a database. The course will not cover creating a new database table.

>>AIM
By the end of the course, delegates will be confident in using the essential features of
Access to find, change, add and extract information from an existing database.

>>OBJECTIVES
By the end of the course, delegates will be able to:

  • Explain what a database is for, and when they would need one.
  • Explain the component parts of a database are.
  • Enter and alter information in a database.
  • Find required records of information.
  • Use queries to sort and select information in many different ways.
  • Create reports that give professional printed output.

>>PARTICIPANT NUMBERS

This course is run for a maximum of six delegates.

>>TIME TABLE SESSIONS

  1. What is a Database? Looking at a sample database; Working with tables; Finding and changing records in a table; Viewing records in Forms
  2. Queries: Creating queries; Using criteria; Sorting; Editing a query
  3. Creating reports with the report wizard; Creating labels and Merging to Word
  4. Parameter Queries; Queries across related tables
>>REQUIREMENTS
Delegates should be confident in using Windows and a mouse plus one other
Windows based package.

Please note that it is possible to customise your course around an existing database.
Back to courses  
Access Introduction