Assignment 1 - Address Book
Music Database for ________________________
You have decided to create a database of your music using Access.
• Save the file as music library in your database folder
• Using the information below create Music Database BUT before you start, READ THE WHOLE ASSIGNMENT to get all the needed information
Step 1 – In Design View enter the following Information (fill this out in pencil)
|Field Name |Data Type |Description |Field Size or format |
|ID | | | |
|Song | | | |
|Artist | | | |
|Album | | | |
|Genre | | | |
|Length (in seconds) | | | |
|Year Released | | | |
• Primary key = ID (use an autonumbered Access field)
• Close and save the table as music.
Step 2 – Create Records
Enter 20 songs of your choosing into your music library. Record the actual information for your songs. You must include:
• At least three different genres
• At least three different release years
• At least five different artists
• The song length in seconds. To calculate the song length in seconds, multiply the number of minutes x 60 then add the number of seconds. For example, a song that is 3:40 in length, would be (3 x 60 + 40) 220 seconds long.
Step 3 – Selecting a Genre
Create a Genre selection box in design view of your table so that only the following Genres can be chosen when someone enters a record into the table.
Step 4 – Creating and Using a form
• Create a FORM to enter the data. Customize the form with a title: My Music Collection
• Change the background colour of the form to Blue.
• Add an appropriate picture to the form.
• Make the font size of the title larger and bold so that it stands out.
• Enter the following information:
|Song |Artist |Album |Genre |Length |Year Released |
|God Gave Me You |Blake Shelton |Red River Blue |Country |3:49 |2011 |
|Livin’ on a Prayer |Bon Jovi |Cross Road |Rock |4:11 |1994 |
|Clocks |Coldplay |A Rush of Blood to the Head |Alternative |5:06 |2002 |
|Someday |Nickelback |The Long Road |Pop |3:27 |2003 |
|Save Me, San Francisco |Train |Save Me, San Francisco |Pop |4:09 |2009 |
Step 5 – Query the database
• Create a new query to find only the songs that are 4:30 and longer. Save your query as Length.
• Create a query to find only the POP songs that were released in 2005 or later. Save your query as 2005 POP
• Print each query result. Make sure your name is on the page.
Step 6 – Report on the database
• Create and print an attractive report based on the music table. Include all field names.
• Group the report by Genre and Sort in ascending order by Artist.
• Choose a stepped layout and landscape orientation
• Name the report Your Name’s Music
• Add an appropriate picture in the header
• Add a line at the bottom that shows the Total Seconds and shows the sum of all the song lengths in your library.
• Add a line under Total Seconds that shows Total Minutes and converts the total seconds of your library into minutes with one decimal.
• Preview to ensure it fits on one page. Your name must be in the report title before you print.
|Summative Application Rubric |
|Database plan filled out on paper, showing ALL fields in database |
|Fields created correctly (type, size) in Access |
|( Form created with customized title |
|( Form background changed to Blue |
|( Form title font enlarged and bolded; appropriate picture included |
|Accurate data entry |
|25 records included (Student chosen records include at least 3 genres, 3 release years, 5 artists) |
|Queries created correctly |
|All songs at least 4:30 long; all POP songs after 2005 |
|( Queries printed as requested |
|Report generated correctly |
|Report printed as requested, on one page |
|Report contains no cut off information ( titles or data) |
|Report includes the total seconds for your database |
|Report shows the total number of minutes of your music library (with one decimal) |
|( Table, form, queries and report named as requested |
|All 4 most 3 some 2 few 1 R Incomplete |
-----------------------
Alternative
New Age
Hip hop
• Other
Pop
Country
Rock
Rap
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
Related searches
- free address book for windows 10
- contact management address book software
- where is address book in windows 10
- address book software
- where is my address book in outlook
- iphone address book app
- address book app windows 10
- download address book from iphone
- my personal address book for windows 10
- find my address book contacts
- my email address book in windows 10
- address book app for pc