Microsoft Office Tutorials and References
In Depth Information
Tutorial 8
Objectives
Sharing, Integrating,
and Analyzing Data
Importing, Exporting, Linking, and Analyzing
Data in the Panorama Database
Session 8.1
• Export an Access table
to an HTML document
and view the
document
• Import a CSV file as an
Access table
• Use the Table Analyzer
• Import and export
XML files
• Save and run
import and export
specifications
Case | Belmont Landscapes
Session 8.2
• Create a multi-page
form using a
tab control
• Embed a chart in
a form
• Create and modify
PivotTables and
PivotCharts
• Link data from an
Excel worksheet
Oren Belmont, Sarah Fisher, and Taylor Sico are pleased with the design and
contents of the Panorama database. Oren feels that other employees would ben-
efit from gaining access to the Panorama database and by sharing data among
the different programs employees use. Oren and Sarah would also like to be
able to analyze the data in the database.
In this tutorial, you will show Oren and Sarah how to import, export, link, and
embed data. You will also introduce them to the charting, PivotTable, and Pivot-
Chart features of Access.
Starting Data Files
Case1
Case2
BelmLogo.gif
Ads.xlsx
Contract.accdb (cont.)
CreditCard.xml
BelmTemp.htm
BelmLogo.gif
Instrument.csv
ParkLogo.gif
Panorama.accdb (cont.) BelmTemp.htm
Room.xlsx
ParkTemp.htm
Products.xlsx
Payables.csv
Schedule.xlsx
tblCustomerBilling.csv
Products.accdb (cont.)
Training.accdb (cont.)
tblProspect.xml
tblPayments.xml
Case3
Case4
Case5
Agency.accdb (cont.)
Personnel.xlsx
ACE.accdb (cont.)
Facility.csv
Vacation.accdb (cont.)
Works.xml
Search JabSto ::




Custom Search