Est. 2002

London Skyline

Home Courses Enquiries Online Training Blogs Locations Prices

Cost Calculator

Price Per Head:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

Tell Me More

Testimonials

British Antarctic Survey

"Our bespoke training was really good and invaluable. We learnt a great deal about Microsoft Access and databasing techniques. Both aspects are so important to our work. Simon, our trainer, was a real expert and he made the two days interesting and enjoyable. Thank you so much"

Pepsico

"Only a small group so really great training interaction. Well prepared and friendly, made what could of been a slightly dull topic enjoyable."

"Very good. I have never used Access before but feel confident that I will be able to set up and manage databases going forward."

Handling Information

Print & Desktop Publishing

Virtual Meetings

Locations

Microsoft Access 2007 Training Course Intermediate

Microsoft Access 2007 Overview

You will be familiar with the basic skills needed to work with Microsoft Office Access, including creating and working with Access tables, relationships, queries, forms, and reports. Now in this hands-on course you will you will consider how to maintain data consistency, how to customize database components ( improve queries, forms, and reports), and how to share Access data with other applications.

Course Duration: 1 Day

Course Outline

Controlling Data Entry using Microsoft Access 2007

Restrict Data Entry Using Field Properties
Establish a Pattern for Entering Field Values
Create a List of Values for a Field

Joining Tables in Access 2007

Create Query Joins
Join Unrelated Tables
Relate Data Within a Table

Creating Flexible Queries in Access 2007

Set Select Query Properties
Create Parameter Queries
Create Action Queries

Improving Forms using Access 2007

Design a Form Layout
Enhance the Appearance of a Form
Restrict Data Entry in Forms
Add a Command Button to a Form
Create a Subform

Customizing Reports in Access 2007

Organize Report Information
Format the Report
Set Report Control Properties
Control Report Pagination
Summarize Report Information
Add a Subreport to an Existing Report
Create a Mailing Label Report

Sharing Data Across Applications in Access 2007

Import Data into Access
Export Data
Analyze Access Data in Excel
Export Data to a Text File
Merge Access Data with a Word Document

Classroom based Intermediate Access Prices from:

If you are interested in this classroom based course but want to know the price beforehand then use the following form to calculate how much.

If you are interested in this course fill out the following form for further details:

Check out all of our Microsoft Access Training

You may also be interested in the following training courses:

Microsoft Access 2016 training course beginners

Microsoft Access 2016 training course intermediate

Microsoft Access 2016 training course advanced

Organising data training course beginners

Microsoft Access 2007 Training Course- Advanced

Microsoft Access 2007 Level 4 Training Course- Advanced

Microsoft Access 2007 Training Course- Beginners

Microsoft Access 2007 Training Course- Intermediate

Microsoft Access 2010 Training Course- Beginners

Birmingham | Brentwood | Cambridge | Coventry | Guildford | Ipswich| Leicester | Luton | Milton Keynes | Northampton | Norwich | Oxford | Peterborough | London (Chiswick) | London (Hammersmith) | London (Heathrow) | London (Kensington) | Reading

Q & A

Easy Spreadsheet Accounts

Microsoft Access 2007 Training Course Intermediate