CIS 101 FINAL EXAM part 1
This part of the exam is to do at home. Part 2 will be some multiple choice questions which you will complete when you hand this in.
DUE: Monday Dec. 9th, 4:PM
Turn in a disk (3.5 floppy or CD-R/RW, your choice)
____________________________________________________________
1. Make a database of your favorite music CD's called favoritemusic.mdb
The fields: Artist, Title, Favorite song on CD, type of music (genre), year the title was released/copyrighted, ID (primary key of type autonumber).
Populate the database with at least 20 records. The release year information should be on the CD itself, if not you can look it up at www.Amazon.com .
Perform the following four queries and save them.
Q1. All artists and titles that are under the genre : rock
Q2. All CD's released before the year 2000 (include all fields in your query)
Q3. All CD's released after the year 1993 (include all fields in your query)
Q4. All CD titles starting with the letter "S"
2. Make a spreadsheet of the same information that's in your database. Insert a column for "Current Retail Value" - call it favoritemusic.xls
Get current retail values from the Internet (from any online music store) and enter them into the spreadsheet.
Make one cell compute the total dollar value of the CD's. Color it BLACK with WHITE text. In the cell to the left of it, insert the word "Total" - boldface the word "Total."
Make another cell compute the average dollar value of the CD's. Color it YELLOW with BLACK text. In the cell to the left of it, insert the word "AVERAGE" - boldface the word "AVERAGE
3. Make a PowerPoint presentation on your findings from the queries and financial analysis. Call it favoritemusic.ppt
It should include:
· Title slide
· 3 body slides
· 7 total (distinct/not repeated) animations
Make sure your full name and the last 4 digits of your social security # are on the disk.