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 firstname.lastname@example.org.
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.
Offering a step-by-step approach to learning the latest version of Office Access 2007, this self-paced tutorial, complete with practice files on CD-ROM, helpful hints, and troubleshooting guidelines, helps users navigate the new user interface, create a database, produce forms and queries, filter data, customize a database, and use VBA to create Web pages based on data. Original. (Beginner/Intermediate)
About the Author
has more than 20 years' experience writing and editing technical subjects for non-technical audiences. For 12 of those years, she was the principal author for Online Press. Joyce is the primary author of numerous books on Office.
Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997. As President and CEO of Online Training Solutions, Inc. (OTSI), Joan guides the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to get things done efficiently.
Joan is the author or coauthor of more than three dozen books about Windows and Office (for the Windows, Mac, and iPad platforms) and three generations of Microsoft Office Specialist certification study guides. Joan is a Microsoft Certified Professional, Microsoft Office Specialist Master (for Office 2013, Office 2010, and Office 2007), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified Technology Associate (for Windows), Microsoft Dynamics Specialist, and Microsoft Certified Trainer.
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 SpecialistMicrosoft 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;