21 Mar I would like a Microsoft Application expert to completely redesign the following Application. It is an application for a trucking company and needs a complete design and fu
I would like a Microsoft Application expert to completely redesign the following Application. It is an application for a trucking company and needs a complete design and functionality do-over. Firstly the login button needs a checkmark or show password option that will allow the user an option to see their password as it is being typed. Similarly, the buttons or forms on the main menu needs to be modified so that when the user clicks on the button or the form it should open in the same tab instead of opening in a new window. There is an extra hauled invoice table that is the exact copy of the invoice table therefore the hauled invoice can be deleted and the invoice table should be used to generate reports. There should be a print functionality button that will print the invoice and other reports after it is generated. This app is for a small business and the client is not happy with the visual appearance of the app (UI) so it needs to be modified and designed in such a way that looks both visually appealing and is easier to use. Having all the buttons or forms of the main menu or dashboard in one area would also help. Some of the requirements are:
INPUT:
- The input forms that will be most important will be to enter the data from each load immediately after it has been delivered.
- There will need to be a form to enter information about the equipment, trucks and trailers.
- Form to enter new driver information
- Form to create an invoice for each load that has been hauled.
REPORTS:
- A report to show all loads hauled for each week.
- A report to show all loads hauled for each driver each week.
- A report to show maintenance shown for all trucks and trailer probably monthly.
- A report to show a driver’s payroll for each week. It should show all the loads they hauled each week with the pay being 25% of the total hauled each week. It should show the taxes withheld each week.
I have provided a sample paper version of what the form should look like when it is printed.
The query needs to be worked on as well to function according to the tables. All the names of the forms and table should be organized and sorted. The current version has the tables names capitalized and the forms are not aligning with each other which needs to be fixed.
| Customer_ID | Company_Name | Vendor_Number | First_Name | Last_Name | Phone_Number | Address | City | State | ZIP | Shipping_History | Shipping_Preferences | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ABC Corp | VN001 | John | Doe | [email protected] | 123-456-7890 | 123 Main St | Cityville | CA | 12345 | Shipment 1 | Express Shipping |
| 2 | XYZ Inc | VN002 | Jane | Smith | [email protected] | 987-654-3210 | 456 Oak St | Townsville | NY | 54321 | Shipment 2 | Standard Shipping |
| 3 | LMN Corporation | VN003 | Bob | Johnson | [email protected] | 555-123-4567 | 789 Maple St | Villagetown | TX | 67890 | Shipment 3 | Express Shipping |
| 4 | PQR Ltd | VN004 | Sara | Williams | [email protected] | 111-111-1111 | 101 Pine St | Cityville | CA | 12345 | Shipment 4 | Standard Shipping |
| 5 | KLM Inc | VN007 | Daniel | Taylor | [email protected] | 777-888-9999 | 202 Elm St | Villagetown | TX | 67890 | Shipment 7 | Standard Shipping |
| Driver_ID | First_Name | Last_Name | Hire_Date | DL_Class | DL_State | DL_Number | DL_Expiration | Endorsements | Phone_Number | Address | City | State | Zip | Medical_Certification | Medical_Expiration | Service_Hours | Training_Records | Performance_Metrics |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Alice | Smith | 2022-01-15 | Class A | CA | DL123456 | 2024-01-15 | Tanker | 987-654-3210 | 456 Oak St | Townsville | CA | 54321 | true | 2023-01-15 | 100 | Training 1 | Good performance |
| 2 | David | Brown | 2022-02-01 | Class B | NY | DL987654 | 2023-02-01 | Hazmat | 222-333-4444 | 555 Elm St | Villagetown | TX | 67890 | true | 2023-02-01 | 150 | Training 2 | Satisfactory performance |
| 3 | Emily | Jones | 2022-03-15 | Class C | CA | DL789012 | 2024-03-15 | None | 333-444-5555 | 777 Oak St | Townsville | NY | 54321 | false | 80 | Training 3 | Average performance | |
| 4 | Michael | Miller | 2022-01-10 | Class A | TX | DL345678 | 2023-01-10 | Tanker, Doubles/Triples | 444-555-6666 | 888 Maple St | Cityville | CA | 12345 | true | 2023-01-10 | 120 | Training 4 | Excellent performance |
| 5 | William | Lopez | 2022-03-01 | Class A | CA | DL345678 | 2023-03-01 | Hazmat | 888-999-0000 | 707 Pine St | Cityville | CA | 12345 | true | 2023-03-01 | 180 | Training 8 | Satisfactory performance |
| Contact_ID | Driver_ID | Emergency_Name | Emergency_Number | Emergency_Address | Emergency_City | Emergency_State | Emergency_Zip |
|---|---|---|---|---|---|---|---|
| 1 | 1 | Emergency Contact 1 | 111-222-3333 | 789 Elm St | Villagetown | CA | 98765 |
| 2 | 2 | Emergency Contact 2 | 777-888-9999 | 999 Pine St | Townsville | NY | 54321 |
| 3 | 3 | Emergency Contact 3 | 888-999-0000 | 111 Oak St | Cityville | CA | 12345 |
| 4 | 4 | Emergency Contact 4 | 999-000-1111 | 222 Maple St | Villagetown | TX | 67890 |
| 5 | 5 | Emergency Contact 5 | 111-222-3333 | 123 Oak St | Townsville | NY | 54321 |
| 6 | 2 | Emergency Contact 6 | 444-555-6666 | 456 Elm St | Cityville | CA | 12345 |
| 7 | 3 | Emergency Contact 7 | 777-888-9999 | 789 Pine St | Villagetown | TX | 67890 |
| 8 | 5 | Emergency Contact 8 | 999-000-1111 | 101 Maple St | Cityville | NY | 54321 |
| 9 | 5 | Emergency Contact 9 | 111-222-3333 | 123 Oak St | Townsville | NY | 54321 |
| Equipment_ID | Insurance_ID | Driver_ID | Type | VIN | Model_Year | Ownership_Status | Equipment_Price | Monthly_Payment | Description | Vehicle_Weight | Vehicle_Length | Vehicle_Width | Vehicle_Height | Trailer_Weight | Trailer_Length | Trailer_Width | Trailer_Height |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 1 | Truck | VIN123456 | 2022 | Owned | ¤ 80,000.00 | ¤ 1,500.00 | Test Truck | 12000 | 30 | 8 | 12 | 8000 | 40 | 8 | 12 |
| 2 | 1 | 3 | Truck | VIN098765 | 2022 | Leased | ¤ 80,000.00 | ¤ 1,600.00 | Leased Truck | 18000 | 45 | 8 | 13 | 0 | 0 | 0 | 0 |
| 3 | 2 | 1 | Trailer | VIN654321 | 2021 | Leased | ¤ 50,000.00 | ¤ 1,000.00 | Leased Trailer | 8000 | 40 | 8 | 12 | 0 | 0 | 0 | 0 |
| 4 | 2 | 2 | Trailer | VIN567890 | 2021 | Owned | ¤ 60,000.00 | ¤ 1,100.00 | Old Trailer | 7500 | 30 | 8 | 11 | 0 | 0 | 0 | 0 |
| 5 | 2 | 3 | Truck | VIN876543 | 2021 | Owned | ¤ 85,000.00 | ¤ 1,700.00 | Owned Truck 3 | 18000 | 42 | 8 | 12 | 0 | 0 | 0 | 0 |
| 6 | 2 | 4 | Trailer | VIN765432 | 2022 | Leased | ¤ 65,000.00 | ¤ 1,300.00 | Leased Trailer 3 | 7200 | 32 | 8 | 11 | 0 | 0 | 0 | 0 |
| 7 | 3 | 3 | Truck | VIN789012 | 2020 | Owned | ¤ 70,000.00 | ¤ 1,200.00 | Old Truck | 15000 | 35 | 8 | 11 | 0 | 0 | 0 | 0 |
| 8 | 3 | 4 | Truck | VIN654321 | 2020 | Owned | ¤ 80,000.00 | ¤ 1,600.00 | Old Owned Truck | 16000 | 38 | 8 | 11 | 0 | 0 | 0 | 0 |
| 9 | 4 | 2 | Truck | VIN012345 | 2023 | Owned | ¤ 90,000.00 | ¤ 1,500.00 | New Truck | 12000 | 30 | 8 | 12 | 8000 | 40 | 8 | 12 |
| 10 | 4 | 4 | Truck | VIN456789 | 2023 | Leased | ¤ 90,000.00 | ¤ 1,800.00 | Leased Truck 2 | 16000 | 40 | 8 | 12 | 0 | 0 | 0 | 0 |
| 11 | 4 | 5 | Trailer | VIN543210 | 2023 | Leased | ¤ 70,000.00 | ¤ 1,400.00 | Leased Trailer 4 | 8000 | 34 | 8 | 12 | 0 | 0 | 0 | 0 |
| 12 | 5 | 1 | Trailer | VIN567890 | 2022 | Leased | ¤ 55,000.00 | ¤ 1,100.00 | Leased Trailer 2 | 8500 | 38 | 8 | 11 | 0 | 0 | 0 | 0 |
| 13 | 5 | 5 | Trailer | VIN234567 | 2020 | Owned | ¤ 50,000.00 | ¤ 1,000.00 | Old Trailer 2 | 7000 | 28 | 8 | 10 | 0 | 0 | 0 | 0 |
| Invoice_ID | Order_ID | Payment_Status | Due_Date | Amount_Due | Payment_Date | Payment_Amount | Payment_Method | Comments | Hauled invoice |
|---|---|---|---|---|---|---|---|---|---|
| 2 | 1 | Pending | 2022-02-28 | ¤ 500.00 | 2022-02-15 | ¤ 300.00 | Credit Card | Invoice for services rendered | Yes |
| 3 | 2 | Paid | 2022-03-15 | ¤ 700.00 | 2022-03-10 | ¤ 700.00 | Cash | Invoice paid on time | Yes |
| 4 | 3 | Pending | 2022-04-01 | ¤ 900.00 | 2022-03-01 | ¤ 1,200.00 | Credit Card | Pending payment for services | Yes |
| 5 | 4 | Paid | 2022-03-01 | ¤ 1,200.00 | 2022-03-01 | ¤ 1,200.00 | Credit Card | Invoice paid in full | Yes |
| 6 | 5 | Pending | 2022-06-15 | ¤ 1,500.00 | 2022-03-10 | ¤ 700.00 | Credit Card | Pending payment for services | Yes |
| 7 | 6 | Paid | 2022-04-05 | ¤ 800.00 | 2022-04-05 | ¤ 800.00 | Cash | Invoice paid on time | No |
| 8 | 7 | Pending | 2022-05-20 | ¤ 1,200.00 | 2022-05-01 | ¤ 0.00 | Credit Card | Pending payment for upcoming services | |
| 9 | 8 | Pending | 2022-07-01 | ¤ 1,000.00 | 2022-06-20 | ¤ 0.00 | Bank Transfer | Pending payment for ongoing project | |
| 10 | 9 | Paid | 2022-04-15 | ¤ 600.00 | 2022-04-10 | ¤ 600.00 | Credit Card | Invoice paid in full and on time | |
| 11 | 10 | Pending | 2022-08-01 | ¤ 2,000.00 | 2022-07-20 | ¤ 0.00 | Cash | Pending payment for multiple orders | Yes |
| 12 | 11 | Paid | 2022-05-01 | ¤ 850.00 | 2022-04-25 | ¤ 850.00 | Credit Card | Invoice paid before the due date | |
| 13 | 12 | Pending | 2022-09-15 | ¤ 1,300.00 | 2022-09-01 | ¤ 0.00 | Bank Transfer | Pending payment for extended services | |
| 14 | 13 | Paid | 2022-06-01 | ¤ 950.00 | 2022-05-28 | ¤ 950.00 | Cash | Invoice paid in full and in cash |
| Insurance_ID | Insurance_Provider | Policy_Number | Policy_Start_Date | Policy_End_Date | Coverage_Type | Deductible_Amount | Premium_Amount |
|---|---|---|---|---|---|---|---|
| 1 | Insurance Co. 1 | POLICY123 | 2022-01-01 | 2023-01-01 | Full Coverage | ¤ 1,000.00 | ¤ 1,200.00 |
| 2 | Insurance Co. 2 | POLICY456 | 2022-02-01 | 2023-02-01 | Collision | ¤ 500.00 | ¤ 800.00 |
| 3 | Insurance Co. 3 | POLICY789 | 2022-03-15 | 2023-03-15 | Liability | ¤ 1,000.00 | ¤ 1,500.00 |
| 4 | Insurance Co. 4 | POLICYABC | 2022-01-10 | 2023-01-10 | Comprehensive | ¤ 750.00 | ¤ 1,000.00 |
| 5 | Insurance Co. 5 | POLICYDEF | 2022-06-01 | 2023-06-01 | Comprehensive | ¤ 1,000.00 | ¤ 1,200.00 |
| Invoice_ID | Order_ID | Payment_Status | Due_Date | Amount_Due | Payment_Date | Payment_Amount | Payment_Method | Comments |
|---|---|---|---|---|---|---|---|---|
| 2 | 1 | Pending | 2022-02-28 | ¤ 500.00 | 2022-02-15 | ¤ 300.00 | Credit Card | Invoice for services rendered |
| 3 | 2 | Paid | 2022-03-15 |
