Fnds015 A-Tech Is Automotive Service Assessment Answers
A customer may make one or more requests (‘Job’) when they call A-TECH, and details about the customer and the type of requests (‘Jobs’) need to be tracked. Requests are identified by a RequestID field. Also A-TECH needs to know the details of the technician who completed a request. Upon completion of a request, the customer receives an invoice that details the work done and the amount that must be paid. A-TECH needs to track all the invoices sent to customers and ensure payment for completed requests is received.
Create a Form:
1. Create a new form, ‘Columnar style’ based on the ‘Invoice’ table and include all the fields from the Invoice table. Name the form Invoice
2. Modify the look of the form and place a SIMPLE and CLEAR image of a car being repaired (find this image from an online search) in the header section of the form. Add a company name to yourform. Add your full name and student ID in the footer section of the form. Don’t forget to type it in likethis: FirstName LastName YAPAC1702
3. Change the background colour of all sections in the ‘Property Sheet section of the form.
Create Queries:
Create these queries to answer the questions below:
1. List all the customers who live in area ‘4216’ and include all the fields. Save the query as ‘Customer Area’.
2. The total value of all discounted invoices for each customer, showing the field CustomerID, LName inthe Customer table, and the fields Discounted Invoice Amount in the Invoice table. Save the query as ‘Invoice_Total’. Hint: you will need to use the in the Show/Hide toolbox in the Design Tab. Alongwith
3. List all the invoices (showing all the fields) that have an Amount of $3,999 or less. Savethe query as
Create a Report
1. Create a Tabular report based on the query ‘Invoice_Total’ and sort in ascending order by, and order by
2. Save as‘Job_Total’.
This assignment is to be submitted through the ‘Assignment 3 submission link’ in week 12 ofthe portal. You will be shown this process in Week 11. Students must submit a zipped folder containing the Access Database file and the ERDtemplate document. The file must be zipped using Winzip or 7ZIP (as a .zipfile). Name each file with your Name and ID number, then name the FOLDER asshown.
Answer:
Buy Fnds015 A-Tech Is Automotive Service Assessment Answers Online
Talk to our expert to get the help with Fnds015 A-Tech Is Automotive Service Assessment Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.
