Microsoft® Office Access® 2010
Course Content
Level 1 (1 day)
Lesson 1: Getting Started with Access Databases
Identify the Elements of the Access 2010 Interface
Identify the Components of a Database
Examine the Relational Database Design Process
Lesson 2: Building the Structure of a Database
Create a New Database
Create a Table
Manage Tables
Establish Table Relationships
Lesson 3: Managing Data in a Table
Modify Table Data
Sort and Filter Records
Work with Subdatasheets
Lesson 4: Querying a Database
Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping
Lesson 5: Designing Forms
Create a Form
Modify the Design of a Form
View and Edit Data Using an Access Form
Lesson 6: Generating Reports
Create a Report
Add a Control to a Report
Format the Controls in a Report
Enhance the Appearance of a Report
Prepare a Report for Print
Level 2 (1 day)
Lesson 1: Controlling Data Entry
Constrain Data Entry Using Field Properties
Establish Data Entry Formats for Entering Field Values
Create a List of Values for a Field
Lesson 2: Joining Tables
Create Query Joins
Join Tables That Have No Common Fields
Relate Data Within a Table
Lesson 3: Creating Flexible Queries
Set the Select Query Properties
Retrieve Records Based on Input Criteria
Create Action Queries
Lesson 4: Improving Forms
Restrict Data Entry in Forms
Organize Information with Tab Pages
Add a Command Button to a Form
Create a Subform
Display a Summary of Data in a Form
Change the Display of Data Conditionally
Lesson 5: Customizing Reports
Organize Report Information
Format Reports
Control Report Pagination
Add a Calculated Field to a Report
Add a Subreport to an Existing Report
Create a Mailing Label Report
Lesson 6: Sharing Data Across Applications
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge
Level 3 (1 day)
Lesson 1: Structuring Existing Data
Restructure the Data in a Table
Create a Junction Table
Improve the Table Structure
Lesson 2: Writing Advanced Queries
Create Subqueries
Create Unmatched and Duplicate Queries
Filter Records Using Criteria
Summarize Data Using a Crosstab Query
Create a PivotTable and a PivotChart
Lesson 3: Simplifying Tasks with Macros
Create a Macro
Attach a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Lesson 4: Creating Effective Reports
Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Publish a Report as a PDF
Lesson 5: Maintaining an Access Database
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database
Level 4 (1 day)
Lesson 1: Integrating Access into Your Business
Import XML Data into an Access Database
Export Access Data to the XML Format
Export Data to an Outlook Address Book
Collect Data Through Email Messages
Lesson 2: Automating a Business Process with VBA
Create a Standard Module
Develop Code
Call a Procedure from a Form
Run a Procedure
Lesson 3: Managing Switchboards
Create a Database Switchboard
Modify a Database Switchboard
Set the Startup Options
Lesson 4: Distributing and Securing Databases
Split a Database
Implement Security
Set Passwords
Convert an Access Database to an ACCDE File
Package a Database with a Digital Signature
Lesson 5: Sharing Databases Using a SharePoint Site
Export a Table to a SharePoint List
Import Data from a SharePoint List
Publish a Database to a SharePoint Site
Move a Database to a SharePoint Site
Work Offline