Access 2007 Introduction Course

Testimonials

Some feedback from courses in the last 18 months:

Excellent foundation for developing skills in Microsoft Access.

Alex Moore
Dimensional Fund Advisors
Access Introduction

All-round really good, covered everything I needed to know and gave me a good working knowledge of Access.

Daniel Cowley
Audiences London
Access Introduction

Enjoyed the day's training and would definitely consider using the training provider again.

Dan Pounder
Extreme Music Library Ltd.
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	Mon 22 Mar 2010	Bloomsbury	3		£224	£225
2007	Fri 16 Apr 2010	Bloomsbury	8		£177	£182
2007	Thu 3 Jun 2010	Bloomsbury	9		£110	£115
2007	Wed 21 Jul 2010	Bloomsbury	10		£75	£80
2007	Mon 23 Aug 2010	Bloomsbury	10		£75	£80
2007	Tue 5 Oct 2010	Bloomsbury	10		£75	£80
2007	Tue 16 Nov 2010	Bloomsbury	10		£75	£80
2007	Tue 14 Dec 2010	Bloomsbury	10		£75	£80

"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.