Book description
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
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Table of contents
- 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
- 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
- 1. Exploring Access 2007
- 2. Creating a Database
-
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
-
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
- 5. Simplifying Data Entry by Using Forms
- 6. Locating Specific Information
-
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
- 8. Working with Reports
- 9. Making Your Database Easy to Use
- 10. Securing and Sharing Information
- Glossary
- A. Choose the Right Book for You
- Index
- About the Authors
- Copyright
Product information
- Title: Microsoft® Office Access™ 2007 Step by Step
- Author(s):
- Release date: January 2007
- Publisher(s): Microsoft Press
- ISBN: 9780735623033
You might also like
book
Python Crash Course, 3rd Edition
Python Crash Course is the world's best-selling guide to the Python guide programming language, with over …
book
Python Crash Course, 2nd Edition
This is the second edition of the best selling Python book in the world. Python Crash …
book
Using Excel for Business and Financial Modelling, 3rd Edition
A hands-on guide to using Excel in the business context First published in 2012, Using Excel …
book
Microsoft® Access® 2010: Step by Step
Experience learning made easy-and quickly teach yourself how to build database solutions with Access 2010. With …