Access 2007 Workbook For Dummies

by Stockman, Joseph C.

• ISBN13: 9780470179536
• ISBN10: 0470179538
• Edition: CD
• Format: Paperback
• Copyright: 2007-12-10
• Publisher: For Dummies

Summary

Do you wish Access was more accessible? Do you wonder what to do with databases in the first place? If you've just been letting Access sit there as an anonymous icon on the Ribbon, Access 2007 Workbook For Dummies can open up new worlds for you.The coolest thing about this friendly, easy-to-follow workbook is that you'll actually create a database that you can use to organize your own home media collection, if you like. In the process, you discover how to build a database from the ground up and some of the ways a database can be helpful, even if you're not a business mogul or an accountant. Using a problem-solution approach, Access 2007 Workbook For Dummies gives you plenty of chances to practice each step, so you gain confidence along with information.You'll discover how to: Set up Access and use database fundamentals Create a home media database from start to finish Build tables, relationships, forms, and reports Use select and action queries View and manipulate data Edit and build simple macros and use them to automate navigation Arrange controls on a form Build a user interface to add, edit, and update data Track every aspect of the media collection, including The bonus CD-ROM includes separate database files for each exercise and a video that walks you through each step of the more complex procedures. In no time you'll find Access is no longer unapproachable.

Author Biography

Joe Stockman is an independent consultant, software designer, and author who has been using Microsoft Access since its initial release. He’s also developed courseware and taught classes in Access and VBA. Joe developed his first application in Access, and then migrated into Visual Basic and VB.NET, where he specializes in creating applications for the Windows Mobile platform. He’s worked for several software companies before forming his consulting business in 2002, where he deals with all types of clients including healthcare, financial, government, manufacturing, and small business. His ability to turn his customers’ wishes into working applications keeps them satisfied. Joe is the co-author of the Access 2007 Bible and Access 2007 VBA Programming For Dummies and also writes for the Advisor Guide to Microsoft Access magazine.

Table of Contents

Introduction

Learning Database Fundamentals

Getting Started with Access

Managing Databases

Creating and Using Tables

Creating and Modifying Tables

Entering Data in Tables

Viewing Data in Tables

Building Relationships

Viewing Data with Select Queries

Creating Single-Table Queries

Creating Multi-Table Queries

Performing Calculations in Queries

Manipulating Data with Action Queries

Changing Data with Update Queries

Adding Data with Append Queries

Removing Data with Delete Queries

Creating Tables with Make Table Queries

Building Forms

Creating and Using Forms

Basic Form Design

Changing Control Properties

Changing Form Properties

Creating Calculated Controls

Advanced Form Design

Formatting a Form

Arranging and Sizing Controls on a Form

Using Combo Boxes and List Boxes

Using Split Forms and Subforms

Building Reports

Creating Simple Reports

Changing Report Design

Grouping and Sorting Reports

Automating Access

Adding Buttons to Forms

Editing and Building Simple Macros

Creating a Switchboard

Importing and Exporting Data

The Part of Tens

Ten Tips for Using Access Like a Pro

Ten (More or Less) Shortcut Keys for Using Access

Ten (More or Less) Shortcut Keys for Entering Data

About the CD

Exercises

Index

Wiley Publishing, Inc

End-User License Agreement

Table of Contents provided by Publisher. All Rights Reserved.