Project Description
GOAL
To create an Apple (Mac) App which has the ability to access a local LAN MS Access MDB residing on a QNAP server. Email or TXT notification of workflow or task completion will be required.
The primary function is to transition from paper based forms to storing completed forms on a server.
There will be multiple phases, involving different forms being converted.
REQUIREMENTS
All development tools and programs need to be purchased and stored on the local server. IP will remain property of company at all times.
PHASE 1
App development on Apple APP download consisting of
(1) Download activation process (once downloaded to an I-PAD, a challenge question based on date / time which requires a changing key to make the APP “active”
(2) Database consisting of
(a) Name, First and Last and Student #
(b) Role (student, User, Instructor, Admin and PIN
(c) Equipment (S/N, Make and Model)
(d) Booking hours (Date and Time)
(e) Form consisting of 4 Sections – each question has a numeric of 1 through 5 (buttons)
a. Section 1 having 8 questions
b. Section 2 having 5 questions
c. Section 3 having 7 questions
d. Section 4 having 5 questions
(3) Once app is activated, student enters first, last name, student number and assigned PIN – PIN as to be changed (and uploaded to DB)
(4) Student fills out form, and selects instructor and booking slot time. A numerical calculation is compiled, with three (3) possible outcomes.
(5) Depending on the status of the user role, TXT and / or email workflow or notification will be required.
(6) Data can be stored on the APP off-line if the booking is within 4 hours – once at site, the off-line data can be up-loaded and then processed.