Access conversion
$500-5000 USD
Paid on delivery
**There are 3 parts to this project
**1. Convert Access db to APD linking to upsized SQL backend
2. Create a webstore based on SQL backend
3. Create a web-app which will mimic the Access ADP.
**_Part 1_:**
We have completed an extensive Access database which we would like to have converted:
-to SQL backend
-update code to reflect updated ActiveX components (using FMS Memo control and DBITech Calendar Controls. We plan on purchasing and incorporating the newer DBI controls in the software).
-fully upgraded to Access 2002 or 2003.
Current system:
The application is has various functions including:
CMS system with info like:
-company info
-addresses
-contacts
-Estimate, WO, Invoices listing/details
-payments
-statement
-notes
-appts
Calendar functions
-2 calenders
-appts are tied to Work Orders
Admin tools
-reporting
-program setup
Other tools
-reporting tool
-bulk email
-search tools.
-and more
FYI. The db is split into an FE and BE
There are **approx** 40 tables, 100 qrys, 100 reports, 100 forms, 0 macros, 15 modules .
**_Part 2:_**
After this is functioning:
-Create a web store from the data.
**_Part 3:_
**the later phases of this project include: (please quote on this)
-Web-enabling the database in ASP.
-This phase will include a component which will allow for a webstore, and allow for existing clients to review thier information.
**_General Notes_**
(NOTE: We are a development company. At this time we are looking for an offshore partner to help us in our coding needs. We hope to find a long term partner(s)).
The Backend will be upsized to SQL while the FrontEnd will be upgraded to Access 2003.
The SQL backend will then be used to develop the website which will include a webstore/catalog and also mimic the existing the db.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. 4) You must sign a non-disclosure and non-compete document with us.
## Platform
MS Windows 9x and XP, MS Access, MS SQL, MS Exchange, ASP.
Project ID: #2975994