Need Help Automating a Secure Nomination Form in MS-Access: How Do I Protect Data?

Hi all, I am new to MS-Access and would like to create a format. Could you help me with the Nomination form which needs to be automated (attached)? It should contain the following:

1. Nominated by (system-generated - computer name or login info for each individual but not manual to avoid misuse)
2. Team
3. Nominee
4. Reason for Nominating

Could you help me in preparing the sheet which would reflect the following:

- The form should appear to all those who are nominating for filling the data, but the data that is filled should appear in another sheet which should be password protected and only accessible to one person. (Table)
- The form should not have the option of going back to the previous record. The thought behind this is that only the individuals should be allowed to nominate, and they should know what info others update.

Could you help me improve the format or suggest the best way? Awaiting your reply.

Regards,
Sree

To automate the Nomination form in MS-Access and ensure data security, follow these steps: 1. Create the form with fields for 'Nominated by' (system-generated), 'Team,' 'Nominee,' and 'Reason for Nominating.' 2. Set up a separate sheet (Table) where the filled data is stored, password-protected, and accessible to only one person. 3. Disable the option to go back to the previous record on the form to maintain confidentiality and individual nomination. 4. Consider using VBA (Visual Basic for Applications) to automate the process further. 5. Test the form thoroughly to ensure it functions as intended and meets the security requirements. By following these steps, you can enhance the automation of the Nomination form in MS-Access while safeguarding the confidentiality of the data.