Synopses & Reviews
Experience learning made easy-and quickly teach yourself how to build database solutions with Access 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include building an Access database from scratch or from templates; publishing your database to the Web; exchanging data with other databases and Microsoft Office documents; creating data-entry forms; using filters and queries; designing reports; using conditional formatting; preventing data corruption and unauthorized access; and other core topics.
About the Author
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.
Joyce Cox has 20+ years’ experience developing training materials on technical subjects for non-technical audiences, including dozens of books about Office and Windows.
Table of Contents
Introducing Microsoft Access 2010; New Features; Lets Get Started!; Modifying the Display of the Ribbon; Dynamic Ribbon Elements; Changing the Width of the Ribbon; Adapting Exercise Steps; Features and Conventions of This Book; Using the Practice Files; Getting Help; Getting Help with This Book; Getting Help with Access 2010; More Information; Simple Database Techniques; Chapter 1: Explore an Access 2010 Database; 1.1 Working in Access 2010; 1.2 Understanding Database Concepts; 1.3 Exploring Tables; 1.4 Exploring Forms; 1.5 Exploring Queries; 1.6 Exploring Reports; 1.7 Previewing and Printing Access Objects; 1.8 Key Points; Chapter 2: Create Databases and Simple Tables; 2.1 Creating Databases from Templates; 2.2 Creating Databases and Tables Manually; 2.3 Manipulating Table Columns and Rows; 2.4 Refining Table Structure; 2.5 Creating Relationships Between Tables; 2.6 Key Points; Chapter 3: Create Simple Forms; 3.1 Creating Forms by Using the Form Tool; 3.2 Changing the Look of Forms; 3.3 Changing the Arrangement of Forms; 3.4 Key Points; Chapter 4: Display Data; 4.1 Sorting Information in Tables; 4.2 Filtering Information in Tables; 4.3 Filtering Information by Using Forms; 4.4 Locating Information That Matches Multiple Criteria; 4.5 Key Points; Chapter 5: Create Simple Reports; 5.1 Creating Reports by Using a Wizard; 5.2 Modifying Report Design; 5.3 Previewing and Printing Reports; 5.4 Key Points; Relational Database Techniques; Chapter 6: Maintain Data Integrity; 6.1 Restricting the Type of Data; 6.2 Restricting the Amount of Data; 6.3 Restricting the Format of Data; 6.4 Restricting Data by Using Validation Rules; 6.5 Restricting Data to Values in Lists; 6.6 Restricting Data to Values in Other Tables; 6.7 Key Points; Chapter 7: Create Custom Forms; 7.1 Modifying Forms Created by Using a Wizard; 7.2 Adding Controls; 7.3 Adding Subforms; 7.4 Using E-Mail Forms to Collect Data; 7.5 Key Points; Chapter 8: Create Queries; 8.1 Creating Queries by Using a Wizard; 8.2 Creating Queries Manually; 8.3 Using Queries to Summarize Data; 8.4 Using Queries to Perform Calculations; 8.5 Using Queries to Update Records; 8.6 Using Queries to Delete Records; 8.7 Key Points; Chapter 9: Create Custom Reports; 9.1 Creating Reports Manually; 9.2 Modifying Report Content; 9.3 Adding Subreports; 9.4 Key Points; Database Management and Security; Chapter 10: Import and Export Data; 10.1 Importing Information; 10.2 Exporting Information; 10.3 Copying to and from Other Office Programs; 10.4 Key Points; Chapter 11: Make Databases User Friendly; 11.1 Creating Navigation Forms; 11.2 Creating Custom Categories; 11.3 Controlling Which Features Are Available; 11.4 Key Points; Chapter 12: Protect Databases; 12.1 Assigning Passwords to Databases; 12.2 Splitting Databases; 12.3 Securing Databases for Distribution; 12.4 Preventing Database Problems; 12.5 Key Points; Chapter 13: Customize Access; 13.1 Changing Default Program Options; 13.2 Customizing the Ribbon; 13.3 Customizing the Quick Access Toolbar; 13.4 Key Points; Glossary; Keyboard Shortcuts; General Shortcut Keys; Keys for Working with Text and Data; Keys for Navigating Records; Keys for Working with the Ribbon; Keys for Working with Online Help; Keys for Basic Office Tasks; About the Authors; Joyce Cox; Joan Lambert; The Team; Online Training Solutions, Inc. (OTSI);