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
Access 2016 For Dummies
Your all-access guide to all things Access 2016 If you don't know a relational database from …
book
Alison Balter's Mastering Access 97 Development, Second Edition
One of the premier corporate database applications, Access, is a powerful application that can be programmed …
book
Windows® 7 Visual™ Quick Tips
Quick and easy answers for common Windows 7 questions Windows 7 is the operating system used …
book
GitHub For Dummies
Code collaboratively with GitHub Once you’ve learned the basics of coding the next step is to …