Australasia's Biggest Online Store

We won't be beaten by anyone. Guaranteed

Exploring Microsoft Office Access 2007, Volume 1
By

Rating
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

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!
Back to top