- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
New Trade Paper
Ships in 1 to 3 days
Other titles in the Step by Step series:
Microsoft Office Access(tm) 2007 Step by Step (Step by Step)by Steve Lambert
Synopses & Reviews
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(R) 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 email@example.com.
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!
Your all-in-one learning experience includes:
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
About the Author
Joan Lambert is the author of more than a dozen books on Windows and Office, including several popular STEP BY STEP titles from Microsoft Press.
Table of Contents
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;
What Our Readers Are Saying
Business » Accounting and Finance