The smartphone contracting company needs a way too more efficiently automate entering the customers details and the cont

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

The smartphone contracting company needs a way too more efficiently automate entering the customers details and the cont

Post by answerhappygod »

The Smartphone Contracting Company Needs A Way Too More Efficiently Automate Entering The Customers Details And The Cont 1
The Smartphone Contracting Company Needs A Way Too More Efficiently Automate Entering The Customers Details And The Cont 1 (113.8 KiB) Viewed 32 times
The smartphone contracting company needs a way too more efficiently automate entering the customers details and the contract the customer may sign up for into the company system. Your group is tasked to develop the automated program where the company staff will be able to interact with the program. The program must detail all the necessary fields that must be entered to effectively capture the customer details and determine if the customer is eligible for a free laptop. A description of how the program is structured and how it should be implemented is below: When the employee (user) clicks on a button the login userform must appear asking the employee to enter their correct details. If the employee is not yet registered on the system, they must be added and stored for later reference. A maximum of 100 employees can be registered on the system at once and no more. If an employee has already registered with the same username, a message pop-up must appear, requesting a different username. Once the username and password match the employees' details, they can proceed to the next window. Once the employee logs-in, a new window appears asking the employee to enter the details of the customers contract details that they want to be captured. It is up to your group to decide what is the best or relevant components needed on the userform to achieve the desired tasks. Once the employee has entered all the desired information there will be an option to calculate the results and indicate if the customer can receive a free laptop with a message box. If the employee is satisfied with the captured information they can proceed and complete the capture which will then add all the information entered into excel. Example of a customer entry below: Employee Username No Customer Name & Surname Customer Smartphone Number Smartphone 05 Years of Service Contract Name Contract Price Eligible (Yes/No) SMITH Lowo Semaka Enter New Customer 1 New A 200.00 0654031 234 0919 877 456 Android Apple LHCARMANN 2 Cobus Joubert Smartchoice a 450.00 YOU From the image above, the fields that need to be captured are: . Employee's username and password (password is employee's ID number) No# Customer Name & Surname Customer smartphone number Smartphone OS (Android or Apple) Years of contract service Contract name • Contract price Eligible (Yes/No) (Not entered, but calculated based on a grade criteria) Page | 21 GROUP ASSIGNMENT (IEPV201) 2022 The list of prices is a pre-defined set that needs to be selected from a list of contract options; thus, the same list will be used to select the Android and Apple contract options; but ONLY display the relevant contract based on the smartphone OS. . .
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply