Level 1 – Build a Strong Database Foundation with Access 2010

• 1. The Access 2010 Interface & File Types
• 1.1. Create a New Database Based on a Template
• 1.2. Create a New Database Using Templates Available at Office.com
• 1.3. Experience the New Access 2010 Interface
• 1.4. Go Backstage via the File Tab
• 1.5. Customize the Quick Access Toolbar
• 1.6. Customize the Ribbon
• 1.7. Access File Types and What They Mean to You
• 1.8. Need Help? It’s Local & Online

• 2. Understanding Key Database Development Concepts
• 2.1. About Relational Databases like Access 2010
• 2.2. Understand Database Objects
• 2.3. Use the Navigation Pane
• 2.4. Database Design Process
• 2.5. Work with Just One Database at a Time

• 3. Build the Foundation of a Database
• 3.1. The Role Tables Play in a Database
• 3.2. Create a Table Using Application Parts
• 3.3. Create a Table in Datasheet View
• 3.4. Create a Table Based on a SharePoint List
• 3.5. About Field Data Types
• 3.6. Create a Multi-Valued Field
• 3.7. Rename a Table
• 3.8. Set the Maximum Allowable Characters for a Field
• 3.9. Assign a Field’s Default Value

• 4. Define Links Between Your Tables with Relationships
• 4.1. The Role of Primary Keys in a Database
• 4.2. Set or Clear a Database Primary Key
• 4.3. About Table Relationships
• 4.4. Add a Table to the Relationship Window
• 4.5. Create a Relationships Between Two Tables
• 4.6. When to Enforce Referential Integrity
• 4.7. Use Cascade Update and Cascade Delete to Manage Your Data
• 4.8. Send the Relationships Report to the Printer
• 4.9. Save the Relationships Report Outside of Access

• 5. Get Your Data Into an Access Table
• 5.1. Use Datasheet View for Data Entry Tasks
• 5.2. Add or Delete a Record in a Table
• 5.3. Use Find and Replace
• 5.4. Undo and Redo Options
• 5.5. Copy the Value in the Row Above
• 5.6. Enter the Current Date
• 5.7. Import an Excel Spreadsheet Into Access
• 5.8. Populate an Access Table Based on Email Messages

• 6. Advanced Table Design in Access 2010
• 6.1. Create a Table in Design View
• 6.2. Customize a Field’s Properties in Design View
• 6.3. Use the Property Sheet Task Pane for Tables
• 6.4. Use Input Masks to Control the Format of Entered Data
• 6.5. Force All Text to Upper or Lower Case
• 6.6. Add a Datasheet Total Row
• 6.7. Use Rich Text in the Memo Field
• 6.8. Show or Hide the Date Picker in the Date/Time Field

• 7. Techniques to Help Avoid Data Entry Errors
• 7.1. About Data Validation
• 7.2. Assign Data Validation Parameters to a Field
• 7.3. Customize the Data Validation Message Box
• 7.4. How Lookup Fields Can Help Prevent Data Entry Errors
• 7.5. Create a Lookup Field
• 7.6. Use Multiple Values in a Lookup Field
• 7.7. How to Switch a Lookup Field Back to a Text Box

Level 2 – Display and Extract Specific Data in Your Access 2010 Tables

• 1. Some Table Options You May Not Have Seen, Yet
• 1.1. Insert a Record Based on an Outlook Contact
• 1.2. Adjust the Height of a Row in Datasheet View
• 1.3. Adjust the Width of a Field in Datasheet View
• 1.4. Hide or Unhide a Field in Datasheet View
• 1.5. Freeze a Field in Datasheet View for Easier Scrolling
• 1.6. Text Formatting Options in Datasheet View
• 1.7. Print Options for Tables

• 2. Filtering in Access 2010
• 2.1. About Filters
• 2.2. Common Filters
• 2.3. Filter by Selection
• 2.4. Filter by Form
• 2.5. Advanced Filters

• 3. Create Select Queries in Access 2010
• 3.1. The Difference Between a Filter and a Query
• 3.2. Select Queries: Explained
• 3.3. Create a Simple Query Using the Wizard
• 3.4. Create a New Query Using Design View
• 3.5. Add a Table to a Query
• 3.6. Use Criteria to Pull Matching Records in a Query
• 3.7. Sort Fields in a Query
• 3.8. Show or Hide Fields in a Query
• 3.9. Run a Query

• 4. Create Action Queries in Access 2010
• 4.1. The Difference Between an Action Query and a Select Query
• 4.2. Action Queries: Explained
• 4.3. Types of Action Queries
• 4.4. Create a Query that Updates Records
• 4.5. Create a Query that Appends Records from One Table to the Bottom of Another Table
• 4.6. Create a Query that Makes a New Table
• 4.7. Create a Query that Deletes Specified Records

