Need a training database

[mikemwa]

I am trying to create a Microsoft Access training database for us at work and I’m not having much success. Can someone look at what I’ve done so far and see if they can make it work or if you know of one out there already that I could download and use that would probably even be better. If there is more to it than just training then that it’s probably better too because I want to expand this as I get time.

Thanks,

Mike

 

[KornGeek]

It seems from your post that what you are asking is "will somebody do this for me?" The forums work best when the question is more of a "I'm stuck trying to get this piece to work. Here is what is happening and here is what I've tried. What should I try next?"

This way, you learn, other who get stuck on the same (or similar) issues learn, and nobody is tackling large projects pro bono.

 

[missinglinq]

Welcome to the forum, mikemwa! While we're talking of forum etiquette, please don't post the same question in two or more spots here. Members in one area may end of wasting time making suggestions that have already been posted in another area. Pick the most approprite place and post there.

Now to the question at hand. Exactly what kind of a "training" database are you looking for? A db to practise your development skills, or one to use to train end users with? And have you taken a look at Northwind?

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[lespaul]

Or one to track mandatory training of employees?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[mikemwa]

I didn't post twice on porpose. I think what happened was When I was about finished we got company. Then when I got back I thought I was still working on it and posted again by accident.
Anyway, is there a way to add attachments to the messages. I can attach the file and explain what I want and the problems I'm having.

Mike

 

[lespaul]

No, there's no way to attach the file. if you have access to a website, you could post it there.

But expecting us to mess around with your database without even knowing the basics of what kind of troubles you are having and what your database is expected to do is unreasonable. You should be able to put into words what your database does....that is all anyone has asked for at this point.



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[Golom]

For example ... not everyone has exactly the same interpretation of the phrase "... Training Database ...".

Who are you training and what kind of training?

- End Users?
- Programmers?
- New Employees?

- Basic Operating Principles?
- Demonstration of New Features?
- Programming Constructs?
- Database Architecture?

 

[mikemwa]

This is just to keep track of past training and future training for a small factory that I just started working for recently. Right now they have everything on paper. The boss was wanting to use Excel and I opened my big mouth and said that Access would be better. I've done some work with Access but certainly am not an expert. We just want to be able to get the info we have into a database and be able to add more as we have more training. What I was trying to do was to have separate forms each for Personal info, Employee info, training info, yearly evaluation, and probably a couple more if I think of them. I've started one but I don't know how to tie it all together and it's not working like I was hoping. The training is things like Forklift, the machines we use etc.

 

[lespaul]

That's very helpful! Have you read the Fundamentals link I provide in my signature? It will give you the basic understanding of how the table structure should be developed and it's something that every MVP will have expected you to have read before starting this project.

By articulating what you want, you have already begun the design process. You have Employees, Evaluations, Training, Training that Employees have taken, perhaps you also need Training that employees NEED to take...this information will help you decide what TABLES you need (these are technically called entities). Now you need to identify the data that you want to store about these entities, these are the attributes. For Employees, you may want to have such information as FirstName, LastName, Address, StartDate, TerminationDate, Position. These will become the fields in the table.

After you complete the remaining steps outlined in the Fundamentals document and believe that your table structure is in 3NF, come back and show us what you came up with and examples of the types of data you are planning on storing and we'll critique and help you improve upon it until it works for you.

HTH


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi