Est. 2002

London Skyline

Home Courses Enquiries Online Training Testimonials Locations Prices

Total Price:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

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

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

Ansaldo NES

"Very Informative and great fun! Would Recommend to others"

"Short, intense, but very productive"

"Very informative and interesting. A lot of details and facts, looking forward to using the database"

Hewden

"Excellent!"

Handling Information

Print & Desktop Publishing

Locations

Microsoft Access 2007 Training Course Intermediate

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

Intermediate Access Prices from:

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

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

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

Facebook - Computer Tutoring

Twitter - Computer Tutoring

Linked In - Computer Tutoring

You Tube - Computer Tutoring

Pinterest - Computer Tutoring

Q & A

Microsoft Access 2007 Training Course Intermediate