Phoenix - Your AI AssistantMicrosoft Access Developer (Azure SQL Back-End)
- Posted:
- Proposals: 42
- Remote
- #4438862
- OPPORTUNITY
- Awarded
Gurgaon 
Description
Experience Level: Expert
We require a Microsoft Access developer to create a robust customer and call management system for our company.
The system will:
Import weekly CRM and Waiver CSVs
Deduplicate bookings and merge records
Calculate 12-month spend and visits
Generate automated call lists for several sales campaigns (party reactivation, birthdays, upsells, etc.)
Provide two user levels (Manager / Staff) with dedicated dashboards, data correction tools, and KPI reporting.
The database back-end will be hosted on Azure SQL Database with Azure AD authentication (IT team will provide).
You’ll build the Access front-end (forms, queries, VBA automation) and ensure clean integration.
Experience in Access-to-SQL linking, VBA ETL routines, and user interface design is required.
The system will:
Import weekly CRM and Waiver CSVs
Deduplicate bookings and merge records
Calculate 12-month spend and visits
Generate automated call lists for several sales campaigns (party reactivation, birthdays, upsells, etc.)
Provide two user levels (Manager / Staff) with dedicated dashboards, data correction tools, and KPI reporting.
The database back-end will be hosted on Azure SQL Database with Azure AD authentication (IT team will provide).
You’ll build the Access front-end (forms, queries, VBA automation) and ensure clean integration.
Experience in Access-to-SQL linking, VBA ETL routines, and user interface design is required.
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Could you please confirm whether the Azure SQL database schema (tables, fields, relationships) will be pre-defined by your IT team, or would part of my role involve designing and normalizing the database structure before linking it to the Access front-end?