Jumat, 23 Mei 2014

[MS_AccessPros] Convert Spreadsheet to database

 

I am trying to convert a spreadsheet with the months as columns across the top and names on the left and the data for each month pertaining to the names would be check boxes. There would be a need for years obviously.

Do I create a table with each of the months as one field or each month being its own field? I just cannot picture it in my head.

the fields would needed are
Supervisor ID (is a number assigned to the Supervisor)
Department ID (is a number assigned to the Department)
Employee Name 1 (there are 2 employees assigned to a task)
Employee Name 2 (there are 2 employees assigned to a task)
Task (the name of the task)
Type (the task type)
Month (the month the task was completed)

Thank You for any assistance

Jim Wagner

Sent from Yahoo! Mail for Windows 8

__._,_.___

Posted by: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar