Access 2010 Transition from Access 2003

Course details

In this course, students will identify and use the new and enhanced features to Microsoft® Office Access® 2010 since the release of Microsoft Access 2003

Objectives

Upon successful completion of this course, students will be able to: - identify the components of the Microsoft Office Access 2010 interface. - build tables and forms and also work with macros. - create queries and reports. - work with external data. - build a database for the web.

Prerequisites

Lessons

Lesson 1: Identifying the Components of the Access 2010 Environment

• Explore the User Interface 
• Access Commands on the Ribbon Tabs 
• Access the Contextual Tabs 
• Customize the Access Environment

Lesson 2: Building Tables and Forms

• Create a Table 
• Build Forms from Existing Table Data 
• Design a Form 
• Work with Macros

Lesson 3: Creating Queries and Reports

• Query a Database 
• Generate Reports 
• Format a Report

Lesson 4: Working with External Data

• Import Data 
• Export Data to Other Applications

Lesson 5: Building a Database for the Web

• Create Tables and Forms in a Web Database 
• Create Queries and Reports in a Web Database 
• Prepare to Publish a Database to Access Services