|

Prentice Hall

Information Technology

My Instructor Resource Center :  Log in or request access

Exploring Microsoft Office Access 2007, Comprehensive
Robert T. GrauerUniversity of Miami
Maurie Lockley

ISBN-10: 0131567888
ISBN-13:  9780131567887

Publisher:  Prentice Hall
Copyright:  2008
Format:  Paper; 736 pp
Published:  07/31/2007
  This item has been upgraded to EXPLORING MICROSOFT OFFC07 ACC&STUDT CD PKG.



>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

 

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

 

    Summary

    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

 

    Summary

    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

 

    Summary

    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

 

    Summary

    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

 

    Summary

    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

 

    Summary

    Key Terms

    Multiple Choice

    Practice Exercises

    Mid-Level Exercises

    Capstone Exercise

    Mini Cases

  • 9780131434783
    Exploring Microsoft Access 2003 Comprehensive
    Grauer & Barber
    ©2004 | Prentice Hall | Paper; 624 pp | Instock
    ISBN-10: 0131434780 | ISBN-13: 9780131434783
    Brief Description

Exploring Access 2007 Volume 2 Blackboard, Student Access Code
Grauer & Lockley
©2008 | Prentice Hall | Access Code Card | Estimated Availability : 03/01/2008
ISBN-10: 0135043832 | ISBN-13: 9780135043837


Exploring Access 2007 Volume 2 CourseCompass, Student Access Code
Grauer & Lockley
©2008 | Prentice Hall | Access Code Card | Estimated Availability : 03/01/2008
ISBN-10: 0135043816 | ISBN-13: 9780135043813


Exploring Access 2007 Volume 2 WebCT, Student Access Code
Grauer & Lockley
©2008 | Prentice Hall | Access Code Card | Estimated Availability : 03/01/2008
ISBN-10: 0135044197 | ISBN-13: 9780135044193


Exploring Access 2007 Volume 2 CourseCompass
Grauer & Lockley
©2008 | Prentice Hall | On-line Supplement | Estimated Availability : 03/01/2008
ISBN-10: 0135044200 | ISBN-13: 9780135044209


Exploring Access 2007 Volume 2 WebCT
Grauer & Lockley
©2008 | Prentice Hall | On-line Supplement | Estimated Availability : 03/01/2008
ISBN-10: 0135044227 | ISBN-13: 9780135044223


Exploring Access 2007 Volume 2 Blackboard
Grauer & Lockley
©2008 | Prentice Hall | On-line Supplement | Estimated Availability : 03/01/2008
ISBN-10: 0135044219 | ISBN-13: 9780135044216


Exploring Access 2007 Volume 2 Blackboard
Grauer & Lockley
©2008 | Prentice Hall | On-line Supplement | Estimated Availability : 03/01/2008
ISBN-10: 0135044219 | ISBN-13: 9780135044216


Exploring Access 2007 Volume 2 CourseCompass
Grauer & Lockley
©2008 | Prentice Hall | On-line Supplement | Estimated Availability : 03/01/2008
ISBN-10: 0135044200 | ISBN-13: 9780135044209


Exploring Access 2007 Volume 2 WebCT
Grauer & Lockley
©2008 | Prentice Hall | On-line Supplement | Estimated Availability : 03/01/2008
ISBN-10: 0135044227 | ISBN-13: 9780135044223


IRCD Exploring Microsoft Access 2007
Grauer
©2008 | Prentice Hall | CD-ROM Only | Instock
ISBN-10: 013156790X | ISBN-13: 9780131567900
  View Downloadable Files



Instructor Reference Cards Access Comprehensive t/a Exploring Microsoft Office Access 12 Comprehensive
Grauer
©2008 | Prentice Hall | Study Card | Instock
ISBN-10: 0136128076 | ISBN-13: 9780136128076


TestGen Exploring Microsoft Access 2007 Comprehensive
Grauer
©2008 | Prentice Hall | Software | Instock
ISBN-10: 0131567918 | ISBN-13: 9780131567917
  View Downloadable Files



Exploring Access 2007 Volume 2 Blackboard
Grauer & Lockley
©2008 | Prentice Hall | On-line Supplement | Estimated Availability : 03/01/2008
ISBN-10: 0135044219 | ISBN-13: 9780135044216


Exploring Access 2007 Volume 2 Blackboard, Student Access Code
Grauer & Lockley
©2008 | Prentice Hall | Access Code Card | Estimated Availability : 03/01/2008
ISBN-10: 0135043832 | ISBN-13: 9780135043837


Exploring Access 2007 Volume 2 CourseCompass
Grauer & Lockley
©2008 | Prentice Hall | On-line Supplement | Estimated Availability : 03/01/2008
ISBN-10: 0135044200 | ISBN-13: 9780135044209


Exploring Access 2007 Volume 2 CourseCompass, Student Access Code
Grauer & Lockley
©2008 | Prentice Hall | Access Code Card | Estimated Availability : 03/01/2008
ISBN-10: 0135043816 | ISBN-13: 9780135043813


