Medical database in Access or suggest your own.
67 USD I need to refine the database I created for the medical point (or discard everything and suggest doing it differently).
| 1 | Database for accounting, managing appointments, and printing referrals and reports by military personnel (rank-Full Name) - data set from the database. |
| 2 | The main information is located in the table "Military Personnel" |
| 3 | The main form is "Military Personnel Card". The left part contains permanent information about the person (it is preferable to make it so that nothing can be changed accidentally. Only after pressing the "Edit" button). Search by Full Name; if not found, suggest adding a new person, and then relevant entries can be entered into these cells. |
| 4 | In the permanent section, create a block of data about the Military Medical Commission (VLC): date of the last commission, diagnosis (VLC conclusion), fitness (fit, limited fit, etc.), and a link to the VLC photo. Make it possible to view VLC by dates for this person. |
| 5 | In the left part, there is a block "Chronic Diseases". It needs to include diseases that have already been diagnosed by relevant specialists (based on their conclusions - it is necessary to enter the diagnosis, date of diagnosis, scan of the conclusion (there may be several - for this year, last year, earlier), scan of studies (ultrasound, tests, etc. sorted by date), prescribed treatment, and frequency (date of the next examination for this disease with a reminder in the dashboard). A checkbox indicating that the diagnosis is valid. |
| 6 | Based on all valid chronic diseases, a printed form "Referral to VLC" should be created. This form can be used to refer a person for "weapon clearance" (then only some of the valid chronic diagnoses need to be selected). This form is also used when referring a person for hospitalization with a chronic disease or during an outpatient appointment (right part of the card) with an acute disease. It is necessary to select where the person is being referred and with which diagnosis. |
| 7 | The right part corresponds to the outpatient appointments of this person. Accordingly, complaints, examination, diagnosis, prescribed treatment, prescribed examination, tests. It is necessary to print referrals for examinations and tests. |
| 8 | Based on all primary information, a cover for the medical history is printed. 9. The dashboard should display on the selected date: 1. In the hospital - surname, diagnosis, hospital. 2. At the consultation - surname, which examination, which consultation. 3. Under control - surname, description. 4. Reminders for today and the next 3 days - surname, description of the reminder, and planned date. |
Applications 6
-
1 day45 USD
1 day45 USD
Good day, I have been working with databases and Access for over 10 years, I will complete everything quickly and efficiently.
-
Winning proposal21 days67 USD
392 Winning proposal21 days67 USD
Hello, Yuriy! I offer you a database on MySQL, which allows storing large arrays of data and is customizable in all aspects.
For your task, MySQL with the HeidiSQL interface and a simple program in Python to easily and quickly fill in new fields is the perfect solution.
I have been specializing in Python + MySQL for 2 years, so I am ready to offer you the most convenient solution!
-
1 day22 USD
265 1 day22 USD
Good day, I am writing on behalf of the company Devoxen. We specialize in the development and refinement of complex databases and medical/accounting systems with forms, access roles, document printing, and dashboards.
We have extensive experience working with similar systems where data structure, protection against accidental editing, form automation (submissions, reports, histories), and the logic of connections between patients, diagnoses, and appointments are crucial.
We can either carefully refine your current database or suggest a more stable architecture if it is already limiting development.
I propose we move to private messages for a more detailed conversation.
-
7 days22 USD
94 8 1 2 7 days22 USD
Good morning.
How about working with Google Sheets?
Data can be stored in tables, and a web interface can be developed based on app script m for management, output, searching, etc.
-
а чому саме аксес? Чому не якусь супабазу? Здоступом через інтернет і різні клієнти можна робити...
-
Юрію, хотілося б в першу чергу зрозуміти чому ви вибрали саме Access. вам потрібно рішення яке б працювало без доступу до мережі лише персональному на компютері ?
-
Current freelance projects in the category Databases & SQL
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 1 day 9 hours back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 2 days 2 hours back ∙ 9 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 2 days 20 hours back ∙ 88 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 2 days 23 hours back ∙ 16 proposals |
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 4 days 21 hours back ∙ 6 proposals |
Kharkiv