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
From United States, New York
Acknowledge(0)
Amend(0)
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
From United States, New York
Acknowledge(0)Amend(0)
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.
From India, Gurugram
Acknowledge(0)Amend(0)
54From India, Gurugram
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Candidate data form.doc
Nomination form-CPHRM.pdf