Course 5443: What’s New in Microsoft Office Access 2007

Introduction In this online course you will learn about the new features and functionality in the latest version of Microsoft Office Access. There have been substantial changes to the user interface in this database application, and this course can help you get up to speed quickly. This course covers the new features that enable you to create, populate, and analyze data in an Access database. You will also learn how to collaborate with others by sharing your database using Microsoft Windows SharePoint Services. Objectives At the end of the course, students will be able to:

• Use the features and functionality of the Microsoft Office Fluent interface for creating a database in Microsoft Access 2007.
• Populate a database with data.
• Analyze the data in a database.
• Share a database by using Microsoft Windows SharePoint Services.

Modules & Lessons Course Overview Module Introduction Navigation Overview Course Information What’s New in Microsoft Office Access 2007 Module Introduction Getting Started Lesson Introduction The Office Fluent Interface The Getting Started Screen Access Fundamentals Work with Tables and Relationships Self Test Populating Database Solutions Lesson Introduction Form Design Import Data from Office Excel Lab: Importing Contacts from Office Outlook Collect Updates by Using Office Outlook Self Test Analyzing Data Lesson Introduction The Filtering Feature Lab: Creating Reports Self Test Sharing Databases by Using WSS Lesson Introduction Benefits of Upsizing Databases to WSS Publishing vs. Upsizing Databases to WSS How to Work with SharePoint Lists Offline SharePoint Lists Management Self Test Module Summary Glossary Module Introduction 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