Is there a way to format a form in a datasheet view to have column headers with names at a 45 degree alignment and names down the LH side of the sheet with data to be input in the fields? It would be a matrix style look so that a user can go to a name, scroll across to a corresponding task and put in an evaluation number.
Easy to do in Excel but not so much in Access. I need Access to manage data for 7 shops in a production facility which would consist of nearly 500 employees covering 800 tasks. Trying to get one central database but design it so it's familiar to them as they use in Excel.
Any ideas?