Thread
:
Table Design - Spreadsheet-like data
View Single Post
#
2
December 4th, 2009, 11:48 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
Posts: 1,017
Table Design - Spreadsheet-like data
I suggest the following tables:
TblDepartment
DepartmentID
Department
TblEmployee
EmployeeID
BadgeNumber
FirstName
LastName
DepartmentID
TblRole
RoleID
Role
TblCourse
CourseID
Course
TblRoleRequiredCourse
RoleRequiredCourseID
RoleID
CourseID
TblEmployeeRole
EmployeeRoleID
EmployeeID
RoleID
TblEmployeeCourseCompleted
EmployeeCourseCompletedID
EmployeeID
CourseID
DateCompleted
Steve
"Cheryl" wrote in message
...
I am new to Access (using 2007) and partly as a learning experience, I'm
trying to build a database to handle training records for my division.
So far I have four tables - although I'm not sure I really need one of
them
- tblEmployees, tblRoles, tblCCC, and tblCourses. tblCCC is a list of
department identifiers and is the one that might go away. I will probably
need another table for employee roles, since an employee can have multiple
roles. And of course I will need a table to hold the actual training
data.
tblEmployee contains lngAutoID, strBadge (PK), strLastName, strFirstName,
strCCC, ysnActive
tblRoles contains lngAutoID (PK) and strRoles
tblCourses contains lngAutoID (PK) and strCourseName
Courses are assigned to an employee based on their role. I have an Excel
spread sheet with roles as column headers (B2:K2) and class names down
column
A (A2:A26). An X in the intersection between role and class indicates
that
that class is required for that role.
How do I take that data and turn it into Access object(s) that I can
query,
use in reports, etc. Any other thoughts on the design thus far would be
greatly appreciated!
Thank you!
Steve[_77_]
View Public Profile
View message headers
Find all posts by Steve[_77_]
Find all threads started by Steve[_77_]