Access 2007: The Missing Manual by Matthew MacDonald

The Missing Credits; About the Author; About the Creative Team; Acknowledgements; The Missing Manual Series; Introduction; What You Can Do with Access; The New Face of Access 2007; The New Features in Access 2007; About This Book; Part I: Storing Information in Tables; Chapter 1: Creating Your First Database; 1.1 Understanding Access Databases; 1.2 Getting Started; 1.3 Saving and Opening Access Databases; 1.4 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 II: 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 III: 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 IV: Building a User Interface with Forms; Chapter 12: Creating Simple Forms; 12.1 Form Basics; 12.2 Sorting and Filtering in a Form; 12.3 Creating Better Layouts; 12.4 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 Linking to Related Data; Part V: 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; 15.5 Connecting Macros to Forms; 15.6 Conditional Macros; Chapter 16: Automating Tasks with Visual Basic; 16.1 The Visual Basic Editor; 16.2 Putting Code in a Form; 16.3 Understanding Objects; 16.4 Using Objects; Chapter 17: Writing Smarter Code; 17.1 Exploring the VB Language; 17.2 Dealing with Trouble; 17.3 Deeper into Objects; 17.4 Using VB to Run a Better Business; Part VI: Sharing Access with the Rest of the World; Chapter 18: Sharing a Database with Multiple Users; 18.1 Opening Up Your Database to the World; 18.2 Preparing Your Database; 18.3 Playing Well with Others; 18.4 Data Corruption; 18.5 Securing Your Database; Chapter 19: Importing and Exporting Data; 19.1 Case for Importing and Exporting; 19.2 Using the Clipboard; 19.3 Import and Export Operations; 19.4 Access and XML; 19.5 Collecting Info by Email; Chapter 20: Connecting Access to SQL Server; 20.1 Should You Switch to SQL Server?; 20.2 Getting Started: SQL Server 2005 Express; 20.3 Creating a SQL Server Database; 20.4 Adding Objects to a SQL Server Database; Chapter 21: Connecting Access to SharePoint; 21.1 Understanding SharePoint; 21.2 Setting Up SharePoint; 21.3 SharePoint and Access; Part VII: Appendix; Appendix A: Customizing the Quick Access Toolbar; A.1 The Quick Access Toolbar; Colophon;