Access Database for Tenancy Management

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.


Solution Approach

  1. Create a database table structure in MS Access
  2. Design Data Entry Forms based on customer discussions and check their functionality in Access, including some user testing.
  3. 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.
  4. Create any reporting or dashboarding
  5. 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

  1. Create the additional tables in Azure
  2. Create appropriate Data Entry forms for handling new Applicants and Rent Calculations and any reporting required.
  3. User Testing
  4. Complete the data structure in Azure
  5. Design user forms and reporting
  6. Final User Testing and Approval

Contact Us for a Free Consultation and Quote

You can call us now on 020 3817 6945 or fill out the form below.

The contact form requires that you configure reCAPTCHA in the site configuration.

The contact form requires that you select an email template.

Access Database and Excel Spreadsheet Developers

Call us : 020 3817 6945

Email us : info@xlteq.com

Find us : Unit 1, Wood Green Farm Buildings, Upper Basildon, Berkshire, RG8 8NA

Made with by BarkWeb Platform: Jolojo