So now I'm learning Access. We had a basic database that had been given to us by someone in another department, but it just didn't do everything we needed and we were having to keep a lot of information on separate Excel spreadsheets. We also had classroom trainings by different trainers that had to be entered into Access. Too many cooks ruin the soup, so we did a work around.
After every classroom session, the trainers enter employee names and class name into a spreadsheet to print certificates. By taking that a little further, adding the course codes, employee IDs, course location and trainer name, we can do a batch upload into Access. Now the trainers send their spreadsheets to me after they print their certificates, I do a little editing, and we batch--hooray! It saves a lot of time and we don't have as many people logging into the Access database. It makes for better consistency in how things are entered and you can spot missing data quickly on a spreadsheet.
I set up additional tables for the other spreadsheets we were keeping, all centered on employee ID, and now we have everything in one database. Now I'm learning forms, reports and advanced queries. I have been really surprised at how much we can do with it and look forward to maximizing the use of Access to help us keep track of our trainings.