Advanced Computer Applications Final Exam

General Instructions: Create a folder in your docs folder. Call the folder,
Final (lastname) Put all your files there.

PART 1 Data Base

Create a data base table that has the following characteristics. (Name the database -TeeShirts.)

Your are selling tee shirts. You have 5 types of shirts .

1. Black Dog Gray = 9.98 2. Black Dog Tan =10.98 3. Black Dog Blue =10.98 4. MVRHS =10.98 5. Lighthouses = 5.98

Use the database to create an invoice
The invoice should allow the customer to order as many of each type of shirt as they wish.
The invoice should subtotal each item , total the entire order, compute MA sales tax and calculate a grand total.

Create a second data base table that has list of all your customers.
list of customers (5) that is related to the invoice (make up the customers)

DEMO ---------------------------------------------------------------------------------------------------------

PART 2 Web Sites Students are to create a web site about the Cassini-Huygens spacecraft. The web site should feature text+graphics and use all the techniques used in class -- client side maps (hotspots like the cell web site) grids -background pictures and so on min 6 pages.  Most info can be found at :http://saturn.jpl.nasa.gov/home/index.cfm Minumum 6 pages