Advanced Importing and Exporting with Access 2010

Microsoft Office Access 2010 offers several advanced options for importing and exporting data. With Access 2010 you can link to, or import data and objects from external sources, such as other Access databases, SQL Server databases, Excel spreadsheets, Microsoft Word files, and XML files. You can also export data and objects from an Access 2010 database to a variety of external sources. This course explains and demonstrates the various methods of importing, exporting, and linking to external data sources in Access 2010.

Learning Objectives

• Import data from one Access database into another Access database
• Import data from SQL Server into an Access database
• Link an Access database to data in SQL Server
• Export data from an Access database to a Word document
• Export data from an Access database to an Excel spreadsheet
• Export data from an Access database to an XML document
• Collect data by using e-mail messages
• Import Outlook 2010 contacts to a new Access 2010 table
• Import data in Access
• Export data from Access to other applications
• Use e-mail messages to collect data in Access
• Import an Outlook 2010 folder to a new Access 2010 table