ACCESS 2000 ADVANCED

COURSE OUTLINE

SECTION 1 – ADVANCED QUERIES

· A REVIEW OF ACTION QUERIES

· UPDATE QUERIES

· MAKE-TABLE QUERIES

· DELETE QUERIES

· JOINING TABLES IN QUERIES

· CROSSTAB QUERIES

SECTION 2 - BUILDING EXPRESSIONS

· WHAT IS AN EXPRESSION?

· THE EXPRESSION BUILDER

SECTION 3 - ENHANCING FORMS AND REPORTS

· FORM PROPERTIES

· PAGE BREAKS

· USING FUNCTIONS IN FORMS

· EMBEDDING OBJECTS

· CREATING SUBFORMS

SECTION 4 - BASIC MACROS

· WHAT IS A MACRO?

· RUNNING A MACRO THROUGH A BUTTON

SECTION 5 - ADVANCED MACROS

· USING CONDITIONAL MACROS

· USING MACROS WITH OBJECTS

· RUNNING AND DEBUGGING MACROS

SECTION 6 - INTRODUCTION TO APPLICATION DEVELOPMENT

· CREATING A SWITCHBOARD

· FINALIZING YOUR APPLICATION

Course Length: 1 day

Prerequisites: Access 2000 Intermediate