BN.com Gift Guide

Access 2010 All-in-One For Dummies [NOOK Book]

Overview

The all-in-one reference to all aspects of Microsoft Access 2010

If you want to learn Microsoft Access inside and out, the nine minibooks in this easy-access reference are exactly what you need. Read the book cover to cover, or jump into any of the minibooks for the instruction and topics you need most. Learn how to connect Access to SQL Server, manipulate your data locally, use nifty new features from Office 2010 such as the enhanced Ribbon, create queries and macros like a ...

See more details below
Access 2010 All-in-One For Dummies

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$22.99
BN.com price
(Save 42%)$39.99 List Price
Note: This NOOK Book can be purchased in bulk. Please email us for more information.

Overview

The all-in-one reference to all aspects of Microsoft Access 2010

If you want to learn Microsoft Access inside and out, the nine minibooks in this easy-access reference are exactly what you need. Read the book cover to cover, or jump into any of the minibooks for the instruction and topics you need most. Learn how to connect Access to SQL Server, manipulate your data locally, use nifty new features from Office 2010 such as the enhanced Ribbon, create queries and macros like a champ, and much more. From the basics to advanced functions, it’s what you need to make Access more accesssible.

  • Shows you how to store, organize, view, analyze, and share data using Microsoft Access 2010, the database application included with Microsoft Office 2010
  • Includes nine minibooks that cover such topics as database design, tables, queries, forms, reports, macros, database administration, securing data, programming with Visual Basic for Applications (VBA), and using Access with the Web
  • Helps you build database solutions that integrate with the Web and other enterprise data sources
  • Offers plenty of techniques, tips, and tricks to help you get the most out of Access

This all-in-one guide contains everything you need to start power-using Access 2010!

Read More Show Less

Product Details

  • ISBN-13: 9780470770627
  • Publisher: Wiley
  • Publication date: 4/9/2010
  • Series: For Dummies Series
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 792
  • Sales rank: 482,771
  • File size: 8 MB

Meet the Author

Alison Barrows has written books on Access, Windows, and the Internet, including Access For Dummies Quick Reference.

Margaret Levine Young is coauthor of over two dozen books, including The Internet For Dummies.

Joseph C. Stockman is an independent consultant, software designer, and author.

Read More Show Less

Table of Contents

Introduction.

Book I: Essential Concepts.

Chapter 1: Introducing Access 2010.

Chapter 2: Getting Started, Getting Around.

Chapter 3: Designing Your Database the Relational Way.

Book II: Tables for Storing Your Data.

Chapter 1: Creating and Modifying Tables.

Chapter 2: Refi ning Your Table in Design View.

Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet.

Chapter 4: Importing and Exporting Data.

Chapter 5: Avoiding "Garbage In, Garbage Out".

Chapter 6: Relating Your Tables and Protecting Your Data.

Book III: Queries (or Getting Information from Your Data).

Chapter 1: Creating Select Queries.

Chapter 2: Letting Queries Do the Math.

Chapter 3: Doing Neat Things with Action Queries and Query Wizards.

Chapter 4: Viewing Your Data from All Angles Using Crosstabs and PivotTables.

Book IV: Forms for Editing Data.

Chapter 1: Designing and Using Forms (and Reports).

Chapter 2: Jazzing Up Your Forms (and Reports).

Chapter 3: Creating Smarter Forms.

Chapter 4: Doing Calculations in Forms and Subforms (and Reports).

Book V: Reporting in Words and Pictures.

Chapter 1: Creating and Spiffi ng Up Reports.

Chapter 2: Printing Beautiful Reports.

Chapter 3: Creating Charts and Graphs from Your Data.

Book VI: Automation with Macros.

Chapter 1: Making Macros Do the Work.

Chapter 2: Making Macros Smarter.

Book VII: Database Administration.

Chapter 1: Database Housekeeping.

Chapter 2: Sharing the Fun: Managing Multiuser Access.

Chapter 3: Securing Your Access Database.

Book VIII: Programming in VBA.

Chapter 1: What the Heck Is VBA?

Chapter 2: Writing Code.

Chapter 3: Writing Smarter Code.

Chapter 4: Controlling Forms with VBA.

Chapter 5: Using SQL and Recordsets.

Chapter 6: Debugging Your Code.

Book IX: Going Beyond Access.

Chapter 1: Automation with Other Offi ce Programs.

Chapter 2: Using Access as a Front-End to SQL Server.

Chapter 3: Using Access with SharePoint.

Appendix: Installing Microsoft Access.

Index.

Read More Show Less

Customer Reviews

Average Rating 3.5
( 3 )
Rating Distribution

5 Star

(0)

4 Star

(2)

3 Star

(0)

2 Star

(1)

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
Sort by: Showing all of 3 Customer Reviews
  • Anonymous

    Posted July 18, 2012

    This is an excellent first time user's guide

    I really like the book. I have both printed and NOOK versions. The only thing I do not like about the NOOK version is the illustrations are nearly impossible to read. However, the convenience of having the text available either in my reader or computer overcomes the one flaw.

    Was this review helpful? Yes  No   Report this review
  • Posted December 14, 2011

    no help

    not as in dept as I had hoped. Was unable to solve my database problem

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted October 27, 2011

    No text was provided for this review.

Sort by: Showing all of 3 Customer Reviews

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