Microsoft Access Advanced
Overview & Objectives:
The skills and knowledge covered in this course are sufficient to automate operations using macros, secure and protect data, create intricate queries, and have a general understanding of the programming environment in Microsoft Access 2003.
7 Hours (Part-time or Fulltime available)
Who should attend:
This course is primarily designed for people who need to know how to automate operations, protect and secure data, and perform complex queries in Microsoft Access 2003. It is ideal for people who working in offices, clubs, or for home use.
This course assumes that you can create a database file, store and manage data. it would also be beneficial to have a general understanding of personal computers and the Windows operating system as you will be required to start applications, work with and copy files, and locate file folders.
A hands-on approach is taken during this course. The exercises are designed to impart relevant skills and knowledge by having participants work through real-life examples and scenarios.
Chapter 1 Splitting A Database
Chapter 2 Action Queries
Chapter 3 Aggregate Queries
Chapter 4 Table & Query Relationships
Chapter 5 Database Replication
Chapter 6 Data Access Pages
Chapter 7 Data Access Page Techniques
Chapter 8 Database Protection
Chapter 9 Database Security
Chapter 10 Macro Basics
Chapter 11 Macro Techniques
Chapter 12 Macros On Forms
Chapter 13 Option Groups And Macros
Chapter 14 VBA Introduction
Training Fee: Au $399.00 - inc. GST
Material provided by Technology and Management Training