ACCESS 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

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