Computer Tutoring Logo
Est. 2002
Menu Button

Cost Calculator

Training Delivery
Number Students?
Laptop hire?
Offsite training?

Course Price: £ *
Price Per Head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

Live Online Face-to-Face
First Name:

Last Name:

Email:

Tel:

Location:

Num Students:
First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.
I would like to receive software tips and special offers

Testimonials

Handelsbanken

I am very impressed with the training. My access skills are very much self taught and I was unsure about whether the level of the course would be right. The training was delivered in a really clear manner and at the right pace. Thank you very much to Richard for the course. I would thoroughly recommend it.

Blaby District Council

"I found the training session really interesting as I use Access daily and had no idea on how much it actually can do. Simon is a fantastic trainer and takes his time explaining all the background so you get to understand better, he is thorough and has the patience of a saint. I would highly recommend anyone considering this training to consider going booking Simon and his team."

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

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.

Training Delivery
Number Students?
Laptop hire?
Offsite training?

Course Price: £ *
Price Per Head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

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

Live Online Classroom
First Name:

Last Name:

Email:

Tel:

Location:

No. Students:

First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.

I would like to receive software tips and special offers





Microsoft Access 2007 Training Course Intermediate

Computer Tutoring takes your privacy seriously and collects essential information such as your name, email, and course preferences to facilitate our services. Additionally, we use cookies to personalise your experience and for Google Ads personalisation, which helps us deliver more relevant advertising to you.

We do not share your personal data, except for specific use-cases like payment processing via PayPal and sending you updates via Mailchimp, if you've opted in for those services. Our site may also use Google Analytics to improve user experience and features links to other websites. Please be aware that Google's Privacy Policy may differ from ours.

We do not store your credit/debit card details. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.

By using our website, you consent to our use of cookies for the purposes outlined above.

For more details, please read our full Privacy Policy.