Australasia's Biggest Online Store

We won't be beaten by anyone. Guaranteed

Exploring Microsoft Office Access 2007, Volume 1

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/e "covers 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 reports Ideal for students and individuals seeking comprehensive instruction for Access 2007.
Product Details

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 ReportsSection 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

Look for similar items by category
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling Exploring Microsoft Office Access 2007, Volume 1 on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by Fishpond World Ltd.
Back to top