1 / 19

Access

Access. Chapter 8- Integrating Access with the Internet and other Programs. Access Internet Reporting. Static HTML by exporting files Server generated HTML files, ASP Dynamic HTML, Data Access Pages XML files- to describe and transfer data using Internet technology. Static HTML Files.

lcharles
Download Presentation

Access

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Access Chapter 8- Integrating Access with the Internet and other Programs

  2. Access Internet Reporting • Static HTML by exporting files • Server generated HTML files, ASP • Dynamic HTML, Data Access Pages • XML files- to describe and transfer data using Internet technology PgP MIS 342 Access

  3. Static HTML Files • file.html • Export tables, queries, forms or reports • Use with a HTML version 3.2 or later browser • HTML templates • Search Help>Answer Wizard for • ‘About the types of Web pages Access creates’ PgP MIS 342 Access

  4. Data Access Pages • Can no longer create, modify in Access 2007 • Multi-purpose but Microsoft centric • Data viewable in some web browsers • Data updateable in Microsoft browsers • Must use Internet Explorer 5 and up (limited use) • Data analysis- • Pivot tables • Charts PgP MIS 342 Access

  5. Active Server Pages (ASP) • Microsoft dependent server technology • But not Microsoft browser dependent! • Combine with VBScript or JavaScript to create interactive web sites • Also ASP.NET PgP MIS 342 Access

  6. Importing HTML • Access can Import tables or lists • Tables <TABLE> </TABLE> • Unordered lists <UL> </UL> • Definition lists <DL> </DL> • Look at Source Code Tags! PgP MIS 342 Access

  7. Tables- Hyperlink Fields • Access can store hyperlinks in tables • Hyperlink to other applications • Hyperlink to the Internet PgP MIS 342 Access

  8. Tables- Hyperlink Fields • Hyperlink Properties • A hyperlink address can have up to four parts • separated by the number sign (#): • displaytext#address#subaddress#screentip • Sample Default Value Field Property: • "CNN#www.cnn.com##Go To CNN" PgP MIS 342 Access

  9. Tables- Hyperlink Fields • Hyperlink Properties • displaytext  — the text that appears in a field or control. • address — the path to a file (UNC path) or page (URL). • subaddress — a location within the file or page. • screentip — the text displayed as a tooltip. PgP MIS 342 Access

  10. Displaying .XML using .XSL • An .xml file can be formatted and displayed like an .html file in a browser if an .xsl file is applied PgP MIS 342 Access

  11. .xml file refers to .xsl file <?xml version="1.0" encoding="UTF-8"?> <?xml-stylesheet type="text/xsl" href="note.xsl"?> <note> <record> <to>Pat</to> <from>Joe</from> <heading>Help</heading> <body>I am lost</body> </record> …. </note> PgP MIS 342 Access

  12. .xsl file contains format instructions <?xml version="1.0" encoding="ISO-8859-1"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <html> <body> <h2>Notes</h2> <table border="1"> <tr bgcolor="#9acd32"> <th align="left">To:</th> <th align="left">From:</th> <th align="left">Heading</th> <th align="left">Body</th> </tr> <xsl:for-each select="note/record"> <tr> <td><xsl:value-of select="to"/></td> <td><xsl:value-of select="from"/></td> <td><xsl:value-of select="heading"/></td> <td><xsl:value-of select="body"/></td> </tr> </xsl:for-each> </table> </body> </html> </xsl:template> </xsl:stylesheet> PgP MIS 342 Access

  13. Important XML Info • .xsl and .xml files must be in same folder • .xml tags are case sensitive • XML is a language, but requires implementation and adoption of standards to become useful • Competitor to EDI • Increasingly important data handling method PgP MIS 342 Access

  14. Program Integration • Access is designed to handle large amounts of data, and convert data to information • Excel is designed to analyze numbers • Word is used to write documents • Graph is used to create charts • Use each for what each is best at PgP MIS 342 Access

  15. Program Integration Methods PgP MIS 342 Access

  16. Program Integration Methods • Import-creates standalone copy of file or object • Embed-creates copy of file or object that is still editable by source program • Link- create link to file or object, still editable by source program PgP MIS 342 Access

  17. Program Integration Considerations • Will I need to edit the file or object? • Is the file or object so large that it is not a good idea to make multiple copies? • Will a network connection to the file or object always be available? • Do I need just one copy of the file or object, and is it shared by many users? PgP MIS 342 Access

  18. Word Integration • Access objects can be placed in Word • Word objects can be placed in Access • Tables, Queries, Forms, Reports can be Published to Word PgP MIS 342 Access

  19. Excel Integration • Create queries to extract numerical information • Then export query results to Excel for analysis • Excel has better chart options, pivot tables and many special functions-statistical, financial… PgP MIS 342 Access

More Related