Here is the scenario. A psychologist has asked me to develop a simple database to keep records of meeting/discussions with clients. As part of the initial meeting they will want the client to take a simple test that I can create with radio buttons.
However they would hand the ipad to the client to complete the test.
Since the database will have details of all clients a client could potentially access the records of other clients if the ipad is handed to them for the test.
My question then is can I password protect withing the file so that they cannot leave the test without entering a password (ie they cannot access the main menu from the test).
If not then I can create the test as a separate db and simply send the results via email/pdf to drop into the main db.