Normalization review of my DB

[mlrucci]

Good afternoon, I have been working on a db for the last couple of months. Unfortunately, I am new to Access and have created a db that is not normalized (thank you for the input Ridders52) which has caused havoc on my current db. I was getting a -1104 and 3048 error after splitting my db. I am hoping someone can review my new thought process and see if I am building the it correctly. The base of my database is as follows. First, there are two types of strokes Ischemic and Hemorrhagic. The Ischemic Stroke can have two procedures TPA and/or Thrombectomy or it could just be a Thrombectomy. The hemorrhagic stroke there is only one procedure. I would like the Ischemic stroke to have to same ID so that I can pull the potential corresponding Thrombectomy to be audited and reviewed.

Let me better explain what I am attempting to do. I am attempting to develop a database that will gather information from auditing charts as to make sure the information required is being documented correctly. We have approximately 5 charts a day to review. If the charting is not completed appropriately, then I address and correct while still pulling stats. There could be multiple individuals involved with this process. Each of the audits are done in incremental periods. Each document has the following information:

1. Name and Date of Birth (the ID is the patient’s MRN) (tblMRN)
2. Specific data based on the type of audit (such as date/times of procedures and arrivals and medications)


3. Baseline assessment scores (tblNIHSS)
4. Ordered vital sign parameters
5. Hospital (tblHospital)

Each of the procedures (3) must have an assessment done at different incremental periods based on the procedure. Currently, we are using Word to try and track that information. As you can imagine, this is a nightmare and very inconsistent. All of the procedures audited there needs to be the following (or variations of):

a. Date of entry
b. Time of entry
c. Vital Signs (Yes/No)
d. BP Parameters (Yes/No)
e. GCS (Yes/No)
f. Pupils (Yes/No)
g. Motor/sensory (Yes/No)
h. Headache (Yes/No)
i. NIHSS (tblNIHSS)
j. Employee making the entry (this is based on tblEmployee)
k. Comment area



For TPA and Thrombectomy Every 15 minutes above needs to be documented for 2 hours

For TPA and Thrombectomy Every 30 minutes above needs to be documented for 6 hours

For TPA and Thrombectomy Every 1 hour the above needs to be documented for 16 hours

The Hemorrhagic is every one hour for 24 hours

In addition to the normalization of my tables, it has been brought to my attention that I need to stop using Lookup for my tables as it causes too many issues with the stabilization of the db. Because of this this, I am not familiar with how to link the tables without it. Would you just connect with the relationships and under the row source put the location (ex: SELECT [tblHospital].[HospitalID], [tblHospital].[HospitalName], [tblHospital].[HospitalActive] FROM tblHospital ORDER BY [HospitalID] or would just put the table in the row source section? I have enclosed a copy of the word document they have been using and my new db for your review.

Again, thank you very much for your help.

tPA Audit Form.zipStrokeAudit2.0_Dawn.accdb.zip

[June7]

Establish table links in Relationship builder although is not absolutely required for a functional db. Use comboboxes for 'lookups'. RowSource can be table, query, or SQL statement.

[mlrucci]

Establish table links in Relationship builder although is not absolutely required for a functional db. Use comboboxes for 'lookups'. RowSource can be table, query, or SQL statement.

thank you for the help with the relationships. Any feedback on the development of the tables for normalization?