Australasia's Biggest Online Store

We won't be beaten by anyone. Guaranteed

Exploring Microsoft Office Access 2007, Volume 1
By

Rating
Hurry - Only 2 left in stock!

Product Description
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 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

Ask a Question About this Product More...
Write your question below:
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