Access Database Consultants Create Tenancy Management Tool
Xlteq are asked to build a Microsoft SQL Server Azure Database with a Microsoft Access Front End. The data storage would be designed according to the specification provided by the client.
Access Database for Tenancy Management
Solution Approach
- Create a database table structure in MS Access
- Design Data Entry Forms based on customer discussions and check their functionality in Access, including some user testing.
- Migrate the data structure and any content to MS Azure and write appropriate SQL views in order to run the Access forms as efficiently as possible.
- Create any reporting or dashboarding
- User Testing
This is an example of a data entry form for adding new maintenance requests, based on the data fields supplied in the customer specification. The green boxes could be populated automatically with information from within the database based on the selections on the right-hand side
- Create the additional tables in Azure
- Create appropriate Data Entry forms for handling new Applicants and Rent Calculations and any reporting required.
- User Testing
- Complete the data structure in Azure
- Design user forms and reporting
- Final User Testing and Approval
Contact us for a free consultation
Either call us now on 020 3817 6945 or fill out the form below and one of our team will be in touch.