Access Training (New Users)

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.

None

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

This course is available as an inhouse course tailored to your organisational aims and objectives, please contact us to discuss your requirements and delegate numbers. (pricing can vary dependant on the size of group)

All prices are excluding VAT, travel is charged with In-house courses at 40p per mile from our head office
Accommodation is required for distances over 100 miles from our head office.