Access Introduction 2000/XP/2003

Duration 2 days

Designed for
Anyone wishing to use Access for the first time or those who have never received formal training

Pre-requisites
It would be beneficial if delegates have attended the Introductory sessions for Microsoft Word and Excel before completing this course

Course Aims
By the end of this course, delegates will be able to build a simple database, including Tables, Forms Querying and Reports. Delegates will also be able to interrogate a simple database and be able to produce labels.

Course content

Introduction to Database Concepts and Terminology
Starting Access
Access Databases
Creating New Databases
Creating an Object
Creating a Table
Changing Tables
Entering Data in Datasheet View
Copy, Move, Delete
Changing the Datasheet’s Layout
Designing Forms
Types of Form
Changing Forms using the Forms Design Work Surface
Editing the Tab order
Calculations within Forms
Creating Forms from Scratch
Multiple Screen Forms
Filter/Sort Records
Queries & Dynasets
Sorting Data
Calculations in Queries
Grouping and Summarising Data
Producing Cross Tabulated Results
Customising Queries with Parameters
Using Filters
Queries to Link Data from Different Tables
Queries with Calculated Fields
Queries to Summarise Data
Queries with Parameters
Action Queries
Action (Update) Query
Action (Make table) Query
Action (Delete) Queries
Action (Append) Query
Printed reports
Using the Report Wizard
Report Design Mode
Calculated and Statistical Fields
Including Graphs in Reports
Organizing Reports
Label Generation

Qualifications
for team leaders
and first line
managers

ILM Endorsement refers to bespoke programmes that have some form of assessment and are approved as ILM Endorsed Awards. Call or contact Adapt to discuss your specific requirements

Looking for a bespoke programme which has been approved by ILM but doesn’t have an assessment process? Choose Adapt to design a programme for an ILM Development Award

What they said about ...

ILM Level 3 Award in First Line Management

Jane is an excellent trainer and explained everything very clearly, excellent course with content well explained

The trainer answered all my questions superbly, very comprehensive on the detail of the course

Very knowledgeable and helpful and understanding and re explaining

Very good course which has taught me how to talk and deal with my team

Kept interesting and fresh throughout. Easy to stay attentive