This is probably pretty simple but I haven't worked with ACCESS since my college days over 15 years ago and am struggling to relate some fields. Is there training out there I could take a few hours out of my day to look over and follow some tutorials or work examples?
Excuse me for my ignorance on Access but I think it's a tool to greatly help budgeting and financial reporting out.
I am trying to figure out the best way to set up a work order report for all of my employees. What I want is to keep it simple, the fields will only be Date, Employee Name, Work Performed, Hours and Cost. Date is standard, Employee Name will be a drop down list of all the employees BUT I WANT to associate a hourly rate to their name. Work Performed will be a drop down list I can create. Hours will be numerical and then the Cost should be Hours multiplied by the Employee Name (since it should relate to their hourly wages). Is this possible?
The idea is at the end of each month or year I can run a report for Work Performed and find the total cost for that item.
Thanks in advance.