Collection 10349: Skills Training for Microsoft Access 2010 - Microsoft Online Learning - MOS 77-885

Collection 10349: Skills Training for Microsoft Access 2010

We will process your order during normal business hours. Please allow up to an hour or two afterwards to receive instructions to logon and get your access code.

Author: Microsoft
ISBN 13: 5038470031847
Published by: MICROSOFT LEARNING
Date Published: 06/2010
User level: Beginner/Intermediate

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