+ Reply to Thread
Results 1 to 9 of 9

Project CRM database

  1. #1
    Forum Contributor
    Join Date
    10-13-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    106

    Project CRM database

    I am looking to create a Access CRM type of database. This is for personal projects so it may be like one could be Garden and there I can log each time I work on it and if I communicate to one of the contractors. I can then keep track of where each one if up to and what was done last. this would be I guess like a CRM database where you can log each time you communicate with a customer so you can see whet interactions was done and dates in order extra, plus get all their details etc.

    I am thinking that I will need a Table for External Stakeholders ( Contractors ) and this would hold each of their details. But what else would I need a table for each of the projects and what else? and how could I have a form for each time I work on a project I can open a form and put which project I am wanting to upload a note too and then upload the note itself?

    Thanks in advance for any help.

    T

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2411 Win 11
    Posts
    24,409

    Re: Project CRM database

    Thinking you may need a contact table, a projects table and an activities table. My 2Cents. Need to build your tables and then bind your form and sub-forms to your tables. Once this is in place, build you queries and reports. Be sure to normalize your tables. You may want to start with Crystal Long's web site. https://www.accessmvp.com/strive4peace/

    Contacts Table
    ---------------
    ContactID (PK)
    Name
    Phone
    Address
    City
    State
    Zip
    Email
    ProjectID (FK)

    Projects Table
    ---------------
    ProjectID (PK)
    Project Name
    Other Pertinant Fields

    Activities Table
    ----------------
    RecordID (PK)
    Date
    Project (FK)
    ContactID (FK)
    Comments
    Other Related Fields
    Last edited by alansidman; 12-23-2023 at 04:47 PM.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,104

    Re: Project CRM database

    Here is a sample of code in this project :

    Please Login or Register  to view this content.
    https://www.youtube.com/watch?v=ITLm...iMNqSXLnjzJvt8

  4. #4
    Forum Contributor
    Join Date
    10-13-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Project CRM database

    That is great thank you so much.

    I am new to Access and understand how to make a form design. I am wanting to make a form so when I fill in the project in and then who I have dealt with and the notes section how can i run a report or query so It will show I can go to garden and pull all the activities on there and what notes are on there in date order? Thank you again in advance

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2411 Win 11
    Posts
    24,409

    Re: Project CRM database

    Did you look at Crystal's web page. It will take you through the basics so that you understand what to do. You must build tables first. Forms come second and then queries and reports.

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2411 Win 11
    Posts
    24,409

    Re: Project CRM database

    The attached should also help in building your RDBMS
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    10-13-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Project CRM database

    Thank you for all your help. I have now done the tables and the relationships as you say. I have created a form now too which is pulling the comments/ motes through which is great.

    Un the activities table I am manually inputted each activity and each one has its own unique number on the activities and what I would love to do on the form is

    1/ be able to have a combo box that pulls the name from the Project name on the activity table and then when the data goes in the table to unique number for that activity also gets populated in the activity table. Currently it is the next available number that is being used.

    2/ Also I would like to have a name box on the activity form and when I save the form the name goes into the contact table automatically.

    Are these easy to do as I have read the links and not be able to manage to figure it out.

    Thank you once again for any and all help.

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2411 Win 11
    Posts
    24,409

    Re: Project CRM database

    Suggest you provide your db uploaded here in a zip file. Make sure that you have 8-10 only records in the DB. Run a compact and repair and then zip the file. Then attach it here. Then provide the details that you wish to accomplish. Not sure what you are doing with out seeing the db. Building one of these is not generic. It may require some VBA but until it is reviewed there is no telling what it will take. Please be specific with your references to your data and tables.

  9. #9
    Registered User
    Join Date
    04-18-2024
    Location
    Brampton, Ontario, Canada
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    1

    Re: Project CRM database

    It's great to see you making progress with your Access CRM database! Here are some steps you can take to address your new requirements:

    To populate the unique number for each activity automatically:
    You can create a combo box on your activity form that pulls the project names from the Projects table.
    Use the After Update event of the combo box to generate the unique number for the activity. You can achieve this by using a DLookup function to find the maximum activity number for the selected project and incrementing it by one.
    Set the value of the unique number field on the form to the generated number.
    To automatically save the name into the Contact table:
    You can add a name box on your activity form.
    Use the After Update event of the name box to save the name into the Contact table. You can achieve this by using an Append query to add the name to the Contact table.
    These tasks are relatively straightforward to implement once you understand the basics of Access. I recommend going through Crystal's web page for a detailed explanation of building tables, forms, queries, and reports.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Project ongoin taping to database
    By hmjihdi in forum Access Tables & Databases
    Replies: 0
    Last Post: 01-25-2022, 06:41 PM
  2. [SOLVED] Obtaining name, project and hours from database
    By Robn02 in forum Excel General
    Replies: 5
    Last Post: 03-08-2018, 12:07 AM
  3. Not able to see database updates until I re-buld the VB2010 project
    By jimexcel68 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2016, 05:39 AM
  4. Office project:DATABASE DATA COPY FROM ONE TO ANOTHER
    By hattisaeed in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2011, 08:32 AM
  5. Database is very slow while opening Project
    By LilyMarie in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 06-26-2009, 03:23 AM
  6. Database is very slow while opening Project
    By LilyMarie in forum Access Tables & Databases
    Replies: 1
    Last Post: 06-26-2009, 03:22 AM
  7. Add Project to 'database'
    By jieyi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2009, 06:09 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1