Exploring Access 2007 Volume 2 WebCT
Grauer & Lockley
©2008 | Prentice Hall | On-line Supplement | Estimated Availability : 03/01/2008
ISBN-10: 0135044227 | ISBN-13: 9780135044223


Exploring Access 2007 Volume 2 WebCT, Student Access Code
Grauer & Lockley
©2008 | Prentice Hall | Access Code Card | Estimated Availability : 03/01/2008
ISBN-10: 0135044197 | ISBN-13: 9780135044193


Exploring Microsoft Access 2007 Comprehensive Student CD
Grauer
©2008 | Prentice Hall | CD-ROM Only | Instock
ISBN-10: 0131567896 | ISBN-13: 9780131567894


PHIT TIPS Microsoft Access 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0131588346 | ISBN-13: 9780131588349
Buy from myPearsonStore


PHIT Tips: File Management
PrenticeHall
©2008 | Prentice Hall | Study Card; 2 pp | Instock
ISBN-10: 0131588354 | ISBN-13: 9780131588356
Buy from myPearsonStore


PHIT Tips: Microsoft Office 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0132332221 | ISBN-13: 9780132332224
Buy from myPearsonStore


PHIT Tips: Microsoft Outlook 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0132050625 | ISBN-13: 9780132050623
Buy from myPearsonStore


PHIT Tips: Microsoft PowerPoint 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0132332558 | ISBN-13: 9780132332552
Buy from myPearsonStore


PHIT Tips: Microsoft Word 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0132050617 | ISBN-13: 9780132050616
Buy from myPearsonStore


PHIT Tips: WinZip for Microsoft Office 2007
PrenticeHall
©2008 | Prentice Hall | Study Card | Instock
ISBN-10: 0131588311 | ISBN-13: 9780131588318
Buy from myPearsonStore


Phit TIPS: Microsoft Excel 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0136128017 | ISBN-13: 9780136128014
Buy from myPearsonStore


Shortcut Key Card: Microsoft Access 2007
PrenticeHall
©2008 | Prentice Hall | Study Card | Out of Stock
ISBN-10: 0132050609 | ISBN-13: 9780132050609


Shortcut Key Card: Microsoft Excel 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0132332531 | ISBN-13: 9780132332538
Buy from myPearsonStore


Shortcut Key Card: Microsoft Office 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 2 pp | Instock
ISBN-10: 0131588400 | ISBN-13: 9780131588400
Buy from myPearsonStore


Shortcut Key Card: Microsoft PowerPoint 2007
PrenticeHall
©2008 | Prentice Hall | Study Card | Out of Stock
ISBN-10: 013158832X | ISBN-13: 9780131588325


Shortcut Key Card: Microsoft Word 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 2 pp | Instock
ISBN-10: 0136128009 | ISBN-13: 9780136128007
Buy from myPearsonStore


Windows Vista PHIT Tip
CIS Prentice Hall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0136128025 | ISBN-13: 9780136128021
Buy from myPearsonStore


Exploring Access 2007 Volume 2 Blackboard, Student Access Code
Grauer & Lockley
©2008 | Prentice Hall | Access Code Card | Estimated Availability : 03/01/2008
ISBN-10: 0135043832 | ISBN-13: 9780135043837


Exploring Access 2007 Volume 2 CourseCompass, Student Access Code
Grauer & Lockley
©2008 | Prentice Hall | Access Code Card | Estimated Availability : 03/01/2008
ISBN-10: 0135043816 | ISBN-13: 9780135043813


Exploring Access 2007 Volume 2 WebCT, Student Access Code
Grauer & Lockley
©2008 | Prentice Hall | Access Code Card | Estimated Availability : 03/01/2008
ISBN-10: 0135044197 | ISBN-13: 9780135044193


Exploring Access 2007 Volume 2 CourseCompass
Grauer & Lockley
©2008 | Prentice Hall | On-line Supplement | Estimated Availability : 03/01/2008
ISBN-10: 0135044200 | ISBN-13: 9780135044209


Exploring Access 2007 Volume 2 WebCT
Grauer & Lockley
©2008 | Prentice Hall | On-line Supplement | Estimated Availability : 03/01/2008
ISBN-10: 0135044227 | ISBN-13: 9780135044223


Exploring Access 2007 Volume 2 Blackboard
Grauer & Lockley
©2008 | Prentice Hall | On-line Supplement | Estimated Availability : 03/01/2008
ISBN-10: 0135044219 | ISBN-13: 9780135044216


Give your students a choice! PearsonChoices products are designed to give your students more value and flexibility by letting them choose from a variety of text and media formats to best match their learning style and their budget.

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, see the Packages Tab.

  • 9780135075494
    Custom PHIT 2007
    Pearson Custom Publishing
    ©2009 | Prentice Hall | On-line Supplement | Instock
    ISBN-10: 0135075491 | ISBN-13: 9780135075494
    Brief Description

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: 0136116507 | ISBN-13: 9780136116509
©2010 | Instock (Additional assembly time required) | Suggested retail price: $271.20 | Buy from myPearsonStore
This package contains:

Grauer & Lockley | ©2008 | Prentice Hall | Paper; 736 pp
Arens, Elder & Beasley | ©2010 | Prentice Hall | Cloth; 872 pp