When the customer drops off something for repair, what info do we need? Also, what should we call this form?
Intake Form Data Type
Date dropped off Date
First Name Short Text
Last Name
Device Description
Device Serial Number Short Text
Phone Number Phone Number Field
Type of phone List Box (Cell, Land Line, Work)
Email Address
Address
Zip Number
Issue Long Text
Customer ID AutoNumber
Tech Job Detail
Customer ID Auto
Device description From the table
Device Serial Number
Issue
Start Date
Resolution
Parts Replaced
Parts Cost
Labor hours
Tech ID List Box
Invoice Form
Customer ID Auto – From Table
Parts Replaced
First Name
Last Name
Issue
Resolution
Phone Number
Email Address
Cost of Parts Calculate parts cost with % mark up – You choose % also * Tax
Labor Cost Calc field = Labor Hours * ? (You choose hourly rate)
Total Cost Cost of Parts + Labor Cost
Add the following items – make up 4 jobs and enter those records using your forms or your table
Add a picture to both forms
Add a color to a field
Don’t forget to write the report for 25% of your grade.
Create 5 queries – 1) qryAveLaborHours
2) qrySerialNumberParameter (To find a specific S/N)
3) qryMaxTotalCost (Finds the most expensive total Cost)
4) qryLastNameParameter (Parameter qry by last name)
5) qryAveTotalCost (Average Total Cost fields)
The post When the customer drops off something for repair, what info do we appeared first on PapersSpot.