subject

Add a field to the Client table named Available Credit. Reset the field to currency. 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 Available Credit field. 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]

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 13:30
Janeโ€™s team is using the v-shaped model for their project. during the high-level design phase of the project, testers perform integration testing. what is the purpose of an integration test plan in the v-model of development? a. checks if the team has gathered all the requirements b. checks how the product interacts with external systems c. checks the flow of data in internal modules d. checks how the product works from the client side
Answers: 1
question
Computers and Technology, 23.06.2019 00:30
If joey was single and his taxable income was $9,500, how much would he pay in taxes each year?
Answers: 1
question
Computers and Technology, 23.06.2019 14:30
Select the correct answer. peter has launched a website that features baby products. however, clients often find they are unable to access the website because the server is down. which feature of cybersecurity should peter focus on for his website? a. data authenticity b. data privacy c. data availability d. data integrity e. data encryption
Answers: 3
question
Computers and Technology, 24.06.2019 07:00
Selective is defined as paying attention to messages that are consistent with oneโ€™s attitudes and beliefs and ignoring messages that are inconsistent.
Answers: 1
You know the right answer?
Add a field to the Client table named Available Credit. Reset the field to currency. Create a data m...
Questions
question
Mathematics, 10.12.2021 05:50
question
Mathematics, 10.12.2021 05:50
question
Chemistry, 10.12.2021 05:50
Questions on the website: 13722367