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
Lesson Objectives
Import Data into Access 2007
- import data into an Access 2007 database
- distinguish between the options available for importing data into Access 2007
Export Data from Access 2007
- export Access 2007 data
- distinguish between the formats you can export to from Access 2007
Collect Data Using E-mail Messages
- set up data collection in Access 2007
- collect data by using e-mail messages
Importing and Exporting Data in Access 2007
Create and modify a PivotTable in Access 2007
- build an Access 2007 PivotTable
- modify a PivotTable in Access 2007
Create and Modify a PivotChart in Access 2007
- build a PivotChart in Access 2007
- modify an Access 2007 PivotChart
Creating PivotTables and PivotCharts in Access 2007
|
Key Concepts:
|
|
Desktop Certifications, Microsoft, Microsoft Certified Application Specialist Certification, 77-605 Using Microsoft Office Access 2007, Desktop Curricula, Microsoft Office 2007, Microsoft Office 2007: Advanced Access
|
|
|
Course Appears in these Categories:
|
• Desktop Certifications >> Microsoft >> Microsoft Certified Application Specialist Certification
• Desktop Skills >> Microsoft Office 2007 >> Microsoft Access 2007: Advanced
• Continuing Professional Education >> National Association of State Boards of Accountancy (NASBA)
|
|
|
Courses you might be interested in:
|
• Programmability and Administration in Access 2007
• Database Administration in Access 2007
• Importing and Exporting Data and Data Presentation in Access 2007
• Advanced Data Management in Access 2007
• Advanced Formatting in Excel 2007
• Advanced Data Management in Excel 2007
• Advanced Customization in Excel 2007
• Customizing Outlook 2007 and Using the Journal
• Configuring Rules, Alerts, and Junk E-mail Settings in Outlook 2007
• Working with SharePoint, Calendars, and Forms in Outlook 2007
• Creating Custom Slide Shows in PowerPoint 2007
|