Brilliant Access 2007 Pocket Book

Joli Balew is a professional writer, technology trainer, network consultant, and a Microsoft Windows Expert Zone Columnist. Some of her previous jobs include technical writing, education content consulting, PC technician, network administrator, high school algebra teacher, and MCSE instructor. She earned her MCSE, MCT and A+ certifications in less than 14 months. She is the author of Windows XP Professional: The Ultimate User's Guide and over 20 other technical books.

Introduction 1. What's New in Access 2007 * Using The Ribbon * Taking Advantage of the Quick Access Toolbar * Working with the Navigation Pane * Other New Tools and Features to Watch For 2. Access 2007 Fundamentals * Opening Access * Function Keys * View Options * Saving in Access * Exiting Access 3. Understanding Access 2007 * Databases and Objects * Tables * Forms * Queries * Reports * Macros * Modules * The Sandbox Operating Mode * Changing the Registry Key 4. The New File Format * Understanding the New File Format * Converting a Database into an Access 2007 File 5. Database Fundamentals * Understanding Databases * Designing a Database * Setting Up Primary Categories * Adding Subcategories * Choosing Primary Keys * Establishing Table Relationships * Analysingthe Design 6. Creating a Database * Creating a New, Blank Database * Creating a Database from a Template * Opening an Existing Database * Copying a Database * Closing a Database 7. Publishing a Database to a Sharepoint Site * What Are Sharepoint Services? 8. Finding Information in Your Database * Finding Words or Phrases * Replacing Words or Phrases 9. Collecting Information Using Outlook 2007 * When to Use Electronic Data Collection * Things to Know Before You Collect Electronic Data * Collecting Data Via the E-Mail * Managing Your Data Collection Replies 10. Table Relationships and Design * Understanding Table Relationships * Creating a Table Relationship * Changing a Table Relationship * Deleting a Table Relationship * Designing a Table 11. Creating Tables * Creating a New, Blank Table in an Existing Template * Creating a Table from a Template * Creating a Table with Links or Imported Information * Entering Data in a Table * Setting Table Properties * Setting the Primary Key for a Table * Removing the Primary Key for a Table 12. Copying or Exporting Table Data * Copying Data from Another Source into Your Table * Exporting a Table to a Sharepoint Site 13. Editing Tables * Changing Column Width * Changing the Row Height * Changing Font Style and Size * Freezing a Column * Changing the Look and Feel of Your Table * Deleting Records 14. Saving, Closing or Deleting a Table * Saving a Table * Closing a Table * Deleting a Table 15. Using Fields in a Table * Inserting a New Field into a New Table * Inserting a New Field into an Existing Table * Adding an Existing Field to a Table * Changing a Field's Content * Deleting a Field * Moving or Copying Data in a Field * Hiding or Unhiding a Field * Setting Field Properties 16. Working with Lookup Columns * What is a Lookup Column? * Lookup Field Properties * Creating a Lookup Column Using the Lookup Wizard * Changing a Lookup Column * Changing a Field to a Lookup Column 17. Using Forms * Understanding Forms * Form Wizard * Entering Data into a Form 18. Creating Forms * Creating a Form Using the Form Tool * Creating a Form Using the Split Form Tool * Creating a Form with the Blank Form Tool * Creating a Form That Contains a Sub Form * Adding a Logo to Your Form 19. Working with Field Controls * What Are Field Controls? * Moving Field Controls * Changing the Size of a Control 20. Adding Special Controls * Using Windows Visual Theme In Controls * Adding Text Box Controls * Creating a List Box or Combo Box * Creating a Calculated Control * Creating a Command Button * Creating an Option Group * Inserting Date and Time into a Form or Report 21. Using Expressions * Understanding Expressions * Creating an Expression Using the Expression Builder 22. Using Conditional Formatting * Applying Conditional Formatting to a Control Based on its Own Value * Using an Expression to Apply Conditional Formatting to Controls * Changing the Conditional Formatting of a Focus Control * Removing Conditional Formatting 23. Sorting and Finding Data * The Difference Between Sorting and Filtering * Sorting a Table, Query or Form * Sorting Records in Case-Sensitive Order * Sorting Records in a Customised Order * Sorting Records Based on Numeric Values Stored in a Text Field * Sorting Records by Date Values 24. Using Filters * Understanding Filters * Filtering Table Data by Selection * Applying Advanced Filters * Saving Filters as Queries 25. Reporting Fundamentals * Understanding Report Sections * Choosing Record Sources for Your Report * Using Totals, Averages, Percentages or Running Sums in Reports 26. Creating a Report * Creating a Report Using the Report Wizard * Creating a Report Using the Report Tool * Creating a Report Using the Blank Report Tool * Creating and Using Subreports * Creating a Grouped or Summary Report 27. Saving or Editing a Report * Modifying Your Report in the Layout View * Modifying Your Report in the Design View * Creating Alternating Row Colours 28. Previewing, Printing and E-Mailing A Report * Viewing Your Report * Printing Your Report * E-Mailing Your Report 29. Creating a Query * Understanding Queries * Creating a Select Query Using the Query Wizard * Creating a Union Query * Creating and Running an Update Query * Creating and Running an Append Query * Creating a Make Table Query 30. Adding to a Query * Adding Criteria to a Query * Adding Calculations to a Query 31. Editing a Query * Editing Data in a Query * Finding, Hiding or Eliminating Duplicate Data 32. Summarizing and Saving Queries * Summarizing Query Values * Saving the Query Results 33. Joining Tables and Queries * Using Inner Joins * Using Outer Joins * Using Cross Joins * Using Unequal Joins * Removing a Join 34. Using Multivalued Fields in a Query * Displaying a Multivalued Field in a Query * Displaying a Bound Value in a Query * Searching for More Than One Query in a Multivalued Field * Using a Query as a Mailmerge Source 35. Working with Attachments * Adding an Attachment Field to a Table * Attaching A Field Directly to a Table * Using Attachments with Forms and Reports * Saving Attached Files to Other Locations * Removing Attached Files 36. Importing and Exporting * Understanding Importing and Exporting Operations * Running, Saving and Scheduling an Import Operation as a Specification 37. Printing in Access * Printing an Access File * Printing in Landscape Orientation * Creating and Printing Labels * Customising Labels 38. Using Macros * Understanding Macros * New Macro Features in Access 2007 * Creating a Macro * Fixing a Macro * Enabling or Disabling Macros 39. Working with Security Settings * The Trust Center * Adding or Removing A Developer from a Trusted Location * Changing a Trusted Location * Encrypting Your Database * Opening an Encrypted Database * Removing a Password from an Encrypted Database * Using the Package-and-Sign Feature