Microsoft Office Access(tm) 2007 Step by Step (Step by Step)

About the Authors; Steve Lambert; M. Dow Lambert III; Joan Lambert Preppernau; The Team; Online Training Solutions, Inc. (OTSI); Introducing Access 2007; New Features; Lets Get Started!; Information for Readers Running Windows XP; Managing the Practice Files; Using the Start Menu; Navigating Dialog Boxes; The Microsoft Business Certification Program; Selecting a Certification Path; Becoming a Microsoft Certified Application Specialist—Microsoft Office Access 2007; Taking a Microsoft Business Certification Exam; More Information; Features and Conventions of This Book; Using the Books CD; Whats on the CD?; Minimum System Requirements; Installing the Practice Files; Adding the Practice File Folder to the Trusted Locations List; Using the Practice Files; Removing and Uninstalling the Practice Files; Getting Help; Getting Help with This Book and Its Companion CD; Getting Help with Access 2007; More Information; Quick Reference; 1 Exploring Access 2007; 2 Creating a Database; 3 Populating a Database; 4 Sharing and Reusing Information; 5 Simplifying Data Entry by Using Forms; 6 Locating Specific Information; 7 Keeping Your Information Accurate; 8 Working with Reports; 9 Making Your Database Easy to Use; 10 Securing and Sharing Information; Chapter 1: Exploring Access 2007; 1.1 Working in Access 2007; 1.2 Understanding Database Concepts; 1.3 Opening an Existing Database; 1.4 Exploring Tables; 1.5 Exploring Queries; 1.6 Exploring Forms; 1.7 Exploring Reports; 1.8 Exploring Other Access Objects; 1.9 Previewing and Printing Access Objects; 1.10 Key Points; Chapter 2: Creating a Database; 2.1 Creating a Database from a Template; 2.2 Creating a Table Manually; 2.3 Creating a Table from a Template; 2.4 Manipulating Table Columns and Rows; 2.5 Key Points; Chapter 3: Populating a Database; 3.1 Importing Information from Another Access Database; 3.2 Importing Information from an Excel Worksheet; 3.3 Importing or Linking to a SharePoint List; 3.4 Collecting Data Through E-Mail; 3.5 Importing Information from a Text File; 3.6 Importing Information from an XML File; 3.7 Importing Information from an HTML File; 3.8 Importing Information from an Outlook Folder; 3.9 Importing Information from a dBASE File; 3.10 Key Points; Chapter 4: Sharing and Reusing Information; 4.1 Exporting Information to Another Access Database; 4.2 Exporting Information to Excel; 4.3 Exporting Information to a SharePoint List; 4.4 Exporting Information to Word; 4.5 Exporting Information to a Text File; 4.6 Exporting Information to an XML File; 4.7 Exporting Information to an HTML File; 4.8 Copying Information to Other Office Programs; 4.9 Key Points; Chapter 5: Simplifying Data Entry by Using Forms; 5.1 Creating a Form by Using the Form Tool; 5.2 Refining Form Properties; 5.3 Changing the Arrangement of a Form; 5.4 Adding Controls to a Form; 5.5 Entering Data in a Form by Using VBA; 5.6 Creating a Form by Using an AutoForm; 5.7 Adding a Subform to a Form; 5.8 Key Points; Chapter 6: Locating Specific Information; 6.1 Sorting Information in a Table; 6.2 Filtering Information in a Table; 6.3 Filtering Information by Using a Form; 6.4 Locating Information That Matches Multiple Criteria; 6.5 Creating a Query Manually; 6.6 Creating a Query by Using a Wizard; 6.7 Performing Calculations by Using a Query; 6.8 Key Points; Chapter 7: Keeping Your Information Accurate; 7.1 Restricting the Type of Data in a Field; 7.2 Restricting the Amount of Data in a Field; 7.3 Specifying the Format of Data in a Field; 7.4 Restricting Data by Using Validation Rules; 7.5 Creating a Simple Lookup List; 7.6 Creating a Multi-Column Lookup List; 7.7 Updating Information in a Table; 7.8 Deleting Information from a Table; 7.9 Preventing Database Problems; 7.10 Key Points; Chapter 8: Working with Reports; 8.1 Creating a Report by Using a Wizard; 8.2 Modifying Report Design; 8.3 Creating a Report Manually; 8.4 Modifying Report Content; 8.5 Adding a Subreport to a Report; 8.6 Previewing and Printing a Report; 8.7 Key Points; Chapter 9: Making Your Database Easy to Use; 9.1 Creating a Switchboard; 9.2 Creating Custom Categories; 9.3 Controlling the Features Available to Database Users; 9.4 Making Favorite Access Commands Quickly Available; 9.5 Key Points; Chapter 10: Securing and Sharing Information; 10.1 Assigning a Password to a Database; 10.2 Preventing Changes to Database Code; 10.3 Securing a Database for Distribution; 10.4 Key Points; Glossary; Choose the Right Book for You; Published and Upcoming Titles;