Microsoft Access 2010 Training Course

Microsoft Access 2010 Training: Level 1
Build a Strong Database Foundation

• The Microsoft Office Access 2010 Interface and File Types
• Create a New Database Based on a Template 010101
• Create a New Database Using Templates Available at Office.com
• Experience the New Access 2010 Interface
• Go Backstage via the File Tab
• Customize the Quick Access Toolbar
• Customize the Ribbon
• Access File Types and What They Mean to You
• Need Help? It's Local and Online

• Understanding Key Database Development Concepts
• About Relational Databases like Access 2010
• Understand Database Objects
• Use the Navigation Pane
• Database Design Process
• Work with Just One Database at a Time

• Build the Foundation of a Database in Access 2010
• The Role Tables Play in a Database
• Create a Table Using Application Parts
• Create a Table in Datasheet View
• Create a Table Based on a SharePoint List
• About Field Data Types
• Create a Multivalued Field
• Rename a Table
• Set the Maximum Allowable Characters for a Field
• Assign a Field's Default Value

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

• Get Your Data Into an Access Table
• Use Datasheet View for Data Entry Tasks
• Add or Delete a Record in a Table
• Use Find and Replace
• Undo and Redo
• Copy the Value in the Row Above
• Enter the Current Date
• Import an Excel Spreadsheet Into Access 2010
• Populate an Access Table Based on Email Messages

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

• Techniques to Help Avoid Data Entry Errors
• About Data Validation
• Assign Data Validation Parameters to a Field
• Customize the Data Validation Message Box
• How Lookup Fields Can Help Prevent Data Entry Errors
• Create a Lookup Field
• Switch a Lookup Field Back to a Text Field

• Office 2010 Training for Access 2010: Resources
• Access 2010 Level 1 Exercises
• Access 2010 Level 1 Sample Files
• Access 2010 Level 1 Knowledge Checks
• Access 2010 Level 1 Training KeyNotes

Microsoft Access 2010 Training: Level 2
Display and Extract Specific Data in Your Tables

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

• Filtering
• About Filters
• Common Filters
• Filter by Selection
• Filter by Form
• Advanced Filters

• Create Select Queries in Access 2010
• The Difference Between a Filter and a Query
• Select Queries: Explained
• Create a Simple Query Using the Wizard
• Create a New Query Using Design View
• Add a Table to a Query
• Use Criteria to Pull Matching Records in a Query
• Sort Fields in a Query
• Show or Hide Fields in a Query
• Run a Query

• Create Action Queries
• The Difference Between an Action Query and a Select Query
• Action Queries: Explained
• Types of Action Queries
• Update Records
• Delete Specified Records
• Append Records from One Table to the Bottom of Another Table
• Create a Query that Makes a New Table

• Queries
• Create a Calculated Field in a Query
• Create a Crosstab Query
• Find Duplicate Values
• Find Unmatched Values
• Prompt for Single Criteria Each Time it is Run
• Prompt for Multiple Criteria Each Time it is Run
• How Joins Can Impact Your Queries
• Return the Top Values in a Query
• Print Options for Queries

• Send Your Access 2010 Information to Other Programs
• Send an Access 2010 Table to Excel 2010
• Send an Access 2010 Table to a Text File
• Send an Access 2010 Table to PDF
• Send an Access 2010 Table to a Word Document
• Email an Access 2010 Table
• Using Saved Exports

• Office 2010 Training for Access 2010: Resources
• Access 2010 Level 2 Exercises
• Access 2010 Level 2 Sample Files
• Access 2010 Level 2 Knowledge Checks
• Access 2010 Level 2 Training KeyNotes

Microsoft Access 2010 Training: Level 3
Display Your Data in Access with Forms and Reorts

• Create a Form in Access 2010
• Create a Form in Just One Click
• Create a Form Using Application Parts
• Create a Form Using the Wizard
• Start a Form from a Blank Slate
• Create a Form in Design View
• Understand Form Sections
• Set Form Section Properties
• Use Form Layout View

• Create a Report in Access 2010
• Create a Report in Just One Click
• Create a Report Using the Wizard
• Start a Report from a Blank Slate
• Create a Report in Design View
• Understand Report Sections
• Set Report Section Properties
• Use Report Layout View

• Advanced Form and Report Design
• Add Controls to Your Form or Report
• Use the Property Sheet Task Pane for Forms and Reports
• Add the Date and Time to a Form or a Report
• Add a Title to a Form or Report
• Change a Form's Tab Order
• Create a Lookup Field on a Form
• Add a Calculated Control to a Form or Report
• Create a Conditional Formatting Rule for a Calculated Field

• Arrange and Edit Form and Report Controls
• Switch a Form or Report Layout Between Stacked and Tabular
• Gridlines in a Form or Report
• Insert Rows and Columns on a Form or Report
• Split a Field Vertically or Horizontally to Reduce its Size
• Move a Field Up or Down on a Form or Report
• Set the Space Between Fields on a Form or Report
• Form and Report Margins

• Some Form Options You May Not Have Seen, Yet
• Add a Command Button to a Form
• Create a Split Form
• Add Tabs to a Form
• Form Print Options

• Some Report Options You May Not Have Seen, Yet
• Report Print Options
• Arrange Report Data Into Columns
• Total Fields
• Create a Grouped or Sorted Report
• Edit Report Group Settings

• Themes and Graphics on a Form or Report
• About Microsoft Office 2010 Themes
• Change a Theme's Color, Font andEffects
• Create andSave a Custom Theme
• Add a Logo to a Form or Report
• Format Form and Report Labels

• Office 2010 Training for Access: Resources
• Access 2010 Level 3 Exercises
• Access 2010 Level 3 Sample Files
• Access 2010 Level 3 Knowledge Checks
• Access 2010 Level 3 Training KeyNotes

Microsoft Access 2010 Training: Level 4
Bonus Techniques for the Advanced Access User

• Database Management
• Copy a Table
• About Database Security
• Use a Database Password
• Identify Object Dependencies
• Run the Database Documenter
• Analyze a Table
• Analyze Database Performance
• Compact and Repair a Database

• Access 2010 Macro Objects
• About Macros
• Use the Action Catalog to Record a Macro
• Create a Custom Macro
• Rename or Delete a Macro
• Edit a Macro
• Create a Data Macro from a Table
• Attach a Macro to a Command Button

• PivotTables in Access 2010
• About PivotTables andPivotCharts
• Create a PivotTable in Access
• Edit a PivotTable's Field Settings in Access
• Control a PivotTable's Data Calculations in Access
• Sort a PivotTable in Access
• Show the Top Values in a PivotTable in Access
• Export a PivotTable Created in Access to Excel 2010
• Create a PivotChart in Access
• Change the PivotChart Type in Access

• Office 2010 Training for Access2010: Resources
• Access 2010 Level 4 Exercises
• Access 2010 Level 4 Sample Files
• Access 2010 Level 4 Knowledge Checks
• Access 2010 Level 4 Training KeyNotes

*Outline, Topics, and Resources subject to change