I need a Microsoft Access file that lets our small property-management office keep every unit and license date in one place and warns us well before anything slips through the cracks. Core data points • Property address • Owner first & last name + email • Tenant first & last name • Last inspection date • Next scheduled inspection date • Rental-license issue date • Rental-license expiration date What the database must do – Every morning, calculate and flag 60-, 30-, and 15-day reminders for both the license expiration and the next inspection date. – Trigger automated email reminders to the owner (and optionally our staff) for each interval. – Let me import an initial spreadsheet of properties, yet still offer manual entry for new units on the fly. – Produce quick reports that show: • All properties with licenses or inspections coming due within a selectable window • A full roster of active properties with their key dates I am flexible on the exact screen layout; straightforward forms that anyone in the office can open, add a property, or click a report button will be fine. Please keep everything within a single .accdb file so we can deploy it over our shared network drive without extra installs. Deliverables 1. Finished Access database with the tables, relationships, queries, forms, and VBA (if needed) to satisfy the above behaviour. 2. One sample Excel import template and brief instructions so staff can load data themselves. 3. A quick walkthrough or short PDF summarising how to add properties, run reports, and test the email alerts. The project is complete when the alerts fire on the correct days, the emails send successfully from our Office 365 account, and the reports print cleanly to PDF.