Fermé

sars DATABASE

I am a pharmacist and i need to design a simple MS Access database with a simple Data Entry Form for the Patien Tests performed daily , a Print Form for the test results , and a reporting form with date selection

In the future if needed we will adjust or add features

I need this to be ready quite soon and as i do not have much free time , and i do not have MS Access knowledge i need outside Help

I experimented with a template of MS Access which i will upload as to see what i need.

We have the Data Entry Form.

1. User will enter patient details on the upper part

2. We need default data to appear on "Manufacturer" , "Model" , "Pharmacy" , "User" but user will be able to alter them if needed

[login to view URL] ONE TickBox "Nasal" or "Nasopharyngeal" or "Saliva" can be chosen per record

4. Only ONE TickBox "Positive" or "Negative"

5. All information should be stored in the database

6. Then we need to print the info in Half A4 paper with background the included "FORM" and the data mapped as explained in the marked sections in the included "FORM-FIELDS"

7. We need a REPORT that Prints a List of the tests done for a period , Displaying the following Data :

a. Surname

b. Name

c. ARC

d. Manufacturer

e. Model

f. Result

Also because there are going to be repeated visits from same patients , i am thinking of a separate table with patient data , so the user can search an "ARC" to find the patient and then by selecting him the form would come up with all data filled for quicker entry

Thanks

Compétences : Microsoft Access, Programmation de bases de données, Administration de Bases de données, MySQL, Excel

Concernant l'employeur :
( 0 commentaires ) Limassol, Cyprus

Nº du projet : #30986393

24 freelances font une offre moyenne de 537 € pour ce travail

(421 Commentaires)
8.2
(1017 Commentaires)
8.2
(444 Commentaires)
8.3
(641 Commentaires)
7.3
(125 Commentaires)
7.1
(15 Commentaires)
6.8
(63 Commentaires)
6.4
(35 Commentaires)
6.4
(95 Commentaires)
6.5
(15 Commentaires)
6.2
(25 Commentaires)
6.0
(64 Commentaires)
6.4
(13 Commentaires)
5.7
(7 Commentaires)
5.6
(95 Commentaires)
5.8
(4 Commentaires)
5.6
(24 Commentaires)
4.8
(50 Commentaires)
4.9
(73 Commentaires)
5.5
(23 Commentaires)
4.5