Database Access multi location + central
- or -
Post a project like this2331
$400
- Posted:
- Proposals: 5
- Remote
- #1781496
- Completed
Description
Experience Level: Intermediate
Estimated project duration: 3 - 4 weeks
"Due to Internet access issues, instead of an online system (PHP/MySQL), a database based on Access would be preferred.
The same database would be installed:
- 7 to 14 locations to collect some laboratory data entry (3 forms) - database will be copy/paste to a dropbox folder (it seems to me a good solution since the internet is really not stable for many labs)
- 1 central database (using the same developed tool Acess) in order to monitor activities of all labs and generate some statistics
Notes:
- Not need to merge data, each lab needs only to manage their own data
- At the central level, no data entry, just need to monitor overall statistics for each and all labs
Will mainly 2 main forms with the below tables:
- USER
- LABORATORY
- COUNTRY
- PATIENT + TEST + RESULT (3 tables)
- WEEKLY_DATA
- BATCH_DATA
With some reporting & graphic functions, and exporting under excel as well. It's a simple project. The main question remains on how at the central levels read and generate statitics from the 14 database stored on 14 folders, there are different ways to manage it, please elaborate.
I am looking for somebody based in Jakarta
The same database would be installed:
- 7 to 14 locations to collect some laboratory data entry (3 forms) - database will be copy/paste to a dropbox folder (it seems to me a good solution since the internet is really not stable for many labs)
- 1 central database (using the same developed tool Acess) in order to monitor activities of all labs and generate some statistics
Notes:
- Not need to merge data, each lab needs only to manage their own data
- At the central level, no data entry, just need to monitor overall statistics for each and all labs
Will mainly 2 main forms with the below tables:
- USER
- LABORATORY
- COUNTRY
- PATIENT + TEST + RESULT (3 tables)
- WEEKLY_DATA
- BATCH_DATA
With some reporting & graphic functions, and exporting under excel as well. It's a simple project. The main question remains on how at the central levels read and generate statitics from the 14 database stored on 14 folders, there are different ways to manage it, please elaborate.
I am looking for somebody based in Jakarta
Jb M.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
40%
Last project
9 Jun 2019
Indonesia
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello. Is it necessary for the freelancer to be based in Jakarta? Looking forward to your response.
537206
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies