Computer Tutoring Logo

Cost Calculator

Training delivery
Number of 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:

Number of 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 2010 Training Course Intermediate Leicester

Leicester Intermediate Microsoft Access 2010 Course Overview

Intermediate Microsoft Access 2010 Training Course training course Leicester

Leicester boasts a multicultural atmosphere and is famous for its association with King Richard III.

1st Floor, Gateway House
Grove Business Park
Enderby
Leicester
LE19 1SY
United Kingdom

The centre at Grove Park is conveniently located immediately off the junction with the M1 and M69 Motorways. The central location provides an ideal base for not just Leicester companies but also national businesses looking for an accessible UK base. Leicester City Centre is a 10 minute drive and the motorways are less than 5 minutes away. A great venue for your Intermediate Microsoft Access 2010 Training Course.

Alternatively if you live in and around Leicester and wish to have your training on-site the we can provide all the equipment, included laptops and projector, required. All we ask is that you provide a little space for the trainer to set up.

There are many other computer training courses in Leicester. Please take the time to look through them.

Course Duration: 1 Day

Complete Course Outline

Controlling Data Entry using Microsoft Access 2010

  • Constrain Data Entry Using Field Properties
  • Establish Data Entry Formats for Entering Field Values
  • Create a List of Values for a Field

Joining Tables using Access 2010

  • Create Query Joins
  • Join Tables with No Common Fields
  • Relate Data Within a Table

Creating Flexible Queries in Access 2010

  • Set the Select Query Properties
  • Retrieve Records Based on Input Criteria
  • Create Action Queries

Improving Forms using Access 2010

  • Restrict Data Entry in Forms
  • Organize Information with Tab Pages
  • Add a Command Button to a Form
  • Create a Subform
  • Display a Summary of Data in a Form
  • Change the Display of Data Conditionally

Customizing Reports using Access 2010

  • Organize Report Information
  • Format Reports
  • Control Report Pagination
  • Summarize Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report

Sharing Data Across Applications in Access 2010

  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge