Convert Microsoft Access 97 Application to Access 2010

Convert Microsoft Access 97 Application to Access 2010

General Description:

Microsoft Access

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

Kemahiran: Pemasukan Data, Microsoft Access

Lihat lagi: convert access access 2010, the open 2010, quickbooks export to csv, quickbooks export csv, parts database access, o.n.e. network, microsoft number, microsoft excel number formats, microsoft access parts database, friendly's application, free l, formats in excel, date utility, data entry own hours, custom formats in excel, create free application, access parts database, access database module, quickbooks number, free certifications, customer database in excel, utility to convert csv, peer-to-peer, peer to, PC Parts

Tentang Majikan:
( 1 ulasan ) Escondido, United States

ID Projek: #1570441