Course 10382: Beginner Skills in Microsoft Access 2010

Introduction This two-hour online course explains how to create and work with a database and its objects by using the new and improved features in Microsoft Access 2010.

Topics covered in this course include:

• Database Basics
• Creating a Database
• Importing and Exporting Data
• Creating and Managing Indexes
• Creating a Query by Using Query Wizard
• Creating an Expression by Using Expression Builder
• Creating a Report
• Grouping and Sorting Data in a Report
• Creating a Form by Using Form Wizard

Student prerequisites:
Learners taking this course may have limited experience working with any database application, especially Access 2010. They may have used either Microsoft Office Access 2003 or Microsoft Office Access 2007. 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 before taking this course.
Objectives At the end of the course, students will be able to:

• Create and edit a database.
• Create and use a query.
• Create and edit a report.
• Create and edit a form.

Modules & 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 System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled