MIS 204 Lesson 10 Hands-On Activity | Complete Solution

In this assignment you will learn how to create forms and reports to access and analyze your data.  Forms are useful for data entry and navigation.  Reports allow you to connect data and create information and then distribute that information as a document.

Step 1: Open Your Lesson 8 HOA Database

Open the database file you created for Hands-On Activity 8.  Then, click File à Save As and give the file a new name using the format of lastname + first initial +HO10 (e.g., bunnybHO10.accdb).

Step 2: Modify the BOOKS table.

1. Open the BOOKS table in design view.
2. Add PRICE as a field after the GENRE field.
3. The data type should be Currency.
4. Save the BOOKS table.
5. Switch to the Datasheet view.  You will now have a PRICE column that is empty.  You need to populate it with price data, which is listed in the table below.  You do not need to enter dollar signs!

When done your BOOKS table should look like this:

6. Close your BOOKS table                                                                                       Step 3: Create a Data Entry for Adding New Books to the Inventory
7. Click on the Create tab.
8. Click on Form Wizard.
9. Make sure the BOOKS table is selected and add all fields to the Selected Fields box.
10. Click Next.
11. When it asks “what layout would you like for your form?” just leave “Columnar” selected
12. Click Next.
13. Change the form title to BOOK ENTRY FORM.
14.  

Click Finish.

 Your form should look like this:

If you look at the bottom of your form you will see a navigation bar that displays what record you are viewing, if any filter is applied, and a search field.You can use this bar to navigate through the existing records in the table, search for a record, and add a new record.You can even change the data in the table!
 

9. Navigate to the record for A Dance with Dragons and change the price to $19.99 and press ENTER.
10. Close your form.
11. Open your BOOKS table.  You will see that the price has been updated!                           Step 4: Create an Inventory Report
12. Click on the Create tab.
13. Click on Report Wizard.
14. Make sure the BOOKS table is selected and add the following fields:  GENRE, AUTHORLAST, AUTHORFIRST, TITLE, and ISBN.  It MATTERS what order you move these fields to the selected fields box.
15. Click Next.
16. Select and move GENRE when report wizard asks you if you want to add any grouping levels; you should see GENRE text in blue above the report template.
17. Click Next.
18. Select AUTHORLAST as your first level of sorting.  Select Ascending
19. Click Next.
20. Change the orientation to Landscape.  Leave Layout as Stepped.
21. Click Next.
22. Change the title to BOOKS INVENTORY REPORT.
23. Click Finish. Your report should look like this:

13. Close Print Preview by clicking on the red ‘X’ on the ribbon.  You will now be in design view.
14. 14. Save your form.                                                                                              Step 5: Improve the appearance of the inventory report.
15. Within In the Design View for the BOOKS INVENTORY REPORT, click once on AUTHORLAST field within the PAGE HEADER section to select this field.  The first click will select this field.  Then click on it again, this should select the text in the field and allow you to change the text.  Change it to Last Name.
    
    Remaining in the Page Header section, make the following changes to these other fields:
    1. GENRE to Genre.
    2.  AUTHORFIRST to First Name.
    3.  

TITLE to Title

2. Remaining in the Page Header section select each field individually by double clicking on each field.
   
   When the Property Sheet window on the right opens up for each field, change the Font Weight from Normal to bold AND change the Font Color to Text Black from Text 1, Lighter 50%.  Close the Property Sheet.
    
3. Double click anywhere in the GENRE Header area (but not on the GENRE field itself).
   
   In the Property Sheet change the Back Color from Background 1 to Text 2, Lighter 80%. To do this, you have to choose “Text Description” in the drop down menu of the Back Color property.  Once you have chosen Text Description, you can over---write Text Description with Text 2, Dark Blue, Lighter 80%.
   
   Change Alternate Back Color to Text 2, Lighter 80% as well.  Close the Property Sheet.
    
4. Double Click on the GENRE field in the GENRE Header area.
   
   In the Property Sheet, Change the Back Color to Text 2, Lighter 80%. Change the Font Size to 14. Close the Property Sheet.
    
5.  

 Click on the field GENRE and then move the mouse cursor over the right border of the field in the GENRE Header section until the cursor changes to a line.  Click and drag the border until it reaches the third vertical line from the left.

Figure 5 - The GENRE Field Resized

Move the mouse until the cursor hovers over the top edge of the Detail bar.The cursor should change to a horizontal bar bisected by a vertical line.Click and drag the bar down until the GENRE Header area is roughly twice as tall.
 

Make the GENRE field in the GENRE Header area three rows of dots larger by repeating the process above, only this time on the bottom border.

Figure 6 - The GENRE Field Resized to be Taller

6. Double click anywhere in the Detail area, but not on any of the fields.
   
   In the Property Sheet, change the Alternate Back Color in the Property Sheet to Background 1.  Close the Property Sheet
7.  

Save your report and then switch to Report View. Your report should look similar to this:

Figure 7 - The Formatted BOOKS INVENTORY REPORT

Step 5: Submit Your Assignment

You have now completed your assignment.  Upload your ACCESS database to the Lesson 10 Hands-On Activity Drop Box. Your assignment will be graded using the following rubric: