Humanities & Social Sciences
Math & Science
Professional & Career
- Business
- Business Statistics
- Communication Sciences & Disorders
- Computer Science
- Counseling
- Criminal Justice
- Culinary, Hospitality, Travel & Tourism
- Deaf Studies & Deaf Education
- Economics
- Education
- EMS & Fire Science (Brady)
- Engineering
- Fashion & Interior Design
- Health Professions
- Information Technology
- Legal Studies & Paralegal
- Nursing
- Student Success & Career Development
- Trades & Technology
Exploring MS Office Access Comprehensive 2003 - Revised Edition
ISBN-10: 0131877410
ISBN-13: 9780131877412
Publisher: Prentice Hall
Copyright: 2006
Format: Paper; 736 pp
Published: 08/03/2005
Status: Out of Print
We're sorry, this product is no longer available.
Please contact your Pearson rep if you are using this product and need instructor resources.
Description
For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.
Master the How and Why of Office 2003! Students master the "How and Why" of performing tasks in Office and gain a greater understanding of how to use the individual applications together to solve business problems.
Features
Chapter opening case studies—to preview the skills covered in each chapter and to set the stage of learning.
Three levels of chapter-ending exercises—Multiple Choice (study guide), Practice (hands-on), and Case Studies (open-ended).
º Offers students plenty of opportunity for review and reinforcement.
All supplements for this series, including Instructor's Manual, Solutions Disk, PowerPoint, and Data Disks, as well as the Computerized Testing System, are available on one CD—InstructorResourceCenter.
Perfect pages - every step of every hands-on exercise as well as every end-of-chapter problem begins on a new page and has its own screen shot:
º Perfect pages are unique to Grauer and ensure students always know where to begin and end assignments.
Accompanying website featuring MyPHLIP technology.
º Provides students and instructors with additional resources and tools to facilitate the learning process.
MOS Certification through the Expert level for all individual applications and Office 2003.
º Provides the necessary training to pass the MOS exam at the Expert level, preparing students to enter today's job market.
Quality, four-color, spiral bound—Exploring Office series covers Word, Access, Excel, and PowerPoint. There are four combined texts in the series—Exploring Microsoft Office Vol. I and II, Microsoft Office Brief, and Getting Started with Microsoft Office.
º Gives students up-to-date information on current applications in an attractive easy-to-use format. (Perfect binding is also available).
Sequential Page Numbering throughout each text. Pages start with number 1 and move sequential. For example Page 1 to 1000.
º This ensures instructors and students can find assigned material.
New To This Edition
- NEW! A new chapter (Chapter 9) on database design and implementation that reviews material from earlier chapters as it takes the student through the development cycle
- NEW! All new chapter-opening case studies
Table of Contents
Chapter 1: Introduction to Access: What Is a Database?
Objectives
Case Study: The South Vancouver Preschool
The College Bookstore
Introduction to Microsoft Access
The Database Window
Tables
Forms, Queries, and Reports
HANDS-ON EXERCISE 1: INTRODUCTION TO ACCESS
Filters and Sorting
HANDS-ON EXERCISE 2: FILTERS AND SORTING
Looking Ahead: A Relational Database
HANDS-ON EXERCISE 3: A LOOK AHEAD
Summary
Key Terms
Multiple Choice
Practice Exercises
Mini Cases
Chapter 2: Tables and Forms: Design, Properties, Views, and Wizards
Objectives
Case Study: Debbie's Fine Fashions
A Student Database
Include the Necessary Data
Store Data in Its Smallest Parts
Avoid Calculated Fields
Creating a Table
Primary Key
Views
Properties
HANDS-ON EXERCISE 1: CREATING A TABLE
Forms
Properties
AutoForms and the Form Wizard
Modifying a Form
HANDS-ON EXERCISE 2: CREATING A FORM
A More Sophisticated Form
HANDS-ON EXERCISE 3: A MORE SOPHISTICATED FORM
Summary
Key Terms
Multiple Choice
Practice Exercises
Mini Cases
Chapter 3: Information from the Database: Reports and Queries
Objectives
Case Study: The Garden Club
Data Versus Information
Reports
Anatomy of a Report
The Report Wizard
Apply What You Know
Bound, Unbound, and Calculated Controls
HANDS-ON EXERCISE 1: THE REPORT WIZARD
Introduction to Queries
Query Design View
Selection Criteria
HANDS-ON EXERCISE 2: CREATING A SELECT QUERY
Access Functions and Calculated Controls
Grouping Records
HANDS-ON EXERCISE 3: GROUPING RECORDS
Crosstab Queries
Action Queries
HANDS-ON EXERCISE 4: CROSSTAB AND ACTION QUERIES
Summary
Key Terms
Multiple Choice
Practice Exercises
Mini Cases
Chapter 4: Proficiency: Relational Databases, Pivot Charts, and the Switchboard
Objectives
Case Study: The Disc Jockey
The Investment Database
Multiple-table Queries
Maintaining the Database
The Import Spreadsheet Wizard
HANDS-ON EXERCISE 1: IMPORTING DATA FROM EXCEL
Total Queries
Microsoft Graph
Pivot Tables and Pivot Charts
HANDS-ON EXERCISE 2: TOTAL QUERIES, CHARTS, AND PIVOT TABLES
The User Interface
The Switchboard Manager
Other Access Utilities
HANDS-ON EXERCISE 3: THE SWITCHBOARD MANAGER
Summary
Key Terms
Multiple Choice
Practice Exercises
Mini Cases
Chapter 5: One-to-many Relationships: Subforms and Multiple-table Queries
Objectives
Case Study: The Residential Colleges
A Database for Consumer Loans
The AutoNumber Field Type
Referential Integrity
Implementation in Access
HANDS-ON EXERCISE 1: ONE-TO-MANY RELATIONSHIPS
Subforms
The Form Wizard
HANDS-ON EXERCISE 2: CREATING A SUBFORM
Multiple-table Queries
HANDS-ON EXERCISE 3: QUERIES AND REPORTS
Expanding the Database
Multiple Subforms
HANDS-ON EXERCISE 4: LINKED SUBFORMS
Summary
Key Terms
Multiple Choice
Practice Exercises
Mini Cases
Chapter 6: Many-to-many Relationships: A More Complex System
Objectives
Case Study: At Your Service
The Computer Superstore
The AutoNumber Field Type
The Relationships Window
HANDS-ON EXERCISE 1: RELATIONSHIPS AND REFERENTIAL INTEGRITY
Subforms, Queries, and AutoLookup
HANDS-ON EXERCISE 2: SUBFORMS AND MULTIPLE-TABLE QUERIES
Parameter Queries
Total Queries
Learning by Doing
HANDS-ON EXERCISE 3: ADVANCED QUERIES
Expanding the Database
The Sales Commission Query
HANDS-ON EXERCISE 4: EXPANDING THE DATABASE
Summary
Key Terms
Multiple Choice
Practice Exercises
Mini Cases
Chapter 7: Building Applications: Macros and a Multilevel Switchboard
Objectives
Case Study: The Movie Studio
A Recreational Sports League
The Switchboard Manager
The Linked Tables Manager
HANDS-ON EXERCISE 1: THE SWITCHBOARD MANAGER
Introduction to Macros
The Macro Window
The AutoExec Macro
Debugging
Application Development
HANDS-ON EXERCISE 2: MACROS AND PROTOTYPING
The Player Draft
Macro Groups
HANDS-ON EXERCISE 3: THE PLAYER DRAFT
Summary
Key Terms
Multiple Choice
Practice Exercises
Mini Cases
Chapter 8: Creating More Powerful Applications: Introduction to VBA
Objectives
Case Study: Return to the Auction
Introduction to VBA
A Better Student Form
Modules and Procedures
HANDS-ON EXERCISE 1: CREATING A COMBO BOX AND
ASSOCIATED VBA PROCEDURE
Facilitating Data Entry
HANDS-ON EXERCISE 2: FACILITATING DATA ENTRY
Error Trapping
HANDS-ON EXERCISE 3: ERROR TRAPPING
Data Validation
HANDS-ON EXERCISE 4: DATA VALIDATION
Summary
Key Terms
Multiple Choice
Practice Exercises
Mini Cases
Chapter 9: Design and Implementation: A Capstone Chapter
Objectives
Case Study: The Group Project
The Development Cycle
From Output to Input
Database Design
HANDS-ON EXERCISE 1: DATABASE DESIGN
Detailed Design
AutoNumber and Field Type
Referential Integrity and Required fields
HANDS-ON EXERCISE 2: THE DETAILED DESIGN
The Visual Design - Version 1.0
The Templates
HANDS-ON EXERCISE 3: THE VISUAL DESIGN
A Basic Form and Report
HANDS-ON EXERCISE 4: A BASIC FORM AND REPORT
Prototyping - "Complete the System"
Macros - A Quick Review
HANDS-ON EXERCISE 5: PROTOTYPING - COMPLETE THE SYSTEM
Add The Reports
HANDS-ON EXERCISE 6: ADD THE REPORTS
The Orders Form
HANDS-ON EXERCISE 7: THE ORDERS FORM
Security Issues
HANDS-ON EXERCISE 8: SUBMISSION TO THE CLIENT
Summary
Key Words and Concepts
Multiple Choice
Practice Exercises
Mini Case
Appendix A: The Design of a Relational Database
Objectives
Overview
Case Study: Fast Food Franchises
Single Table Solution
Multiple Table Solution
Queries to the Database
The Relational Model
Case Study: Student Transcripts
Introduction to Normalization
Case Study: Order Entry
The Normalization Process
An Easy Way to Third Normal Form
Queries to the Database
Summary
Key Terms
Multiple Choice
Appendix B: Toolbars
Appendix C: Mail Merge
Overview
Appendix D: Using XML with Microsoft® Access 2003
Overview
Introduction to XML
HANDS-ON EXERCISE 1: INTRODUCTION TO XML
Microsoft Access and XML
HANDS-ON EXERCISE 2: ACCESS AND XML
Summary
Key Terms
Multiple Choice
Getting Started with Microsoft® Windows XP
Objectives
Case Study: Unforeseen Circumstances
Welcome to Windows XP
The Desktop
Moving and Sizing a Window
Anatomy of a Window
Pull-down Menus
Dialog Boxes
Help and Support Center
HANDS-ON EXERCISE 1: WELCOME TO WINDOWS XP
Files and Folders
The Exploring Office Practice Files
Connecting to the Internet
HANDS-ON EXERCISE 2: DOWNLOAD THE PRACTICE FILES
Windows Explorer
Personal Folders
Moving and Copying a File
Deleting a File
Backup
HANDS-ON EXERCISE 3: WINDOWS EXPLORER
Increasing Productivity
The Control Panel
Shortcuts
The Search Companion
HANDS-ON EXERCISE 4: INCREASING PRODUCTIVITY
Fun with Windows XP
Windows Media Player
Digital Photography
Windows Messenger
HANDS-ON EXERCISE 5: FUN WITH WINDOWS XP
Summary
Key Terms
Multiple Choice
Practice with Windows XP
Mini Cases
Getting Started with VBA: Extending Microsoft Office 2003
Objectives
Case Study: On-the-Job Training
Introduction to VBA
The MsgBox Statement
The InputBox Function
Declaring Variables
The VBA Editor
HANDS-ON EXERCISE 1: INTRODUCTION TO VBA
If . . . Then . . . Else Statement
Case Statement
Custom Toolbars
HANDS-ON EXERCISE 2: DECISION MAKING
For . . . Next Statement
Do Loops
Debugging
HANDS-ON EXERCISE 3: LOOPS AND DEBUGGING
Putting VBA to Work (Microsoft Excel)
HANDS-ON EXERCISE 4: EVENT-DRIVEN PROGRAMMING (MICROSOFT EXCEL)
Putting VBA to Work (Microsoft Access)
HANDS-ON EXERCISE 5: EVENT-DRIVEN PROGRAMMING (MICROSOFT ACCESS)
Summary
Key Terms
Multiple Choice
Previous Edition(s)
Grauer & Barber
©2004 | Prentice Hall | Paper; 624 pp | Out of Print
ISBN-10: 0131434780 | ISBN-13: 9780131434783
Brief Description | More Info
Author Bios
Dr. Robert T. Grauer
Dr. Robert T. Grauer is an Associate Professor in the Department of Computer Information Systems at the University of Mniami where he has been honored with the Outstanding Teacher Award in the School of Business.
Dr. Grauer has written more than 20 books on programming and information systems. His work has been translated into three foreign languages and is in use at all levels of higher education at both the national and international level.
Dr. Grauer has also been a consultant to several major corporations including IBM and American Express. He received his Ph.D. in Operations Research in 1972 from the Polytechnic Institute of Brooklyn.
Maryann M. Barber
Maryann M. Barber is a lecturer in the Department of Computer Information Systems at the University of Miami. She has been honored with several teaching awards, including the Excellence in Teaching Awards for the School of Business, the Freshman Teaching Award, the Apple Polishing Award, the Student Government Professor of the Year Award, the Interfraternity Council Professor of the Year Award, and the University of Miami Excellence in Teaching Award.
Maryann is also the Faculty Master at Stanford Residential College. She is a member of numerous leadership honor societies at the University of Miami, including Iron Arrow, Mortar Board, and Omicron Delta Kappa.
Grauer
©2006
|
Prentice Hall
|
On-line Supplement
|
Live
ISBN-10: 013172889X |
ISBN-13: 9780131728899
|
| | | More Info |
For the CIS: Office Applications Discipline
PHIT TIPS Microsoft Access 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 4 pp
|
Instock
ISBN-10: 0131588346 |
ISBN-13: 9780131588349
More Info
PHIT Tips: File Management
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 2 pp
|
Instock
ISBN-10: 0131588354 |
ISBN-13: 9780131588356
More Info
Phit TIPS: Microsoft Excel 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 4 pp
|
Instock
ISBN-10: 0136128017 |
ISBN-13: 9780136128014
More Info
PHIT Tips: Microsoft Office 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 4 pp
|
Instock
ISBN-10: 0132332221 |
ISBN-13: 9780132332224
More Info
PHIT Tips: Microsoft Outlook 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 4 pp
|
Instock
ISBN-10: 0132050625 |
ISBN-13: 9780132050623
More Info
PHIT Tips: Microsoft PowerPoint 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 4 pp
|
Instock
ISBN-10: 0132332558 |
ISBN-13: 9780132332552
More Info
PHIT Tips: Microsoft Word 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 4 pp
|
Instock
ISBN-10: 0132050617 |
ISBN-13: 9780132050616
More Info
PHIT Tips: WinZip for Microsoft Office 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card
|
Instock
ISBN-10: 0131588311 |
ISBN-13: 9780131588318
More Info
Shortcut Key Card: Microsoft Office 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 2 pp
|
Instock
ISBN-10: 0131588400 |
ISBN-13: 9780131588400
More Info
Windows Vista PHIT Tip
Prentice Hall
©2008
|
Prentice Hall
|
Study Card; 4 pp
|
Instock
ISBN-10: 0136128025 |
ISBN-13: 9780136128021
More Info
Log in to the Instructor Resource Center
Login name:
Password:
Forgot login/password? | Need to redeem an access code?
Instructor Resource Center File Download
This work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning. Dissemination or sale of any part of this work (including on the World Wide Web) will destroy the integrity of the work and is not permitted. The work and materials from this site should never be made available to students except by instructors using the accompanying text in their classes. All recipients of this work are expected to abide by these restrictions and to honor the intended pedagogical purposes and the needs of other instructors who rely on these materials.| Cancel | I accept, proceed with download |
Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, browse our available packages below, or contact your Pearson Higher Education representative to create your own package.
Package ISBN-10: 0131890751 | ISBN-13: 9780131890756
©2006 | Out of Stock
Suggested retail price: $77.33 Buy from myPearsonStore
This package contains:
Pearson | ©2004 | Prentice Hall | Paper; 0 pp
Package ISBN-10: 0132293986 | ISBN-13: 9780132293983
©2006 | Not Yet Published
Suggested retail price: $72.67
This package contains:
Grauer | ©2004 | Prentice Hall | CD-ROM Only; 0 pp
Package ISBN-10: 0132288850 | ISBN-13: 9780132288859
©2006 | Out of Stock
Suggested retail price: $109.33 Buy from myPearsonStore
This package contains:
Pearson | ©2004 | Prentice Hall | Paper; 0 pp
Pearson | ©2006 | Prentice Hall | Kit/Package/ShrinkWrap
