Import and export files

The student learning outcomes of Unit 9 are:
1. Export an Access table to an HTML document  and view the document.
2. Import a CSV file as an Access table.
3. Use a table analyzer.
4. Import and Export XML files
5. Save and run import and export specifications.
6. Create a multi-page form using a tab control.
7. Embed a chart in a form.
8. Create and modify PivotTables abd  PivotCharts
9. Link data from an Excel worksheet.

Important Points.

1. Internet is a worldwide collection of millions of interconnected computers.
2. World Wide Web is a vast collection of digital documents available on the internet.
3. Web Page is an individual document
4. Web Server is the computer that stores web site (pages)
5. Web Client is the computer requesting a web page from a web server.
6. HTTP stands for hypertext transfer protocol.
7. HTML stands for hypertext markup language.
8. ISP stands for Internet Service Provider. An ISP is like an on ramp to the freeway. The ISP gives you access to the internet.
9. The Uniform Resource Locator(URL) identifies the address where the Web page is stored. Internet web pages begin with http:// URL.
10. A static web page shows the state of the database object at the time the page was created.
11. A dynamic Web page is updated automatically each time the page is viewed and therefore reflects the current state of the database at that time.
12. A interactive Web page is one in which the user can add records, delete records, and edit records. In access this is called a data access page.
13. CSV (comma separated values) file is a text fiel in which commas separate values. Import CSV file. Click external data, click text file button. click browse, select file, click ok.
14. Table Analyzer analyzes a single table and if necessary, splits it into two or more tables that are in third normal form.  It looks for redundant data.  Click the I would like a wizard to analyze my table after importing the data.
15. XML (Extensible markup language) is a programming language that is similar in format to html and can exchange data between programs. 
16.  To Import XML file, click External data tab on ribbon, click XML file button, click browse, select file, make sure structure and data ridio button is selected, click ok. 
17 To export table as XML file. right click table, click export, click xml file, click browse, click save when you have identified where you want to save file.
18. Import and Export steps can be save by clicking the save export step or import steps buttons.
19. Creating a Multi-page form can be done two ways: Page Break tool, or tab control tool to insert a control that a tab control.
20. In controls group click tab control button, click the mouse button where you want the control, a tab control with two pages will be place in th form.
21. When integrating information between programs the program containg the orginal object is called the source program and where you place it is called the desination program.
22. Importing includes the contents of a file in a new table or append it to an existing table.
23. Embedding preserve its connection to the sourc program which enbles the editing of the object.  Changes made in the orginal object are not reflected in the embedded object.
24. Linking you include a connection in the destination program to the orginal file maintained by the source program.  Any changes made to the orginal file using the source program are fefledcted in the linked file.
25. To embed a chart in a form. Select form, in control group on design tab click insert chart, position the pointer where you want the chart, click next, select the fields and click next, select the type of chart and click next, select the linking field and click next, enter the title and click next, click dispaly a legend, click finish. 
26. A tag <> is the basic unit of the HTML document.
27 Connection string is a string of text that specifies the disk location and the database name used to connect a page to an access database.
28. Absolute Path is the location of the database. c:\access\filename. 
29. A theme is a collection of formats that determines the appearance of the controls, sections, body and text in a data access page.
30. A PivotTable is an interactive table that lets you analyze data dynamically using a we browser.
31. PivotTable toolbar lets you perform actions such as sorting and filtering when viewing and using a pivottable.
32. The detail area, consist of the detail field and detail values.
33 The row area consist of a row field and row field items provides row groupings.
34. The column area consist of a column field and column field items provides column groupings.
35. The filter area consist of a filter field and filter field items lets you restrict which data appears.
36. When using a pivot table we are using office pivottable component is is one of the office web components.
37.
The PivotChart toolbar let you perform actions such as sorting and filtering.
38. The plot area provides a background for the data marker and gridlines.
39. A data marker is a bar, dot, segment, or other symbol that represents a single data value.
40. Data field identifies what which values the data markers represent and identifies each value displayed a a value axis label.
41. Category field identifies each value that displayed as a category axis label
42. Series field identifies the data markers subdivisions.
43. legend provides a list of the series field values and how these values are indicated on the data markers.
44. filter field lets you restrict which data appears on the chart.
45. Link to the data in an excel worksheet: click external data tab on the ribbon, click the excel button in the import group, click browse and select the workbook, click open, click link to the data source by crating a linked table, click OK, click next, click finish, click ok. 27.



Best Practice: In this chapter we will be using a template. You have probably noticed that in the right hand bottom of the screen when you open up Access 2002 the option new from template file. Under that are two hyper links. 1. General Template. 2. Template in MicroSoft.com. Templates found in the General Template are databases already set up that address specific database programming needs. Such as in inventory data base, personnel database, payroll, etc. Templates found in the Templates from MicroSoft.com contain additional database templates. The direct hyperlink the web based templates is http://officeupdate.microsoft.com/templategallery/. As you continue your work as a database developer do not reinvent the wheel. Look at the Access2002 templates that are available to use. Many of them can be used directly without any modification for projects that you may need to do. Other templates will only need slight modification to be useful to you. As a developer you will find that reusing database structures (templates) that you have built before leads to profit.

Important Points.
1. You should by this time have your tables and relationships built for your class project.
Best Practice: