Humanities & Social Sciences
Math & Science
Professional & Career
- Business
- Business Statistics
- Communication Sciences & Disorders
- Computer Science
- Counseling
- Criminal Justice
- Culinary, Hospitality, Travel & Tourism
- Deaf Studies & Deaf Education
- Economics
- Education
- EMS & Fire Science (Brady)
- Engineering
- Fashion & Interior Design
- Health Professions
- Information Technology
- Legal Studies & Paralegal
- Nursing
- Student Success & Career Development
- Trades & Technology
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
We're sorry, this product is no longer available and has been replaced with Exploring Microsoft Office Access 2007 Comprehensive.
Please contact your Pearson rep if you are using this product and need instructor resources.
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
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
Previous Edition(s)
Grauer & Barber
©2004 | Prentice Hall | Paper; 624 pp | Out of Print
ISBN-10: 0131434780 | ISBN-13: 9780131434783
Brief Description | More Info
Grauer & Lockley
©2008
|
On-line Supplement
|
Estimated Availability : 03/01/2008
ISBN-10: 0135044219 |
ISBN-13: 9780135044216
Instructors, request content (at no cost)
|
More Info
Grauer & Lockley
©2008
|
On-line Supplement
|
Estimated Availability : 03/01/2008
ISBN-10: 0135044200 |
ISBN-13: 9780135044209
Take a Tour
|
More Info
Grauer & Lockley
©2008
|
On-line Supplement
|
Estimated Availability : 03/01/2008
ISBN-10: 0135044227 |
ISBN-13: 9780135044223
More Info
Grauer
©2008
|
Prentice Hall
|
Access Code Card
|
Instock
ISBN-10: 0536551693 |
ISBN-13: 9780536551696
More Info
Grauer
©2008
|
Prentice Hall
|
Access Code Card
|
Instock
ISBN-10: 0536551723 |
ISBN-13: 9780536551726
More Info
Grauer
©2008
|
Prentice Hall
|
Access Code Card
|
Instock
ISBN-10: 0536551766 |
ISBN-13: 9780536551764
More Info
Grauer
©2008
|
Prentice Hall
|
CD-ROM Only
|
Instock
ISBN-10: 013156790X |
ISBN-13: 9780131567900
|
| | | More Info |
Grauer
©2008
|
Prentice Hall
|
On-line Supplement
|
Live
ISBN-10: 0131567918 |
ISBN-13: 9780131567917
|
| | | More Info |
Grauer & Lockley
©2008
|
On-line Supplement
|
Estimated Availability : 03/01/2008
ISBN-10: 0135044219 |
ISBN-13: 9780135044216
Instructors, request content (at no cost)
|
More Info
Grauer & Lockley
©2008
|
On-line Supplement
|
Estimated Availability : 03/01/2008
ISBN-10: 0135044200 |
ISBN-13: 9780135044209
Take a Tour
|
More Info
Grauer & Lockley
©2008
|
On-line Supplement
|
Estimated Availability : 03/01/2008
ISBN-10: 0135044227 |
ISBN-13: 9780135044223
More Info
Access code cards
Grauer
©2008
|
Prentice Hall
|
Access Code Card
|
Instock
ISBN-10: 0536551693 |
ISBN-13: 9780536551696
More Info
Grauer
©2008
|
Prentice Hall
|
Access Code Card
|
Instock
ISBN-10: 0536551723 |
ISBN-13: 9780536551726
More Info
Grauer
©2008
|
Prentice Hall
|
Access Code Card
|
Instock
ISBN-10: 0536551766 |
ISBN-13: 9780536551764
More Info
Grauer & Lockley
©2008
|
On-line Supplement
|
Estimated Availability : 03/01/2008
ISBN-10: 0135044219 |
ISBN-13: 9780135044216
More Info
Grauer & Lockley
©2008
|
On-line Supplement
|
Estimated Availability : 03/01/2008
ISBN-10: 0135044200 |
ISBN-13: 9780135044209
More Info
Grauer & Lockley
©2008
|
On-line Supplement
|
Estimated Availability : 03/01/2008
ISBN-10: 0135044227 |
ISBN-13: 9780135044223
More Info
Grauer
©2008
|
Prentice Hall
|
CD-ROM Only
|
Instock
ISBN-10: 0131567896 |
ISBN-13: 9780131567894
More Info
For the CIS: Office Applications Discipline
PHIT TIPS Microsoft Access 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 4 pp
|
Instock
ISBN-10: 0131588346 |
ISBN-13: 9780131588349
More Info
PHIT Tips: File Management
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 2 pp
|
Instock
ISBN-10: 0131588354 |
ISBN-13: 9780131588356
More Info
Phit TIPS: Microsoft Excel 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 4 pp
|
Instock
ISBN-10: 0136128017 |
ISBN-13: 9780136128014
More Info
PHIT Tips: Microsoft Office 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 4 pp
|
Instock
ISBN-10: 0132332221 |
ISBN-13: 9780132332224
More Info
PHIT Tips: Microsoft Outlook 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 4 pp
|
Instock
ISBN-10: 0132050625 |
ISBN-13: 9780132050623
More Info
PHIT Tips: Microsoft PowerPoint 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 4 pp
|
Instock
ISBN-10: 0132332558 |
ISBN-13: 9780132332552
More Info
PHIT Tips: Microsoft Word 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 4 pp
|
Instock
ISBN-10: 0132050617 |
ISBN-13: 9780132050616
More Info
PHIT Tips: WinZip for Microsoft Office 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card
|
Instock
ISBN-10: 0131588311 |
ISBN-13: 9780131588318
More Info
Shortcut Key Card: Microsoft Office 2007
PrenticeHall
©2008
|
Prentice Hall
|
Study Card; 2 pp
|
Instock
ISBN-10: 0131588400 |
ISBN-13: 9780131588400
More Info
Windows Vista PHIT Tip
Prentice Hall
©2008
|
Prentice Hall
|
Study Card; 4 pp
|
Instock
ISBN-10: 0136128025 |
ISBN-13: 9780136128021
More Info
Websites and Online Courses
Grauer & Lockley
©2008
|
On-line Supplement
|
Estimated Availability : 03/01/2008
ISBN-10: 0135044219 |
ISBN-13: 9780135044216
Instructors, request content (at no cost)
|
More Info
Grauer & Lockley
©2008
|
On-line Supplement
|
Estimated Availability : 03/01/2008
ISBN-10: 0135044200 |
ISBN-13: 9780135044209
Take a Tour
|
More Info
Grauer & Lockley
©2008
|
On-line Supplement
|
Estimated Availability : 03/01/2008
ISBN-10: 0135044227 |
ISBN-13: 9780135044223
More Info
Grauer
©2008
|
Prentice Hall
|
Access Code Card
|
Instock
ISBN-10: 0536551693 |
ISBN-13: 9780536551696
More Info
Grauer
©2008
|
Prentice Hall
|
Access Code Card
|
Instock
ISBN-10: 0536551723 |
ISBN-13: 9780536551726
More Info
Grauer
©2008
|
Prentice Hall
|
Access Code Card
|
Instock
ISBN-10: 0536551766 |
ISBN-13: 9780536551764
More Info
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
©2009 | Prentice Hall | On-line Supplement | Live
ISBN-10: 0135075491 | ISBN-13: 9780135075494
Brief Description | More Info
Log in to the Instructor Resource Center
Login name:
Password:
Forgot login/password? | Need to redeem an access code?
Instructor Resource Center File Download
This work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning. Dissemination or sale of any part of this work (including on the World Wide Web) will destroy the integrity of the work and is not permitted. The work and materials from this site should never be made available to students except by instructors using the accompanying text in their classes. All recipients of this work are expected to abide by these restrictions and to honor the intended pedagogical purposes and the needs of other instructors who rely on these materials.| Cancel | I accept, proceed with download |
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 contact your Pearson Higher Education representative.
