Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-11-2011, 06:59 AM
hektisk hektisk is offline Access or Excel? Windows 7 32bit Access or Excel? Office 2010 32bit
Novice
Access or Excel?
 
Join Date: Apr 2011
Posts: 6
hektisk is on a distinguished road
Default


Quote:
The benefit lies in being able to retrieve data by hospital/doctor when doing data entry (you don't have to input all the details every time) and for subsequent reporting. If you know they're in the data in a consistent format, that makes retrieval much simpler.
Details of what? I apologize - I don't mean to be obtuse. We would store no data except for their name on the hospitals and doctors in this database. So we wouldn't, for example, store the doctor's address or the hospital's phone number. I'd plan on creating a lookup with fixed values (drop-down box) to ensure consistency. If I were to create new tables for hospitals and doctors, why would I not create tables for every other column which has a pre-set number of options (such as the wounds or infections columns)?


If I understand Access' reporting capabilities (and I may not!), I don't think I'll have to do mail merges right now. Our health care-specific accounting package has all of the information needed for mailings, and since mass mailings come out of the business office, they'd continue using that program. This project is not meant to replace that program but rather store data and create reports otherwise unavailable to us.

What I was planning on doing, for now, was just running with the Excel workbooks and then importing them to Access when I had the forms ready. (I'm comfortable that the data entry folks can use the bulky spreadsheet I created!). In fact, our hospice has already started using the workbook I created for them. In giving it more thought, I can see why it's necessary to interface with both programs. Our hospice workbook automatically calculates the next assessment period, which is vital for hospice operations, and I doubt there's a way to comfortably replicate these calculations in Excel. Maybe a linked workbook is the answer, I don't know. I have a lot of researching to do!

Also, there are some sample reports hidden in the Excel workbook I uploaded. While the links are broken (the reports were designed early in the process), you can see what I was trying to do.
Reply With Quote
  #2  
Old 04-11-2011, 04:24 PM
macropod's Avatar
macropod macropod is offline Access or Excel? Windows 7 32bit Access or Excel? Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by hektisk View Post
Details of what? I apologize - I don't mean to be obtuse. We would store no data except for their name on the hospitals and doctors in this database. So we wouldn't, for example, store the doctor's address or the hospital's phone number. I'd plan on creating a lookup with fixed values (drop-down box) to ensure consistency. If I were to create new tables for hospitals and doctors, why would I not create tables for every other column which has a pre-set number of options (such as the wounds or infections columns)?
Well, if you're planning "on creating a lookup with fixed values (drop-down box) to ensure consistency", that's a definite candidate for a table in its own right. I imagine your 'catchment' in this regard is for the most part fairly limited, so the number of entries to go into and be maintained in the table would be relatively small.

And, yes, you could create another look-up table for 'conditions' but I imagine there'd be so many variations compared to the number of patients that the effort in creating and maintaining it would outweigh the potential benefits.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel to lookup Access Database PeterP Excel 1 06-11-2009 12:33 PM
Access or Excel? Should I uses Access or Excel? tinkertron Office 5 03-29-2009 08:30 PM
Excel or Access ? inferno Excel 0 10-03-2008 03:42 AM
Delete excel files by code in Access Barry Richardson Office 0 06-13-2005 06:26 AM
Access or Excel? MS ACCESS - Import from Excel problem Gregory_in_Montauk Office 6 05-06-2005 08:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft