Originally Posted by
avicknair
Hello, I am relatively new to access and was hoping to find some help for an upcoming project that I am performing at my workplace. I am tasked with creating a table with data of all employees and their assets (phones, computers, aircards, etc.) This information is all being put together so that my IT manager can easily use a form to search by name or location. I have gotten as far as creating a form and a query so that I can search by keywords to narrow down the long list of employees.
The issue at hand is that we want this to be a database used by the entire company. We would like any employee to be able to open the program and search for someone to find things like their phone number, email, etc (a sort of address book). That part is taken care of. What I am looking to do is have the more classified info (phones, computers, aircards, etc.) to be ONLY accessible to my IT manager. I am looking for a way to set up a password in my form and then input the correct formula (whether that is an IF/THEN statement or something along those lines) in the query so that when he types in the password, all of the classified info will be shown.
Apologies if my terminology is not correct, I have only just started to delve into what seems to be the deep rabbit hole of Microsoft Access. If any clarification is needed, please do not hesitate to leave a question.
Thank you for reading!