Course Details

Previous Page


Importing and Exporting Data and Data Presentation in Access 2007


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
Microsoft Office Access 2007 offers several options for importing and exporting data, and also provides a variety of data presentation strategies. With Access 2007 you can link to, or import data and objects from external sources such as other Access databases, Excel spreadsheets, text files, XML files, and SharePoint lists. You can also export data and objects from an Access 2007 database to external sources. This course explains and demonstrates the various methods of importing, exporting, and linking to external data sources. It also describes how to create and modify PivotTables and PivotCharts as an alternate way to organize and present database data. The options used to apply aggregate functions to a PivotTable, add a calculated field to a PivotTable, and export a PivotTable to an Excel spreadsheet are also discussed in the course.

Target Audience
Anyone wishing to become familiar with Microsoft Access 2007 at an advanced level; anyone seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; anyone seeking to obtain Microsoft Application Professional certification.

Prerequisites
The Skillsoft Microsoft Office 2007: Beginning Access learning path; familiarity with a Windows user environment

Expected Duration (hours)
2.0

Lesson Objectives

Importing and Exporting Data and Data Presentation in Access 2007

  • import data into an Access 2007 database
  • distinguish between the options available for importing data into Access 2007
  • export Access 2007 data
  • distinguish between the formats you can export to from Access 2007
  • set up data collection in Access 2007
  • collect data by using e-mail messages
  • import an object into an Access 2007 database
  • export a database object to Excel
  • collect data using e-mail messages
  • build an Access 2007 PivotTable
  • modify a PivotTable in Access 2007
  • build a PivotChart in Access 2007
  • modify an Access 2007 PivotChart
  • create a PivotTable in Access 2007
  • create a PivotChart in Access 2007
  • modify a PivotTable
  • modify a PivotChart
  • Course Number:
    mo_adax_a01_dt_enus