Tutorial 8 : Sharing, Integrating, and Analyzing Data
In this tutorial you will learn how to import, export, link, and embed data. You will also be introduced to the charting, PivotTable, and PivotChart features of Access. You will see that exporting data as HTML or XML files allow you to view data from your database via an internet browser which can provide visibility to users who do not have access to the actual database. Sometimes you may have existing data that you need to include in your database, instead of entering all of the data manually you can import the data to reduce entry errors and decrease time. This data can be imported from an Excel spreadsheet, a CSV (comma separated value) file, or text file directly into an existing Access table, or a new one. When importing data you want to make sure you reduce redundancy, and the Table Analyzer can help you do just that. The table analyzer splits a single table into two or more tables if it finds redundant data. This process is called normalization, and the table analyzer ensures that your tables are in 3NF (third normal form - see the additional resources for information about 3NF).
|
By the end of this tutorial you will know how to:
|
The below resources are provided as additional information that will help you understand the concepts introduced by the textbook.
Textbook pg. ACA15-ACA21
|
The presentation above reiterates the key points from the Tutorial. It is great to use while going through the chapter as a notes road-map, however, just reading through the presentation will not be enough to understand the concepts provided in the textbook, you must work through the entire tutorial project. |