Cindi asks you to enhance the Vendor database with forms and reports. Complete the following steps:
1. Open the Vendor database you created and worked with in Tutorials 1 through 3, and then click the Enable Content button next to the security warning, if necessary. 2. Use the Form Wizard to create a form based on the Product table. Select all fields for the form and the Columnar layout; specify the title ProductData for the form. 3. Apply the Facet theme to the ProductData form only. 4. Insert the Supplies picture, which is located in the Access1 Review folder provided with your Data Files, in the ProductData form. Remove the picture from the control layout, and then move the picture to the right of the form title. 5. Drag a bottom corner of the image to increase its size until the items in the picture are all clearly visible. Continue to resize and reposition the image until it is in the location you want, making sure to keep it within the shaded area of the title and to the right of the title. 6. Edit the form title so that it appears as “Product Data” (two words), and change the font color of the form title to the Blue-Gray, Text 2, Darker 25% theme color. 7. Resize the Weight in Lbs field value box so it is the same width (approximately) as the Units/Case field value box above it. 8. Change the alignment of the Price, Units/Case, and Weight in Lbs fields so that their values appear left-aligned in the field value boxes. 9. Save your changes to the form design. 10. Use the ProductData form to update the Product table as follows:
a. Use the Find command to search for the word “test” anywhere in the ProductName field, and then display the record for the mononucleosis test (ProductID MO269). Change the Price in this record to 49.50. b. Add a new record with the following field values: Product ID: EG400 Supplier ID: SAN481 Product Name: Non-Latex exam gloves Price: 4.75 Units/Case: 80 Weight in Lbs: 2 Temp Controlled?: no Sterile?: no c. Save and close the form.
11. Use the Form Wizard to create a form containing a main form and a subform. Select all fields from the Supplier table for the main form, and select ProductID, ProductName, Price, TempControl, and Sterile—in that order—from the Product table for the subform. Use the Datasheet layout. Specify the title SuppliersAndProducts for the main form and ProductSubform for the subform.
12. Change the form title text to Suppliers and Products. 13. Resize the subform to the right, increasing its width by approximately three inches, and then resize all columns in the subform to their best fit, working left to right. Navigate through each record in the main form to make sure all the field values in the subform are completely displayed, resizing subform columns and the subform itself, as necessary. Save and close the SuppliersAndProducts form. 14. Use the Report Wizard to create a report based on the primary Supplier table and the related Product table. Select the SupplierID, Company, City, Category, ContactFirst, ContactLast, and Phone fields—in that order—from the Supplier table, and the ProductID, ProductName, Price, and Units fields from the Product table. Do not specify any additional grouping levels, and sort the detail records in ascending order by ProductID. Choose the Outline layout and Portrait orientation. Specify the title ProductsBySupplier for the report. 15. Change the report title text to Products by Supplier. 16. Apply the Facet theme to the ProductsBySupplier report only. 17. Resize and reposition the following objects in the report in Layout view, and then scroll through the report to make sure all field labels and field values are fully displayed:
a. Resize the report title so that the text of the title, Products by Supplier, is fully displayed. b. Move the ProductName label and field value box to the right a bit (be sure not to move them too far so that the longest product name will still be completely visible). c. Resize the Product ID field label on its right side, increasing its width slightly so the label is fully displayed. d. Move the Units/Case label and field value box to the right a bit; then resize the label on its left side, increasing its width slightly so the label is fully displayed. e. Select the field value boxes only (not the field labels) for the following four fields: SupplierID, Company, City, and Category. Then move the four field value boxes to the left until their left edges align (roughly) with the “S” in “Supplier” in the report title. f. Resize the Company field value box on its right side, increasing its width slightly so that all company names are fully displayed.
18. Change the color of the report title text to the Blue-Gray, Text 2, Darker 25% theme color. 19. Insert the Supplies picture, which is located in the Access1 Review folder provided with your Data Files, in the report. Move the picture to the right of the report title. Drag a bottom corner of the image to increase its size until the items in the picture are all clearly visible. Continue to resize and reposition the image until it is in the location you want, making sure to keep it within the shaded area of the title and to the right of the title. 20. Apply conditional formatting so that the Category field values equal to Service appear as dark red and bold. 21. Preview each page of the report, verifying that all the fields fit on the page. If necessary, return to Layout view and make changes so the report prints within the margins of the page and so that all field names and values are completely displayed. 22. Save the report, print its first page (only if asked by your instructor to do so), and then close the report. 23. Compact and repair the Vendor database, and then close it.
