Access® 2010 All-in-One For Dummies®

by ; ;
Format: eBook
Pub. Date: 2010-04-01
Publisher(s): For Dummies
Availability: This title is currently not available.
List Price: $41.99

Rent Book

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

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

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.

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.