Exploring Microsoft Access 2000 with VBA

by Grauer, Robert T.; Barber, Maryann

• ISBN13: 9780130196989
• ISBN10: 0130196983
• Edition: Spiral
• Format: Paperback
• Copyright: 2000-02-01
• Publisher: Pearson College Div

Summary

For any course teaching application software using Microsoft Office 2000 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, and writing style. Concepts as well as key-strokes are stressed. 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 new Office 2000 applications.

Table of Contents

Preface	xi
Introduction to Microsoft Access: What is a Database?	1	(48)
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)
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)
Maintaining the Database	17	(8)
Filters and Sorting	25	(2)
Filters and Sorting	27	(5)
Looking Ahead: A Relational Database	32	(2)
4: A Look Ahead	34	(7)
Summary	41	(1)
Key Words and Concepts	41	(1)
Multiple Choice	42	(2)
Practice with Access 2000	44	(4)
Case Studies	48	(1)
Tables and Forms: Design, Properties, Views, and Wizards	49	(52)
Chapter Objectives	49	(1)
Overview	49	(1)
Case Study: A Student Database	50	(3)
Include the Necessary Data	51	(1)
Store Data in Its Smallest Parts	51	(1)
Avoid Calculated Fields	52	(1)
Creating a Table	53	(3)
Primary Key	53	(1)
Views	54	(1)
Properties	55	(1)
Creating A Table	56	(9)
Forms	65	(5)
Controls	65	(2)
Properties	67	(1)
The Form Wizard	67	(2)
Modifying a Form	69	(1)
Creating A Form	70	(9)
A More Sophisticated From	79	(1)
A More Sophisticated Form	80	(9)
Summary	89	(1)
Key Words and Concepts	90	(1)
Multiple Choice	90	(2)
Practice with Access 2000	92	(7)
Case Studies	99	(2)
Information From the Database: Reports and Queries	101	(60)
Chapter Objectives	101	(1)
Overview	101	(1)
Reports	102	(5)
Anatomy of a Report	104	(1)
The Report Wizard	104	(1)
Apply What You Know	104	(3)
The Report Wizard	107	(8)
Introduction to Queries	115	(5)
Query Window	116	(2)
Selection Criteria	118	(2)
Creating A Select Query	120	(7)
Grouping Records	127	(2)
Grouping Records	129	(11)
Crosstab Queries	140	(1)
Action Queries	140	(1)
Crosstab and Action Queries	141	(8)
Summary	149	(1)
Key Words and Concepts	149	(1)
Multiple Choice	150	(2)
Practice with Access 2000	152	(7)
Case Studies	159	(2)
Proficiency: Relational Databases, External Data, Charts, and the Switchboard	161	(44)
Chapter Objectives	161	(1)
Overview	161	(1)
The Investment Database	162	(3)
Multiple-Table Queries	163	(1)
Maintaining the Database	164	(1)
The Import Spreadsheet Wizard	165	(1)
Importing and Exporting Access Objects	166	(9)
Total Queries	175	(3)
Total Queries and Charts	178	(7)
The User Interface	185	(3)
The Switchboard Manager	187	(1)
Other Access Utilities	187	(1)
The Switchboard Manager	188	(7)
Summary	195	(1)
Key Words and Concepts	195	(1)
Multiple Choice	196	(2)
Practice with Access 2000	198	(5)
Case Studies	203	(2)
One-To-Many Relationships: Subforms and Multiple Table Queries	205	(54)
Chapter Objectives	205	(1)
Overview	205	(1)
Case Study: Consumer Loans	206	(5)
Referential Integrity	209	(1)
Implementation in Access	209	(2)
One-To-Many Relationships	211	(6)
Subforms	217	(3)
The Form Wizard	219	(1)
Creating A Subform	220	(8)
Multiple-Table Queries	228	(2)
Queries and Reports	230	(7)
Expanding the Database	237	(3)
Multiple Subforms	239	(1)
Linked Subforms	240	(7)
Summary	247	(1)
Key Words and Concepts	247	(1)
Multiple Choice	247	(2)
Practice with Access 2000	249	(7)
Case Studies	256	(3)
Many-To-Many Relationships: A More Complex System	259	(58)
Chapter Objectives	259	(1)
Overview	259	(1)
Case Study: The Computer Super Store	260	(6)
The AutoNumber Field Type	263	(1)
The Relationships Window	264	(1)
Referential Integrity	265	(1)
Relationships and Referential Integrity	266	(5)
Subforms, Quereies, and AutoLookup	271	(2)
Subforms and Multiple Table Queries	273	(8)
Parameter Queries	281	(2)
Total Queries	283	(2)
Learning by Doing	285	(1)
Advanced Queries	286	(8)
Expanding the Database	294	(3)
The Sales Commission Query	296	(1)
Expanding the Database	297	(9)
Summary	306	(1)
Key Words and Concepts	306	(1)
Multiple Choice	307	(2)
Practice with Access 2000	309	(6)
Case Studies	315	(2)
Building Applications: The Switchboard, Macros, and Prototyping	317	(50)
Chapter Objectives	317	(1)
Overview	317	(1)
Case Study: A Recreational Sports League	318	(6)
The Switchboard Manager	321	(1)
The Linked Tables Manager	322	(2)
The Switchboard Manager	324	(10)
Introduction to Macros	334	(2)
The Macro Window	334	(1)
The AutoExec Macro	335	(1)
Debugging	335	(1)
Application Development	336	(2)
Macros and Prototyping	338	(7)
The Player Draft	345	(4)
The Unmatched Query Wizard	346	(1)
Macro Groups	346	(3)
The Player Draft	349	(9)
Summary	358	(1)
Key Words and Concepts	358	(1)
Multiple Choice	358	(3)
Practice with Access 2000	361	(6)
Case Studies	367	(1)
Creating More Powerful Applications: Introduction to VBA	367	(48)
Chapter Objectives	367	(1)
Overview	367	(2)
Introduction to VBA	369	(4)
Modules and Procedures	371	(2)
Create a Combo Box and Associated VBA Procedure	373	(8)
Facilitating Data Entry	381	(2)
Facilitating Data Entry	383	(8)
Error Trapping	391	(2)
Error Trapping	393	(7)
Data Validation	400	(1)
Data Validation	401	(7)
Summary	408	(1)
Key Words and Concepts	408	(1)
Multiple Choice	409	(2)
Practice with Access 2000 and VBA	411	(3)
Case Studies	414	(1)
Appendix A: Toolbars	415	(8)
Appendix B: Designing a Relational Database	423	(10)
Appendix C: Combining an Access Database With a Word Form Letter	433	(10)
Appendix D: A Semester Project	443