Help on Database design

[new2access via AccessMonster.com]

I am about to design a employee training database that will answer the
following questions:

- List all training sessions which were conducted in the month of January
2009?
- How many training sessions have been conducted until the present date?
- Which company has the highest rate of No-Shows?
- Which potential trainees are due for training in the month of December 2009?

- How many trainees have successfully completed Janitorial 105?
- List the vacation dates for each instructor?
- How many instructors are available for the month of June 2009?
- Which instructors specialize in giving Arabic Lectures?
- List down all the contractor workforce which understands the Hindi language?

- List down all names which have been absent at their assigned training
session 3 or more times?

What do i need or do in order to meet the requirements of this database? i am
planning of having 4 tables (Employees, Instructors, Courses & Training
History)

and is it possible for a database to generate a unique ID like for example:
101-NWS-22-06
where:
101 (Course No - from Course Table)
NWS (Initial of Instructor - from the Instructor table)
22-06 (Course Date - June 22)

I really need your expertise in designing this database.
That's it for now...

 

[Jeff Boyce]

These newsgroups work well in helping people answer fairly specific
questions about Access. Your questions seem more in line with a full-blown
development project. I don't know if you'll find any volunteers here
able/willing to dedicate the time to build you a system (or even lay out all
the considerations).

If you are unfamiliar with normalization and relational database design,
that would be a very good place to start. What are the "entities" and
"relationships" you are working with?

If you have some experience with these, then the next step is working on how
Access does what it does. If you are new to Access, plan to spend some time
learning. But you might not need to build this from scratch ... consider
searching on-line for employee training databases/applications. There might
be something available at low/no cost that you could adapt -- you'd either
adapt how you do business to fit how the application works, or adapt the
application to fit how you work.

How many people will be using this application? Be aware that Access is NOT
like Word or Excel. It isn't a "bookcase", it's a powertool that you use
to build bookcases. So if you don't have experience designing easy-to-use
graphical user interfaces, plan on spending more time learning this! "Easy
.... is HARD!" Creating an application that focuses the users on what they
need to get done instead of how they need to learn to use the tool is much
more difficult (for you) than just handing them the raw Access file and
hoping they don't break something...

And don't think you can get out of all of the above if you decide to hire
someone instead of build it yourself. If you don't have a way to evaluate
what the hired developer is claiming, how will you evaluate who's best for
the job?!

Best of luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[J. Williams]

Try http://accesstrainingdatabase.blogspot.com/. The employee training
database templates here aren't free, but are affordable (under $20) and easy
to use. The deluxe version seems to be what you describe.