Basic Microsoft Access CRM

@AwaisChaudhry

Hello, I’m Muhammad Awais. I understand you want two Excel tables (Contacts and Properties) turned into a single, easy-to-maintain Microsoft Access CRM with a solid one-to-many relationship, preserved fields, and a scalable design. I will import both sheets, create clean relational tables with referential integrity, and build user-friendly data-entry forms for Contacts and Properties, plus a combined form to view related records side-by-side. I’ll add a button to open Outlook email for selected contacts and another to trigger a Word mail-merge using the active contact and its linked property. I’ll implement the preset queries you listed: Contacts by property, Emails sent to contacts, and Properties in the 5,000–10,000 SF range. Deliverables: an .accdb with tables, relationships, forms, queries, and the VBA/macros needed for Outlook and Word links, plus a concise how-to document for future expansion. The interface will be clean and scalable for a single user today with room to grow, and I will provide clear comments to ease maintenance. Do you have any preferred naming conventions for tables and fields or requirements for multi-user access and security as you scale? Best regards,

@Tanmoy236

Hi! I’m an expert in Microsoft Access database design with 9+ years of experience building CRM systems that are clean, relational, and easy to maintain. I specialize in turning Excel data into fully functional, scalable Access solutions. Here's how I can help: * Import your Contacts and Properties sheets and set up relational tables with enforced referential integrity * Build intuitive data-entry forms for Contacts, Properties, and combined views showing related records * Add command buttons for sending Outlook emails and Word mail merges using active contacts and property info * Create preset queries: Contacts by property, Emails sent, and Properties by size range * Deliver a fully functional .accdb file with annotated VBA/macros and a short how-to for future updates Could you clarify if your Word mail-merge template already exists or should I create a reusable template for you?

@maverick44000

Hello Sir, I am highly skilled in MS Access and I can deliver this Excel to Access conversion project within a day. Let's discuss and kick off. You do not need to pay anything upfront. Once you get the accdb and tutorial file, you may release the funds then. I have delivered several Access projects for various clients. Lets discuss and kick off. Good day, Usman

@VladimirLilenko

Hello! I'm a Databases Developer, Access, Excel and VBA expert more than twenty years. I have completed many complex projects in my practice and I am ready to carry out your in the price and in the shortest possible time and with the highest quality. You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f Regards, Vladimir

@peteyjfife

Hello, I would love to help you on your project. I am a Microsoft Expert and Data Analyst. I can create a custom database for you. Have a look at my profile. Check out my profile. All these database were once EXCEL spreadsheets. I have a whole lot more too. I have been certified and working with many Microsoft products. I am well rehearsed in VBA for MS Access as well as EXCEL. I have been building custom ACCESS Databases for 30 years. I can take your current data and make it into a database where I can create custom forms, reports, invoices, and many other things. Thanks, Pete

@zafarfarooq612

Hello, I am an experienced Microsoft Access developer with a strong background in building clean, relational CRMs from Excel data, and I can deliver a stable, easy-to-maintain database tailored exactly to your workflow. I will import both Excel tables while preserving all fields, design proper primary/foreign-key relationships with enforced referential integrity, and build intuitive data-entry forms for Contacts, Properties, and a combined relational view. I will also create the required preset queries, plus VBA-driven buttons to launch pre-addressed Outlook emails and Word mail-merge letters directly from Access, ensuring everything works seamlessly together. The final .accdb will be well-structured, fully commented, and paired with clear documentation so you can safely extend the database in the future without breaking existing functionality, giving you a clean, scalable CRM you can start using immediately. Regards, Zafar

@ameenulhaq66

Hi Barry, Thank you for considering my proposal for your Microsoft Access CRM project. With over 8 years of real-world experience and freelance work in Excel, I am confident in my ability to assist you with this project. I have carefully reviewed your requirements for transitioning your Excel tables into a comprehensive Microsoft Access CRM system. I am eager to discuss your project further and explore how we can collaborate to bring your vision to life. I would like to connect with you in chat to delve deeper into the specifics of your project and ensure that we are aligned in our approach. Regards,

@vsprybhanu

Hi, I can turn your Contacts and Properties Excel tables into a single, well-structured Access CRM. The database will have relational tables with enforced integrity, data-entry forms (including a combined view), and buttons to email contacts via Outlook or mail-merge letters in Word. The interface will be clean, intuitive, and scalable. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more detail. Best Regards, Virendra

@jawadaman

Dear Concerned, I am an experienced MS access developer. I can do this job for you. If interested in hiring me then lets have a discussion to clarify the scope and estimates accordingly. Thanks Regards

@brayanstiven5

Hi Barry W.. I am very excited with your project because I have completed similar project recently. The skills required for your project are my main specialty. I can handle this perfectly and have abundent experiences. Please confirm that I am one of the best fits for you and drop me a message for further discussion. Thanks and Best Regards. Brayan Stiven A.

@vw1514518vw

MS Access professional VBA developer ready to do the required MS Access CRM with the functionality and features you mentioned. You can check samples for my previous MS Access works and clients' reviews from links below. https://www.freelancer.com/projects/c-sharp-programming/Command-Board/reviews https://www.freelancer.com/projects/microsoft-access/Command-Board-Fire-Dept-35152448/reviews https://www.freelancer.com/projects/database-administration/Upgrade-Legacy-Access-Database/reviews https://www.freelancer.com/projects/microsoft-access/have-microsoft-access-with-tables/reviews

@emilesd617

Hi, I am a database developer with 8 years of experience building practical, maintainable data-driven tools, with a strong focus on Microsoft Access–based CRM systems. I am familiar with Microsoft Access, Excel imports, relational database design, VBA, and integrating Access with Outlook and Word for email and mail-merge workflows. I'm an individual freelancer and can work on any time zone you want. For this project, I would import your existing Excel tables, design clean relational structures with enforced referential integrity, build intuitive data-entry and combined forms, and implement VBA-driven buttons to open pre-addressed Outlook emails and Word mail-merge templates. I would also deliver the required preset queries and provide clear documentation so you can safely extend the database later. Please contact me with the best time for you to have a quick chat. Looking forward to discussing more details. Thanks. Emile.

@KellogITSolution

Hello I am working with MS-Access database and VBA for the past 22 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Access Projects through Freelancer.com. I would do your work and is ready to start right now. I have gone through your project specification and the file that you have asked for reference. Give me the job, get it done, satisfy yourself and then make payment. I wont seek any payment from u until ur job is fully done as per your satisfaction. Customer satisfaction is much more important and my top most priority. No satisfaction no payment. Hope to hear positively from u. Regards John

@volodymyrkoval

Hello, I will convert your Contacts and Properties Excel sheets into a clean, relational Access CRM with enforced referential integrity so contacts link to buildings both ways. I have all the necessary skills to successfully complete this project, including Microsoft Access design, VBA for Outlook and Word automation, and Excel import experience. I have experience over 10+ years and will build data-entry forms, a combined related-records view, queries you requested, and buttons for Outlook email and Word mail-merge. I will deliver a well-commented .accdb with tables, relationships, queries, forms, VBA/macros and a short how-to document for future field/table additions. I can complete this within 5 business days and am ready to start as soon as you provide the files and any Word template preferences. Best regards, Volodymyr

@wilfrednjorog

Hi there, I'm excited about the opportunity to transform your Excel tables into a well-structured Microsoft Access CRM. With extensive experience in database design and programming, I will import your data while ensuring proper relational integrity. I'll create user-friendly forms and essential queries to facilitate easy data management and quick insights. By adhering to your specifications, including the email integration and mail merge functionalities, I aim to provide a scalable solution that meets your current needs and allows for future growth. Best regards,

@durgesh8527

As a seasoned Full Stack Software Engineer with over 12 years of experience, I have amassed a vast knowledge in various software development disciplines that are applicable to your project. Studying your request meticulously, I understand how important it is for your CRM to be organized, seamless and future proof. With my expertise in creating intuitive and elegant interfaces using various database management systems like MongoDB, .Net, MySql and more, I can guarantee a stable and scalable Access CRM. My competence in Excel and database programming is a vital asset, especially in importing your Excel tables into Access while securely maintaining all existing fields. Additionally, my experience with building clean relational databases and perfectly enforcing referential integrity ensures that your database can grow safely over time without apology or issues. I am also well versed in VBA/Macros; this means I can effortlessly provide the two essential features you require: an Outlook email window that opens at a click of a button allowing you to select one or multiple contacts; and another button that generates Word letters merged with contact-specific property information. All these coupled with necessary queries such as "Contacts by property" are delivered succinctly in my coding structure. Partnering with me will ensure the delivery of an easy-to-use CRM system packed with everything you need

@codefusion53

Hello. I propose to design and deliver a structured Microsoft Access CRM that consolidates your existing Contacts and Properties Excel tables into a single, relational .accdb database. The solution will include properly normalized tables with enforced primary/foreign key relationships and referential integrity to ensure long-term data stability and scalability. I will build intuitive data-entry forms for Contacts and Properties, along with a master-detail form that displays related records side-by-side for efficient navigation. Custom queries will be created to support your immediate needs, including contacts by property, email activity tracking, and property size filtering. VBA-driven command buttons will be implemented to launch pre-addressed Outlook emails to selected contacts and to generate Word mail-merged letters using a reusable template. All automation (Outlook and Word integration) will be fully contained within Access and clearly commented for maintainability. The database interface will be clean, user-friendly, and structured to support future expansion without breaking existing functionality. Final delivery will include the completed .accdb file and concise documentation explaining how to safely add fields, tables, or automation later. Regards, Justin.

@eliza019

Hello there, With extensive experience in statistical and predictive analytics, My proficiency in SPSS combined with my programming skills in Python will not only ensure an effective data analysis but also allow for flexibility and automation, optimizing efficiency throughout the process. Throughout my career, I have consistently proven my problem-solving mindset transforming complex datasets into clear and actionable insights that clients can use to drive their business forward. Data cleaning and transformation is an often-overlooked area of importance; however, it's where precise analysis begins. My vast experience in this area ensures thorough sorting of your data for accurate analysis - leaving no stone unturned. Lastly, I recognize that clear communication is vital to successful project completion. I assure you of my commitment in communicating regularly and effectively throughout this project, leaving no room for ambiguities. Trusting me with this project will not just avail you of a qualified individual but also someone who is dedicated in leveraging their knowledge and experience for unparalleled client satisfaction.3

@muhammadj121

Hi there! I can transform your Excel Contacts and Properties tables into a fully relational Access CRM with data-entry forms, referential integrity, and intuitive combined views. VBA-powered buttons will enable Outlook emails and Word mail merges, and all queries, forms, and code will be documented for easy future expansion. With 8+ years of experience in Excel, I deliver accurate, efficient, and well-structured data solutions—on time and within budget. I specialize in: Advanced Excel dashboards, formulas, and pivot tables Data cleaning, analysis, and visualization VBA/Macro automation to save time Google Sheets automation via Apps Script You’ll receive: Fully editable, documented files Clean, easy-to-use dashboards Fast communication and unlimited revisions View my profile and work: freelancer.com/u/muhammadj121 Looking forward to helping streamline your data processes! – Junaid