ACCESS 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 Fundamentals

To schedule this course, visit Corporate Training Group, Inc. at www.ctgtraining.com or call (888) 244-2226.