Table of Contents

Microsoft® Office Access™ 2007 Step by Step
By Steve Lambert, M. Dow Lambert III, Joan Preppernau
...............................................
Publisher: Microsoft Press
Pub Date: January 03, 2007
Print ISBN-10: 0-7356-2303-1
Print ISBN-13: 978-0-7356-2303-3
Pages: 384

Table of Contents  | Index

		Copyright
		About the Authors
		Introducing Access 2007
		Information for Readers Running Windows XP
		The Microsoft Business Certification Program
		Features and Conventions of This Book
		Using the Book's CD
		Getting Help
		Quick Reference
		Chapter 1.  Exploring Access 2007
			Working in Access 2007
			Understanding Database Concepts
			Opening an Existing Database
			Exploring Tables
			Exploring Queries
			Exploring Forms
			Exploring Reports
			Exploring Other Access Objects
			Previewing and Printing Access Objects
			Key Points
		Chapter 2.  Creating a Database
			Creating a Database from a Template
			Creating a Table Manually
			Creating a Table from a Template
			Manipulating Table Columns and Rows
			Key Points
		Chapter 3.  Populating a Database
			Importing Information from Another Access Database
			Importing Information from an Excel Worksheet
			Importing or Linking to a SharePoint List
			Collecting Data Through E-Mail
			Importing Information from a Text File
			Importing Information from an XML File
			Importing Information from an HTML File
			Importing Information from an Outlook Folder
			Importing Information from a dBASE File
			Key Points
		Chapter 4.  Sharing and Reusing Information
			Exporting Information to Another Access Database
			Exporting Information to Excel
			Exporting Information to a SharePoint List
			Exporting Information to Word
			Exporting Information to a Text File
			Exporting Information to an XML File
			Exporting Information to an HTML File
			Copying Information to Other Office Programs
			Key Points
		Chapter 5.  Simplifying Data Entry by Using Forms
			Creating a Form by Using the Form Tool
			Refining Form Properties
			Changing the Arrangement of a Form
			Adding Controls to a Form
			Entering Data in a Form by Using VBA
			Creating a Form by Using an AutoForm
			Adding a Subform to a Form
			Key Points
		Chapter 6.  Locating Specific Information
			Sorting Information in a Table
			Filtering Information in a Table
			Filtering Information by Using a Form
			Locating Information That Matches Multiple Criteria
			Creating a Query Manually
			Creating a Query by Using a Wizard
			Performing Calculations by Using a Query
			Key Points
		Chapter 7.  Keeping Your Information Accurate
			Restricting the Type of Data in a Field
			Restricting the Amount of Data in a Field
			Specifying the Format of Data in a Field
			Restricting Data by Using Validation Rules
			Creating a Simple Lookup List
			Creating a Multi-Column Lookup List
			Updating Information in a Table
			Deleting Information from a Table
			Preventing Database Problems
			Key Points
		Chapter 8.  Working with Reports
			Creating a Report by Using a Wizard
			Modifying Report Design
			Creating a Report Manually
			Modifying Report Content
			Adding a Subreport to a Report
			Previewing and Printing a Report
			Key Points
		Chapter 9.  Making Your Database Easy to Use
			Creating a Switchboard
			Creating Custom Categories
			Controlling the Features Available to Database Users
			Making Favorite Access Commands Quickly Available
			Key Points
		Chapter 10.  Securing and Sharing Information
			Assigning a Password to a Database
			Preventing Changes to Database Code
			Securing a Database for Distribution
			Key Points
		Glossary
		Choose the Right Book for You
			Published and Upcoming Titles
		Index