Post date: Mar 19, 2014 5:59:46 PM
Introduction
This training provides you with the skills and knowledge required to create, customize, use, and share Access 2010 databases.
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:
o Create and edit a database.
o Create and use a query.
o Create and edit a report.
o Create and edit a form.
Lessons
Course Overview
Module Overview
Navigation Overview
Navigation Overview
Course Information
Course Information
Lab Information
Lab Information
Beginner Skills in Access 2010
Module Overview
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
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
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
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 Summary
Module Summary
Glossary
Glossary
Module 2: Course 10383: Intermediate Skills in Microsoft Access 2010
Students will be able to:
o Modify a database
o Create complex queries to extract and process specific information
Lessons
Course Overview
Module Overview
Navigation Overview
Navigation Overview
Course Information
Course Information
Lab Information
Lab Information
Intermediate Skills in Access 2010
Module Overview
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
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 Summary
Module Summary
Glossary
Glossary
Module 3: Course 10384: Advanced Skills in Microsoft Access 2010
Students will be able to:
o Create programmed elements to automate tasks and add functionality to database objects and controls.
o Share and distribute database information.
Lessons
Course Overview
Module Overview
Navigation Overview
Navigation Overview
Course Information
Course Information
Lab Information
Lab Information
Advanced Skills in Access 2010
Module Overview
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
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
Module Summary
Module Summary
Glossary
Glossary