Prentice Hall
My Instructor Resource Center : Log in or request access
Exploring Microsoft Office Access 2007, Comprehensive
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

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.

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: