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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help on Database design
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 whe 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... -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200907/1 |
#2
|
|||
|
|||
Help on Database design
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 http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ "new2access via AccessMonster.com" u51724@uwe wrote in message news:993f796d457c1@uwe... 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 whe 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... -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200907/1 |
Thread Tools | |
Display Modes | |
|
|