L
LAC
Looking for existing template to allow me to track Physician/Provider License
expiration, contract expiration/renewals, etc.
expiration, contract expiration/renewals, etc.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Vinson
Looking for existing template to allow me to track Physician/Provider License
expiration, contract expiration/renewals, etc.
That's a VERY specific requirement; I very much doubt that anyone has
made such a database as a template (Microsoft certainly would not have
done so).
It sounds like you should create - or hire someone to create - a
custom database for you; this is in fact typically how databases are
built. Templates are not all that common and often need to be heavily
modified anyway.
To create the database yourself, identify the Entities - real-life
people, things, or events, such as Physicians, Practices,
ContractingAgencies, Contracts, Renewals, etc. Each type of Entity
gets its own table. Identify the Relationships: for instance, each
Physician might have several Contracts, and each Contract might cover
several Physicians; if so, you need another table, PhysicianContracts,
to link the two.
Each type of Entity has "attributes" - bits of information about the
entity, e.g. a Physician has a FirstName, LastName, probably some
other biographical info; each attribute becomes a Field.
If you need help setting this up, please post back.
John W. Vinson[MVP]
L
LAC
thank you
John Vinson said:That's a VERY specific requirement; I very much doubt that anyone has
made such a database as a template (Microsoft certainly would not have
done so).
It sounds like you should create - or hire someone to create - a
custom database for you; this is in fact typically how databases are
built. Templates are not all that common and often need to be heavily
modified anyway.
To create the database yourself, identify the Entities - real-life
people, things, or events, such as Physicians, Practices,
ContractingAgencies, Contracts, Renewals, etc. Each type of Entity
gets its own table. Identify the Relationships: for instance, each
Physician might have several Contracts, and each Contract might cover
several Physicians; if so, you need another table, PhysicianContracts,
to link the two.
Each type of Entity has "attributes" - bits of information about the
entity, e.g. a Physician has a FirstName, LastName, probably some
other biographical info; each attribute becomes a Field.
If you need help setting this up, please post back.
John W. Vinson[MVP]