Importing and Exporting Data and Data Presentation in Access 2007

When you register for training with TrainUp.com, you are also supporting local education. Find out how.

Course 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.

Learning Objectives

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

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.

Duration

119 minutes

Course Price

$74.95

This course is also included in the Following Elearning Collection(s):

view more collections

Looking to Enroll a Group?

Instant Access
From Anywhere
Unlimited
Viewing
6-12 Months
To Complete

Join The 50,000+ Companies That Have Purchased Training from TrainUp.com

50K+ Companies Trained
Including 90% Of Fortune 500 Companies Have Purchased Training With TrainUp.com
300K+ Courses & Videos
Live Instructor-Led (Classroom & Virtual), Self-Paced E-learning & Custom OnSite Training Solutions From Leading Training Providers
800+ Expert Instructors
Industry-Leading Subject Matter Experts (SMEs).Tenured &
Award-Winning Instructor Network

Online Course

Importing and Exporting Data and Data Presentation in Access 2007

Join The 50,000+ Companies That Have Purchased Training from TrainUp.com

Details about this course, including summary information, upcoming dates, and a link to this page, will be sent to the recipient specified below.

Send course information to the email address below:

Need to request approval from a manager at your organization? Add their email address below:

Bring Any training to your facility or train your team members remotely with a customized virtual course. Fill out the form to get started and a solutions rep will be in touch shortly!

Our on-site team responds to every request the same day!