Access 2010 All-in-One For Dummies

by ; ;
Edition: 1st
Format: Paperback
Pub. Date: 2010-05-10
Publisher(s): For Dummies
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $41.99

Buy New

Arriving Soon. Will ship when available.
$39.99

Rent Book

Select for Price
There was a problem. Please try again later.

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

The all-in-one reference to all aspects of Microsoft Access 2010If 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 AccessThis all-in-one guide contains everything you need to start power-using Access 2010!

Author Biography

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.

Table of Contents

Introduction
Essential Concepts
Introducing Access 2010
Getting Started, Getting Around
Designing Your Database the Relational Way
Tables for Storing Your Data
Creating and Modifying Tables
Refi ning Your Table in Design View
Sorting, Finding, and Filtering Data in a Datasheet
Importing and Exporting Data
Avoiding "Garbage In, Garbage Out"
Relating Your Tables and Protecting Your Data
Queries (or Getting Information from Your Data)
Creating Select Queries
Letting Queries Do the Math
Doing Neat Things with Action Queries and Query Wizards
Viewing Your Data from All Angles Using Crosstabs and PivotTables
Forms for Editing Data
Designing and Using Forms
Jazzing Up Your Forms
Creating Smarter Forms
Doing Calculations in Forms and Subforms
Reporting in Words and Pictures
Creating and Spiffi ng Up Reports
Printing Beautiful Reports
Creating Charts and Graphs from Your Data
Automation with Macros
Making Macros Do the Work
Making Macros Smarter
Database Administration
Database Housekeeping
Sharing the Fun: Managing Multiuser Access
Securing Your Access Database
Programming in VBA
What the Heck Is VBA?
Writing Code
Writing Smarter Code
Controlling Forms with VBA
Using SQL and Recordsets
Debugging Your Code
Going Beyond Access
Automation with Other Offi ce Programs
Using Access as a Front-End to SQL Server
Using Access with SharePoint
Appendix: Installing Microsoft Access
Index
Table of Contents provided by Publisher. All Rights Reserved.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.