Access to SharePoint Migration
$5000-20000 USD
Pagado a la entrega
Requirements: We are seeking a SharePoint/.NET developer to migrate an existing Access 97 database to SharePoint Foundation 2010 (free version). The current database tracks client information, generates reports, contains a document reference library, and has data entry that has simple calculations. The proposed solution is to use SharePoint Foundation 2010 with an MS SQL embedded database that allows for the client to input data, generate reports, and store documents using a document library. Certain data must be able to export to QuickBooks. An internet-facing web page must be created to allow the client's external customers to login from the web to view read-only data. The SharePoint site and forms must be heavily customized to meet the needs of the client.
## Deliverables
**Additional requirements:
*** Create an internet-facing SharePoint web page
- Allow the end-user to enter their client number and date of birth to check the status of their order
* Currently, our client does not have a transaction/receipt reconciliation system
- Generate a sequential receipt number when receipts are printed
- For financial transactions, if the end-user deletes the financial transaction from the order, it hides the data from the order, but does not delete from the database
-- A custom report needs to be written that displays all financial transactions that were deleted from orders, including the order number, date it was deleted, and who deleted
* For each order, there are two methods of deliveries: pick up or mail
- For mail, allow the end-user to input the courier's tracking number, the courier used, and financial transaction
* Create a SharePoint document repository for each client's order
- The end-user searches for the client, clicks on the client's name from the results, then clicks on the client's order, then the documents associated with that order are displayed
* Financial transaction history
- For all financial transactions, log the transaction information in a non-modifiable report, including deleted financial data
- Some financial data will be exported into QuickBooks
* Data migration: create a script or develop a method to migrate specific data from the Access 97 database into SharePoint.
* Certain data fields will be exported to a report/document from SharePoint
**Attachments:
*** Current System Analysis documentation
* Current Access 97 database relationship of certain tables
* Scope Change Log
Due to confidential information, additional attachments/reports will be sent upon acceptance of bid.
**Status Reports:
**
* Weekly status reports are required and will be due every Monday by 10:00 am Central Time.
**Deliverable Deadlines:**
* Major deadlines for deliverables will be provided after developer has been selected.
## Platform
SharePoint Foundation 2010 (free version) on Windows Server 2008
Nº del proyecto: #3560308