Microsoft Training: Microsoft Access 2003 Level 2 Course

As you begin this course, you should have the basic skills you need to work with a Microsoft® Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.

To ensure the successful completion of Microsoft Access 2003: Level 2, we recommend completion of the following courses, or equivalent knowledge (basic familiarity with Access tables, relationships, queries, forms, and reports) from another source:

Microsoft Access 2003: Level 1

This course is rated as an Intermediate Course, suitable for accomplished computer users.

Topics covered on the 2 day Microsoft Access 2003 Level 2 course

Planning a Database

Design a Relational Database
Identify Database Purpose
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize the Data
Designate Primary and Foreign Keys

Building the Structure of a Database

Create a New Database
Create a Table Using a Wizard
Create Tables in Design View
Create Relationships between Tables

Controlling Data Entry

Restrict Data Entry with Field Properties
Create an Input Mask
Create a Lookup Field

Finding and Joining Data

Find Data with Filters
Create Query Joins
Join Unrelated Tables
Relate Data Within a Table

Creating Flexible Queries

Set Select Query Properties
Create Parameter Queries
Create Action Queries

Improving Your Forms

Enhance the Appearance of a Form
Restrict Data Entry in Forms
Add Command Buttons
Create a Subform

Customizing Your Reports

Organize Report Information
Set Report Control Properties
Control Report Pagination
Summarize Information
Add a Subreport to an Existing Report
Create Mailing Labels

Expanding the Reach of Your Data

Publish Access Data as a Word Document
Analyze Access Data in Excel
Export Data to a Text File
Merge Access Data with a Word Document

If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Microsoft Access Training and bespoke Microsoft Access courses

If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.

PTR Associates Limited

21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk

Microsoft Courses:Microsoft Access 2003 Level 2 Training Course

Microsoft Access 2003 Level 2 Course