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.
The Book That Should Have Been in the BoxThe Missing Credits;About the Author;About the Creative Team;Acknowledgements;The Missing Manual Series;Introduction;What You Can Do with Access;The Modern Face of Access;The New Features in Access 2010;About This Book;Part One: Storing Information in Tables;Chapter 1: Creating Your First Database;1.1 Understanding Access Databases;1.2 Getting Started with Your First Database;1.3 Saving Databases;1.4 Opening Databases;1.5 The Navigation Pane;Chapter 2: Building Smarter Tables;2.1 Understanding Data Types;2.2 Design View;2.3 Access Data Types;2.4 The Primary Key;2.5 Six Principles of Database Design;Chapter 3: Mastering the Datasheet: Sorting, Searching, Filtering, and More;3.1 Datasheet Customization;3.2 Datasheet Navigation;3.3 lĐ