I was asked to created a program to calculate commissions for employees and supervisors (% of employees commission) based on sale logs that the employees would input into a "form". Should I use Access to build this? Multiple users will be using the same form during the day (inputting their sales) at the same time. I also need to make sure that they can't see any other form, report or table than the ones I want them to see. Each user needs to have their own log in.
Side questions as I work with this terminal: Access 2007 is extremely slow when I'm in anything else other then design view. Why would that be?