Access 2007 Workbook For Dummies w/ CD

Overview

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

See more details below
Paperback
$16.38
BN.com price
(Save 34%)$24.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (17) from $1.99   
  • New (7) from $8.92   
  • Used (10) from $1.99   
Sending request ...

Overview

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.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Read More Show Less

Product Details

  • ISBN-13: 9780470179536
  • Publisher: Wiley
  • Publication date: 12/10/2007
  • Series: For Dummies Series
  • Edition number: 1
  • Pages: 327
  • Sales rank: 877,035
  • Product dimensions: 8.04 (w) x 9.98 (h) x 0.77 (d)

Meet the Author

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.
Read More Show Less

Table of Contents

Introduction.

Part I: Learning Database Fundamentals.

Chapter 1: Getting Started with Access.

Chapter 2: Managing Databases.

Part II: Creating and Using Tables.

Chapter 3: Creating and Modifying Tables.

Chapter 4: Entering Data in Tables.

Chapter 5: Viewing Data in Tables.

Chapter 6: Building Relationships.

Part III: Viewing Data with Select Queries.

Chapter 7: Creating Single-Table Queries.

Chapter 8: Creating Multi-Table Queries.

Chapter 9: Performing Calculations in Queries.

Part IV: Manipulating Data with Action Queries.

Chapter 10: Changing Data with Update Queries.

Chapter 11: Adding Data with Append Queries.

Chapter 12: Removing Data with Delete Queries.

Chapter 13: Creating Tables with Make Table Queries.

Part V: Building Forms.

Chapter 14: Creating and Using Forms.

Chapter 15: Basic Form Design.

Chapter 16: Changing Control Properties.

Chapter 17: Changing Form Properties.

Chapter 18: Creating Calculated Controls.

Part VI: Advanced Form Design.

Chapter 19: Formatting a Form.

Chapter 20: Arranging and Sizing Controls on a Form.

Chapter 21: Using Combo Boxes and List Boxes.

Chapter 22: Using Split Forms and Subforms.

Part VII: Building Reports.

Chapter 23: Creating Simple Reports.

Chapter 24: Changing Report Design.

Chapter 25: Grouping and Sorting Reports.

Part VIII: Automating Access.

Chapter 26: Adding Buttons to Forms.

Chapter 27: Editing and Building Simple Macros.

Chapter 28: Creating a Switchboard.

Chapter 29: Importing and Exporting Data.

Part IX: The Part of Tens.

Chapter 30: Ten Tips for Using Access Like a Pro.

Chapter 31: Ten (More or Less) Shortcut Keys for Using Access.

Chapter 32: Ten (More or Less) Shortcut Keys for Entering Data.

Appendix A: About the CD.

Appendix B: Exercises.

Index.

Wiley Publishing, Inc. End-User License Agreement.

Read More Show Less

Customer Reviews

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

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com 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 & Noble.com 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 & Noble.com 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 BN.com 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

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com 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 BN.com. 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)