Access^® 2010 All-in-One For Dummies^®

by Alison Barrows; Margaret Levine Young; Joseph C. Stockman

• ISBN13: 9780470651773
• ISBN10: 0470651776
• Format: eBook
• Copyright: 2010-04-01
• Publisher: For Dummies

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!

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 (and Reports)

Jazzing Up Your Forms (and Reports)

Creating Smarter Forms

Doing Calculations in Forms and Subforms (and Reports)

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.