Convert Microsoft Access 97 Application to Access 2010
1. Currently existing Microsoft Access 97 custom application called “Workorder” needs to be migrated to Access 2010. Approximately 45,000 existing parts records, 50,000 workorder records and 5,000 customer records, and others, etc. The following modifications need to be made to Workorder:
a. On the Parts data entry the “Thickness” field needs to be modified to free text entry.
b. Add a field “Surface Area” to
c. Add a field “Masking Requirements” to
d. Add ability to attach a file (PDF, JPG, Etc) to
e. Add a search utility using drop-down fields to search by: Part Number and/or Process and/or Customer and/or Date.
f. Certifications, which are printed, need an option enabling them to be emailed.
g. Currently, when we enter new orders or customer info, we can’t see it unless we exit Access and start the program over again. Workorder needs to show the data entered without having to do that.
h. Workorder needs to be simultaneously accessible from multiple PC’s running Access 2010, with one PC used as a server, on the same local peer network.
i. Workorder would optionally be a runtime application able to run up to 10 users on a local peer network, with one PC used as a server, without Access 2010 installed.
j. Currently shipped orders are not removed from the open orders report until 24 hours. We need shipped orders to be removed from open orders report as soon as they are marked shipped.
k. Add a Sales Order input screen with about 25 fields integrated into existing application and database
l. Application speed must be as fast as current Access 97 application.
m. A data export utility must be created to export any selected data records and/or fields in excel, csv, quickbooks, and 5 other formats.
n. Modify all existing interfaces to be user friendly (user friendly so that no Access experience is necessary)
o. Add user friendly Reports creation module to enable users to create their own reports