|
Project #5 (20 pts) MS ACCESS - MUSICAL RECORDING INVENTORYSee Data Files at Project 5 - Data File (MS Access)
Your job is to create a database of musical recordings which includes two tables, a form, and a report. When you finish, back it up to flash drive, or email it to yourself as an attachment. 1. CREATE A NEW BLANK DATABASE. Name the database using your own name as a part of each name, such as John Smith Recordings. 2. CREATE TWO TABLES (ONLY TWO!) - Remember to reset the data type of the Primary Key in each table in design view. Name the music table with your name, followed by Music Table, such as "Smith Music Table". The other table is named with your name, such as "Smith Company Table". **Adjust the SIZES of the fields to more reasonable sizes. **Make the "Media" field display in "ALL CAPS." To do this, use "design view", and place a > (greater than sign) in the Format properties box. 3. DEFINE A RELATIONSHIP BETWEEN THE TWO TABLES - use the "Database Tools" tab. Create a Relationship Report and save it. 4. CHECK THE DATA AND DESIGN - Be sure you've entered all the data as required, and check the Design Views also. NOTE the Field Names are a part of the "Design", not part of the data. 5. CREATE A FORM - Use the Form Wizard, to create an input form for viewing and entering data into the "Music Table". Make it a columnar form, and include all fields. 6. CREATE A QUERY - Create a query to display only the Music Table records that have CD in the Media field. Display all fields. Use Query Wizard or Design View. Name it "CDS ONLY". 7. CREATE A REPORT FROM THE MUSIC TABLE - Use the Report Wizard to create a landscape, tabular report, based on the Music Table. Put your name in the name and title of the report. Make sure that all the data and field titles show up on the page. include all of the "Music Table" fields. 8. SUBMIT THIS DATABASE USING Blackboard (bb.ualr.edu) - Remember that the Pop-Up blocker must be turned off - DISABLED -in order to use Blackboard. |