Experience learning made easy—and quickly teach yourself how to build database solutions with Access 2007. With Step By Step, you set the pace—building and practicing the skills you need, just when you need them!
Build databases from scratch or from templates
Exchange data with other databases and Office documents
Create forms to simplify data entry
Use filters and queries to find and analyze information
Design rich reports that help make your data meaningful
Help prevent data corruption and unauthorized access
Your all-in-one learning experience includes:
Files for building skills and practicing the book’s lessons
Fully searchable eBook
Bonus quick reference to the Ribbon, the new Microsoft Office interface
Windows Vista® Product Guide eReference—plus other resources on CD
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
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
Comments about Microsoft Press Microsoft® Office Access™ 2007 Step by Step:
I used this book as part of my study toward MCAS certification in Access. It is a great companion volume to the Microsoft Certified Application Specialist Study Guide. It helped me to refresh what I already knew about Access 2007 and it introduced me to some features and shortcuts I did not know until I read the book. The practice files are a great help too.
