Access 2002 (Office XP): Level 4

COST Prices include GST and are subject to change
Member Corporate Standard
$128.00 $157.00 $197.00
 

Overview

In this course, students will create and modify a database switchboard. Students will also set and modify startup options. Students will develop a data access page and include a PivotTable and PivotChart in it. Students will distribute a database and add security features to it. Students will integrate Access into business operations. Students will also automate a business process using VBA.

Prerequisites
 
Hardware and Software Required:

  • Browser Microsoft Internet Explorer 6 (or higher)
  • Browser Mozilla Firefox 2 (or higher)
  • Browser Apple Safari 2 (or higher)
  • Operating System Microsoft Windows 2000, XP, or Vista
  • Operating System Apple Mac OS X 10.4 (or higher)
  • Processor Pentium III 1 GHz (or better)
  • Processor Macintosh Intel-based or PowerPC G4 (or better)
  • RAM 512 MB (1 GB or more recommended)
  • Internet connection 256K (broadband recommended)
  • Adobe Flash Player 8 (current version recommended)
  • Adobe Reader 7 (or higher)

Course Content

On completion of this course, you should be able to:

  • Create and modify a database switchboard;
  • Set and modify startup options;
  • Develop a data access page including a PivotTable and PivotChart;
  • Distribute a database and add security features to it;
  • Integrate Access into business operations;
  • Automate business processes using VBA.

Duration

3.5 hours (nominal)