Exploring Microsoft Access 97

by Grauer, Robert T.; Barber, Maryann

• ISBN13: 9780137542277
• ISBN10: 0137542275
• Edition: 1st
• Format: Paperback
• Copyright: 1998-03-01
• Publisher: Pearson College Div

Summary

For any course teaching application software using Microsoft Office 97 applications. This book will appeal to students in a variety of disciplines including liberal arts, business, and the sciences. All books in this series offer consistent presentationcommon design, pedagogy, writing style, and level. Concepts as well as key-strokes are emphasized. Hands-on exercises in every lesson provide just the right amount of practice time. This best-selling author team's hands-on approach and conceptual framework helps students master important concepts, as well as the features of the powerful Office 97 applications.

Table of Contents

PREFACE	xi	(6)
Microsoft Office 97: Six Applications in One	xvii
1 Introduction to Microsoft(R) Access: What Is a Database?	1	(36)
CHAPTER OBJECTIVES	1	(1)
OVERVIEW	1	(1)
Case Study: The College Bookstore	2	(1)
Introduction to Microsoft Access	3	(3)
The Database Window	3	(1)
Tables	4	(2)
HANDS-ON EXERCISE 1: INTRODUCTION TO MICROSOFT ACCESS	6	(7)
Maintaining the Database	13	(1)
Find and Replace Commands	13	(1)
Data Validation	14	(1)
Forms, Queries, and Reports	14	(3)
HANDS-ON EXERCISE 2: MAINTAINING THE DATABASE	17	(9)
Looking Ahead: A Relational Database	26	(3)
Summary	29	(1)
Key Words and Concepts	29	(1)
Multiple Choice	30	(2)
Practice with Access 97	32	(3)
Case Studies	35	(2)
2 Tables and Forms: Design, Properties, Views, and Wizards	37	(50)
CHAPTER OBJECTIVES	37	(1)
OVERVIEW	37	(1)
Case Study: A Student Database	38	(3)
Include the Necessary Data	39	(1)
Store Data in Its Smallest Parts	39	(1)
Avoid Calculated Fields	40	(1)
Creating a Table	41	(3)
Primary Key	41	(1)
Views	42	(1)
Properties	43	(1)
HANDS-ON EXERCISE 1: CREATING A TABLE	44	(9)
Forms	53	(5)
Controls	53	(2)
Properties	55	(1)
The Form Wizard	55	(2)
Modifying a Form	57	(1)
HANDS-ON EXERCISE 2: CREATING A FORM	58	(9)
A More Sophisticated Form	67	(1)
HANDS-ON EXERCISE 3: A MORE SOPHISTICATED FORM	68	(9)
Summary	77	(1)
Key Words and Concepts	78	(1)
Multiple Choice	78	(2)
Practice with Access 97	80	(5)
Case Studies	85	(2)
3 Information from the Database: Reports and Queries	87	(50)
CHAPTER OBJECTIVES	87	(1)
OVERVIEW	87	(1)
Reports	88	(5)
Anatomy of a Report	90	(1)
The Report Wizard	90	(1)
Apply What You Know	90	(3)
HANDS-ON EXERCISE 1: THE REPORT WIZARD	93	(8)
Introduction to Queries	101	(5)
Query Window	102	(2)
Selection Criteria	104	(2)
HANDS-ON EXERCISE 2: CREATING A SELECT QUERY	106	(7)
Grouping Records	113	(2)
HANDS-ON EXERCISE 3: GROUPING RECORDS	115	(11)
Summary	126	(1)
Key Words and Concepts	127	(1)
Multiple Choice	127	(3)
Practice with Access 97	130	(4)
Case Studies	134	(3)
4 One-to-Many Relationships: Subforms and Multiple Table Queries	137	(52)
CHAPTER OBJECTIVES	137	(1)
OVERVIEW	137	(1)
Case Study: Consumer Loans	138	(4)
Implementation in Access	141	(1)
Referential Integrity	142	(1)
HANDS-ON EXERCISE 1: ONE-TO-MANY RELATIONSHIPS	142	(7)
Subforms	149	(3)
The Subform Wizard	151	(1)
HANDS-ON EXERCISE 2: CREATING A SUBFORM	152	(9)
Multiple Table Queries	161	(2)
HANDS-ON EXERCISE 3: QUERIES AND REPORTS	163	(7)
Expanding the Database	170	(3)
Multiple Subforms	172	(1)
HANDS-ON EXERCISE 4: LINKED SUBFORMS	173	(7)
Summary	180	(1)
Key Words and Concepts	181	(1)
Multiple Choice	181	(2)
Practice with Access 97	183	(4)
Case Studies	187	(2)
5 Many-to-Many Relationships: A More Complex System	189	(62)
CHAPTER OBJECTIVES	189	(1)
OVERVIEW	189	(1)
Case Study: The Computer Super Store	190	(5)
The AutoNumber Field Type	193	(1)
The Relationship Window	193	(1)
Referential Integrity	194	(1)
HANDS-ON EXERCISE 1: RELATIONSHIPS AND REFERENTIAL INTEGRITY	195	(8)
Subforms, Queries, and AutoLookup	203	(3)
HANDS-ON EXERCISE 2: SUBFORMS AND MULTIPLE TABLE QUERIES	206	(9)
Advanced Queries	215	(4)
Parameter Queries	215	(2)
Total Queries	217	(2)
Learning by Doing	219	(1)
HANDS-ON EXERCISE 3: ADVANCED QUERIES	220	(8)
Expanding the Database	228	(3)
The Sales Commission Query	230	(1)
The Get External Data Command	231	(1)
HANDS-ON EXERCISE 4: EXPANDING THE DATABASE	231	(9)
Summary	240	(1)
Key Words and Concepts	241	(1)
Multiple Choice	241	(2)
Practice with Access 97	243	(5)
Case Studies	248	(3)
6 Building Applications: Introduction to Macros and Prototyping	251	(56)
CHAPTER OBJECTIVES	251	(1)
OVERVIEW	251	(1)
The Coral Springs Soccer Association	252	(1)
The Linked Tables Command	253	(2)
HANDS-ON EXERCISE 1: CREATING A USER INTERFACE	255	(10)
Macros	265	(3)
The Macro Window	265	(1)
The AutoExec Macro	266	(1)
Debugging	266	(2)
HANDS-ON EXERCISE 2: INTRODUCTION TO MACROS	268	(8)
The Player Draft	276	(4)
The Find Unmatched Query Wizard	273	(5)
Macro Groups	278	(2)
HANDS-ON EXERCISE 3: THE PLAYER DRAFT	280	(10)
Prototyping	290	(2)
HANDS-ON EXERCISE 4: PROTOTYPING	292	(8)
Summary	300	(1)
Key Words and Concepts	300	(1)
Multiple Choice	301	(2)
Practice with Access 97	303	(3)
Case Studies	306	(1)
APPENDIX A: TOOLBARS	307	(4)
APPENDIX B: DESIGNING A RELATIONAL DATABASE	311	(10)
APPENDIX C: AN ACCESS DATABASE WITH A WORD FORM LETTER	321	(10)
APPENDIX D: A SEMESTER PROJECT	331
Prerequisites: Introduction to Windows 95	1
INDEX