Collection 10349: Skills Training for Microsoft Access 2010
Product Details
Product Description
This four-hour online collection provides you with the skills and knowledge required to create, customize, use, and share Access 2010 databases.Topics covered in this collection 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
Student prerequisites:
Learners taking this course should already be familiar with Microsoft Office Access 2003, Microsoft Office Access 2007, or some other database application. Learners who are familiar with Access 2003 and unfamiliar with the ribbon must complete Course 4697: Introduction to the New Microsoft® Office Fluent? User Interface.
This collection includes the following courses:
Course 10382: Beginner Skills in Microsoft Access 2010
Course 10383: Intermediate Skills in Microsoft Access 2010
Course 10384: Advanced Skills in Microsoft Access 2010
System Requirements:
Pentium II 400 MHz or higher
256MB RAM or more
Microsoft Internet Explorer 6.0 or higher
256k connection (broadband recommended)
Windows XP, 2000 or higher
Flash Player 7.0 or higher
Speakers and soundcard
Access 2010 is required to use the local labs included in this course.
Subscription: 1 year.
Table of Contents
Course 10382: Beginner Skills in Microsoft Access 2010
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
Glossary
Course 10383: Intermediate Skills in Microsoft Access 2010
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
Glossary
Course 10384: Advanced Skills in Microsoft Access 2010
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
Glossary