Philosophy Courses  Instructors   Stories

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