Exploring Microsoft Office Access 2007 Volume 1 / Edition 7

Exploring Microsoft Office Access 2007 Volume 1 / Edition 7

by Robert T. Grauer, Keith Mulbery, Maurie Wigman Lockley, Keith Mulbery
     
 

ISBN-10: 0132252120

ISBN-13: 9780132252126

Pub. Date: 06/15/2007

Publisher: Prentice Hall

The Exploring series helps students master the "How and Why" of performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles feature “Perfect pages” where every step of every hands-on exercise as well as every end-of-chapter problem begins on a new page

…  See more details below

Overview

The Exploring series helps students master the "How and Why" of performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles feature “Perfect pages” where 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 to make it easier to follow. Each chapter contains Hands-on Exercises, Capstone Exercises, and Mini-Cases for practicing and reviewing skills acquired. Exploring Microsoft Office Access 2007 Volume 1, 1/e covers the following topics: introduction to Access and databases; relational databases and multi-table queries; customize, analyze, and summarize query data; creating and editing professional, useful reports Ideal for students and individuals seeking comprehensive instruction for Access 2007.

Product Details

ISBN-13:
9780132252126
Publisher:
Prentice Hall
Publication date:
06/15/2007
Series:
Exploring Series
Edition description:
New Edition
Pages:
368
Product dimensions:
8.72(w) x 10.74(h) x 0.60(d)

Table of Contents

Chapter 1 - Introduction to Access: Finding Your Way through a Database

Section 1: Data and Files Everywhere!

Exploring, Describing, and Navigating Among the Objects in an Access Database

Understanding the Difference Between Working in Storage and Memory

Practicing Good File Management

Backing up, Compacting, and Repairing Access Files

Hands-On Exercises 1 Introduction to Databases

Section 2: Filters, Sorts, and Access Versus Excel

Creating Filters

Sorting Table Data on One or More Fields

Knowing When to Use Access or Excel to Manage Data

Hands-On Exercises 2: Data Manipulation: Filters and Sorts

Section 3: The Relational Database

Using the Relationship Window

Understanding Relational Power

Hands-On Exercises 3: Introduction to Relationships

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 2 - Relational Databases and Multi-Table Queries: Designing Databases and Using

Section 1: Related Data

Table Design, Properties, Views, and Wizards

Designing Data

Creating Tables

Hands-On Exercises 1: Table Design, Properties, Views, and Wizards

Section 2: Multiple Table Database

Understanding Table Relationships

Sharing Data with Excel

Establishing Table Relationships

Hands-on Exercises 2: Imports and Relationships

Section 3: Queries

Creating a Query

Specifying Criteria for Different Data Types

Copying and Running a Query

Using the Query Wizard

Understanding Large Database Differences

Hands-On Exercises 3: Multi-Table Query

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 3 - Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Section 1: Data Summary and Analysis

Understanding the Order of Precedence

Creating a Calculated Field in a Query

Hands-On Exercises 1: Calculated Query Fields

Section 2: Expression Builder

Creating Expressions with the Expression Builder

Creating and Editing Access Functions

Performing Date Arithmetic

Hands-On Exercises 2: Expression Builder, Functions, and Date Arithmetic

Section 3: Data Aggregates

Creating and Working with Data Aggregates

Hands-On Exercises 3: Data Aggregates

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 4 - Create, Edit and Perform Calculations in Reports: Creating Professional and Useful Reports

Section 1: Appearance Matter

Planning Reports

Using Different Report Views

Creating and Editing a Report

Hands-On Exercises 1: Introduction to Access Reports

Section 2: The Anatomy of a Report

Identifying Report Elements, Sections and Controls

Adding Grouping Levels Using the Layout View

Adding Fields to a Report

Hands-On Exercises 2: Create, Sort, Edit, Nest and Remove Groups from Reports

Section 3: The Report and Label Wizard

Using the Report Wizard

Hands-On Exercises 3: Report Wizard

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >