Hi All,
I've been tasked with building a web based sales form that my company's sales force can use to enter their lead and prospect information.
I'm fairly new with Access having designed a couple of basic stand alone databases using Access 2013 and I'm familiar with my limited security options using the desktop client. What I need to understand is if I would be able to build something using the Access Web app that would allow each sales person to login and enter/modify and view only their prospect information. Is this possible with the Access Web app and if so, what's the best way to approach it? Would each salesperson have their own table or could they all use the same table somehow?
Apologies if this has been covered in another post, but I was unable to find anything.
Thanks for any help.