Access 2003 VBA Package
This package helps existing Access database users enhance their productivity by using Visual Basic. Participants will gain advanced Access Skills and learn how to develop programs in VBA.
Quick Facts
$1,650 incl GST
Save $825.00
Download Course Brochures
About the Package
The Access 2003 VBA package is designed for people who have a thorough working knowledge of Microsoft Access, but no programming knowledge. The combination of advanced Access training and VBA programming techniques give students the ability to develop VisualBasic programs.
The Access 2003 – Visual Basic for Applications package includes the following courses:
Advanced Microsoft Access 2003 - Masterclass (2 days)
Microsoft Access 2003 - Visual Basic for Applications (3 days)
Prerequisites
Students should have completed the FastTrack to Access 2003 course, or have equivalent practical knowledge, including database design, tables, queries, forms and reports, prior to commencing this package. Participants should also follow the sequence of courses listed above. More details on prerequisites can be found within individual course descriptions.
Subject to prerequisites being met, one or more participants can book into a package. Review training package conditions .
Courses Units: Advanced Microsoft Access 2003 - Masterclass
- Unit 1: Data Validation
- - Using Expressions to Validate Data
- - Limitations of Data Validation
|
- Unit 2: Normalising a Database
- - First Normal Form
- - Second Normal Form
- - Third Normal Form
- - Bryce-Codd Normalisation
- - Breaking Normalisation Rules
|
- Unit 3: Splitting a Database
- - Why Split a Database?
- - Using the Database Splitter
- - Linking Tables Manually
- - Updating Links
- - Using Multiple Linked Tables
|
- Unit 4: Action Queries
- - Make Table Queries
- - Append Queries
- - Update Queries
- - Delete Queries
|
- Unit 5: Aggregate Queries
- - Grouping Data
- - Analysing Data
- • Sum and Average
- • Count, Min, Max
|
- Unit 6: Cross tab Queries And Pivot Tables
- - Analysis Periodic Data Using Pivot Tables
- - Using Pivot Tables
- - Using Pivot Charts
|
- Unit 7: Table And Query Relationships
- - Cascading Updates and Deletes
- - Searching for Orphan Records
- - Join Types
- • Inner Joins
- • Left and Right Joins
- • Union
- - Understanding Access SQL
|
- Unit 8: Database Security
- - Database Passwords
- - User Level Security
- - Creating a Custom Login Page
|
- Unit 9: Introducing Access VBA
- - VBA Fundamentals
- • Msgbox and InputBox
- • IF Statement
- • Reacting to User Input
|
- Unit 10: Advanced Form Design
- - GUI Design
- • Developing a Standard GUI
- • Screen Size / Resolution Issues
- - Applying and Clearing Form Filters
- - Modifying where Clause’s
- • AND and OR
- • Including String Delimiters
- - Cascading Combo Boxes
- - Validating Form Data
|
- Unit 11: Building a Reporting System
- - Passing Parameters
- • Via Forms
- • Via Objects
- - Parameter Fields
- • Combo Boxes
- • Text Boxes
- • Check Boxes
- • Option Groups
|
- Unit 12: Advanced Reporting System
- - Hiding Sections
- - 'On NoData’ Event
- - Report Formatting Techniques
- • Shading Alternate Lines
- • Custom Numbering Techniques
|
- Unit 13: Extending Beyond Access
- - Access ADP Format
- - Moving to a Server Model
- • SQL Server 2005
- • MySQL
- - Using XML Data within Access
- - Using Access Data on the web
|
Courses Units: Microsoft Access 2003 - Visual Basic for Applications
- Unit 1: Development Basics
- - The Access Development Environment
- - The Importance of Splitting Databases
- - Maintaining Links
- - Using the Database Splitter
- - Using Queries for Reports And Forms
- - Access Run-Time
- - Understanding Client/Server
- - Development Basics Quick Reference
- - On your Own
|
- Unit 2: Macros And VBA
- - Macro Overview
- - Creating Macros
- - Assigning Macros
- - Creating More Complex Macros
- - Converting Macros to VBA Code
- - Macros Versus VBA
- - Macros and VBA Quick Reference
- - On your Own
|
- Unit 3: VBA Essentials
- - Programming Environment Overview
- - The Role of Forms
- - Creating a Startup Form
- - Understanding Modules
- - Code Behind Forms
- - Standard Code Modules
- - Standard Vs Class Modules
- - Naming Conventions
- - VBA Essentials Quick Reference
|
- Unit 4: VBA Subroutines
- - Understanding Modules in Access
- - The Anatomy of a Module
- - Creating a Subroutine
- - Creating a Function
- - Calling Procedures
- - Passing Parameters
- - Returning Values
- - Scoping Procedures
- - VBA Subroutines Quick Reference
|
- Unit 5: Variable VBA
- - Overview of Variables
- - Creating String Variables
- - Option Explicit
- - Working with Numbers
- - Dealing with Overflows
- - Working with Decimals
- - Working with Dates
- - Default Values
- - Scoping Variables
- - Local Variables
- - Module-Wide Variables
- - Passing Parameters
- - Passing Parameters By Value
- - Variable VBA Quick Reference
|
- Unit 6: Interactive VBA
- - The Act of Communicating
- - Creating a Simple Input Box
- - Creating More Elaborate Input Boxes
- - Global Positioning
- - Simple Message Boxes
- - Creating Larger Messages
- - Breaking a Message Line
- - Customising Icons And Buttons
- - Message Box Functions
- - Responding to Different Buttons
- - Interactive VBA Quick Reference
|
- Unit 7: Decisive VBA
- - Decisions Overview
- - Creating an in-line If
- - Creating a Block If
- - Multiple If
- - Multiple If Using Text
- - Using Case Statements
- - Value Ranges in Case Statements
- - Case Statements with OR
- - Asking Yes/No Questions
- - Decisive VBA Quick Reference
|
- Unit 8: Looping VBA
- - Program Loops
- - Creating a While Loop
- - Taking Care of Counters
- - Creating an Until Loop
- - For Each Loops
- - Exiting From Loops
- - For Next Loops
- - Looping VBA Quick Reference
|
- Unit 9: the DoCmd Object
- - Overview of DoCmd
- - Navigating with DoCmd
- - Moving through Records
- - Filtering Records with DoCmd
- - Opening a Form with DoCmd
- - Opening a Report with DoCmd
- - Closing a Form
- - Creating Variable Reports
- - The DoCMD Object Quick Reference
|
- Unit 10: ActiveX Data Objects - Tables
- - Overview of ADO
- - Setting References Using VBA
- - Creating a Table with ADO
- - Removing a Table Using ADO
- - Populating a Form Using ADO
- - Dealing with an Empty Table
- - ActiveX Data Objects Quick Reference
|
- Unit 11: ADO Forms and Recordsets
- - Overview of ADO with Forms and Recordsets
- - Navigating Records in a Form
- - Finding a Record
- - Updating a Record
- - Deleting a Record
- - Adding a New Record
- - ADO Forms and Recordsets Quick Reference
|
- Unit 12: Debugging VBA
- - Overview of Debugging
- - Setting a BreakPoint
- - Setting Additional Breakpoints
- - Stepping through a Procedure
- - Viewing the Call Stack
- - Using the Locals And Immediate Windows
- - Adding a Watch
- - Deleting a Watch
- - Debugging VBA Quick Reference
|
- Unit 13: Handling Errors in VBA
- - Error Handling Overview
- - Understanding Common Errors
- - Creating a Simple Error Handler
- - Understanding the Error Object Model
- - More Elegant Error Handling
- - Resuming From Errors
- - Forcing an Error
- - Creating Custom Errors
- - Handling Errors Quick Reference
|
Upcoming Dates
You’ll need to check the dates for each of the individual courses within this Package.
Check our Course Dates, or contact us to discuss your specific needs.
$1,650 incl GST
Save $825.00
