Microsoft Office XP Microsoft Office XP Illustrated Introductory, EnhancedIllustrated Introductory, Enhanced

Office Applications with Internet Office Applications with Internet ExplorerExplorer

IntegratingIntegrating

2Integrating Office Applications with Internet Explorer Unit D

Plan a Web publicationPlan a Web publication Create a Web pageCreate a Web page Format a Web pageFormat a Web page Create a Web page from a Word Create a Web page from a Word

documentdocument Create a Web page from an Access Create a Web page from an Access

tabletable

ObjectivesObjectives

3Integrating Office Applications with Internet Explorer Unit D

Create a Web page from an Excel Create a Web page from an Excel workbookworkbook

Create a Web page from a Create a Web page from a PowerPoint presentationPowerPoint presentation

Add hyperlinksAdd hyperlinks

ObjectivesObjectives

4Integrating Office Applications with Internet Explorer Unit D

Unit IntroductionUnit Introduction

A A Web pageWeb page is a file that can be stored on is a file that can be stored on a special computer called a a special computer called a Web serverWeb server..– Web pages can be viewed on the World wide Web pages can be viewed on the World wide

Web or an intranet using a browserWeb or an intranet using a browser– Web pages use Web pages use Hypertext Markup Language Hypertext Markup Language

(HTML)(HTML) formatting formatting• HTML is the programming language used to HTML is the programming language used to

describe how each element of a Web page should describe how each element of a Web page should appear when viewed by a browserappear when viewed by a browser

– Web pages are posted, or Web pages are posted, or publishedpublished, on a , on a Web site or intranetWeb site or intranet

5Integrating Office Applications with Internet Explorer Unit D

Planning a Web PublicationPlanning a Web Publication

A A Web publicationWeb publication is a group of is a group of associated Web pages focused on a associated Web pages focused on a particular theme or topic.particular theme or topic.

To help you create a Web page:To help you create a Web page:– Sketch each Web pageSketch each Web page– Create each Web pageCreate each Web page– Format each Web pageFormat each Web page– View each Web page using a browserView each Web page using a browser– Format hyperlinksFormat hyperlinks

6Integrating Office Applications with Internet Explorer Unit D

Planning a Web Planning a Web Publication (cont.)Publication (cont.)

Sample Web publication sketch

7Integrating Office Applications with Internet Explorer Unit D

Planning a Web Planning a Web Publication (cont.)Publication (cont.)

Naming Web Pages.Naming Web Pages.– Filenaming conventions and folder Filenaming conventions and folder

structure are important when planning a structure are important when planning a Web publicationWeb publication

– Different operating systems place Different operating systems place different restrictions on filenamesdifferent restrictions on filenames

• It is safest to use the standard eight-dot-It is safest to use the standard eight-dot-three naming convention (mypage.htm)three naming convention (mypage.htm)

8Integrating Office Applications with Internet Explorer Unit D

Creating a Web PageCreating a Web Page

To create a Web page, you must To create a Web page, you must create a document that use HTML create a document that use HTML formatting.formatting.– HTML places codes, called HTML places codes, called tagstags, ,

around the elements of a Web pagearound the elements of a Web page– Word automatically inserts HTML tagsWord automatically inserts HTML tags– Word includes many Web templatesWord includes many Web templates

• Word has themes that are predesigned Word has themes that are predesigned formats that give Web pages a consistent formats that give Web pages a consistent looklook

9Integrating Office Applications with Internet Explorer Unit D

Creating a Web Page (cont.)Creating a Web Page (cont.)

Willow theme applied

Inserted heading

10Integrating Office Applications with Internet Explorer Unit D

Creating a Web Page (cont.)Creating a Web Page (cont.)

Choosing Web page content and Choosing Web page content and style.style.– A well designed Web page A well designed Web page

communicates a visual message that communicates a visual message that complements the purpose of the Web complements the purpose of the Web publicationpublication

– The design of a Web publication The design of a Web publication expresses the personality and expresses the personality and character of your institution or character of your institution or organizationorganization

11Integrating Office Applications with Internet Explorer Unit D

Formatting a Web pageFormatting a Web page

Use the same formatting tools in Use the same formatting tools in Word that you use to format a Word that you use to format a document.document.– Word automatically insert tags to Word automatically insert tags to

formatting so a Web browser can formatting so a Web browser can interpret the formatting and display it interpret the formatting and display it properlyproperly

12Integrating Office Applications with Internet Explorer Unit D

