Automation of Employee Entry-Exit Data Export to Microsoft Access

Project Description:

We are looking for a skilled freelancer to assist with automating the export of our employee entry-exit data. This data is currently stored in an SQL database via Access Control software. The project requires the following tasks to be completed:

Data Export to Microsoft Access:

Extract daily entry-exit data from the SQL database.
Export the data to Microsoft Access.
Scheduled Data Export to Word File:

Automate the export of data from Microsoft Access to a Word file at a scheduled time each day.
Ensure the Word file is saved in a designated folder.
Data Transformation:

During the export process, alter the employee card numbers to employee IDs.
File Naming Convention:

Ensure the exported Word file follows a designated naming format.
We have an existing script from previous software that may be referenced if needed.

Requirements:

Proficiency in SQL, Microsoft Access, and Microsoft Word.
Experience with automation and scheduling tasks.
Ability to write and modify scripts for data extraction and export.
Attention to detail in transforming data and adhering to naming conventions.
If you are interested in this project and have the required skills, please submit your proposal, including your estimated timeline and cost.

Thank you!