If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with Hospitals Database
I work with a company that sells medical equipment to approximately 50 area
hospitals. The goal is to create a database that includes all the hospitals and then the doctors by specialty, the nurses by department and then other departments like receiving docks, etc as needed. How do I set this up?? I've already created a list in Excel and exported it into Access.... now I need help with forms, tables and relationships. I know it's not that difficult, just having a hard time "grasping the concept" and my boss is getting impatient. (don't blame him) Thank you very much!!! -- Jodi |
#2
|
|||
|
|||
Help with Hospitals Database
Jodi-Atlas Medical wrote:
I work with a company that sells medical equipment to approximately 50 area hospitals. The goal is to create a database that includes all the hospitals and then the doctors by specialty, the nurses by department and then other departments like receiving docks, etc as needed. How do I set this up?? I've already created a list in Excel and exported it into Access.... now I need help with forms, tables and relationships. I know it's not that difficult, just having a hard time "grasping the concept" and my boss is getting impatient. (don't blame him) Thank you very much!!! Do blame him. He needs to understand that although Access is a power tool, people need time and space to learn how to use it. Tell him the database can be quick, good, cheap (pick any two). Very briefly, you need to take this in stages if you're going to make a success of it. First, it's vital (!) that you understand the principles of table design, formally called "normalisation", and how you represent one-to-one, one-to-many and many-to-many relationships in combinations of tables and fields. These may help: http://www.lynda.com/home/Player.aspx?lpk4=31001 (free sample) http://tinyurl.com/ms-table-design-tutorial (free) If you spend 50% of your total time on getting your table design right it'll be 50% of a much smaller total time! Once you have your tables right, fool around with the various wizards to create queries, forms and eventually reports. You'll find that Access Wizards will "recognise" certain patterns of table design and offer options which will do a great deal of the work for you. Get your table design wrong and you'll be swimming against the tide. Forget everything except tables, relationships and queries at first. Is your customer a person or an institution, for example? Are you tracking orders and invoices or simply sales contacts? Pick a pivotal corner of the world you're modelling and come back with specifics. You might also play around with the "Northwind" database that comes as a sample with Access to get a flavour of what's possible. Access is powerful and rewarding, but it does take the best of us time to master it. Phil, London |
#3
|
|||
|
|||
Help with Hospitals Database
Jodi
If I hear something from one person, it might be them. If I hear the same thing from two people, I may need to pay attention... What Philip said ... times 2! Regards Jeff Boyce Microsoft Office/Access MVP "Jodi-Atlas Medical" wrote in message ... I work with a company that sells medical equipment to approximately 50 area hospitals. The goal is to create a database that includes all the hospitals and then the doctors by specialty, the nurses by department and then other departments like receiving docks, etc as needed. How do I set this up?? I've already created a list in Excel and exported it into Access.... now I need help with forms, tables and relationships. I know it's not that difficult, just having a hard time "grasping the concept" and my boss is getting impatient. (don't blame him) Thank you very much!!! -- Jodi |
#4
|
|||
|
|||
Help with Hospitals Database
On Thu, 17 Sep 2009 09:23:01 -0700, Jodi-Atlas Medical
wrote: I work with a company that sells medical equipment to approximately 50 area hospitals. The goal is to create a database that includes all the hospitals and then the doctors by specialty, the nurses by department and then other departments like receiving docks, etc as needed. How do I set this up?? I've already created a list in Excel and exported it into Access.... now I need help with forms, tables and relationships. I know it's not that difficult, just having a hard time "grasping the concept" and my boss is getting impatient. (don't blame him) Thank you very much!!! Well... Access isn't "Excel on Steroids". It's very different, and requires a different mindset. You'll need quite a few tables: Hospitals; Doctors; Specialties; Departments; Nurses; etc. It's vital that you get a properly normalized set of tables FIRST before you start messing with forms and reports! Here's some resources to get started; or post back with specific questions, we'll be glad to help. Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html Roger Carlson's tutorials, samples and tips: http://www.rogersaccesslibrary.com/ A free tutorial written by Crystal: http://allenbrowne.com/casu-22.html A video how-to series by Crystal: http://www.YouTube.com/user/LearnAccessByCrystal MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Help with Hospitals Database
Thank you very much! I'll let you know how it works out!
-- Jodi "John W. Vinson" wrote: On Thu, 17 Sep 2009 09:23:01 -0700, Jodi-Atlas Medical wrote: I work with a company that sells medical equipment to approximately 50 area hospitals. The goal is to create a database that includes all the hospitals and then the doctors by specialty, the nurses by department and then other departments like receiving docks, etc as needed. How do I set this up?? I've already created a list in Excel and exported it into Access.... now I need help with forms, tables and relationships. I know it's not that difficult, just having a hard time "grasping the concept" and my boss is getting impatient. (don't blame him) Thank you very much!!! Well... Access isn't "Excel on Steroids". It's very different, and requires a different mindset. You'll need quite a few tables: Hospitals; Doctors; Specialties; Departments; Nurses; etc. It's vital that you get a properly normalized set of tables FIRST before you start messing with forms and reports! Here's some resources to get started; or post back with specific questions, we'll be glad to help. Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html Roger Carlson's tutorials, samples and tips: http://www.rogersaccesslibrary.com/ A free tutorial written by Crystal: http://allenbrowne.com/casu-22.html A video how-to series by Crystal: http://www.YouTube.com/user/LearnAccessByCrystal MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials -- John W. Vinson [MVP] |
#6
|
|||
|
|||
Help with Hospitals Database
Good point - I will take that to heart, I will learn this program and get
this database working so that my boss will be happy! Thank you for your words of wisdom! -- Jodi "Jeff Boyce" wrote: Jodi If I hear something from one person, it might be them. If I hear the same thing from two people, I may need to pay attention... What Philip said ... times 2! Regards Jeff Boyce Microsoft Office/Access MVP "Jodi-Atlas Medical" wrote in message ... I work with a company that sells medical equipment to approximately 50 area hospitals. The goal is to create a database that includes all the hospitals and then the doctors by specialty, the nurses by department and then other departments like receiving docks, etc as needed. How do I set this up?? I've already created a list in Excel and exported it into Access.... now I need help with forms, tables and relationships. I know it's not that difficult, just having a hard time "grasping the concept" and my boss is getting impatient. (don't blame him) Thank you very much!!! -- Jodi |
#7
|
|||
|
|||
Help with Hospitals Database
You need some database background. Fortunately MVP Crystal Long has both
downloadable and video tutorials which will help: http://www.accessmvp.com/Strive4Peace/Index.htm -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Jodi-Atlas Medical" wrote in message ... I work with a company that sells medical equipment to approximately 50 area hospitals. The goal is to create a database that includes all the hospitals and then the doctors by specialty, the nurses by department and then other departments like receiving docks, etc as needed. How do I set this up?? I've already created a list in Excel and exported it into Access.... now I need help with forms, tables and relationships. I know it's not that difficult, just having a hard time "grasping the concept" and my boss is getting impatient. (don't blame him) Thank you very much!!! -- Jodi |
Thread Tools | |
Display Modes | |
|
|