How do I create a database for company policies and procedures?

  • Thread starter Thread starter Tabra
  • Start date Start date
T

Tabra

It should allow me to link staff to those policies and procedures that apply
to their positions in the organisation. Ultimately we hope to create one
large dB to hold all standardised information that all staff can access based
on their positions.
 
Thanks Stefan but I have spent six hours today scrolling through and
evaluating all the templates in Microsoft website and have found nothing
really suitable.
 
hi Tabra,
Thanks Stefan but I have spent six hours today scrolling through and
evaluating all the templates in Microsoft website and have found nothing
really suitable.
Click to expand...
Searching for 'employee organisation policy' shows some useful basic
templates. Maybe you need to pick two or three of them and merge them to
get your desired results.


mfG
--> stefan <--
 
Thanks Stefan but I have spent six hours today scrolling through and
evaluating all the templates in Microsoft website and have found nothing
really suitable.
Click to expand...

The templates aren't really designed as fully-functional, ready to run
applications specific to your business. Instead, they are suggestions,
starting points, for your own (or your hired developer's) use in creating a
customized database.

Databases are complicated. They need a lot more thought and more work than
(say) an Excel spreadsheet or a Word document. Here are some resources to get
you started:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/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
 
I have an Access2007 database I built for a historical society to hold
"historical references" (information and attachments) that relate to people.
It would be close. It doesn't have security (example: Bill Smith the
marketing guy can only see certain policies/procedures, but the rest is
probably pretty close to what you need).

When you pull up the detail screen for a person it shows that person's
information on the general tab and another tab showing historical references
associated with that person.

When pulling up a historical reference it shows the historical reference
information and associations to people.

Mine also has other relationships (like people to people and historical ref
to historical ref).

I did a ribbon on the top with simple buttons and used split forms to show
the lists of people and historical references. Simple searching and
filtering of people and historical reference lists. A few reports. All
code no macros (except the autoexec macro).

The table design is very close to what Ken Sheridan indicated.

I would be willing to email you some screenshots or possible an ACCDE
version of the database if that would help? You could look at the tables
etc....

Use the email from my website if you want to contact me (I don't check
newsgroups everyday).

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com
 
Back
Top