Microsoft Access

MS Excel

At Motiv8 Development we know that one size doesn’t fit all. Our I.T. training can be tailored to meet your specific requirements. Courses can be ‘pick and mixed’ to suit your individual needs and we also cater for most of the versions of software currently in use.

Training can be delivered at your site or venue near to you and we can train individuals or groups up to five people. We keep group sizes small so we can provide the individual support participants require to maximise the outputs and benefits of the training. If required, we can even supply the PC's for the training.

Outlines of the different levels of training offered are detailed below. However, contact us to discuss your specific needs.This ½ day session is aimed at new users of Access who would like to understand the basics of working with Access and create databases. 

 


 

Level 1 - Duration: 1/2 day

This ½ day session is aimed at new users of Access who would like to understand the basics of working with Access and create databases.

 

Pre-requisites

It is assumed that delegates have a knowledge of the Windows environment and little or no knowledge of Microsoft Access.

 

Topics Covered

  • Getting into Access
  • The database window
  • Database types (flat file / relational)
  • Creating a new database
  • Creating a table
  • Entering data
  • Filtering data
  • Basic queries

 


 

Level 2 - Duration: 1/2 day

This ½ day session is aimed at new users of Access and builds on the lessons learned in Level 1. During this session delegates will create input forms and queries.

 

Pre-requisites

It is assumed that delegates have a good knowledge of the Windows environment and some knowledge of Microsoft Access.

 

Topics Covered

  • Building a form
  • Building queries
  • Building ‘quick queries’
  • Building flexible queries
  • Creating reports
  • Output query results to reports
  • Edit reports

 


 

Level 3 - Duration: 1/2 day

This ½ day session is aimed at users of Access who wish to build relational databases. During this session delegates will create multiple tables and queries based upon relational data.

 

Pre-requisites

It is assumed that delegates will have a good knowledge of the Windows environment and some knowledge of Microsoft Access.

 

Topics Covered

  • Building multiple tables
  • Linking tables
  • Types of relationships
  • Creating ‘lookups’
  • Building queries
  • Using Expression Builder
  • Querying multiple tables
  • Creating calculations in queries

 


 

Level 4 - Duration: 1/2 day

This ½ day session is aimed at users of Access who wish to build relational databases.  During this session delegates will create multiple tables and forms based upon relational data.

 

Pre-requisites

It is assumed that delegates will have a knowledge of the Windows environment and some knowledge of Microsoft Access.

 

Topics Covered

  • Creating lookups in a table
  • Creating forms and sub forms
  • Using lookups in a form
  • Using forms with queries
  • Using calculations in a form
  • Creating buttons on forms

 


 

Level 5 - Duration: 1/2 day

This ½ day session is aimed at users of Access who want to make databases easy to use.

 

Pre-requisites

It is assumed that delegates have a good knowledge of the Windows environment and have a working knowledge of Microsoft Access.

 

Topics Covered

  • Building multiple forms
  • Using forms to define query criteria
  • Building a user interface
  • Outputting data to Excel
  • Using and creating form controls