Convert Excel to Access Database
Budget: $30 – $250 SGD
I am looking for a skilled developer to convert an Excel file containing employee access rights information into a Microsoft Access database. The database should be accessible only through a simple and functional front-end form. This project involves creating a system that allows me to manage staff access rights efficiently.
Key Requirements:
- Convert existing Excel data into a Microsoft Access database.
- Develop a front-end form for easy data entry and management.
- Enable functionalities to add new staff, view existing staff access, and manage access rights.
- Include inputs for effective dates when adding or removing access rights and staff.
- Implement change tracking for auditing purposes.
- Ensure the database is a local copy for single-user access, without network sharing.
- Manage access rights such as email, file sharing directories, and internal software platform access.
Ideal Skills and Experience:
- Proficiency in Microsoft Access and database design.
- Experience in creating user-friendly forms for data entry.
- Strong understanding of data management and auditing practices.
- Ability to implement effective date tracking for changes.
- Attention to detail and ability to maintain data integrity.
The database should track the following details for each staff member:
- Name and department
- Join date
- Offboarding date
I am looking forward to working with a professional who can deliver a reliable and efficient solution.
Key Requirements:
- Convert existing Excel data into a Microsoft Access database.
- Develop a front-end form for easy data entry and management.
- Enable functionalities to add new staff, view existing staff access, and manage access rights.
- Include inputs for effective dates when adding or removing access rights and staff.
- Implement change tracking for auditing purposes.
- Ensure the database is a local copy for single-user access, without network sharing.
- Manage access rights such as email, file sharing directories, and internal software platform access.
Ideal Skills and Experience:
- Proficiency in Microsoft Access and database design.
- Experience in creating user-friendly forms for data entry.
- Strong understanding of data management and auditing practices.
- Ability to implement effective date tracking for changes.
- Attention to detail and ability to maintain data integrity.
The database should track the following details for each staff member:
- Name and department
- Join date
- Offboarding date
I am looking forward to working with a professional who can deliver a reliable and efficient solution.