Access 2010: The Missing Manual

by Matthew MacDonald

Overview

Unlock the secrets of this powerful database program and discover how to use your data in creative ways. With this book’s easy step-by-step process, you’ll quickly learn how to build and maintain a complete Access database, using Access 2013’s new, simpler user interface and templates. You also get practices and tips from the pros for good database design—ideal whether you’re using Access for school, business, or at home.

The important stuff you need to know:

• Build a database with ease. Store information to track numbers, products, documents, and more.
• Customize the interface. Build your own forms to make data entry a snap.
• Find what you need fast. Search, sort, and summarize huge amounts of information.
• Put your data to use. Turn raw info into printed reports with attractive formatting.
• Share your data. Collaborate online with SharePoint and the Access web database.
• Dive into Access programming. Get tricks and techniques to automate common tasks.
• Create rich data connections. Build dynamic links with SQL Server, SharePoint, and other systems.

Product Details

ISBN-13:	9781449382377
Publisher:	O'Reilly Media, Incorporated
Publication date:	07/01/2010
Series:	Missing Manual Series
Pages:	812
Product dimensions:	7.00(w) x 9.20(h) x 1.70(d)

About the Author

Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.

Table of Contents

• The Missing Credits
• Introduction
• Part One: Storing Information in Tables
  • Chapter 1: Creating Your First Database
  • Chapter 2: Building Smarter Tables
  • Chapter 3: Mastering the Datasheet: Sorting, Searching, Filtering, and More
  • Chapter 4: Blocking Bad Data
  • Chapter 5: Linking Tables with Relationships
• Part Two: Manipulating Data with Queries
  • Chapter 6: Queries That Select Records
  • Chapter 7: Essential Query Tricks
  • Chapter 8: Queries That Update Records
  • Chapter 9: Analyzing Data with Crosstab Queries and Pivot Tables
• Part Three: Printing Reports
  • Chapter 10: Creating Reports
  • Chapter 11: Designing Advanced Reports
• Part Four: Building a User Interface with Forms
  • Chapter 12: Creating Simple Forms
  • Chapter 13: Designing Advanced Forms
  • Chapter 14: Building a Navigation System
• Part Five: Programming Access
  • Chapter 15: Automating Tasks with Macros
  • Chapter 16: Connecting Macros to Forms and Tables
  • Chapter 17: Automating Tasks with Visual Basic
  • Chapter 18: Writing Smarter Code
• Part Six: Sharing Access with the Rest of the World
  • Chapter 19: Sharing a Database with Multiple Users
  • Chapter 20: Importing and Exporting Data
  • Chapter 21: Connecting Access to SQL Server
  • Chapter 22: Connecting Access to SharePoint
  • Chapter 23: Building a Web Database
• Part Seven: Appendix
  • Customizing Access