All our training courses can be designed to suit your company's needs.
Take a look at all the different features that separate us 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

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

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