Скачать или смотреть Illustrated Access 365 | Module 10: SAM Project B

Please contact us if you need this project or any other project in any subject to be completed.
WhatsApp: +1-343-321-3276
Email: [email protected]
#illustratedaccess365 #ReliableDelivery

Illustrated Access 365 | Module 10: SAM Project B
Reliable Delivery
CREATING MACROS
PROJECT STEPS
1. You are a Route manager for Reliable Delivery, a parcel delivery company in Ottawa, Canada, that provides parcel delivery services to other businesses and individuals throughout Canada. In this project you will improve the database by creating macros. Complete the following:
a. Create a new macro in Macro Design View and add the OpenForm macro action.
b. Modify the OpenForm macro action to open the DriverSalary form in Form View using the other default macro argument values.
c. Save the macro with the name OpenDriverSalaryForm and run it.
d. Close the DriverSalary form, then close the OpenDriverSalaryForm macro.
2. Open the OpenClientReports macro in Macro Design View and complete the following:
a. Collapse the first OpenReport action that opens the ClientInfo report.
b. Expand the second OpenReport action and use Report as the value for the View argument.
c. Delete the third OpenReport action that opens the ClientFinancial report. Save and close the OpenClientReports macro.
3. Open the OpenDriverReports macro in Macro Design View and complete the following:
a. Expand both of the macro actions.
b. Open the Action Catalog if it is not already open and show all actions within it.
c. Add the OpenQuery action in the macro.
d. Set Query Name to RoutesByClient, leave the other settings at their default values.
e. Position the OpenQuery action as the second action in the macro. Save and close the OpenDriverReports macro.
4. Create a new macro in Macro Design View with the following instructions:
a. Add an If program flow block.
b. Use the conditional expression [Province] = "ON" in the If block.
c. Add a SetProperty macro action within the If block.
d. Use TravelBonus for the Control Name argument, BackColor for the Property argument, and #90EE90 for the Value argument. (Hint: #90EE90 is light green.)
e. Add an Else block and add a SetProperty macro action within it.
f. Use TravelBonus for the Control Name argument, BackColor for the Property argument, and #FFFFFF for the Value argument in the Else block. (Hint: #FFFFFF is white.)
Save the macro with the name Travel as shown in Figure 1, and then close it.

5. Open the DriverSalary form in Design View and complete the following:
a. Attach the Travel macro to the On Current event of the form.
Switch to Form View and navigate through several records. Those with "ON" in the Province text box should display a light green background in the Travel Bonus text box. Save and close the DriverSalary form.


6. Open the ClientEntry form in Design View and complete the following:
a. Use #FFFF00 for the Hover Fore Color property for the Close command button. (Hint: #FFFF00 is yellow.)
b. Save the form, display it in Form View and hover over the Close command button to test the change. Close the ClientEntry form.
7. In Design View of the Driver table complete the following:
a. Create a data macro on the Before Change event.
b. If the Province field value is "ON" and the ContractEmployee field value is True use the SetField action to set the value of the TravelBonus field to 500 as shown in Figure 2.
c. Save and close the data macro then open the table in Datasheet View. (Hint: Select Yes in the Microsoft Access window that appears asking if you want to save the table now.) Check the ContractEmployee field value to True (Yes) for the first two records, DriverID 510345 Roberto Reyes and 510347 Tony Roth, to test your data macro. Close the Driver table.