Windows 7 64bit 
Access 2007
Ok, I am new to Access and have been reading Access 2007 The Missing Manual to help learn the software as well as reading some posts here. I need to create a database to be able to track tasks that a set of people do. There 50 people that will be tracked and information needs to include the date, location they were working, hours worked, name, and the the actual items being tracked (basically the number of times per day that they perform a certain task). I currently have all of this information setup in a single table. The problem however is that different parts of the data are going to be entered into the database at different times. So lets say the first bit of data that gets entered is schedule information which includes the EmployeeName, Date, Location, and HoursWorked. At another time or day the next set of information for that record to be entered will be goal information which is about 5-7 different numbers. And yet at another time or date, the actual tracking numbers themselves will be entered. I guess where I am getting confused is how to either go back and edit a record that has already been entered to fill in the remaining fields or does the one large table need to be broken up somehow into separate tables such as Schedule/Goals/Actual and if so, I am not sure how they would all need to be linked to make sense of the data later in a report? Please forgive my ignorance and I hope I explained that somewhat coherently, I am here to learn I hope!!
Reply With Quote
