Computer Tutoring Logo
Est. 2002
Menu Button

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
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:

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 training special offer emails
I would like to be notified about free software hints and tips

Testimonials

3D Entertainment Group

"Really well delivered, able to answer all questions."

"Thorough but not too complicated that couldn't follow along."

"Very well presented and broken down into easy to manage sections bearing in mind such a complicated application."

SELEX Sensors & Airborne Systems

"I felt that the one zone nature of the course enabled the trainer to answer questions and use examples specific to my needs."

CMG Rescue Services

"Professional whilst enjoyable."

"Excellent value for money."

National Police Improvement Agency

"Very comprehensive, all queries answered. Came away feeling confident."

"Very well explained, by a very enthusiastic trainer."

"Easy to understand, relaxed and informative."

Microsoft Access 2010 Training Course Intermediate

In this Access training course you will improve and customize tables, queries, forms and reports, and share Access data with other applications. You will learn streamline data entry and maintain data integrity, join tables to retrieve data from unrelated tables, create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries. You will also learn how to improve forms, customize reports to organize the displayed information and produce specific print layouts and share data between Access and other applications.

Course Duration: 1 Day

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

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.

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
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:

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 training special offer emails
I would like to be notified about free software hints and tips





Microsoft Access 2010 Training Course Intermediate