Providing and Tracking Education to healthcare providers Database

[msaleh]

Hello -


I have tried to modify a free from online DB to satisfy our needs, due to my zero knowledge in Access I keep getting error messages and keep failing. I gave up and trying to get some help please. Anyone that can help will be greatly appreciated. (See attachment)


Here is a general overview of what needs to be accomplished:
1. We provide Education either (one Educator-to- one healthcare provider) or (one or multiple Educators-to-one or multiple healthcare providers).


2. So, the education can be of TYPE ("Single", or "Multiple")


3. The education STYLE can be either ("New Provider Education" or "Demand Education")


4. I will have the following tables:
---"tbl_Educator" -- (Edcuator LName, Educator FName)


---"tbl_Education" -- (Type, Style, who is the educator, if the single education type then what is the name of the provider getting the education, and all his attribute like department, division, specialty, practice..., If a multiple education style then same idea but no need for one single provider, I need the number of providers received the education.)


I like the idea to get provider information from outlook if available otherwise to be entered.



---"tbl_Department",
---"tbl_Division",
---"tbl_Specialty",
---"tbl_Practice",
---"tbl_Medical Group"-- (three types, MG, MP, LH)



I will be happy to explian in more detail any needed information. Thank you so much for the help.

[ranman256]

this app should really start with a MAIN MENU form.

This is very bizzare why it keeps asking for company, but theres no reference to it , nor embedded code.
Im at a loss.

[msaleh]

My apology Ranman256, I am new to Access and was not sure how to make the modification correct. I hope someone will read my goal of the database needed and be able to help. Thank you for viewing.

[aytee111]

In order to be able to make modifications to someone else's database one must first have a good understanding of what the database is doing, and secondly to be able to change the parts that aren't working. I would not recommend using this database, it was not created by someone proficient in Access.

I recommend you start with an empty database, create the tables you have described above and go from there.