training administration databas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Training Administration Database

Training Administration Database

resolvedResolved · Medium Priority · Version 2003

Anthony has attended:
Access Introduction course

Training Administration Database

Hi,

Newton Burgher delivered a very useful course for us yesterday and in it he mentioned a training admin tool he'd developed using Access 2003. Is there any chance I could see this?

RE: Training Administration Database

Hi there Anthony

I need to catch up with Newson to see which database he is relating to. He is out training at the moment so it may not be till Monday that I can get back to you.

It is worth mentioning that we do have extensive experience in database creation and troubleshooting consultancy. Having a better understanding of what you are trying to achieve can give us the opportunity to recommend some options to you. If you are interested to have a conversation on this please contact me.

Kind regards

Jacob

RE: Training Administration Database

Hello Jacob,

Thanks for getting back to me.

A colleague and myself are trying to produce a training administration database. At the moment we have only been able to get so far with Access.

What we need is something that can list:

*Employees and their individual details (i.e. department, d.o.b, gender etc)

*Training Courses and their details (i.e. Course name, number of days, course date, development area)

...and then we need to be able to produce attendance records for each course and also a "learning log" for each individual member of staff so that they can acess a list of what training they have attended/qualificaations they have received.

My guess is that we will need a table for Staff, a table for Courses and possibly a table for Attendance. Is that correct? The difficulty has come for us when we've tried to extract the required information from these tables. We found it difficult to establish how to Relate the fields and also how to produce tables with the necessary results.

I hope this is clear! If not, please let me know and I'll try again.

Any advice will be greatly appreciated.

Kind regards,

Anthony.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips


Server loaded in 0.09 secs.