1001 Freelance Projects
Latest Projects from
Freelance Marketplaces
View Project
View this project in detail
(Note: you will be redirected to external marketplace)
Project title:
MS Access Database CRM/ Appointment Scheduler Build
Posted by:
External project from PeoplePerHour
Started:
28-Aug-2024 05:22 GMT
Description:
Project Overview:

I am seeking proposals from experienced database developers to design and build a Microsoft Access-based Customer Relationship Management (CRM) system. This CRM will be used by myself to manage resident details, track property maintenance work, and monitor communication history with residents. The system is intended to replace mycurrent Excel-based process and provide a more robust and integrated solution.

Scope of Work:

The CRM should include, but is not limited to, the following functionalities:

Resident and Address Management:

Maintain detailed records of residents, including contact information, communication history, and notes.
Track addresses and associated properties, including property type and status.
Work Package Tracking:

Manage work packages for different types of property maintenance works, including but not limited to:
Damp and Mould Works
Window and Door Replacement Works
Track related tasks such as asbestos surveying and removal.
Assign multiple contractors to specific jobs as needed.
Job and Contractor Management:

Track the status of jobs from initiation to completion.
Manage contractor details, assignments, and communication.
Resident Communication History:

Record communication history with residents, including dates, details of communications, and follow-up actions.
Manage staff assignments to specific communications.
Reporting and Analysis:

Generate reports in Excel format to facilitate data analysis and decision-making.
Provide customized reporting options based on various criteria (e.g., job status, contractor performance, resident interactions).
Key Requirements:

The database must be easily navigable; the primary user interface will be stored locally, with possible assignments to external users for data inputting.
The system should have robust data validation and error-checking mechanisms to ensure data integrity.
Integration with Excel is required for both importing and exporting reports and data.
The system must be designed to allow for future enhancements and scalability, particularly for adding additional work packages.
Main Menu Design:
A user-friendly main menu that allows users to:
Add and edit resident information.
Enter and update job details.
Schedule and manage appointments linked to each property.
View and manage contracts linked to specific properties.

Ideally I would like to have a Teams/ Zoom call to run through my current process, which will clearly demonstrate the current workflow. Open to quotes and suggestions on further enhancements and features.
Please provide an example or demonstration of previous relevant work to showcase expertise and design capabilities.
The project deadline is deliverable by the end of September or earlier if possible.
Project ID:
3401681
Project category:
Project budget:
View this project in detail
(Note: you will be redirected to external marketplace)
Last Projects / Browse Projects
  Project Started
Website SEO Need backlinks (S$7)
Category: Content Marketing, Digital Marketing, Internet Marketing, Link Building, Marketing, Search Engine Marketing (SEM), SEO, Social Media Marketing, Website Analytics, Website Optimization
Budget: $12 - $30 SGD
03 Sep 2025 04:03 GMT
Migrate Sites & Refresh WordPress Layout
Category: CPanel, DNS, HTML, PHP, SSL, Web Design, WordPress
Budget: $250 - $750 AUD
03 Sep 2025 04:03 GMT
Launch Today: Facebook Lead Campaign
Category: Advertising, Copywriting, Digital Marketing, Facebook Ads, Facebook Marketing, Google Adwords, Internet Marketing, Lead Generation
Budget: $250 - $750 USD
03 Sep 2025 04:03 GMT
Modern Vibrant Dog Collar Packaging
Category: Adobe Illustrator, Photoshop, Branding, Creative Design, Graphic Design, Logo Design, Packaging Design, Visual Design
Budget: $30 - $250 USD
03 Sep 2025 04:02 GMT
Aplikasi pengajuan pembelian barang dan pembayaran
Category: Database Programming, Google Apps Scripts, HTML, JavaScript, Laravel
Budget: $10 - $30 USD
03 Sep 2025 04:01 GMT
Mexico City Legalization Courier
Category: Admin Support, Courier, Customer Service, International Shipping, Legal Assistance, Logistics, Project Management, Time Management
Budget: $50000 - $100000 USD
03 Sep 2025 03:59 GMT
Facebook Marketing for Wellness Product Pakistan only
Category: Digital Marketing, Facebook Ads, Facebook Marketing, Instagram Ads, Instagram Marketing, Internet Marketing, Social Media Marketing, Twitter
Budget: $10 - $30 USD
03 Sep 2025 03:58 GMT
Mechanical CAD Drawing of Machine Parts
Category: 3D CAD, 3D Modelling, AutoCAD, CAD / CAM, Drafting, Mechanical Design, Mechanical Engineering, Solidworks
Budget: $15 - $25 AUD
03 Sep 2025 03:58 GMT
Cookbook Designer for Vibrant 5-Book Series
Category: Adobe InDesign, Book Design, Canva, EBook Design, Graphic Design, Illustration, Photoshop, Typography
Budget: $10 - $30 AUD
03 Sep 2025 03:56 GMT
Construction
Category: Building Architecture, Graphic Design, Interior Design, Photoshop, Web Design
Budget: $15 - $25 USD
03 Sep 2025 03:56 GMT
مشروع برمجة بسيطة وكتابة مقالات
Category: Article Writing, Blog Writing, Content Writing, Creative Writing, Programming, Software Development, Technical Writing, Web Development
Budget: $250 - $750 USD
03 Sep 2025 03:55 GMT
Translate Straightforward Legal Documents
Category: English (US) Translator, English Translation, German Translator, Legal Translation, Legal Writing, Proofreading, Spanish Translator, Translation
Budget: €30 - €250 EUR
03 Sep 2025 03:54 GMT
Doctor Digital Reputation Turnaround
Category: Audit, Branding, Content Strategy, Content Writing, Digital Marketing, Facebook Marketing, Instagram Marketing, Research, SEO, Social Media Management
Budget: ₹12500 - ₹37500 INR
03 Sep 2025 03:54 GMT
Business Account Form Creation
Category: Adobe Acrobat, Branding, Business Writing, Email Marketing, Graphic Design, Logo Design, Microsoft Word, PDF, Stationery Design, Word
Budget: $30 - $250 NZD
03 Sep 2025 03:53 GMT
Figma to HTML/CSS Conversion
Category: Bootstrap, CSS, Django, Figma, Frontend Development, HTML, PSD To HTML, Web Development
Budget: $30 - $250 USD
03 Sep 2025 03:52 GMT
Browse All Projects
Projects by Skills ...
android
ajax
asp
aspnet
cms
cpp
csharp
css
delphi
design
drupal
excel
facebook
flash
html
java
javascript
joomla
iphone
mysql
photoshop
php
python
ruby
seo
sql
sysadm
translate
typing
twitter
vbnet
xml
wordpress
writing
New!
Проекты на русском
(Projects in Russian)

Copyright © 2005-2024
1001 Freelance Projects