Access 2000 - Advanced
 
All our training courses can be tailored to suit your company's needs.
Take a look at all the features that set us apart from other access 2000 advanced training courses.

Objectives :

Course objective is to improve upon Access Database Usage & Design.

Who should Attend :

Delegates who have attended the intermediate course
Course objective is to improve upon Access Database Usage & Design.

Duration :

2 days

Course Content      
 

 CREATING QUERIES THAT RELATE
     TO OPEN FORMS:


 USING FUNCTIONS IN FORMS:
       Date and Formatting Functions
       Text Processing Functions
       Conditional Functions


 OUTER JOIN QUERY TYPES and
     EXCEPTION REPORTING
       SQL Query statements and ANSI SQL
       Select Queries
       Distinct and Distinct Row variations
       Union Queries
       Data Processing Queries


  CREATING RELATIONSHIPS &
     ENFORCING REFERENTIAL INTEGRITY
 

 CREATING & CUSTOMISING REPORTS
     AND GROUPS


 GRAPHICS & GRAPHS IN REPORTS
       Sub Reports
       Running Reports from Open Forms


 EXTENDING FORM USAGE
       Custom Data Entry Forms
       Sub Forms and Graphs in Forms
       Using UnBound forms and Controls
       Using Aggregate Dfunctions() in Forms and
       reports
       Using Advanced Functions in Forms
       Reports and Queries
       Using Controls and Control Properties

 SETTING ACCESS DEFAULT PROPERTIES

Access 2000 - Advanced

Page 2

 Introduction To Macros

Using and Building Macros
Adding Buttons to Forms
Introduction to the Macro Windows
Building Basic Macros
Chaining Macros and Conditional Macros
File Processing Macros
Macros that perform menu Actions
Opening and Closing Forms
Modifying Fields with Macros
Macros to Filter Data
Macros to transfer data
Activating Dialogue Boxes
Running and Printing Reports from Macros
Conditional Actions in Macros
Running External Applications
Using The SENDKEYS to Transfer Data Instructions
Transfer and Attach database options
Mail-Merge and Excel and Word
Custom Menu Design
Customising the Toolbar and ACCESS 2.0
Removing the Toolbars from Use
AUTOEXEC Macros
Using Switchboard Forms for Dialogue
Using Dialogue Boxes for simple interrogation
Creating User Dialogue Boxes with UnBound Forms and Controls
Form and Control Events
 

  Building Command Bars & Menus
     Security in Access

Database v User Level Security
Enabling Access Security
Using the Security Wizard
Creating Administrator Accounts
New Users and Groups
Changes to database Ownership

 ODBC etc

*ODBC Links
*Direct & Parse through Queries
*Depends upon availability of server/network links