Formatting a Web page (cont.)Formatting a Web page (cont.)

Bold heading

Formatted bullet

characters

Inserted logo

13Integrating Office Applications with Internet Explorer Unit D

Creating a Web Page Creating a Web Page from a Word Documentfrom a Word Document

By saving an existing Word file in By saving an existing Word file in HTML format, you can create a Web HTML format, you can create a Web page from the document.page from the document.– Click Save as Web Page on the File Click Save as Web Page on the File

menumenu

14Integrating Office Applications with Internet Explorer Unit D

Creating a Web Page Creating a Web Page from a Word Document (cont.)from a Word Document (cont.)

Word file saved in HTML format

15Integrating Office Applications with Internet Explorer Unit D

Creating a Web Page Creating a Web Page from an Access Tablefrom an Access Table

Create static HTML documents from Create static HTML documents from Access tables, forms, queries, and Access tables, forms, queries, and reports.reports.– A static HTML document reflects the A static HTML document reflects the

data at the time the document was data at the time the document was savedsaved

– Subsequent updates to the data are not Subsequent updates to the data are not reflected in the HTML documentreflected in the HTML document

16Integrating Office Applications with Internet Explorer Unit D

Creating a Web Page Creating a Web Page from an Access Table (cont.)from an Access Table (cont.)

Table from Access

database

17Integrating Office Applications with Internet Explorer Unit D

Creating a Web Page Creating a Web Page from an Access Table (cont.)from an Access Table (cont.)

Using Access to create static and Using Access to create static and dynamic Web pages.dynamic Web pages.– Access objects can be either static or Access objects can be either static or

dynamic Web pagesdynamic Web pages– A Data Access page is dynamically A Data Access page is dynamically

linked to the database file so that linked to the database file so that changes are reflected in the Web pagechanges are reflected in the Web page

18Integrating Office Applications with Internet Explorer Unit D

Creating a Web Page Creating a Web Page from an Excel Workbookfrom an Excel Workbook

Excel lets you specify worksheet Excel lets you specify worksheet ranges to use as sources for Web ranges to use as sources for Web pages.pages.

Excel data formatted in

Word

19Integrating Office Applications with Internet Explorer Unit D

Creating a Web Page from Creating a Web Page from a PowerPoint Presentationa PowerPoint Presentation

PowerPoint presentations contain PowerPoint presentations contain multiple screens of information, multiple screens of information, called slides.called slides.– When a presentation is converted to When a presentation is converted to

HTML format, a Web page is created HTML format, a Web page is created for each slidefor each slide

– You can navigate through an HTML You can navigate through an HTML presentation when viewed with a presentation when viewed with a browserbrowser

20Integrating Office Applications with Internet Explorer Unit D

Creating a Web Page from a Creating a Web Page from a PowerPoint Presentation (cont.)PowerPoint Presentation (cont.)

Slide titles

Main frame

Left frame

21Integrating Office Applications with Internet Explorer Unit D

Creating a Web Page from a Creating a Web Page from a PowerPoint Presentation (cont.)PowerPoint Presentation (cont.)

Using Frames.Using Frames.– Frames help you navigate through Frames help you navigate through

associated Web pagesassociated Web pages– Frames are helpful when you want Frames are helpful when you want

common navigation elements for all of common navigation elements for all of the Web pages in a publicationthe Web pages in a publication

• Some older Web browsers may not Some older Web browsers may not support framessupport frames

22Integrating Office Applications with Internet Explorer Unit D

Adding HyperlinksAdding Hyperlinks

After you create the Web pages for After you create the Web pages for your publication, you need to add your publication, you need to add hyperlinks.hyperlinks.– Hyperlinks link pages within a Hyperlinks link pages within a

publication and other Web pages in publication and other Web pages in other publicationsother publications

– A A relative linkrelative link gives another page’s gives another page’s address in relation to the current pageaddress in relation to the current page

23Integrating Office Applications with Internet Explorer Unit D

Adding Hyperlinks (cont.)Adding Hyperlinks (cont.)

ScreenTip appears when you point to

hyperlink

Hyperlink

24Integrating Office Applications with Internet Explorer Unit D

Adding Hyperlinks (cont.)Adding Hyperlinks (cont.)

Publishing your Web pages.Publishing your Web pages.– Your Web publication is not available to Your Web publication is not available to

anyone outside your local computer anyone outside your local computer network until you publish itnetwork until you publish it

• Placed on the Web or on an intranet Placed on the Web or on an intranet serverserver