A robust property management application developed with VBA, featuring a user-friendly GUI and flexible database storage.
Developed by John Garvey, this project is a comprehensive property management tool built entirely using Microsoft Office Visual Basic for Applications (VBA). The application is designed to streamline property management tasks through an intuitive graphical user interface (GUI).
Key Storage Features:
- Database Mode: Stores property data efficiently in an MS Access database (
.accdb). - Legacy Mode: Capable of storing data directly within Excel spreadsheets.
To ensure the application runs smoothly, your system should meet the following specifications:
- Operating System: Windows 11 x64 (Tested on build 10.0.22631)
- Software: Microsoft Excel and Microsoft Access (Desktop versions supporting VBA)
Follow these instructions to get a copy of the project up and running on your local machine.
To run this application, you must download both the Excel macro-enabled workbook and the Access database file:
- Download
EAPM.xlsm - Download
EAPM.accdb ⚠️ Important: Place both files in the exact same local folder on your PC.
- Open the
EAPM.xlsmfile. - You will be prompted with a login screen. Use the appropriate credentials below to access the system based on your required user role:
| Access Level / Role | Username | Password |
|---|---|---|
| Admin | Sparky |
GoDevils |
| Support | Becca |
reallyNeat |
| Support | Gabe |
thisIsFun |
| Analyst | Clarisa |
iLoveExcel |
- Microsoft Excel - Frontend GUI and legacy data storage
- Microsoft Access - Primary relational database management
- VBA - Visual Basic for Applications (Logic & Automation)
John S. Garvey
- GitHub: @jgarvey928
- LinkedIn: John S. Garvey
- Portfolio: My Portfolio