Introduction:
In this activity I want you to think like a disc jockey at a radio station. A disc jockey must be able to find the music he/she wants to play and do it quickly. An easy way to do this is to build a database. In this project you will build a database about music and musicians. We will use all the skill we learned in the Address book activity and we will go into more depth in building tables, queries and reports. There is much to know
Procedure:
Part 1 Create the Music database and the CD table
Top- Create the database named: last first music.mdb
- **SAVE IN YOUR THAWSPACE**
- Create the table named: last name CDs
- Match what you see below:
New skills:
Primary key
Notice the little icon next to the field "CD title" above . This indicates that the field has been given a "primary key".
A primary key does 2 things:
- Will not allow you to enter a blank record
- Will not allow repeated data
To create the primary key:
- <right click> in the gray area next to the CD title field. Then simply choose the primary key
Date/time Data Type
Notice that the datatype for the field "Date released" is Date/Time.
In the picture below you will see the drop down box and the choice for date/time
This selection forces all date/time entries to look the same!
At the bottom of the page you will see another set of options under "Field Properties"
Select "Short Date" as indicated in the image below:
Part 2 Entering Music Data
TopIn this part of the activity you will be entering the music information into the database.
Goal:
Enter at least 10 records in your database, with a minimum of 3 different artists
You need to find:
- Label (record company)
- release date
You will be searching the Internet to find the required information. Sites you may find helpful:
- http://www.cdnow.com/
- http://amazon.com
- http://www.buy.com/
- http://www.samgoody.com/
- http://www.billboard.com/
- http://vh1.com/
**I had success simply using Google and searching for:
- (for example) Beatles white album release date
Part 3 Adding Additional Data
TopGoal:
At least 50 unique CDs in your Database
This would be very time consuming finding all 50
We will be efficient and share information in class to speed this up
Directions will be giving in class... 1 important part of the process is shown in the image below
Part 4 Make These Queries
Top- Query #1: Artist, CD Title, Year Released
- Sorted by Artist in ascending order
- Query #2: Artist, CD Title, Year Released
- Sorted by Artist and Year Released in ascending order
- Query #3: Artist, CD Title, Year Released,
- Sorted by Year Released in ascending order;
- and only show records for years greater than 1998.
- Query #4: New skill- Make a Stats Query using the Query Wizard
- Choose only CD rating
- In the wizard you have the option of adding summaries
- Choose to find the Min, Max and Average of the CD rating. The picture below should help.
- Query #5: Genre, Artist, CD Title
- Sorted by Genre in ascending order
- and then sorted by artist.
Summary option for query #4
Part 5 Build reports for each query
Top- Build a report for each query from part 4
- Make sure all your reports have the same formatting and colors
- When building a professional product you need to have a consistent look and feel for each report
New Skill:
When you build the 5th report from query #5 add Grouping levels for Genre
As you walk thru the report wizard there is one question about adding a grouping level and you want to choose Genre
You can see the choice from the wizard in the image below
Assessment:
Points will be assigned in the following way: |
|
Database with correct fields and formatting |
5 points |
50 unique entries |
15 points |
5 correct queries |
15 points |
| 5 correct reports (one with grouping levels) | 15 points |
Total |
50 points |
