Microsoft Access 2010: The Missing Manual

Description

Go from Access novice to true master with the professional database design tips and crystal-clear explanations in this book. You'll learn all the secrets of this powerful database program so you can use your data in creative ways -- from creating product catalogs and publishing information online to producing invoices and reports.

* 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 brand-new 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

CONTENTS:

The 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 Advanced Editing; 3.4 Printing the Datasheet; Chapter 4: Blocking Bad Data; 4.1 Data Integrity Basics; 4.2 Input Masks; 4.3 Validation Rules; 4.4 Lookups; Chapter 5: Linking Tables with Relationships; 5.1 Relationship Basics; 5.2 Using a Relationship; 5.3 More Exotic Relationships; 5.4 Relationship Practice; Part Two: Manipulating Data with Queries; Chapter 6: Queries That Select Records; 6.1 Query Basics; 6.2 Creating Queries; 6.3 Queries and Related Tables; Chapter 7: Essential Query Tricks; 7.1 Calculated Fields; 7.2 Query Functions; 7.3 Summarizing Data; 7.4 Query Parameters; Chapter 8: Queries That Update Records; 8.1 Understanding Action Queries; 8.2 Update Queries; 8.3 Append Queries; 8.4 Delete Queries; 8.5 Tutorial: Flagging Out-of-Stock Orders; Chapter 9: Analyzing Data with Crosstab Queries and Pivot Tables; 9.1 Understanding Crosstab Queries; 9.2 Creating Crosstab Queries; 9.3 Pivot Tables; 9.4 Pivot Charts; Part Three: Printing Reports; Chapter 10: Creating Reports; 10.1 Report Basics; 10.2 Printing, Previewing, and Exporting a Report; 10.3 Formatting a Report; 10.4 Filtering and Sorting a Report; Chapter 11: Designing Advanced Reports; 11.1 Improving Reports in Design View; 11.2 The Report Wizard; 11.3 The Label Wizard; 11.4 Fine-Tuning Reports with Properties; 11.5 Expressions; 11.6 Grouping; Part Four: Building a User Interface with Forms; Chapter 12: Creating Simple Forms; 12.1 Creating Forms; 12.2 Using Forms; 12.3 Sorting and Filtering in a Form; 12.4 Creating Fancy Forms; 12.5 The Form Wizard; Chapter 13: Designing Advanced Forms; 13.1 Customizing Forms in Design View; 13.2 Taking Control of Controls; 13.3 Forms and Linked Tables; Chapter 14: Building a Navigation System; 14.1 Mastering the Navigation Pane; 14.2 Building Forms with Navigation Smarts; 14.3 Navigation Forms; 14.4 Linking to Related Data; Part Five: Programming Access; Chapter 15: Automating Tasks with Macros; 15.1 Macro Essentials; 15.2 Macros and Security; 15.3 Three Macro Recipes; 15.4 Managing Macros; Chapter 16: Connecting Macros to Forms and Tables; 16.1 Macro-Powered Forms; 16.2 Conditional Macros; 16.3 Data Macros; Chapter 17: Automating Tasks with Visual Basic; 17.1 The Visual Basic Editor; 17.2 Putting Code in a Form; 17.3 Understanding Objects; 17.4 Using Objects; Chapter 18: Writing Smarter Code; 18.1 Exploring the VB Language; 18.2 Dealing with Trouble; 18.3 Deeper into Objects; 18.4 Using VB to Run a Better Business; Part Six: Sharing Access with the Rest of the World; Chapter 19: Sharing a Database with Multiple Users; 19.1 Opening Up Your Database to the World; 19.2 Preparing Your Database; 19.3 Playing Well with Others; 19.4 Data Corruption; 19.5 Securing Your Database; Chapter 20: Importing and Exporting Data; 20.1 Case for Importing and Exporting; 20.2 Using the Clipboard; 20.3 Import and Export Operations; 20.4 Access and XML; 20.5 Collecting Info by Email; Chapter 21: Connecting Access to SQL Server; 21.1 Should You Switch to SQL Server?; 21.2 Getting Started: SQL Server Express; 21.3 Creating a SQL Server Database; 21.4 Adding Objects to a SQL Server Database; Chapter 22: Connecting Access to SharePoint; 22.1 Understanding SharePoint; 22.2 Setting Up SharePoint; 22.3 SharePoint and Access; Chapter 23: Building a Web Database; 23.1 Understanding Web Databases; 23.2 Your First Web Database; 23.3 Publishing a Web Database; 23.4 Delving Deeper into Web Objects; 23.5 Converting an Existing Database to a Web Database; Part Seven: Appendix; Customizing Access; Adding Your Favorites to the QAT; Personalizing the Ribbon;