Microsoft Access 2010 Step by Step

Description

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.

CONTENTS:

Introducing Microsoft Access 2010; New Features; Let’s 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);