looking for help setting up employee journal database

[Tommy]

I am looking for a template or help setting up an employee journal database
that needs to include Name, Employee #, Hire date, with space for a topics
discussed section that can be time and date stamped.

 

[John Vinson]

I am looking for a template or help setting up an employee journal database
that needs to include Name, Employee #, Hire date, with space for a topics
discussed section that can be time and date stamped.

Sounds like you've gone a long way toward doing this yourself!

I don't know of a template, but a very simple two-table database would
be a good start:

Employees
EmployeeID <Primary Key> (Don't us # in fieldnames)
LastName
FirstName
MiddleName
Suffix
HireDate

Discussions
DiscussionID Autonumber Primary Key
DiscDate Date/Time
TopicDiscussed Text


A simple Form based on Employees, with a subform based on Discussions
would work for data entry; you could set the Default Value of the
textbox bound to DiscDate on the subform to Now() to timestamp each
record with the date and time it was entered.

If you have a standard list of topics, you might add that as a lookup
table; you might also want a Memo field in discussions wherein to
enter the outcome of the discussion, comments about it, etc.

John W. Vinson[MVP]

 

[mnature]

Microsoft has several templates that might work for you. This link takes you
to a page for business templates, and there is one for Event Management, and
another for Issues. Also, when you start Access, there is an option for
using a template from your computer, and there are a variety of templates
available that way also. Depending on why you need an employee journal, one
of those might be easily modified for your application.

http://office.microsoft.com/en-us/templates/CT011366681033.aspx

 

[Bob Miller]

John, I would also want EmployeeID Foreign Key in the Discussions tabl
so that each discussion can be linked to the appropriate Employee.
The report would link to the subreport via this.

I am looking for a template or help setting up an employee journa
database
that needs to include Name, Employee #, Hire date, with space for
topics
discussed section that can be time and date stamped.

Sounds like you've gone a long way toward doing this yourself!

I don't know of a template, but a very simple two-table database would
be a good start:

Employees
EmployeeID Primary Key (Don't us # in fieldnames)
LastName
FirstName
MiddleName
Suffix
HireDate

Discussions
DiscussionID Autonumber Primary Key
DiscDate Date/Time
TopicDiscussed Text


A simple Form based on Employees, with a subform based on Discussions
would work for data entry; you could set the Default Value of the
textbox bound to DiscDate on the subform to Now() to timestamp each
record with the date and time it was entered.

If you have a standard list of topics, you might add that as a lookup
table; you might also want a Memo field in discussions wherein to
enter the outcome of the discussion, comments about it, etc.

John W. Vinson[MVP

 

[John Vinson]

John, I would also want EmployeeID Foreign Key in the Discussions table
so that each discussion can be linked to the appropriate Employee.
The report would link to the subreport via this.

Oops! Of course - thanks Bob, good catch!

John W. Vinson[MVP]