1. If you are using Access 2016, do the following.

1. Add a field to the Client table named AvailableCredit. Set the field to currency.
2. Create a data macro associated with the After Update event for the Client table. When a user updates the Balance field, the macro should subtract the new balance from the credit limit and place that value in the AvailableCredit field.
3. Create a data macro associated with the After Delete event for the OrderLine table. When a user deletes a record because it is complete or cancelled, the macro should look up the order number in the WorkOrders table and delete it there as well. Use the For Each Record in the WorkOrders table. Hint: You can use the OLD keyword in the Where Condition: [Old].[OrderNum] = [WorkOrders].[OrderNum]. Test the data macro by deleting a record from the OrderLine table and ensuring that the record also is deleted from the WorkOrders table.

Rate $22.50 $22.50 $20.00 $15.00 Street CreditLimit ConsitNum $2,500.00 19 $5,000.00 19 $10,000.00 22 Consultant ConsltNum LastName FirstName Street City State Zip Code Hours 19 Turner Christopher 554 Brown Dr. Tri City FL 32889 40 22 Jordan Patrick 2287 Port Rd. Easton FL 33998 40 40 35 Allen Sarah 82 Elliott St. Lixton FL. 34344 35 51 Shields Tom 373 Lincoln Ln. Sunland FL 39876 10 Client ClientNum ClientName City State Zip Code Balance 143 Hershey, Jarrod 135 E Mill Street Easton FL. 33998 $1,904.55 175 Goduto, Sean 12 Saratoga Parkway Tri City FL 32889 $2,814.55 299 Two Crafty 9787 NCR 350 Sunland FL 39876 $8,354.00 Cousins West 322 Prichard's Pizza & 501 Air Parkway Lizton FL 34344 $7,335.55 Pasta 363 Salazar, Jason 56473 Cherry Tree Dr Easton 33998 $900.75 Fisherman's Spot 49 Elwood Ave. Harpersburg FL. 31234 $4,113.40 Shop 449 Seymour, 4091 Brentwood Ln Amo FL. 34466 $557.70 Lindsey 458 Bonnie's Beautiful 9565 Ridge Rd. Tri City 32889 $4,053.80 Boutique 677 Yates, Nick 231 Day Rd. Sunland FL 39876 $2,523.80 733 Howler, Laura 1368 E. 1000 S. Lizton FL. 34344 $3,658.05 826 Harpersburg Bank 65 Forrest Blvd. Harpersburg FI. 31234 $6,824.55 867 MarketPoint Sales 826 Host St. Easton FL 33998 $3,089.00 $10,000.00 35 $2,500.00 $7,500.00 35 19 405 $5,000.00 22 $7,500.00 22 $2,500.00 $5,000.00 $10,000.00 $5,000.00 35 22 19 19 WorkOrders Order Num Order Date 67101 9/6/2018 67313 9/7/2018 67424 9/10/2018 67838 9/10/2018 67949 9/10/2018 68252 9/12/2018 68868 9/14/2018 68979 9/17/2018 Client Num 733 458 322 867 322 363 867 826 OrderLine Order Num TaskID 67101 S077 67313 LASI 67424 M049 67424 UP38 67838 LASI 67949 PIS4 67949 VR39 67949 WA33 68252 DISS 68868 SA44 68979 ACAS 68979 DA11 ScheduledDate QuotedPrice 9/10/2018 $144.00 9/12/2018 $104.00 9/14/2018 $65.00 9/14/2018 $185.00 9/20/2018 $104.00 9/21/2018 $50.00 9/21/2018 $88.00 9/21/2018 $126.00 9/24/2018 $50.00 9/24/2018 $200.00 9/27/2018 $77.00 9/27/2018 $970.00 Tasks TaskID AC65 DAI1 DINS HA63 HI31 LASI M049 OT99 PIS4 Description Category Accessories ACC Data recovery major DRM Data recovery minor DRM Hardware major HAM Hardware minor HAM Local area networking (LAN) LAN Mobility MOB Other work OTH Printing issues PRI Software major SOM Software minor SOM Security install/repair SIR Upgrades UPG Virus removal VIR Wide area networking (WAN) WAN Web connectivity WEC Price $80.00 $175.00 $50.00 $225.00 $165.70 $104.00 $65.00 $99.99 $50.00 $200.00 $144.00 $126.00 $185.00 $90.00 $130.00 $75.00 SA44 S177 S191 UP38 VR 39 WA33 WC19 Rate $22.50 $22.50 $20.00 $15.00 Street CreditLimit ConsitNum $2,500.00 19 $5,000.00 19 $10,000.00 22 Consultant ConsltNum LastName FirstName Street City State Zip Code Hours 19 Turner Christopher 554 Brown Dr. Tri City FL 32889 40 22 Jordan Patrick 2287 Port Rd. Easton FL 33998 40 40 35 Allen Sarah 82 Elliott St. Lixton FL. 34344 35 51 Shields Tom 373 Lincoln Ln. Sunland FL 39876 10 Client ClientNum ClientName City State Zip Code Balance 143 Hershey, Jarrod 135 E Mill Street Easton FL. 33998 $1,904.55 175 Goduto, Sean 12 Saratoga Parkway Tri City FL 32889 $2,814.55 299 Two Crafty 9787 NCR 350 Sunland FL 39876 $8,354.00 Cousins West 322 Prichard's Pizza & 501 Air Parkway Lizton FL 34344 $7,335.55 Pasta 363 Salazar, Jason 56473 Cherry Tree Dr Easton 33998 $900.75 Fisherman's Spot 49 Elwood Ave. Harpersburg FL. 31234 $4,113.40 Shop 449 Seymour, 4091 Brentwood Ln Amo FL. 34466 $557.70 Lindsey 458 Bonnie's Beautiful 9565 Ridge Rd. Tri City 32889 $4,053.80 Boutique 677 Yates, Nick 231 Day Rd. Sunland FL 39876 $2,523.80 733 Howler, Laura 1368 E. 1000 S. Lizton FL. 34344 $3,658.05 826 Harpersburg Bank 65 Forrest Blvd. Harpersburg FI. 31234 $6,824.55 867 MarketPoint Sales 826 Host St. Easton FL 33998 $3,089.00 $10,000.00 35 $2,500.00 $7,500.00 35 19 405 $5,000.00 22 $7,500.00 22 $2,500.00 $5,000.00 $10,000.00 $5,000.00 35 22 19 19 WorkOrders Order Num Order Date 67101 9/6/2018 67313 9/7/2018 67424 9/10/2018 67838 9/10/2018 67949 9/10/2018 68252 9/12/2018 68868 9/14/2018 68979 9/17/2018 Client Num 733 458 322 867 322 363 867 826 OrderLine Order Num TaskID 67101 S077 67313 LASI 67424 M049 67424 UP38 67838 LASI 67949 PIS4 67949 VR39 67949 WA33 68252 DISS 68868 SA44 68979 ACAS 68979 DA11 ScheduledDate QuotedPrice 9/10/2018 $144.00 9/12/2018 $104.00 9/14/2018 $65.00 9/14/2018 $185.00 9/20/2018 $104.00 9/21/2018 $50.00 9/21/2018 $88.00 9/21/2018 $126.00 9/24/2018 $50.00 9/24/2018 $200.00 9/27/2018 $77.00 9/27/2018 $970.00 Tasks TaskID AC65 DAI1 DINS HA63 HI31 LASI M049 OT99 PIS4 Description Category Accessories ACC Data recovery major DRM Data recovery minor DRM Hardware major HAM Hardware minor HAM Local area networking (LAN) LAN Mobility MOB Other work OTH Printing issues PRI Software major SOM Software minor SOM Security install/repair SIR Upgrades UPG Virus removal VIR Wide area networking (WAN) WAN Web connectivity WEC Price $80.00 $175.00 $50.00 $225.00 $165.70 $104.00 $65.00 $99.99 $50.00 $200.00 $144.00 $126.00 $185.00 $90.00 $130.00 $75.00 SA44 S177 S191 UP38 VR 39 WA33 WC19