• 5. Work with Access 2010 Queries
• 5.1. Create a Calculated Field in a Query
• 5.2. Create a Crosstab Query
• 5.3. Create a Query that Finds Duplicate Values
• 5.4. Create a Query that Finds Unmatched Values
• 5.5. Create a Query that Prompts for Single Criteria Each Time it is Run
• 5.6. Create a Query that Prompts for Multiple Criteria Each Time it is Run
• 5.7. How Joins Can Impact Your Queries
• 5.8. Return the Top Values in a Query
• 5.9. Print Options for Queries

• 6. Send Your Access 2010 Information to Other Programs
• 6.1. Send an Access Table to Excel
• 6.2. Send an Access Table to a Text File
• 6.3. Send an Access Table to PDF
• 6.4. Send an Access Table to a Word Document
• 6.5. Send an Access Table to a SharePoint List
• 6.6. Email an Access Table
• 6.7. Use an Access Table as the Data Source for a Word Mail Merge
• 6.8. Save an Export for Future Use

Level 3 – Display Your Data in Access 2010 with Forms and Reports

• 1. Create a Form in Access 2010
• 1.1. Create a Form in Just One Click
• 1.2. Create a Form Using Application Parts
• 1.3. Create a Form Using the Wizard
• 1.4. Start a Form from a Blank Slate
• 1.5. Create a Form in Design View
• 1.6. Understand Form Sections
• 1.7. Set Form Section Properties
• 1.8. Use Form Layout View

• 2. Create a Report in Access 2010
• 2.1. Create a Report in Just One Click
• 2.2. Create a Report Using the Wizard
• 2.3. Start a Report from a Blank Slate
• 2.4. Create a Report in Design View
• 2.5. Understand Report Sections
• 2.6. Set Report Section Properties
• 2.7. Use Report Layout View

• 3. Advanced Form & Report Design
• 3.1. Add Controls to Your Form or Report
• 3.2. Use the Property Sheet Task Pane for Forms and Reports
• 3.3. Add the Date and Time to a Form or a Report
• 3.4. Add a Title to a Form or Report
• 3.5. Change a Form’s or Report’s Tab Order
• 3.6. Create a Lookup Field on a Form or Report
• 3.7. Add a Calculated Control to a Form or Report
• 3.8. Create a Conditional Formatting Rule for a Calculated Field

• 4. Arrange and Edit Form and Report Controls
• 4.1. Switch a Form or Report Layout Between Stacked and Tabular
• 4.2. Work with Gridlines in a Form or Report
• 4.3. Insert Rows and Columns on a Form or Report
• 4.4. Split a Field Vertically or Horizontally to Reduce its Size
• 4.5. Move a Field Up or Down on a Form or Report
• 4.6. Set the Space Between Fields on a Form or Report
• 4.7. Align Controls on a Form or Report
• 4.8. Work with Form and Report Margins
• 4.9. Work with Control Anchoring

• 5. Some Form Options You May Not Have Seen, Yet
• 5.1. Add a Command Button to a Form
• 5.2. Create a Split Form
• 5.3. Add Tabs to a Form
• 5.4. Form Print Options
• 5.5. Create a Switchboard

• 6. Some Report Options You May Not Have Seen, Yet
• 6.1. Report Print Options
• 6.2. Arrange Report Data Into Columns
• 6.3. Work with Total Fields
• 6.4. Create a Grouped or Sorted Report
• 6.5. Edit Report Group Settings

• 7. Work with Themes and Graphics on a Form or Report
• 7.1. About Office 2010 Themes
• 7.2. Change a Theme’s Color, Font & Effects
• 7.3. Create & Save a Custom Theme
• 7.4. Add a Logo to a Form or Report
• 7.5. Insert Any Image on a Form or Report
• 7.6. Add an Image as a Background
• 7.7. Format Form and Report Labels

Level 4 – Bonus Techniques for the Advanced Access 2010 User

• 1. Database Management
• 1.1. Copy a Table
• 1.2. About Database Security
• 1.3. Use a Database Password
• 1.4. Identify Object Dependencies
• 1.5. Run the Database Documenter
• 1.6. Analyze a Table
• 1.7. Analyze Database Performance
• 1.8. Compact and Repair a Database

• 2. Work with Macro Objects
• 2.1. Use the Built-in Macros
• 2.2. Understand the Action Catalog
• 2.3. Create a Data Macro from a Table
• 2.4. Create a Custom Macro
• 2.5. Add a Condition to a Macro
• 2.6. Rename or Delete a Macro
• 2.7. Edit a Macro
• 2.8. Attach a Macro to a Command Button

• 3. Work with PivotTables in Access 2010
• 3.1. About PivotTables & PivotCharts
• 3.2. Create a PivotTable in Access
• 3.3. Edit a PivotTable’s Field Settings in Access
• 3.4. Control a PivotTable’s Data Calculations in Access
• 3.5. Sort a PivotTable in Access
• 3.6. Show the Top Values in a PivotTable in Access
• 3.7. Export a PivotTable Created in Access to Excel

• 4. Work with PivotCharts in Access 2010
• 4.1. Create a PivotChart in Access
• 4.2. Change the PivotChart Type in Access
• 4.3. Work with PivotChart Labels in Access
• 4.4. Sort PivotChart Data in Access