Microsoft Advanced Access 2007 Course Outline
COURSE INFORMATION
Duration: Two Days: 9am - 4:30pm
Price: $780
Book: Enquire or make a course booking
TARGET AUDIENCE & PURPOSE
This Advanced Access Course is for skilled developers who wish to add high-end sophistication, automation and security.
OBJECTIVES
By the end of this course participants should be able to:
- Split tables out of a database file
- Create action queries
- Work with query joins and table relationships
- Use database replication and synchronisation
- Create Data Access Pages
- Protect a database file
- Create macros
- Create simple VBA procedures
PREREQUISITES
Participants should be skilled users of Access, having attended the Basics and Intermediate Access courses and should already be able to:
- Create a database
- Define the fields and properties for a table
- Create table relationships
- Create simple calculation and select queries
- Create forms for Data Entry, Switchboard and Query-By-Form
- Create and modify reports
COURSE CONTENT
| Splitting A Database Overview Splitting A Database, Splitting A Database, Working With A Split Database, Updating Database Links Action Queries Using A Make Table Query, Creating An Update Query, Creating A Saved Update Query, Running A Saved Query, Creating A Delete Query, Creating An Append Query Query Relationships Overview Table Relationships & Queries, Understanding Join Types, Finding Orphan Records, Removing Orphan Records, Locating Exceptions, Understanding SQL Database Replication Initiating Database Replication, Creating Additional Replicas Creating A Partial Replica, Synchronising To A Replica, Synchronising From A Replica, Synchronising To A Partial Replica Data Access Pages Overview Data Access Pages, Data Access Page Wizard, Working With A Data Access Page, Using The Page Outside Access 2000 Data Access Page Techniques Data Access Page Techniques Overview, Creating A Basic Data Access Page Design, Promoting And Demoting Fields, Displaying Related Records, Modifying Pivot Table Lists, Creating A Scrolling Marquee. Formatting A Page Database Protection Overview Database Protection, Setting A Password, Opening A File With A Password, Removing A Password, Encrypting & Decrypting A Database File, Hiding Database Objects, Displaying Hidden Objects, Unhiding An Object |
Database Security Overview Database Security, How Security Is Achieved, Creating A New Workgroup & An Administrator, Removing The Default Admin User, Logging On As The System Administrator, Securing A Database, Adding Groups & Users, Assigning Permissions, Testing The Security, Joining Another Workgroup Macro Basics Overview Of Macros, Creating A Macro, Running A Macro, Modifying An Existing Macro, Interacting With The User, Documenting Macros Macro Techniques Overview Macro Techniques, Creating A Print Macro, Using Conditions To Enhance The Macro, Creating A Sequence Of Conditions, Using The MsgBox, Action Statement, Creating A Msgbox Condition, Configuring The Message Box, Soliciting Input Macros On Forms Macros On Forms, 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 Option Group Macros Option Groups and Macros, How Option Groups Work, Creating An Option Group, Copying Toggle Buttons, Creating The Filter Macro, Handling The Exceptions, Attaching Macro To The Option Group VBA Introduction Overview Visual Basic For Applications, Creating A Simple Form Procedure, Editing An Existing, Procedure, Creating A Standard Module, Testing The Code, Modifying A Module, Attaching A Module Procedure To A Control, Navigating The VBA Editor |