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.
Storing Information in Tables
Chapter 1 Creating Your First Database
Understanding Access Databases
Getting Started with Your First Database
The Navigation Pane
Chapter 2 Building Smarter Tables
Understanding Data Types
Access Data Types
The Primary Key
Six Principles of Database Design
Chapter 3 Mastering the Datasheet: Sorting, Searching, Filtering, and More
Printing the Datasheet
Chapter 4 Blocking Bad Data
Data Integrity Basics
Chapter 5 Linking Tables with Relationships
Using a Relationship
More Exotic Relationships
Manipulating Data with Queries
Chapter 6 Queries That Select Records
Queries and Related Tables
Chapter 7 Essential Query Tricks
Chapter 8 Queries That Update Records
Understanding Action Queries
Tutorial: Flagging Out-of-Stock Orders
Chapter 9 Analyzing Data with Crosstab Queries and Pivot Tables
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.