Replacement China, Inc.
You are employed at Specialty Foods, Ltd., a small international gourmet foods distributor. The company has asked you to modify the database and improve the reliability of the data entry process. You decide to create a few macros and also add a menu for the common forms and reports. You will also modify the record source of one of the reports.
For the purpose of grading the project you are required to perform the following tasks:
Start Access. Open the downloaded Access database namedexploring_a10_Grader_h1.accdb. Save the database asexploring_a10_Grader_h1_LastFirst.
Open the Orders table in Datasheet view, observe the data, and then switch to Design view. Create a data macro attached to the Before Change event.
Use the SetField Action to populate the ExpectedShipDate in the table. The ExpectedShipDate will always be 10 days after the OrderDate. Save the macro. Close the macro. Save the table.
Switch to Datasheet view of the Orders table. Retype the OrderDate in the first record (Order No 10248) and press DOWN ARROW. The macro will be triggered and automatically fill in the ExpectedShipDate with a date 10 days after the OrderDate.
Repeat the test on the second and third records (10249 and 10250). Close the table.
Open the Main Menu form in Design view. Add three buttons below the Forms label that will open the three forms in the database: Enter Customers, Enter Employees, and Enter Suppliers (in that order and to show all records). Set the first one at the 2" mark on the vertical ruler and the 1"mark on the horizontal ruler. Set the height of the button to 0.5" and the width to 1". The first button should have the caption Enter Customers with the button named as cmdEnterCustomers.
Repeat the same procedure for Enter Employees and Enter Suppliers, setting each button immediately below the one before it.
Add three buttons below the Reports label that will print preview the three reports in the database: Employees, Orders, and Products (in that order). Set the first one at the 2" mark on the vertical ruler and the 4" mark on the horizontal ruler. Set the height of the button to 0.5" and the width to 1". The first button should have the caption Employees with the button named as cmdEmployees.
Repeat the same procedure for Orders and Products, setting each button immediately below the one before it. Save the form, switch to Form view, and then test the buttons. Close all objects except the Main Menu form.