34 Edgwarebury Lane, Edgware, Middlesex,UK, London, HA88LW
Ben Beitler

Please see the below some of the screenshots of my property portfolio system built using Microsoft Access and VBA.

Access Database Form Interface example - Portflio Manager
Access Database Form Interface example – Portfolio Manager

The above interface is the starting screen which gives you a quick search tool for an individual (vendor) or date reference, profile details including obvious name and address, valuations and lender information. Tabbed screens also show related history of sale and sold prices for the current property. There is also a contact log tab that is interactive and a menu driven system to navigate to other processes and screens.

Access Database Form Interface example – Contact Log

The above screen is a snapshot view of the contact manager tool which is linked to the main interface providing further functionality to keep of track of various types of calls and logs. There is an added feature to interact with Microsoft Outlook and set reminders as a task.

Access Database Form Interface example - Deal Calculator
Access Database Form Interface example – Deal Calculator

The above screenshot is a deal calculator tool that works out and computes the profitability (or loss) of a new acquisition and can be programmed to meet your rules and workflows. The ‘Results’ box is simple to determine the outcome of profit and cash flow.

There are other features which include the ability to create stand-alone tasks, Outlook tasks, run reports and import external data from other (CRM) systems.

In fact, anything can be added due to the flexibility and customisation features of Microsoft Access and VBA. There is no ‘out of the box‘ solution which is why there is no fixed price for a system.

If you would like to know more about this system or any other systems I have, please get in contact with me and I will discuss your requirements.

A final thought! some of my clients like to build their own solutions from a base system (like the above) and normally this lands up being a mentoring and training development project which is an ideal way to learn and improve your Access skills ten fold.

About Author:

Access Database Tutorial is the leading website is about learning to build an Access database using the most effective techniques.In this Articles it talks about  Microsoft access. To know more visit at

Ben Beitler

(+44) 7881 502400

United Kingdom, London 

5 out of 5 from 1 reviews

Write a review

Overal review:

Type your review:
(max 1000 characters)
Verification code:
Microsoft Office in Bromley
Microsoft. Microsoft Office, Microsoft Office, Bromley ...
Microsoft Office Cheap in FL
businesses like The apple company, Adobe in addition to 'microsoft' company affordable. Microsoft ...
Wayne’s High Access Rope & High Access in Melbourne
Access is one of the largest companies for facade restoration and maintenance services in Melbourne. We ...
Education » Online Learning in New York
Increment and this will keep increment so if you see the sense going up n timeouts increasing ...