Access Training (New Users)

Available as a public course?:

No

Duration:

2.00 days

This Access introduction to intermediate 2 day course will teach new or unfamiliar users of Access to create and work with a fully usable database.

You will be able to create a database from scratch, create queries and reports, use forms, create mailing lists and much much more. Suitable for any one.

Aims and Objectives:

This 2 day course will enable a new user / non trained user to create a fully workable database for your organisation.

At the end of this course the delegates will:

Have a good working knowledge of Microsoft Access.
Be able to create a database from scratch.
Understanding and use tables, fields and records and the rules for entering data
Create simple queries, use forms and, ultimately create reports
Understand relational databases and be able to work with related tables

Please let us know which version of Microsoft Office you are using when booking, we can train 2000 / 2003 & 2007 applications. We also have 10 v2003 laptops available if you require them, no charge for their use.

The course price is for up to 10 delegates attending.

Pre-Course Work:

None

Proposed Course Outline:

Day 1 -

Database Concepts

Database concepts and terminology
Exploring the Access environment
Planning and designing databases
Getting help
Closing a database and Access

Access Basics

Exploring tables
Examining queries
Exploring reports

Creating Databases

Creating a database
Using the table wizard
Working in design view

Working with Fields and Records

Changing the design of a table
Adding and deleting records
Finding and editing records
Sorting and filtering records

Querying Tables

Creating and using queries
Modifying query results and queries
Using calculations in queries

Creating and Using Forms

Creating forms by using AutoForm
Using the form wizard
Using design view
Finding, sorting and filtering records

Creating and Using Reports

Using the report wizard and queries
Creating, modifying and printing reports

Importing, Exporting and Linking Objects

Importing Access objects
Exporting Access objects
Linking Access objects

Day 2

Creating relational databases

Database normalising
Introducing relating tables
Adding referential integrity

Working with related tables

The lookup wizard
Changing lookup fields
Inputting data to related tables

Defining data entry rules

Using input masks
Setting a property
Setting a validation rule

Using advanced query features

How to join a table in queries
Creating a calculated field
Using an action query

Creating advanced queries

Summarise and group values
Create a crosstab query
Using a parameter query

Creating advanced form design

Working with graphics
Working with calculations
Working with combo boxes
Working with unbound controls

Using advanced report features

Create customized headers and footers
Add a calculated value
Work with sub-reports

Course Evaluation:

This course will be evaluated at Level 1 of the Kirkpatrick Training Evaluation Model (Reaction to Learning), via a short questionnaire, which will be completed at the end of the course.

Practical Arrangements:

Maximum number of delegates: Suggested max. 10
Number of rooms required: One large training room
Room layout: U Shape / Boardroom
Equipment required: Flipchart, Projector, Pads and Pens for delegates. CM Training will provide all delegates materials (handouts, copy of powerpoint slides etc., and a laptop to connect to the projector)
Please contact us if you would like to use our laptops for delivery - no charge
Timings: 9.30 to 4.30

Price (In-house Course):

£549.00 per day