Access 2007 Basics provides detailed instructions on how to use Microsoft Access 2007 and will prepare students to handle most modern business office applications with the software. The text is divided into eight chapters and one appendix. Each chapter contains detailed text coverage of key Access concepts, exercises with step-by-step instructions, and review projects that force students to think for themselves. In general, the exercises are presented in increasing order of difficulty. Upon completion, students will have a solid understanding of how to create and design databases, and manipulate the various database objects. 

An Instructor's Resource CD is free upon request with a class-sized order. Unit tests are available in the Instructor's Resource CD.

TABLE OF CONTENTS

CHAPTER 1: INTRODUCTION TO ACCESS
INTRODUCTION
DATABASE BASICS
LAUNCH ACCESS
APPLICATION WINDOW
NAVIGATION PANE
DATABASE OBJECTS
RECORD NAVIGATION
ENTER, EDIT, AND DELETE RECORDS
HELP FEATURES
PRINTING OPTIONS
CHAPTER SUMMARY
CHAPTER 1 PROJECTS

CHAPTER 2: CREATE AND DESIGN A DATABASE
INTRODUCTION
DATABASE DESIGN
CREATE A TABLE
DATA TYPES
FIELD PROPERTIES
ENTER DATA IN A TABLE
FORMAT RECORDS IN A DATASHEET
CHAPTER SUMMARY
CHAPTER 2 PROJECTS

CHAPTER 3: TABLE RELATIONSHIPS, FILTERS, AND QUERIES
INTRODUCTION
TABLE RELATIONSHIPS
FILTERS
QUERIES
CHAPTER SUMMARY
CHAPTER 3 PROJECTS

CHAPTER 4: FORMS
INTRODUCTION
FORMS
FORM DESIGN VIEW
CONTROLS
RECORDS
PROPERTIES
CHAPTER SUMMARY
CHAPTER 4 PROJECTS

CHAPTER 5: REPORTS
INTRODUCTION
REPORTS
REPORT DESIGN VIEW
CONTROLS
MAILING LABELS
PRINT TABLE RELATIONSHIPS
CHAPTER SUMMARY
CHAPTER 5 PROJECTS

CHAPTER 6: DATA ANALYSIS
INTRODUCTION
ADVANCED QUERIES
PIVOTTABLES AND PIVOTCHARTS
CHAPTER SUMMARY
CHAPTER 6 PROJECTS

CHAPTER 7: DATABASE MANAGEMENT
INTRODUCTION
DATABASE MANAGEMENT
DATABASE OBJECTS
CHAPTER SUMMARY
CHAPTER 7 PROJECTS

INDEX