I am building a medical insurance database in my existing DB. This is for billing purposes. For eg, I have to bill an insurance for a patient on the day of visit. There are many CPT codes (procedure codes) with its prices. Now the insurance pays me the contracted rate and the rest has to get adjusted. Sometimes there is a balance which is charged to the patient and sometimes its $0. Now the same patient can have multiple insurances, so I have to bill the primary and then bill the balance to the secondary.
I checked all the seminars and cannot decide which will come close to what I want. I have built one on my own but it is not enough for me to track which ones have paid, which needs to be billed to the pt and which need to be rebilled. Can you suggest which one may work for me?
Scott Axton 3 years ago
My opinion is that you should not try and cherry pick your knowledge by jumping into this seminar or that one. Many of the Seminars contain some pretty advanced concepts that you just have to have the base knowledge for.
The Seminars are not intended to be stand alone programs that you plug into your database. They usually contain lots of related information to a specific subject that are more in depth than Richard can cover in a 20 - 30 min. TechHelp video.
Instead, your time and money really would be better spent following in the courses, one at a time, in order. Richard teaches you the "How and Why" of doing certain things in MS Access. There isn't any course that does exactly what you asked above. This really is a case of you have to learn how to crawl, then walk, before you can run.
Once you have the base knowledge you can apply what you have learned to solving nearly ANY database problem you are working on.
It's difficult for me to say, because I don't know your level of knowledge with Access. I see you've only completed my Beginner lessons, so I would say definitely finish the first few Expert levels and make sure you understand relationships WELL. If I were to build something like this, I'd probably submit the bill to the primary insurance, then record their payment, then COPY the invoice to send to the secondary insurance. This is going to require knowing how to copy a record with all of the dependent child records. Definitely a Developer-level topic. I cover that in Developer 24.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Seminars.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
