Microsoft Access 2010 24-Hour Trainer


This book-and-video package is the perfect introduction to Access 2010

Microsoft Access is the most popular database system in the world and this practical guide will soon have you building Access applications using the Access 2010. This book is designed for beginner-to intermediate-level Access users and covers the basics of building and working with the major features of the program. Over 60 lessons are included to discuss these features and provide step-by-step examples ...

See more details below
$32.71 price
(Save 27%)$44.99 List Price
Other sellers (Paperback)
  • All (13) from $9.99   
  • New (7) from $9.97   
  • Used (6) from $11.25   
Sending request ...


This book-and-video package is the perfect introduction to Access 2010

Microsoft Access is the most popular database system in the world and this practical guide will soon have you building Access applications using the Access 2010. This book is designed for beginner-to intermediate-level Access users and covers the basics of building and working with the major features of the program. Over 60 lessons are included to discuss these features and provide step-by-step examples showing you exactly how each feature can be implemented in a real world Access database application. The accompanying DVD provides clear, easy-to-follow videos of the authors demonstrating each of the examples discussed in the book, as well as extra commentary, so that no reader is left behind!

  • Provides examples of building Access database applications from scratch or from existing database templates.
  • Discusses how to use Access 2010 and the major components it provides, such as the Navigation Pane, Ribbon, and the many database object designers.
  • Teaches the basics of building and working with each of the major Access database object types: tables, queries, forms, reports, macros, and VBA code modules.
  • Introduces exciting new Access 2010 features, such as the new macro designer, the new Ribbon designer, and even how to customize the Access Backstage.
  • Teaches the basics of writing VBA code and provides specific examples about how and when to use it.
  • Each lesson includes a step-by-step written example and DVD video showing exactly how to accomplish the tasks discussed in the lesson.

Even if you have no experience with Access 2010, this guide will have you building robust Access applications with the best of them! If you want to get quickly up to speed on Access 2010, Access 2010 24-Hour Trainer is the perfect place to start.

Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at using a link provided in the interior of the e-book.

Read More Show Less

Product Details

  • ISBN-13: 9780470591673
  • Publisher: Wiley
  • Publication date: 6/21/2011
  • Edition number: 1
  • Pages: 552
  • Sales rank: 715,270
  • Product dimensions: 7.30 (w) x 9.20 (h) x 1.10 (d)

Meet the Author

Geoffrey L. Griffith has over 14 years' experience with Access beginning with Access 2.0. He is the coauthor of Access 2007 VBA Programmer's Reference and Access 2010 Programmer's Reference.

Truitt L. Bradly, a Microsoft Access MVP, is an accountant, analyst, and developer who has developed several database applications using Access and SQL Server. He is the coauthor of Microsoft Access Small Business Solutions.

Read More Show Less

Read an Excerpt

Microsoft Access 2010 24-Hour Trainer

By Geoffrey L. Griffith Truitt L. Bradly

John Wiley & Sons

Copyright © 2011 John Wiley & Sons, Ltd
All right reserved.

ISBN: 978-0-470-59167-3

Chapter One

Installing Access 2010

Before you can begin using Access 2010, you must acquire a copy of the program and then install it on a machine. If you already have a copy of Access installed on your machine, you can easily skip this lesson and move on to the next. However, if you have never purchased or installed Access 2010 (or earlier versions), continue on with this lesson to find out more about getting and installing the most widely used database program in the world—Microsoft Access!


This lesson explains some of the options available for purchasing a copy of Access 2010 and provides a step-by-step guide to installing Access 2010 as a part of Microsoft Office 2010. There is no previous experience or knowledge of Access required to complete this lesson.


You can purchase Microsoft Access 2010 as a standalone product or as part of Microsoft Office 2010 Professional (or higher versions of Office). Office 2010 Professional edition includes Access, Excel, PowerPoint, Publisher, Outlook, and Word. Office 2010 Professional Plus also includes Communicator and InfoPath. Office 2010 Enterprise adds Grove and OneNote. The Office 2010 Ultimate edition adds Outlook Business Contact Manager.

Purchasing Directly from Microsoft

