Call our Course Adviser hotline
RIGHT NOW on

COURSE TITLE:

Microsoft Access Training UK

LEVEL:

Introduction : Intermediate : Advanced

COURSE LENGTH:

1 day

COURSE PRICES:

• On Site Price, at your Home or Office: £327 p/person per day. Special Group Rates
• Off Site Price, at our Training Centre: £190 p/person per day. Special Group Rates
• Closed Courses available for groups of 4 or more - Contact Us for a quote or call now on 0870 041 2102

*All prices quoted exclude VAT

COURSE OVERVIEW:

Microsoft Access is an easy to use database package with powerful features for managing and analysing data.

The course outlines below set out the full range of topics you can choose to cover during your on-site training course, and you can build your course around your exact training requirements, or any specific projects you or your staff are working on at present.
You will find that this approach makes our courses the most effective and productive use of your training budget available today.
For off-site courses use the outline below as a guide to the modules available, contact us now for a full off-site course outline and training dates.

Introduction Level

Working with a Relational Database
Identify Uses of a Relational Database
Define Database Terminology
Create a New Database Based on a Template
Examine the New Database

Planning a Database
Identify Database Purpose
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize the Data
Designate Primary and Foreign Keys
Identify Table Relationships

Building the Basic Structure
Create a Blank Database
Create a Table using a Wizard
Compare Datasheet and Design Views
Create Tables in Design View
Create Relationships between Tables

Working with Tables
Modify a Table Design
Work in Datasheet View
Work with Subdatasheets

Creating and Working with Select Queries
Examine a Query
Create a Query using a Wizard
Work in Query Design View
Select Records
Edit Values in a Query Datasheet
Add a Calculated Field to a Query
Perform a Calculation for a Group of Records

Creating and Using Forms
Create AutoForms
Create a Form Using a Wizard
Modify the Design of the Form
Use Forms to Work with Data

Creating and Using Reports
Create an AutoReport
Create a Report Using a Wizard
Examine a Report in Design View
Create a Calculated Field
Change the Format of a Control
Change the Style of a Report
Adjust Report Width

Intermediate Level

Managing a Database and Data
Import Data
Maintain Record Integrity
Export Data
Document Table Relationships

Controlling Data Entry
Make Data Entry More Accurate
Make Data Entry More Efficient
Facilitate Data Entry

Finding and Joining Data
Find Data with Filters
Get the Correct Data with Query Joins
Build Bridges Between the Data
Relate Data Within a Table

Creating Flexible Queries
Summarize Data with Queries
Enter Criteria on the Fly
Maintain Data with Queries

Improving Your Forms
Enhance the Appearance of a Form
Enhance the Usability of a Form
Make Your Forms More Professional
Display Form Data from Multiple Tables

Customizing Your Reports
Organize Report Information
Enhance Data Layout
Work with Report Pagination
Summarize Information
Add a Subreport to an Existing Report
Create Mailing Labels

Making Your Data Available on the Web
Create a Data Access Page
Improve the Look of a Data Access Page
Edit Data Using a Data Access Page
Group Records in a Data Access Page

Advanced Level

Structuring Existing Data
Use the Table Analyzer Wizard for Help
Decide on Your Own Design
Create a Junction Table
Modify the Original Tables and Completing the Design
Compact and Repair a Database

Summarizing Data
Group and Summarize Records in Different Ways
Summarize with a Crosstab Query
Pivot Query Results
Display a Graphical Summary on a Form

Simplifying Tasks with Macros
Create a Macro
Attach a Macro to a Command Button
Restrict Records

Adding Interaction and Automation with Macros
Require Data Entry with a Macro
Display a Message Box with a Macro
Automate Data Entry

Making Forms More Usable
Change the Display of Data Under Certain Conditions
Display a Calendar on a Form
Organize Information with Tab Pages

Making Reports More Powerful
Cancel Printing of a Blank Report
Include a Chart
Arrange Data in Columns
Distribute Reports as a Snapshot

Expanding the Reach of Your Data
Merge Access Data with a Word Document
Publish Access Data as a Word Document
Analyze Access Data in Excel

Accessing Object Names

BACK TO TOP