Database Concepts

Database concepts and terminology
Exploring the Access environment
Planning and designing databases
Getting help
Closing a database and Access

Access Basics

Exploring tables
Examining queries
Exploring reports

Creating Databases

Creating a database
Using the table wizard
Working in design view

Working with Fields and Records

Changing the design of a table
Adding and deleting records
Finding and editing records
Sorting and filtering records

Querying Tables

Creating and using queries
Modifying query results and queries
Using calculations in queries

Creating and Using Forms

Creating forms by using AutoForm
Using the form wizard
Using design view
Finding, sorting and filtering records

Creating and Using Reports

Using the report wizard and queries
Creating, modifying and printing reports

Importing, Exporting and Linking Objects

Importing Access objects
Exporting Access objects
Linking Access objects

Training is held in our modern, comfortable, air-conditioned suites

Modern-spec IT, fully networked with internet access

"What do I get on the day?"

Learning tools

Breaks and timing

Courses start at 9:30am.
Please aim to be with us for 9:15am.
Joining information (how to get to our venues)

In-course handbook

Contains unit objectives, exercises and space to write notes

Refreshments

Available throughout the day:

• Hot beverages
• Clean, filtered water
• Biscuits

Reference material

Available online. 100+ pages with step-by-step instructions

Lunch

Lunch is provided at a local restaurant or pub. Browse the sample menus:

• Bloomsbury
• Limehouse
• Southwark

24 months access to Microsoft trainers

Your questions answered by Microsoft qualified trainers online.

• On a public schedule at one of our
  London training venues.
• On-site at your company office UK wide
• Near-site, at a location close to you
• Tailored courses to your requirements
• Consultancy