New Perspectives on Microsoft Office Access 2003, Comprehensive, Second Edition

by ADAMSKI/FINNEGAN/HOMMEL

• ISBN13: 9780619268114
• ISBN10: 0619268115
• Edition: 2nd
• Format: Paperback
• Copyright: 2005-02-14
• Publisher: Cengage Learning

Summary

Part of the New Perspectives series, this text offers a case-based, problem-solving approach and innovative technology to make learning Microsoft Access 2003 skills both meaningful and memorable for users. This Second Edition has been updated to include a variety of new material to keep your course up-to-date and engaging.

Table of Contents

Preface	p. v
File Management	p. 1
Read This Before You Begin	p. 2
Managing Your Files	p. 3
Creating and Working with Files and Folders in Windows XP	p. 3
Office	p. 1
Read This Before You Begin	p. 2
Using Common Features of Microsoft Office 2003	p. 3
Preparing Promotional Materials	p. 3
Access: Level I Tutorials	p. 1
Read This Before You Begin	p. 2
Introduction to Microsoft Access 2003	p. 3
Viewing and Working with a Table Containing Employer Data	p. 3
Creating and Maintaining a Database	p. 35
Creating the Northeast Database, and Creating, Modifying, and Updating the Position Table	p. 35
Querying a Database	p. 81
Retrieving Information About Employers and Their Positions	p. 81
Creating Forms and Reports	p. 129
Creating a Position Data Form, an Employer Positions Form, and an Employers and Positions Report	p. 129
Access: Level II Tutorials	p. 169
Read This Before You Begin	p. 170
Enhancing a Table's Design and Creating Advanced Queries	p. 171
Making the Jobs Database Easier to Use	p. 171
Creating Custom Forms	p. 221
Creating a Multi-page Form	p. 221
Creating Custom Reports	p. 287
Creating a Potential Income Report	p. 287
Integrating Access with the Web and with Other Programs	p. 369
Creating Web-Enabled and Integrated Information for the Jobs Database	p. 369
Access: Level III Tutorials	p. 441
Read This Before You Begin	p. 442
Using Action Queries and Defining Table Relationships	p. 443
Enhancing User Interaction with the Overseas Database	p. 443
Automating Tasks with Macros	p. 489
Creating a User Interface for the Overseas Database	p. 489
Using and Writing Visual Basic for Applications Code	p. 553
Creating VBA Code for the Overseas Database User Interface	p. 553
Managing and Securing a Database	p. 599
Managing and Securing the Overseas Database	p. 599
Enhancing an Investment Club Database	p. 1
Tracking Parking Permits and Violations	p. 7
Internship Program for Pontiac College	p. 13
Relational Databases and Database Design	p. 1
Tables	p. 2
Keys	p. 3
Relationships	p. 5
One-to-One	p. 6
One-to-Many	p. 6
Many-to-Many	p. 7
Entity Subtype	p. 8
Entity-Relationship Diagrams	p. 9
Integrity Constraints	p. 11
Dependencies and Determinants	p. 11
Anomalies	p. 14
Normalization	p. 15
First Normal Form	p. 15
Second Normal Form	p. 17
Third Normal Form	p. 19
Natural, Aritificial, and Surrogate Keys	p. 21
Microsoft Access Naming Conventions	p. 25
Summary	p. 28
Key Terms	p. 28
Review Questions	p. 28
Glossary/Index	p. 1
Task Reference	p. 18
Microsoft Office Specialist Certification Grid	p. 23
Table of Contents provided by Ingram. All Rights Reserved.