Amazon no longer offers textbook rentals. We do!

Exploring MS Office Access Comprehensive 2003 - Revised Edition

by: Grauer, Robert T.; Barber, Maryann

Exploring MS Office Access Comprehensive 2003 - Revised Edition

by: Grauer, Robert T.; Barber, Maryann

ISBN 13:
9780131877412
ISBN 10:
0131877410
Edition: 1st
Format: Paperback
Copyright: 01/01/2006
Publisher: Pearson College Div

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

The Exploring series gives the "how and why" of performing tasks in Office 2003. It provides new chapter opening case studies, real-world practice exercises; full business and integrated end of chapter cases, and expert topics of Microsoft Office 2003.

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
Introduction to Access
Filters and Sorting
Hands-On Exercise
Filters and Sorting
Looking Ahead: A Relational Database
Hands-On Exercise
A Look Ahead
Summary
Key Terms
Multiple Choice
Practice Exercises
Mini Cases
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
Creating A Table
Forms
Properties
AutoForms and the Form Wizard
Modifying a Form
Hands-On Exercise
Creating A Form
A More Sophisticated Form
Hands-On Exercise
A More Sophisticated Form
Summary
Key Terms
Multiple Choice
Practice Exercises
Mini Cases
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
The Report Wizard
Introduction to Queries
Query Design View
Selection Criteria
Hands-On Exercise
Creating a Select Query
Access Functions and Calculated Controls
Grouping Records
Hands-On Exercise
Grouping Records
Crosstab Queries
Action Queries
Hands-On Exercise
Crosstab and Action Queries
Summary
Key Terms
Multiple Choice
Practice Exercises
Mini Cases
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
Importing Data From Excel
Total Queries
Microsoft Graph
Pivot Tables and Pivot Charts
Hands-On Exercise
Total Queries, Charts, and Pivot Tables
The User Interface
The Switchboard Manager
Other Access Utilities
Hands-On Exercise
The Switchboard Manager
Summary
Key Terms
Multiple Choice
Practice Exercises
Mini Cases
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
One-To-Many Relationships
Subforms
The Form Wizard
Hands-On Exercise
Creating A Subform
Multiple-table Queries

Queries and Reports
Expanding the Database
Multiple Subforms
Hands-On Exercise
Linked Subforms
Summary
Key Terms
Multiple Choice
Practice Exercises
Mini Cases

Table of Contents provided by Publisher. All Rights Reserved.

Amazon no longer offers textbook rentals. We do!

Exploring MS Office Access Comprehensive 2003 - Revised Edition

Exploring MS Office Access Comprehensive 2003 - Revised Edition

9780131877412

0131877410

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Exploring MS Office Access Comprehensive 2003 - Revised Edition

Exploring MS Office Access Comprehensive 2003 - Revised Edition

9780131877412

0131877410

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products