Data留学生代做、代写database、Java，Python，c/c++程序语言代做

日期：2020-04-18 11:20

Access Module 4 Creating Reports and Forms

Lab 2: Presenting Data in the Museum Gift Shop Database

Problem: The local Museum operates a gift shop that sells various science-related items. The gift shop manager would

like to prepare reports and forms for the database.

Note: To complete this assignment, you will be required to use your completed lab 3-2. Before you start, be sure your

primary keys are set for the proper fields, as defined in Lab 1-2.

Instructions: Perform the following tasks:

1. Run Access and open Lab 3-2.

2. *Open the Form Design for the Item Form from lab 1-2 and MODIFY it as follows below. If you do not have this form,

use the Form Wizard to START the form, then continue in Design view with these modifications.

a. Create the form (as shown, but WITHOUT the Item Type field) using the Form Wizard. Close and save the

form as "Item Status Form".

b. IN the navigation panel, open the Design View of the form. Click on "Create" on the ribbon. Click on the

Design TAB on the ribbon, to get to the Form Design Tools.

c. Move your cursor to the top of the line labeled "form footer" NEAR the bottom of the form,until you see

the mouse pointer change to the line with arrows pointing up and down, indicating you cam change the

height of the row like you might have done in your spreadsheets. Drag downward so that the label moves

downward giving you more space below the last fields in your form.

d. In the center of the ribbon, there is a collection of icons. Find the tool that is called the "Combo box" (you

might need to use the scroll button INSIDE the tool icons in the ribbon).

e. Click the icon once then go to an open place in your form design and "draw" the combo box by holding the

left button down and dragging the mouse in a rectangular or diagonal fashion.

f. You now have an UNBOUND combo box and the Combo Box Wizard will pop up. Select the 2nd box ("I will

type the values that I want"). Click "Next".

g. Type any one of the 3 item types, move your cursor the empty box below and type another. Repeat for the

3rd type, then click Next. Click Next AGAIN to have it "Remember...".

h. Type the name "Item Type" for the label. This does NOT finish the job. You have only created a box and a

label for it. NOW you can CONNECT it to your table.

i. Right-click INSIDE the "unbound" box, then in the properties table that now appears, click on the Data tab.

In the Control Source box, click on the drop-down arrow and select "Item Type".

j. Switch your form to the Form view. You should now see the drop down arrow for your Item Status. Click it to

we can see the list. Take a SCREEN SHOT of the form, with the list showing, so we can see it (it won't appear

of you just do a normal print!!) You do NOT have to show the Design view.

k. Use the form to get to items 5923, 7934 and change the Description to have your initials at the beginning of

the description.

l. If there are fewer than 10 items on hand, the on hand value should appear in a red bold font (Hint: this is a

conditional format). Save the changes to the form, navigate to item 5923 and print the form.

Access Module 4 Creating Reports and Forms

3. *Open the Item Status Report in Layout view and create the report shown in Figure 4- 85. Group the report by Item

Type and sort by Description within Item Type. Create a formula to display the average wholesale cost. If there are 5

or fewer items on hand, the value should appear in a red bold font. Save the changes to the report. Print the report.

4. *Filter the report for all items where the number on hand is less than 10. Save the filtered report as Filtered Item

Status Report. Print the report.

Access Module 4 Creating Reports and Forms

5. Use the Report Wizard to create the Items by Vendor report shown BELOW in Figure 4-86. The report is grouped by

Vendor Name and sorted by Description within Vendor Name. Create subtotals by Vendor Name.

6. Be sure the column headings for Wholesale Price and Item Number take TWO lines instead of the one line shown.

7. Submit the revised database in the format specified by your instructor.

8. *Use the Design View to add the average wholesale price (a formula in a textbox) as the new last line of the Items by

Vendor Report. Be sure the title for that line says only “Average Price”. Print the report.

Access Module 4 Creating Reports and Forms