Microsoft sells Access 2010 along with all of the Office editions at the Microsoft website (, go there to compare the features of each edition. Microsoft offers three basic plans to purchase retail software online:

* Purchase the product online, have the DVD shipped to your location, and use the product key included in the materials shipped to you.

* Purchase the product online, download the installation files to your computer, and use the product key that is provided at purchase to activate the software.

* Download and install a trial version that you can use for 60 days before purchasing.

Microsoft Office is also available in DVD versions at retail stores that sell computer software and at online software retailers. Check multiple outlets for the best price, but make sure you use a legitimate dealer. If a deal sounds too good to be true, it probably is; you don't want to get stuck with an illegal copy of Office 2010 for which you paid a substantial amount of money.

System Requirements

Before buying a copy of Access or Office, check the minimum system requirements for the version you are purchasing; that way you can ensure the software is compatible with your computer. The Office products are available in 32-bit and 64-bit versions. Your computer's CPU architecture and Windows operating system version will determine if you can use the 64-bit version of Access (or Office). The 64-bit version of Access requires that the system have a 64-bit processor and be running a 64-bit version of Windows.

Side-by-Side Installations

Note that Access 2010 can be installed side-by-side with older versions of Access. When installing Access with older versions, it is always recommended that you install older versions first and newer versions last. However, if you use an older version of Access and then go back to Access 2010 while both versions are installed side-by-side, it will retrigger a (somewhat) short installation process every time. This is because the last installed version of Access is the system default version, and that setting is updated if a different version of Access is run! Though this fact is important to consider because installation can be painfully time-consuming, it probably won't make much of a difference for most Access users.

Default versus Custom Installations

The Access (or Office) installation program provides a choice of installation options:

* Default installation installs features used by the majority of users and is sufficient for most installations. For both Office 2010 and Access 2010 installation programs, the default options install everything you need to start using Access.

* Custom installation allows you to select and install specific features (and programs, if installing Office). It also allows you to specify a location other than the default. Custom user information can also be entered.

Usually the default installation is all you need, and novice computer users may not want to attempt a custom installation. The default installation for both Office and Access is sufficient to complete the lessons in this book.


Once you have acquired the Access 2010 software, installing it is easy. To start the installation process for Access (or Office), depending on the version that you are using, you need to execute the setup.exe file for Access or Office, respectively. If you have the DVD, simply inserting the disk into your computer should automatically start the installation process. If it does not, follow these steps:

1. Go to My Computer.

2. Right-click the DVD drive with the disk.

3. Choose the Explore option.

From the Explorer window, you can also navigate and manually run the setup.exe program provided on the root of the installation disk. Another option is right-clicking the DVD and selecting AutoPlay from the context menu.

If you downloaded the software, you may need to create an install DVD from the downloaded .iso file. Most CD/DVD writer software will create a disk to install the software from the .iso file. Also, several free programs are available for simply extracting .iso files to disk. Whichever method you choose, simply run the setup.exe file to begin the installation of Access (or Office):

1. After you begin, the installation program will extract the needed files from the installation disk.

2. You are prompted to enter the product key.

3. Enter the key. The installation program will verify the key before you can proceed. The key is a 25-digit key that consists of both numbers and letters.

4. There is a check box at the bottom of the dialog that allows Office 2010 to attempt to automatically activate the product online. Uncheck the box if you do not want to activate the product at this time.

5. Read the license agreement. If you accept the terms, check the box at the bottom of the pop-up signifying that you agree to the Microsoft software license terms. Acceptance of the terms is required before the installation can be completed.

6. Click Install Now (or click Customize to create a custom installation). Choosing the custom installation allows you to select products and file locations and to specify the user information.

7. After clicking Install Now, a progress bar appears on the Installation Progress dialog. Assuming no errors occur, installation will complete and Access will be ready to use.

Four types of component installation options exist: Run from My Computer, Run All from My Computer, Install on First Use, and Not Available. When either the Run or Run All option is selected for a feature, the installation program installs that feature completely to the machine. The Install on First Use option installs the feature the first time it is actually used within the program. The Not Available option specifies not installing the feature at all.


In this lesson you install the Office 2010 Professional Plus edition. Other editions of Office 2010 have similar installation processes.

Lesson Requirements

Verify that the computer on which you are attempting to install the Office 2010 products meets or exceeds the minimum technical requirements; otherwise the installation will fail. You also need the DVD included in the software package, a downloaded installation file that can be executed from a drive, or a DVD created after downloading the product files from Microsoft or a retailer.


Make sure you have the product key available to enter when prompted. Failure to provide the key results in failed installation.


1. Insert the program DVD and run the setup program.

2. Enter the 25-digit product key. The installation program will verify it is a valid key. If the verification fails, check the key and make corrections as necessary.

3. Read the software license terms. If you accept the terms, check the box at the bottom of the dialog.

4. Choose the desired installation options by accepting the defaults or selecting only the applications you want installed, accept the default or set a custom file location, and accept the defaults or enter user information.

5. Click the Install Now button to start the installation.

6. Wait for the installation to complete. Then remove the DVD and store it in the original packing with the product key in case you ever need to reinstall or repair corrupt program files.


Installing Access 2010 or Office 2010 Professional on a computer that meets or exceeds the minimum technical requirements is usually very straightforward and easy. The simple installation discussed in this lesson is normally sufficient for most users. Custom installations provide more flexibility and allow you to select the options you wish to install. No matter which option you choose, Access 2010 is easy to set up and get going on your Windows machine!

Please select Lesson 1 on the DVD to view the video that accompanies this lesson.


Excerpted from Microsoft Access 2010 24-Hour Trainer by Geoffrey L. Griffith Truitt L. Bradly Copyright © 2011 by John Wiley & Sons, Ltd. Excerpted by permission of John Wiley & Sons. All rights reserved. No part of this excerpt may be reproduced or reprinted without permission in writing from the publisher.
Excerpts are provided by Dial-A-Book Inc. solely for the personal use of visitors to this web site.

Read More Show Less

Table of Contents


Lesson 1: Installing Access 2010.

Lesson 2: Getting Started in Access 2010.

Lesson 3: Creating a New Database Application.

Lesson 4: Access Database Objects.

Lesson 5: The Access 2010 Ribbon.

Lesson 6: The Access 2010 Backstage.

Lesson 7: The Access 2010 Navigation Pane.

Lesson 8: Creating a Table in Datasheet View.

Lesson 9: Creating a Table in Design View.

Lesson 10: Access 2010 Data Types.

Lesson 11: Table and Field Properties.

Lesson 12: Data Validation and Limiting User Input.

Lesson 13: Creating Value List Fields.

Lesson 14: Creating Lookup Tables.

Lesson 15: Table Modifications.

Lesson 16: Creating Table Relationships.

Lesson 17: Creating Table Field Indexes.

Lesson 18: Creating Tables from External Data.

Lesson 19: Creating Linked Tables.

Lesson 20: Collecting Data via E-mail.

Lesson 21: Creating Queries with the Wizard.

Lesson 22: Creating Queries in Design View.

Lesson 23: Creating Select Queries.

Lesson 24: Data Aggregation and Grouping.

Lesson 25: Creating Parameter Queries.

Lesson 26: Creating Append Queries.

Lesson 27:Creating Update Queries.

Lesson 28: Creating Delete Queries.

Lesson 29: Creating Make Table Queries.

Lesson 30: Creating Crosstab Queries.

Lesson 31: Creating Forms in Layout View.

Lesson 32: Creating Forms in Design View.

Lesson 33: Acc ess Form Properties.

Lesson 34: Access 2010 Form Controls.

Lesson 35: Working with Subforms and Subreports.

Lesson 36: Embedded Macros in Forms.

Lesson 37: Adding Code to Forms.

Lesson 38: Access 2010 Form Types.

Lesson 39: Creating PivotCharts.

Lesson 40: Access Application Navigation.

Lesson 41: Creating Reports in Layout View

Lesson 42: Creating Reports in Design View.

Lesson 43: Access Report Properties.

Lesson 44: Report Sorting, Grouping, and Totals

Lesson 45: Using Macros in Reports.

Lesson 46: Creating Macros in Access 2010.

Lesson 47: Macro Types and Security.

Lesson 48: Macro Parts.

Lesson 49: Building Macros.

Lesson 50: Data Macros in Access 2010.

Lesson 51: The Visual Basic Editor.

Lesson 52: Introduction to VBA.

Lesson 53: Using Operators in VBA.

Lesson 54: Using Variables in VBA.

Lesson 55: Creating Class Modules.

Lesson 56: The Access Object Model.

Lesson 57: Working with DAO.

Lesson 58: Access Application Settings.

Lesson 59: Customizing the Navigation Pane.

Lesson 60: Customizing the Ribbon.

Lesson 61: Customizing the Backstage.

Lesson 62: The Access Runtime.


Appendix: What’s on the DVD?


Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)