Level 3
8 Relationships, primary key, joins, referential integrity and cascade options
8 AutoLookup, filtering and indexes
8 Field and table properties
8 Operators, expressions and functions
8 Calculations in forms and reports
8 Selecting records in queries
8 Multi-table forms
8 Form properties, form sections, form tabs and form appearance
8 Option groups, combo boxes and command buttons
8 Creating forms and reports without a Wizard
8 Editing and formatting reports
8 Sorting and grouping
8 Form letters with Access and Word
Level 4
8 Subdatasheets, subforms and subreports
8 Crosstab queries, parameter queries, query Wizards and action queries
8 Importing, exporting and linking
8 Bound and unbound objects
8 Hyperlinks, static web pages and data access pages
8 Creating, running and editing macros
8 Macro groups and conditions for actions
8 Using macros for events in forms and reports
8 Command buttons and customised toolbars
8 Introduction to automated applications
8 Switchboards, dialogue boxes, menus and toolbars
Visual Basic For Access Manual (Both Levels are combined in the one manual)
Level 1 (Day 1)
8 The Access Development Environment
8 Importance of Splitting Databases
8 Maintaining Links
8 Using the Database Splitter
8 Using Queries for Reports and Forms
8 Access Run Time
8 Understanding Client/Server
8 Creating and Assigning Macros
8 Converting Macros to VBA Code
8 Why you shouldn’t use macros
8 Role of Forms and creating a start-up form
8 Code Behind forms
8 Standard Code modules
8 Class Code Modules
8 Naming Conventions
8 Creating a Subroutine, Function, Procedures
8 Passing Parameters and Returning Values
8 Creating Strings, working with numbers and dealing with Overflows.
8 Passing Parameters
8 Message Boxes, Breaking a Message Box
Level 2 (Day 2)
8 Creating an Inline If
8 Multiple If
8 Using Case
8 Asking Yes No Questions
8 Program Loops
8 Creating an Unlimited
Loop
8 For Each Loops and For Next Loops
8 Navigating with DoCmd
8 Filtering Records
8 Opening a Form and Report
8 Closing Forms
8 DAO, Creating a Table and Populating a table
8 Dealing with an Empty Table
8 Debugging VBA using Breakpoints
8 Stepping through a procedure
8 Handling errors and forcing and error
8 Error Handling