Access 2007 Introduction Course

Testimonials

Some feedback from recent courses:

"Very well communicated and delivered."
Simon B, IT World
[Access Introduction]

"Overall the course was very well structured and informative. Each individual area covered was well presented and explained. Any extra questions were answered well by the trainer."
Christopher Taylor, ABN AMRO Bank NV
[Access Introduction]

"Good equipment, friendly atmosphere, very comfortable environment."
Jonathan D, GfK Media
[Access Introduction]

London and UK wide

Microsoft Access 1 day instructor-led. Courses never cancelled: Guaranteed. From £75 (list price £225)

Training formats available

on a public schedule at one of our London training venues
on-site at your company office UK wide
closed group at one of our London training venues
near-site at a location close to you
bespoke one-to-one basis
tailored training courses to your requirements

Who is this training course suitable for?

Our Microsoft Access 2007 Introduction course is suitable for complete beginners to Microsoft Access.

Prerequisites

A working knowledge of Windows is required, or our Microsoft Windows Introduction course. No experience of MS Access is required.

Benefits

At the end of this course you will have a good working knowledge of microsoft access 2007 training basics. You will feel more confident using Access, and be able to create a database from scratch. Understanding and using tables, fields and records and the rules for entering your data is the foundation from which you can create simple queries, use forms and, ultimately create reports.

After completing this course you will be prepared to attend the Access 2007 Intermediate training course.

Course Syllabus

What's new in Access 2007

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

Public Schedule - Pricing and Availability

Version	Date	Location	Places available	Book	Next place rate (£)
Access Introduction 2007 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	2009 Aug 24 Mon	Bloomsbury	6	book now	£224	£224
2007	2009 Oct 23 Fri	Bloomsbury	10	book now	£75	£210
2007	2009 Dec 21 Mon	Bloomsbury	10	book now	£75	£210
2007	2010 Jan 25 Mon	Bloomsbury	9	book now	£75	£210
2007	2010 Feb 22 Mon	Bloomsbury	10	book now	£75	£210
2007	2010 Mar 22 Mon	Bloomsbury	10	book now	£75	£210

"What do I get on the day?"

Microsoft qualified trainers with industry relevant experience
Modern air conditioned training suite, flat screen PC's, 1 per delegate
Lunch provided in a comfortable and relaxed setting
Comprehensive course material and files to take away
What do I get on the day? - More information

What is Microsoft Access?

Microsoft Access is a desktop database application, packaged with Microsoft Office Professional. Unlike Excel, Access is able to work with millions of records, allowing large databases to be created, updated, searched and reported on by multiple users. From simple data capture to complex automation and user interfaces, Access brings all the powerful functionality of a complete database, without the need for expensive servers and administration.