Overview:
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 Method:
This course uses a combination of instructor presentation, and student hands-on practical exercises. Participants will have the opportunity to apply what they have learned in the classroom throughout the course.
Who will benefit from this course?
This training course is primarily designed for people who need to know how to automate operations in Microsoft Access 2003
Pre-requisites:
Before attending this course you should have completed:
- Courses 715: MS Access Introduction
- Course 717: MS Access Intermediate
or have equivalent knowledge and experience
What can you expect to gain from this course?
After completing this course, you 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 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:
Module 1:Splitting a Database
- Using the database splitter
- Working with a split Database
- Updating database links
Module 2:Database Security
- Understanding database security
- Creating a workgroup
- Creating an administrator
- Removing the default admin user
- Logging on as the system administrator
- Securing a database
- Adding groups
- Adding users
- Assigning permissions
- Testing database security
- Joining another workgroup
Module 3:Database Replication
- Understanding database replication
- Creating a replica
- Creating additional replicas
- Creating a partial replica
- Synchronising to a replica
- Synchronising from a replica
- Synchronising to a partial replica
Module 4:Aggregate Queries
- Creating an aggregate query
- Working with aggregate queries
- Creating Queries with multiple aggregates
- Modifying aggregate headings
- Aggregating calculated fields
- Applying criteria to aggregates
- Creating a query to nest
- Creating an aggregate from a query
Module 5:Data Access Pages
- Creating a data access page
- Applying themes to data access pages
- Working with data access pages
- Using a data access page outside access
Module 6:Data Access Page Techniques
- Creating a data access page design
- Promoting and demoting fields
- Working with data access page fields
- Displaying related records
- Formatting a pivot table list
- Adding columns to a pivot table list
- Creating a scrolling marquee
- Formatting a page
- Macros versus VBA
- Creating a macro
- Running a macro
- Modifying an existing macro
- Interacting with the user
- Documenting macros
Module 8:Macro Techniques
- Creating a print macro
- Using conditions to enhance a macro
- Creating a sequence of conditions
- Using the MsgBox action statement
- The MsgBox function
- Using MsgBox in a condition
- Reconfiguring a message box
- Using the InputBox function
- Creating an event macro
- Creating a group macro
- Attaching macros from a group
- Creating a group macro for forms
- Attaching macros to form events
- Setting form properties
- Testing form property changes
Module 10:Option Groups and Macros
- Testing a sample option button macro
- Creating an option group
- Copying toggle buttons
- Option group properties
- The apply filter macro action
- Creating a filter macro
- Using the apply filter macro action
- Handling exceptions
- Attaching a macro to an option group
Additional Module:VBA Introduction*
- Introductory VBA terminology
- Writing a simple form procedure
- Examining a simple sub procedure
- The MsgBox and InputBox functions
- Editing an existing procedure
- Creating a standard module
- Project - loan simulator code
- Testing the code
- Modifying a module
- Creating a button on a form
- Running a procedure from a control
- Navigating the VBA editor
* self-study topic: no class time allotted to this topic