Comprehensive Access Database for Cleaning Service
Budget: $3,000 – $5,000 USD
I am seeking a freelancer with vast experience in Microsoft Access and Data Management to create a comprehensive database for my small residential cleaning company.
The database should include:
-Job Site Details: This includes capturing data on the date and time of each job, its specific location address, and the customer's name. Detailed site specifics such as the number of bedrooms, bathrooms, hallways, windows, closets, doors, kitchens and other areas cleaned, the time taken to complete each task, as well as projected and actual labor hours should also be included.
-Customer Satisfaction: An efficient system to measure and record customer satisfaction levels is also necessary. This will include ratings on a scale of 1-5, feedback/comments, specific areas for improvement, and the option to select a favorite employee.
-Employee Performance: The database should also track metrics such as punctuality, quality of work done, customer feedback received, average rooms cleaned per hour, and average square footage cleaned per hour by each employee.
**When creating this database I would prefer that whenever possible, the developer NOT use code but rather use the graphical user interface processes so that non coders (Myself) can easily navigate and edit or build onto the database**
In addition, I would like the database to track our financials, payroll, marketing campaigns and emails. The ideal candidate should have a high level of expertise in database management, proficiency in Microsoft Access, and a strong understanding of data analysis. Knowledge in accounting and marketing analytics would be a plus. This project offers an opportunity to develop an innovative tool which will help streamline a bustling business.
The database should include:
-Job Site Details: This includes capturing data on the date and time of each job, its specific location address, and the customer's name. Detailed site specifics such as the number of bedrooms, bathrooms, hallways, windows, closets, doors, kitchens and other areas cleaned, the time taken to complete each task, as well as projected and actual labor hours should also be included.
-Customer Satisfaction: An efficient system to measure and record customer satisfaction levels is also necessary. This will include ratings on a scale of 1-5, feedback/comments, specific areas for improvement, and the option to select a favorite employee.
-Employee Performance: The database should also track metrics such as punctuality, quality of work done, customer feedback received, average rooms cleaned per hour, and average square footage cleaned per hour by each employee.
**When creating this database I would prefer that whenever possible, the developer NOT use code but rather use the graphical user interface processes so that non coders (Myself) can easily navigate and edit or build onto the database**
In addition, I would like the database to track our financials, payroll, marketing campaigns and emails. The ideal candidate should have a high level of expertise in database management, proficiency in Microsoft Access, and a strong understanding of data analysis. Knowledge in accounting and marketing analytics would be a plus. This project offers an opportunity to develop an innovative tool which will help streamline a bustling business.