CGS 2542

1
CGS 2542

• Tutorial 8
• Databases and the Web

2
Internet vs the Web

• Whats the difference?
• Internet - worldwide connection of computers and
  computer networks
• Includes the hardware, software and protocols to
  make it work
• Web - worldwide collection of digital documents
  available on the Internet

Discussion
3
Relevance?

• Retail sales
• Business-to-business
• EDI
• Databases
• Interactive forms
• Electronic Commerce

4
Microsoft Web Components

• Must have Web Components installed
• There is a Pivot Table/Chart Component
• Must have a Browser to see the Web pages

5
The main difference between XML and HTML
XML is not a replacement for HTML. XML and
HTML were designed with different goals XML was
designed to describe data and to focus on what
data is. HTML was designed to display data and
to focus on how data looks. HTML is about
displaying information, XML is about describing
information.
6
XML vs HTML

• Whats the difference ?

XML User Defined Tags Data Driven Strict Tag
Adherence HTML Predefined Tags Presentation
Driven Loose Tag Adherence
7
Exporting

• To HTML

8
Exporting

• To XML

9
Importing XML to Access
10
Data Access Pages

• Static
• Dynamic

Static Page
11
Data Access Page
Dynamic Page
12
Web Page PreviewPage AC 379
13
Pivot Tables
Used for Analysis
14
Pivot Table Tools
Field List
Field List
Pivot Chart
Pivot Table
15
Pivot Charts
16
Design View
Must use this Field List
Widen so you can see the toolbar
17
Exporting to Excel

• Office Links

Use this tool
18
Query Results in Excel
AutoSum
19
Hyperlink fields
20
Level II Test Overview

• Lookup Wizard Field
• Matching-Nonmatching search
• Comparison Operators
• Logical Operators
• Calculated Fields
• Custom Report
• Data Access Page
• Pivot Chart

21
Review for Level II Test

• Use Level I Test database as the starting point
• Create a test folder on your memory stick.
• Create a Lookup Wizard field
• Create advanced queries using matching,
  nonmatching and logical operator values

22
Review for Level II Test

• Create advanced queries using calculated fields
• Create a custom report with calculated totals for
  certain fields
• Know how to format a report in design view
• Know how to use the Sorting and Grouping button

23
Review for Level II Test

• Add Header and Footer sections to a report
• Change properties for a text or label box
• Create a data access page using the Page Wizard
• Create a Pivot Chart

24
Review Calculated Fields

• AveRevenueCapacity85
• Sum(AveRevenue)
• Result would be Total Average Revenue
• PotentialRevenueCapacity1.0585
• Sum(PotentialRevenue)
• Result would be Total Potential Revenue

25
Lets Do Tutorial 8

• Final Project Table Relationships
• are due March 29