×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Microsoft Office Access 2003 Comprehensive / Edition 1
     

Microsoft Office Access 2003 Comprehensive / Edition 1

by Robert T. Grauer, Maryann Barber
 

ISBN-10: 0131877410

ISBN-13: 9780131877412

Pub. Date: 08/03/2005

Publisher: Pearson

Product Details

ISBN-13:
9780131877412
Publisher:
Pearson
Publication date:
08/03/2005
Series:
Grauer Exploring Office 2003 Series
Edition description:
REV
Pages:
736
Product dimensions:
8.94(w) x 10.98(h) x 1.11(d)

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

 

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews