Course Outline

Explore an Access 2010 Database

• Working in Access 2010
• Understanding Database Concepts
• Exploring Tables
• Exploring Forms
• Exploring Queries
• Exploring Reports
• Previewing and Printing Access objects

Create Databases and Simple Tables

• Creating Databases from Templates
• Creating Databases and Tables Manually
• Manipulating Table Columns and Rows
• Refining Table Structure
• Creating Relationships between Tables

Display Data

• Sorting Information in Tables
• Filtering Information in Tables
• Filtering Information by Using Forms
• Locating Information That Matches Multiple Criteria

Maintain Data Integrity

• Restricting the Type of Data
• Restricting the Amount of Data
• Restricting the Format of Data
• Restricting Data by Using validation Rules
• Restricting Data to Values in Lists
• Restricting Data to Values in Other Tables

Create Queries

• Creating Queries by using a wizard
• Creating Queries Manually
• Using Queries to Summarize Data      
• Using Queries to Perform Calculations            
• Using Queries to Update Records       
• Using Queries to Delete Records        

Create Simple Forms

• Creating Forms by Using the Form Tool
• Changing the Look of Forms
• Changing the Arrangement of Forms
• Create Custom Forms
• Modifying Forms Created by Using a wizard
• Adding Controls
• Adding Subforms
• Using E-Mail Forms to Collect Data

Create Simple Reports

• Creating Reports by Using a wizard
• Modifying Report Design
• Previewing and Printing Reports

Create Custom Reports

• Creating Reports Manually
• Modifying Report Content
• Adding Subreports