Course 5452: Importing and Exporting Information in Microsoft Office Access 2007

Introduction This online course covers the skills and knowledge you will need to import and export information to and from Access 2007 databases. This includes importing information from other Microsoft Office applications, as well as from other data sources. This course will also cover exporting Access 2007 information to other applications. Objectives At the end of the course, students will be able to:

• Import information from Microsoft Office applications.
• Import information from other sources.
• Export information to Office applications and other files.

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information Course Information Importing and Exporting Information in Access 2007 Module Introduction Importing Information from Office Applications Lesson Introduction Import Information from Another Access 2007 Database Lab: Importing Information from an Excel Worksheet Collect Data by Using E-Mail Import Information from an Outlook Folder Advantages of Linking to Information Import from or Link to a SharePoint List Self Test Importing Information from Other Sources Lesson Introduction Import Information from a Text File Import Information from an XML File Lab: Importing Information from an HTML File Import Information from a dBASE File Self Test Exporting Information Lesson Introduction Valid Export Formats for the Access 2007 Database Objects Lab: Exporting Information to Another Access 2007 Database Export Information to Other Office Applications Export Information to a SharePoint List Export Information to Other Files Lab: Copying Information to Other Office Programs 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