Which template to use? LEGOLAND Help!!!

[Ant_LEGO]

Hey guys,

I am new pretty green to Access but have used it a little when I was in college. I recently started a new job for LEGOland and the person before me was using Excel to track some employee information and it is a mess. I have been racking my brain on how I want to reorganize everything and I have decided that Access is the way to go. That being said I don't really have the knowledge to build it from the ground up and was wondering if I could get some suggestions on a template to use. I need something very basic that would really just organize Departments within departments, then employees within those departments, then awards given to those employees.

kind of like this

Department 1-----Department A------ Employee A------ Awards

there are about 5 main departments then 2-5 sub departments within each

any help would be amazing and if you are in southern California maybe I could repay you somehow for a tip haha. Kids sure love visits here

[aytee111]

Google Access templates, there are lots out there.

If you wish to learn Access and/or do this yourself, here are some links (post # 7):
https://www.accessforums.net/showthread.php?t=65906

[Ant_LEGO]

Hey guys,

I am new pretty green to Access but have used it a little when I was in college. I recently started a new job for LEGOland and the person before me was using Excel to track some employee information and it is a mess. I have been racking my brain on how I want to reorganize everything and I have decided that Access is the way to go. That being said I don't really have the knowledge to build it from the ground up and was wondering if I could get some suggestions on a template to use. I need something very basic that would really just organize Departments within departments, then employees within those departments, then awards given to those employees.

kind of like this

Department 1-----Department A------ Employee A------ Awards

there are about 5 main departments then 2-5 sub departments within each

any help would be amazing and if you are in southern California maybe I could repay you somehow for a tip haha. Kids sure love visits here

[June7]

An organization hierarchy database is a type of recursive database. Manufacturing/assembly and family tree are other examples. IMHO, the most difficult kind of database to understand and design. Review https://www.youtube.com/watch?v=s2gKxkJ_sXM. Unfortunately, some of the most efficient query techniques are not available in Access - review http://www.dbta.com/Columns/DBA-Corn...SQL-96878.aspx

[Ant_LEGO]

Thank you so much! This is a great place for me to start

[pbaldy]

Duplicate threads merged since both had replies. In the future, there's no need to post the same question twice. Welcome to the site!