Importing and Exporting Data and Data Presentation in Access 2007

Course details

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.

• 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