About This Training Course

Why use Access?

• Create your own custom database at a fraction of the cost of CRM and similar solutions.
• Customise reports to your requirements

Subjects Covered

At the completion of Microsoft Access 2010 Introductory and Intermediate you should be able to:

• understand how Access is used and how to navigate around it
• design a database with lookup tables
• create a database structure using Access 2010
• modify the structure of an existing table
• add records to a new table
• add transactional records to a lookup database
• work with the records in a database table
• sort and filter records in a table
• create simple and effective queries
• create meaningful reports from tables
• create and use a variety of forms
• use various data validation features in Access to protect data
• format the data in a table
• perform more advanced queries using a variety of querying techniques
• create and use parameter queries
• create calculated queries
• modify and adapt an existing form according to specific needs
• create and use macros in Access
• work with a number of macro techniques
• create macros on forms

Training Course Outcomes

At the end of this Microsoft Access 2007/2010 Training Course participants should be able to:

• understand how Access is used and how to navigate around it
• design a database with lookup tables
• create a database structure using Access 2010
• modify the structure of an existing table
• add records to a new table
• add transactional records to a lookup database
• work with the records in a database table
• sort and filter records in a table
• create simple and effective queries
• create meaningful reports from tables
• create and use a variety of forms
• use various data validation features in Access to protect data
• format the data in a table
• perform more advanced queries using a variety of querying techniques
• create and use parameter queries
• create calculated queries
• modify and adapt an existing form according to specific needs
• create and use macros in Access
• work with a number of macro techniques
• create macros on forms

Prerequisites

There are no Prerequisites for this Microsoft Access 2007/2010 Training Course.

Other Information

If you need further information contact Startnextweek.com.au on 1300 728 102