9780470532188

Microsoft Access 2010 All-in-One for DummiesŪ

by ; ;
  • ISBN13:

    9780470532188

  • ISBN10:

    0470532181

  • Edition: 1st
  • Format: Paperback
  • Copyright: 5/10/2010
  • Publisher: For Dummies

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $39.99 Save up to $11.20
  • Rent Book $35.99
    Add to Cart Free Shipping

    TERM
    PRICE
    DUE

Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The Rental copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

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.

Rewards Program

Write a Review