Exploring Microsoft Office Access 2007, Volume 1
by Grauer, Robert; Lockley, MaurieEdition: 1st
Format: Paperback
Pub. Date: 2008-01-01
Publisher(s): Prentice Hall
Other versions by this Author
List Price: $83.00
Rent Textbook
Select for Price
New Textbook
We're Sorry
Sold Out
Used Textbook
We're Sorry
Sold Out
eTextbook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
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/ecovers 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 reportsIdeal for students and individuals seeking comprehensive instruction for Access 2007.
Table of Contents
| Introduction to Access: Finding Your Way through a Database | |
| 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 | |
| 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 | |
| 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 | |
| Relational Databases and Multi-Table Queries: Designing Databases and Using | |
| Related Data | |
| Table Design, Properties, Views, and Wizards | |
| Designing Data | |
| Creating Tables | |
| Hands-On Exercises 1: Table Design, Properties, Views, and Wizards | |
| Multiple Table Database | |
| Understanding Table Relationships | |
| Sharing Data with Excel | |
| Establishing Table Relationships | |
| Hands-on Exercises 2: Imports and Relationships | |
| 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 | |
| Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions | |
| Data Summary and Analysis | |
| Understanding the Order of Precedence | |
| Creating a Calculated Field in a Query | |
| Hands-On Exercises 1: Calculated Query Fields | |
| 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 | |
| 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 | |
| Create, Edit and Perform Calculations in Reports: Creating Professional and Useful Reports | |
| Appearance Matter | |
| Planning Reports | |
| Using Different Report Views | |
| Creating and Editing a Report | |
| Hands-On Exercises 1: Introduction to Access Reports | |
| 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 | |
| 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 | |
| Table of Contents provided by Publisher. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.