Help finding a simple template for Project assignment

[zb134]

Hi,



Let me start by saying I am an absolute noob to Ms Access.
What I am trying to do is a have a very simple project assignment database where I already have a list of employees. I want to assign some projects to employees. An project can have multiple employees.
I want to create reports to show either what projects and employee is working on or to look at a project and see who all are working on it.

I was wondering if there is a template for this somewhere or a tutorial.

[orange]

In very basic terms you will have 3 tables (underlined fields means Primary Key)

Employees(EmpId,EmpName,......other Employee specific fields)

Projects(ProjId, ProjName, ProjectStartDt,ProjectEndDt,.... other Project specific fields)

Junction table to keep track of Employees Working On Project

EmployeeOnProject(EmpOnProjID,[EmpId + Projid] as Unique Index, other fields specifci to this Employee Working On This Project...)

[zb134]

In very basic terms you will have 3 tables (underlined fields means Primary Key)

Employees(EmpId,EmpName,......other Employee specific fields)

Projects(ProjId, ProjName, ProjectStartDt,ProjectEndDt,.... other Project specific fields)

Junction table to keep track of Employees Working On Project

EmployeeOnProject(EmpOnProjID,[EmpId + Projid] as Unique Index, other fields specifci to this Employee Working On This Project...)

Thanks a lot!
I picked it up easier than I thought and made it as such.
I also made a switch board for easy access to everything.

One final question, is there any way to have reports printed on a system without MS access