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.
Inhaltsverzeichnis
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