A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Employee Training Database



 
 
Thread Tools Display Modes
  #1  
Old December 16th, 2008, 07:40 PM posted to microsoft.public.access.tablesdbdesign
Shon[_2_]
external usenet poster
 
Posts: 12
Default Employee Training Database

Hello,
I'm in a position of having to develop some type of training db
for my company. I must admit I'm not the most enthusiastic MS Access person
but have been trying to work my way through. I've taken a few classes but the
information covered was not relevant to what I need. It seems so complicated
building the different tables and then making sure everything is linked
together. I that something was mentioned about classroom management. Where
can I find out more about that?

Any and all help greatly appreciated!

  #3  
Old December 17th, 2008, 12:52 AM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default Employee Training Database

Steve" replied in message
... for a modest fee.


You can't be serious.
Surely *no one* could be as slow a learner as you appear to be.
  #4  
Old December 17th, 2008, 12:56 AM posted to microsoft.public.access.tablesdbdesign
John... Visio MVP
external usenet poster
 
Posts: 900
Default Stevie the troll is harrassing the posters again!

"Steve" wrote in message
m...
I provide help with Access applications for a modest fee. I have developed
several training databases. I can help you with your training database.
Contact me at .

Steve



These newsgroups are provided by Microsoft for FREE peer to peer support.
Stevie is a known troll who enjoys ignoring that fact and had been
harrassing posters for more than haf a decade.

The fact that he has to continually grovel for work indicates that he has
never impressed his former clients enough for repeat business. His other
posts in these newsgroups are also a testiment to his lack of
professionalism and the lack of quality in his work.

John... Visio MVP

  #5  
Old December 17th, 2008, 01:05 AM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default Employee Training Database

Hi Shon.

There is quite a bit of work in setting up a training database. As a
minimum, you probably need:
- a table of persons (trainers and trainers)
- a table of units (the subjects taught from time to time)
- a table of classes (each time a subject is offered)
- a table of enrollees (who is enrolled in a class)

You probabaly also need to identify peoples roles, and what units are
expected for each role. From that you can deduce what units each person
should have covered. This will let you identify the gaps (what units they
have not covered, or units where their competency has expired.)

There may be other tables to track attendance, assesssment criteria,
evaluation of each person's criteria, and qualifications/competences earned.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Shon" wrote in message
...
Hello,
I'm in a position of having to develop some type of training db
for my company. I must admit I'm not the most enthusiastic MS Access
person
but have been trying to work my way through. I've taken a few classes but
the
information covered was not relevant to what I need. It seems so
complicated
building the different tables and then making sure everything is linked
together. I that something was mentioned about classroom management.
Where can I find out more about that?

Any and all help greatly appreciated!


  #6  
Old December 17th, 2008, 09:27 AM posted to microsoft.public.access.tablesdbdesign
Keith Wilby
external usenet poster
 
Posts: 812
Default Employee Training Database

"Steve" wrote in message
m...
I provide


http://home.tiscali.nl/arracom/whoissteve.html

  #7  
Old December 17th, 2008, 02:21 PM posted to microsoft.public.access.tablesdbdesign
Shon[_2_]
external usenet poster
 
Posts: 12
Default Employee Training Database

Thank you so much for responding to my request. This sounds way more
complicated than I think my schedule allows. Can you recommend any software
that may help me?

Thanks again

"Allen Browne" wrote:

Hi Shon.

There is quite a bit of work in setting up a training database. As a
minimum, you probably need:
- a table of persons (trainers and trainers)
- a table of units (the subjects taught from time to time)
- a table of classes (each time a subject is offered)
- a table of enrollees (who is enrolled in a class)

You probabaly also need to identify peoples roles, and what units are
expected for each role. From that you can deduce what units each person
should have covered. This will let you identify the gaps (what units they
have not covered, or units where their competency has expired.)

There may be other tables to track attendance, assesssment criteria,
evaluation of each person's criteria, and qualifications/competences earned.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Shon" wrote in message
...
Hello,
I'm in a position of having to develop some type of training db
for my company. I must admit I'm not the most enthusiastic MS Access
person
but have been trying to work my way through. I've taken a few classes but
the
information covered was not relevant to what I need. It seems so
complicated
building the different tables and then making sure everything is linked
together. I that something was mentioned about classroom management.
Where can I find out more about that?

Any and all help greatly appreciated!



  #8  
Old December 18th, 2008, 02:20 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default Employee Training Database

Shon,

If I may be direct, you've not really defined what you are trying to do.

Also, you have to decide whether or not you want to learn Access well enough
to create your application or not. It will be work and a struggle, but for
someone with that objective, worth it. From your initial comment plus
saying that you want some software to do it for you, it sounds like you are
saying "NOT". If so, then you're on the wrong track in asking for tips on
how to do what you don't want to do. While I certainly wouldn't go to a
forum abuser, you might use a search engine to find an Access developer to do
it for you. Or you might start with spreadsheets or Word processor tables
that lists courses, instances of people taking courses etc. Not a good
platform for data that is inherently relational, but it's something.
  #9  
Old December 19th, 2008, 02:35 PM posted to microsoft.public.access.tablesdbdesign
Bob Waggoner[_2_]
external usenet poster
 
Posts: 80
Default Employee Training Database

..Shon,
There is another way - open Access, select NEW from the File Menu, go to
Templates Online and select Classroom Management. Access creates the database
for you. Once that is done, you can study how it works and learn from that
while you have fulfilled your obligation to the company.

"Shon" wrote:

Hello,
I'm in a position of having to develop some type of training db
for my company. I must admit I'm not the most enthusiastic MS Access person
but have been trying to work my way through. I've taken a few classes but the
information covered was not relevant to what I need. It seems so complicated
building the different tables and then making sure everything is linked
together. I that something was mentioned about classroom management. Where
can I find out more about that?

Any and all help greatly appreciated!

  #10  
Old January 10th, 2009, 04:17 AM posted to microsoft.public.access.tablesdbdesign
shokoh
external usenet poster
 
Posts: 2
Default Employee Training Database


"Fred" wrote in message
...
Shon,

If I may be direct, you've not really defined what you are trying to do.

Also, you have to decide whether or not you want to learn Access well

enough
to create your application or not. It will be work and a struggle, but

for
someone with that objective, worth it. From your initial comment

plus
saying that you want some software to do it for you, it sounds like you

are
saying "NOT". If so, then you're on the wrong track in asking for tips on
how to do what you don't want to do. While I certainly wouldn't go to a
forum abuser, you might use a search engine to find an Access developer to

do
it for you. Or you might start with spreadsheets or Word processor

tables
that lists courses, instances of people taking courses etc. Not a good
platform for data that is inherently relational, but it's something.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.