ACCESS XP FUNDAMENTALS

COURSE OUTLINE

 

SECTION 1 - INTRODUCTION

                WHAT IS A DATABASE

                STARTING AND EXITING ACCESS XP

                OPENING A DATABASE

                CLOSING A DATABASE

                THE ACCESS XP SCREEN

                WORKING WITH MENUS

                WORKING WITH TOOLBARS

SECTION 2 - WORKING WITH DATA

                ENTERING DATA

                ADDING RECORDS

                DELETING RECORDS

                FINDING RECORDS

                SORTING A TABLE

                AUTOCORRECT

                SPELL CHECK

SECTION 3 - CREATING TABLES

                CREATING A NEW DATABASE

                CREATING TABLES

                USING THE TABLE WIZARD

                CREATING A TABLE MANUALLY

                MODIFYING A TABLE

                TABLE PROPERTIES

SECTION 4 - USING FORMS

                CREATING FORMS

                MODIFYING A FORM

SECTION 5 QUERIES

                FILTERING A TABLE

                CREATING AND SAVING A SELECT QUERY

SECTION 6 - CREATING REPORTS

                TYPES OF REPORTS

                MODIFYING A REPORT

                CREATING MAILING LABELS

                APPENDIX

                DATABASE COMPATIBILITY AMONG ACCESS VERSIONS

                HELP OVERVIEW

 

Course Length: 1 day

Prerequisites: Microsoft Windows

 

 

 

ACCESS XP INTERMEDIATE

COURSE OUTLINE

 

SECTION 1 - RELATIONSHIPS

                UNDERSTANDING RELATIONSHIPS

                TYPES OF RELATIONSHIPS

                REFERENTIAL INTEGRITY

                CREATING RELATIONSHIPS

                EDITING RELATIONSHIPS

SECTION 2 QUERIES

                QUERIES

                PARAMETER QUERIES

                ACTION QUERIES

                CALCULATING IN QUERIES

                QUERY WIZARDS

SECTION 3 FORMS

                CREATING FORMS

                MODIFYING A FORM

                CREATING COMBO AND LIST BOXES

                SETTING PROPERTIES FOR CONTROLS

                SETTING TAB ORDER

SECTION 4 REPORTS

                TYPES OF REPORTS

                CREATING GROUP REPORTS

SECTION 5 - USING THE DATABASE WIZARD

                CREATE A DATABASE USING A DATABASE WIZARD

                APPENDIX - USING ACCESS WITH WORD

                USING ACCESS AND WORD

 

Course Length: 1 day

Prerequisites: Access XP Fundamentals

 

ACCESS XP 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 XP Intermediate