Access 2007 New Features

Course details

In this course, students will be introduced to the new features available in Microsoft® Office Access.

Objectives

Upon successful completion of this course, students will be able to: 

• explore the Microsoft Office Access 2007 interface. 
• work with tables and forms. 
• create queries and reports using the enhanced features of Access 2007. 
• work with external data.

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