Exploring Microsoft Office Access 2007 Comprehensive / Edition 1

Paperback (Print)
Buy New
Buy New from BN.com
Buy Used
Buy Used from BN.com
(Save 34%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 98%)
Other sellers (Paperback)
  • All (17) from $1.99   
  • New (5) from $65.00   
  • Used (12) from $1.99   


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 Comprehensive 1/e, covers the following topics: introduction to Access; relational databases and multi-table queries; how to customize, analyze, and summarize query data; create, edit and perform calculations in creating professional and useful reports; using sub-reports, advanced query types, pivot tables and charts; data protection; database maintenance; customizing a database with programming languages.Ideal for students and individuals seeking a comprehensive introduction to Access 2007.

Read More Show Less

Product Details

  • ISBN-13: 9780131567887
  • Publisher: Pearson
  • Publication date: 8/14/2007
  • Series: Exploring Series
  • Edition description: New Edition
  • Edition number: 1
  • Pages: 750
  • Product dimensions: 8.30 (w) x 10.70 (h) x 1.00 (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


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


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


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


Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 5 — Pivot Tables and Charts

Section 1 Data Mining

Create a PivotTable view

Calculate aggregate statistics

Modify a PivotTable

Hands-on Exercise 1: Create and Use a PivotTable

Section 2 Charts Convey Information

Select an appropriate chart type

Identify chart elements

Edit a PivotChart

Hands-on Exercise 2: PivotCharts and Modifications

Section 3 Calculations in PivotTables and PivotCharts

Create calculations in a PivotTable

Hands-on Exercise 3: 3 Calculating Field Values in PivotTables


Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 6 — Data Protection: Integrity, Validation, Reliability

Section 1 Data Validity

Establish Data Validity

Create a Lookup

Modify a Lookup by Adding and Deleting Values

Create and Modify a Multivalue Lookup Field

Work with Input Masks

Hands-on Exercise 1: Data Protection

Section 2 Forms

Create Forms Using the Forms Tools

Hands-on Exercise 2: Form Creation Tools

Section 3 Form Customization

Create Custom Forms Using Design View

Add Action Buttons and Combo Box Controls

Create Subforms

Fashion Functional Formats

Hands-on Exercise 3: Customizing Forms


Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 7 — Advanced Queries: Using Queries to Change Data

Section 1 Action Queries

Maintain a Database

Understand Action Queries

Create an Update Query

Use a Make table Query

Create a Delete Query

Hands-on Exercise 1: 1 Create an Update Query

Section 2 Advanced Queries

Construct Crosstab Queries

Work with Parameter Queries

Create Find Unmatched Queries

Understand Find Duplicate Queries

Hands-On Exercise 2: Advanced Queries


Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 8 — Get Connected: Exchanging Data Between Access and Other Applications

Section 1 Access and the World Wide Web

Create a Hyperlinked Field

Edit a Hyperlinked Field

Add and Use Table Attachment Fields

Hands-on Exercise 1: Make Connections

Section 2 Data Connections

Add and Use Attachment Fields in Forms and Reports

Export Objects as HTML Files

Import and Link to HTML Files

Share XML Data

Share Data with Excel

Hands-on Exercise 2: 2 Share Data

Section 3 E-Mail Management with Access and Outlook


Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 9 — Bulletproofing the Database

Section 1 Data Protection

Managing and Securing the Data

Hands-on Exercise 1: Managing and Securing the Data

Using Analysis Tools to Improve Database Performance and Documentation

Moving Data to New Database Files

Hands-on Exercise 2: Using Database Tools

Section 2 Table Design Goals: Efficient Accurate and Scalable

Analyzing and Optimizing Object Relationships in an Access Database

Section 3 Helping Database Users

Create Usable Switchboards

Hands-on Exercise 3: The Switchboard Manager


Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 10 - Customizing a database with macros and Visual Basic for Applications

Section 1 Programming with Macros

Understanding the purpose for macros in Access

Creating embedded macros using Wizards

Creating macros using the Macro Builder

Assigning macros to events

Using conditions to control macro actions

Hands-On Exercises 1: Customizing a database using macros

Section 2 Understanding database programming with Visual Basic for Applications (VBA)

Using the Visual Basic Editor

Creating procedures

Declaring Variables

Using decision structures

Using repetition structures

Managing data using Recordsets

Hands-On Exercise 2: Customizing a database using VBA


Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)