Access Training Course:  

 

 

Synopsis:

Microsoft Access is a powerful programme designed to make storing your information safely and securely a breeze.  This course will give you the lowdown on all the useful features, shortcuts and techniques to make data retrieval easy and accurate.

Please let us know which version of Microsoft Office you are using when booking, we can train 2000/2003/2007/2010 applications.

Pre-Requisites:

None

 Course Outline:

This 2 day Access course will enable non trained / new 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

Course Content:

Course Outline – 1 Day

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

Course Outline – 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

Learning Outcomes;

 This course is about demonstrating your MS access skills and taking these to the next level.

Duration:

2 Days

No of Delegates – The Total Number of delegates that can sit this is course is a maximum of 12 to uphold the quality of our training and to ensure the course is properly embedded to achieve the companies /  individual goals.

Prices – £849 (ex VAT)  Per day for up to 12 delegates trained onsite

(An additional charge for travel will be applied at 40p per mile from Sequence HQ to your premises)