Skills Training in Microsoft Access 2010
ICT Education Newsletter
This training provides you with the skills and knowledge required to create, customize, use, and share Access 2010 databases.
Topics
Topics covered in this training include:
Database Basics
Creating a Database
Defining a Primary Key
Creating Datasheet Relationships
Creating a Complex Query
Using Lookup Fields
Creating and Editing a Query in SQL View
Creating a Report
Creating Pivot Objects
Creating and Editing a Macro
Handling Errors in a Macro
Creating and Editing a Module
Packaging a Database
Sharing a Database
Program
Module 1: Course 10382: Beginner Skills in Microsoft Access 2010
Students will be able to:
1) Create and edit a database.
2) Create and use a query.
3) Create and edit a report.
4) Create and edit a form.
1) Creating and Editing a Database
Introduction
Exploring the Access 2010 Interface
Database Basics
Reviewing Access 2010 Fundamentals
Creating a Database
Viewing a Database
Importing and Exporting Data
Editing and Formatting Table Data
Creating and Managing Indexes
Creating an Events Database
Self Test
2)Creating and Using a Query
Introduction
Creating a Query by Using Query Wizard
Creating an Expression by Using Expression Builder
Creating a Criteria-Based Query
Performing Calculations by Using a Query
Creating a Query
Self Test
3)Working with a Report
Introduction
Creating a Report
Creating a Label
Grouping and Sorting Data in a Report
Performing Calculations in a Report
Creating and Editing a Report
Self Test
4)Creating and Editing a Form
Introduction
Creating a Form by Using Form Wizard
Creating a Form by Using the Form Tool
Editing a Form in Design View
Creating a Form
Self Test
Module 2: Course 10383: Intermediate Skills in Microsoft Access 2010
Students will be able to:
1)Modify a database
2)Create complex queries to extract and process specific information
1)Modifying a Database
Introduction
Creating a Table
Modifying a Table
Defining a Primary Key
Reviewing Table Fundamentals
Creating Datasheet Relationships
Validating Data in a Table
Using Lookup Fields
Creating a Default Database Template
Compacting a Database
Editing a Database
Self Test
2)Working with Complex Queries
Introduction
Creating a Complex Query
Creating a Totals Query
Creating and Editing a Query in SQL View
Creating Pivot Objects
Creating and Editing Complex Queries
Self Test
Module 3: Course 10384: Advanced Skills in Microsoft Access 2010
Students will be able to:
1)Create programmed elements to automate tasks and add functionality to database objects and controls.
2)Share and distribute database information.
1)Creating Programmed Elements
Introduction
Exploring the Macro Environment
Creating and Editing a Macro
Creating an Embedded Macro
Handling Errors in a Macro
Creating and Editing a Module
Creating a Macro
Self Test
2)Sharing Database Information
Introduction
Creating an Execute-Only Database
Encrypting a Database
Using the Access 2010 Runtime Program
Packaging a Database
Synchronizing a Database with a SharePoint List
Importing Data from and Exporting Data to SharePoint Lists
Sharing a Database
Self Test