ACCESS 2000 FUNDAMENTALS

COURSE OUTLINE

SECTION 1 - INTRODUCTION

· WHAT IS A DATABASE

· STARTING AND EXITING ACCESS 2000

· OPENING A DATABASE

· CLOSING A DATABASE

· THE ACCESS 2000 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 – HELP

· HELP OVERVIEW

Course Length: 1 day

Prerequisites: Introduction to Windows