Microsoft Access 2010 Training Course Intermediate Leicester

Course: Microsoft Access 2010 Public Course
Level: Intermediate
Date: 8th August 2012
Duration: 1 Day
Venue: Cambourne (Near Cambridge) Computer Tutoring Venue
Price: £200 + VAT Includes:

1 Day's Interactive Training
1 Months Post Training Support
Comprehensive Manual
Lunch

This course is designed to teach individuals intermediate-level operations of the Microsoft® Office Access® program. 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.

In this course you will improve and customize tables, queries, forms and reports, and share Access data with other applications.

Microsoft Access 2010 Training Course (Intermediate) Outline - Leicester

Controlling Data Entry

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

Joining Tables

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

Creating Flexible Queries

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

Improving Forms

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

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

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

Microsoft-Access-2010-Training-Course-Leicester-Intermediate

Course Duration: 1 Day

Leicester Grove Park

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 & projector, required. All we ask is that you provide a little space for the trainer to set up.

Maybe you would prefer your training at an alternative venue.

To see more details as to our Training Venues click one of the links below: