FINAL PREP APPLICATION GUIDE

EXCEL

Do the sales.xls exercise. Follow instructions in the spreadsheet.

Do the finance.xls exercise. Follow instructions in the spreadsheet.

WEB DESIGN

1. Use netscape composer to create a page containing the following:

• A title saying "home page".
• Some text that is the largest size and some that is not.
• A hyperlink to another site.
• A picture.

2. Upload the page and picture to your web site.

3. View your site in the browser.

POWERPOINT

1. Create a presentation that has the following slides:
1. Practice slide 1
2. Practice slide 2 title and practice slide 2 body
3. Practice slide 3
2. On the first page, Add your name after "practice slide 1".
3. On the first page, animate the "practice slide 2 title" box to fly in from the right, and the "practice slide 2 body" box to fly up from the bottom.
4. On the third page, add the text "Web search" and hyperlink it to your favorite web site.
5. On the third page, also insert clip art of a computer. (There is one in the "Science and Tech" category.)
6. Move the third page to between page 1 & 2.
7. Copy the first slide to a new last slide. Change the text from "practice slide 3" to "Good Bye".
8. Print the powerpoint presentation as a handout with 6 slides per page.
9. Save the presenation as POWERPOINT.ppt

ACCESS:

1. Create a new database with the following fields:

Field	Type	Size
Customer ID	Text	3
First Name	Text	20
Last Name	Text	20

2. Create a query listing only the first and last name, not the customer id.

3. Create a report listing the first and last name of the customers. (Use the wizard.)