|
 |
 |
 |
 |
 |
 |
|
|
|
 |
|
|
Microsoft Access - Level 3 |
|
|
 |
|
|
|
 |
 |
 |
|
 |
 |
|
|
 |
 |
|
 |
 |
 |
 |
|
 |
 |
|
|
 |
|
The skills and knowledge covered in this course are sufficient to automate operations using macros, secure and protect data, and have a general understanding of the programming environment in Microsoft Access 2003.
Learning Outcomes:
At the completion of this courseware participants will be able to:
• split the tables from a database file
• completely secure a database file and its objects so that unauthorised access is prevented
• create and maintain multiple copies of a database file
• create aggregated queries
• create a data access page
• create data access pages using the Design View
• create simple macros
• use conditions in macros
• create macros that used with forms
• create a macro for an option group to provide instant filtering
• write a simple procedure in VBA.
Course Content:
• Splitting A Database
• Database Security and Replication
• Aggregate Queries
• Data Access Pages and Page Techniques
• Macro Basics
• Macro Techniques
• Macros On Forms
• Option Groups And Macros
• VBA Introduction
Target Audience:
This course is primarily designed for people who need to know how to automate operations in Microsoft Access 2003. It is ideal for people who working in offices, clubs, or for home use.
Duration:
1 Day
Courseware:
High quality learning materials are available for purchase by participants. Participants will also be presented with a certificate of achievement upon completion of the course.
|
|
|
|
|
|
 |
 |
|
 |
 |
 |
 |
|
 |
 |
|
|
|
|
