Homework answers / question archive / Access chapter 10 grader project EX16_AC_CH10_GRADER_CAP_HW - Specialty Foods, Ltd

Access chapter 10 grader project EX16_AC_CH10_GRADER_CAP_HW - Specialty Foods, Ltd

MS Access

Share With

---

Access chapter 10 grader project

EX16_AC_CH10_GRADER_CAP_HW - Specialty Foods, Ltd.

Project Description:

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 add a menu for the common forms and reports. You will also modify the record source of one of the reports.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Instructions

1. Start Access. Open the downloaded Access database named  exploring_a10_Grader_h1.accdb . Save the database as  exploring_a10_Grader_h1_LastFirst .

2. 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. Hint: To create the data macro, on the Design tab, in the Field, Record & Table

Events group, click Create Data Macros.

3. 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. Hint: Click the Add New Action arrow, and then click SetField. In the Name box,  type  ExpectedShipDate . In the Value box, type  [OrderDate]+10.

4.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.

5. Repeat the test on the second and third records (10249 and 10250). Close the  table.

6. 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 . Hint: To add a button, on the Design tab, in the Controls group, click Button. Click  and drag to position and size the button.

7. Repeat the same procedure for  Enter Employees  and  Enter Suppliers , setting  each button immediately below the one before it.

8. 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.

9. 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.

10.Switch to Design view, add an  Exit  button that exits Access to the top-right corner  of the form, at the 0" mark on the vertical ruler and the 5" mark on the horizontal  ruler, with a height of  0.5 " and a width of  1 ". Name the button  cmdExit .

11. Apply the Slice theme to the Main Menu form only. Save the form, switch to Form  view, and then test the Exit button. Reopen the database. Hint: On the Design tab, in the Themes group, click Themes.

12. Open the Employees report in Design view. Open the Property Sheet and click the  Record Source box. Type an SQL statement into the Record Source property of the  report. The statement should select all fields (*) for employees with the Sales  Representative title. Save the report. Test the report in Print Preview and close the  report. Hint: On the Design tab, in the Tools group, click Property Sheet. On the Data tab,  click in the Record Source cell, type  SELECT * FROM Employees WHERE  Title="SalesRepresentative";  and press ENTER.

13.  Save the database. Close the database, and then exit Access. Submit the database as directed.