Exploring Microsoft Access 2002 Comprehensive

by Grauer, Robert T.; Barber, Maryann

• ISBN13: 9780130924308
• ISBN10: 013092430X
• Edition: 1st
• Format: Paperback
• Copyright: 2002-01-01
• Publisher: Pearson College Div

Summary

For any course teaching application software using Microsoft Office 2002 applications. This book will appeal to students in a variety of disciplines including liberal arts, business, and the sciences.The Exploring MS Office XP series gives the "when and why" of performing tasks in Office XP; it provides new integrated, real-world practice exercises; it's customizable in the RightPHit Program, certified to the core, and provides expert levels of Microsoft Office XP.

Table of Contents

EXPLORING MICROSOFT ACCESS VERSION 2002.

1. Introduction to Microsoft Access: What Is a Database?
2. Tables and Forms: Design, Properties, Views, and Wizards.
3. Information from the Database: Reports and Queries.
4. Proficiency: Relational Databases, External Data, Charts, and the Switchboard.
5. One-to-Many Relationships: Subforms and Multiple Table Queries.
6. Many-to-Many Relationships: A More Complex System.
7. Building Applications: The Switchboard, Macros, and Prototyping.
8. Creating More Powerful Applications: Introduction to VBA.
Appendix A: Toolbars.
Appendix B: Designing a Relational Database.
Appendix C: Combining an Access Database with A Word Form Letter.
Appendix D: A Semester Project.
Prerequisites: Essentials of Windows 95.

Excerpts

ABOUT THIS SERIES Continuing a tradition of excellence, Prentice Hall is proud to announce the latest update in Microsoft Office texts: the new Exploring Microsoft Office XP series by Robert T. Grauer and Maryann Barber. The hands-on approach and conceptual framework of this comprehensive series helps students master all aspects of the Microsoft Office XP software, while providing the background necessary to transfer and use these skills in their personal and professional lives. WHAT'S NEW IN THE EXPLORING OFFICE SERIES FOR XP The entire Exploring Office series has been revised to include the new features found in the Office XP Suite, which contains Word 2002, Excel 2002, Access 2002, PowerPoint 2002, Publisher 2002, FrontPage 2002, and Outlook 2002. In addition, this revision includes fully revised end-of-chapter material that provides an extensive review of concepts and techniques discussed in the chapter. Many of these exercises feature the World Wide Web and application integration. Building on the success of the Web site provided for previous editions of this series, Exploring Office XP will introduce the MyPHLIP Companion Web site, a site customized for each instructor that includes on-line, interactive study guides, data file downloads, current news feeds, additional case studies and exercises, and other helpful information. Start out at www.prenhall.com/grauer to explore these resources! Organization of the Exploring Office Series for XP The new Exploring Microsoft Office XP series includes four combined Office XP texts from which to choose: Volume Iis MOUS certified in each of the major applications in the Office suite (Word, Excel, Access, and PowerPoint). Three additional modules (Essential Computer Concepts, Essentials of Windows, and Essentials of the Internet) are also included. Volume IIpicks up where Volume I left off, covering the advanced topics for the individual applications. A VBA primer has been added. TheBrief Microsoft Office XPedition provides less coverage of the individual applications than Volume I (a total of 8 chapters as opposed to 14). The supplementary modules (Windows, Internet, and Concepts) are not included. A new volume,Getting Started with Office XP,contains the first chapter from each application (Word, Excel, Access, and PowerPoint), plus three additional modules: Essentials of Windows, Essentials of the Internet, and Essential Computer Concepts. Individual texts for Word 2002, Excel 2002, Access 2002, and PowerPoint 2002 provide complete coverage of the application and are MOUS certified. For shorter courses, we have created brief versions of the Exploring texts that give students a four-chapter introduction to each application. Each of these volumes is MOUS certified at the Core level. To complete the full coverage of this series, custom modules on Microsoft Outlook 2002, Microsoft FrontPage 2002, Microsoft Publisher 2002, and a generic introduction to Microsoft Windows are also available. The Microsoft Office User Specialist (MOUS) program is globally recognized as the standard for demonstrating desktop skills with the Microsoft Office suite of business productivity applications (Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, and Microsoft Outlook). With a MOUS certification, thousands of people have demonstrated increased productivity and have proved their ability to utilize the advanced functionality of these Microsoft applications. By encouraging individuals to develop advanced skills with Microsoft's leading business desktop software, the MOUS program helps fill the demand for qualified, knowledgeable people in the modern workplace. At the same time, MOUS helps satisfy an organization's need for a qualitative assessment of employe