Microsoft Access 2007 - Level 2

Duration: 
1 Day
Class Size: 
Max 10 Students
Time: 
9.00am – 4.30pm
Price: 
$350 incl GST
Microsoft Access 2007

This one day course aims to increase your productivity by providing the skills and knowledge necessary to effectively use the data manipulation features of Microsoft Access.

Who Should Attend: 

This course is intended for people who know how to create multi-table databases and who now wish to extract information from their database more effectively.

Course Pre-requisites: 

An understanding of database creation and design is assumed.

Course Objectives: 

At the completion of this course participants will be able to:

  • sort and filter data in a table
  • format data in tables
  • use a range of data validation techniques to protect data integrity
  • export records from Access
  • export records to HTML for use on the web
  • add parameters to queries to capture criteria data
  • add calculated fields to queries
  • create action queries to make tables, update, append, and delete records
  • understand table and query relationships and how they affect the integrity of data
  • protect your database files against unauthorised access
  • use the Switchboard Manager to create a menu system
Course Content: 
  • Sorting & Filtering Table Data
  • Formatting Table Data
  • Data Validation
  • Exporting Records - Exporting To HTML
  • Parameter Queries - Calculated Fields
  • Action Queries
  • Table & Query Relationships
  • Database Protection
  • Using The Switchboard

Course Calendar

Contact Learning Lab for information on course dates.

Student Handbook

To access the student handbook please click the following link. Student Handbook.

For more information

Please call 02 9318 1222, or contact our Support Team online. Alternatively, use our contact form to send us an email.