Results 1 to 7 of 7

Thread: Database problem

  1. #1
    Full Member
    Join Date
    Nov 2011
    Location
    Garsfontein
    Posts
    90
    Thanks
    2
    Thanked 11 Times in 11 Posts

    Database problem

    Could anyone plz advise on this.

    Whats the quickest and best way of creating a database for suppliers/customers and is there any downloadable programs that support that??

    Please advise

    Thank you

  2. #2
    Diamond Member adrianh's Avatar
    Join Date
    Mar 2010
    Location
    Cape Town
    Posts
    5,089
    Thanks
    336
    Thanked 808 Times in 642 Posts
    Make a spreadsheet. You can always port the data to another databse such as ACCESS if you need to.
    How easily someone is offended is directly proportional to how stupid they are.
    ~GS Elevator

  3. #3
    Email problem mother's Avatar
    Join Date
    Jul 2011
    Location
    Northwest Province
    Posts
    333
    Thanks
    31
    Thanked 45 Times in 35 Posts
    Blog Entries
    2
    Adrian is right. The quickest way is a spreadsheet. And then use pivot tables to extract your data. The great thing about such a databse, is its flexibility. You can redesign your reports at a mouse click, and look at and analyse your data literally in any format you choose.

  4. #4
    Bronze Member rfnel's Avatar
    Join Date
    Jun 2011
    Location
    Germiston
    Posts
    196
    Thanks
    120
    Thanked 41 Times in 31 Posts
    Blog Entries
    4
    Scaffold, can you go into more detail? What exactly would you expect from your database?

    There are numerous free applications available, but their suitability depends on your requirements. Do you simply want to keep track of supplier/customer contact details? Do you want to keep track of purchases and sales? How much information do you want to store?
    "Fortune favours the bold" - Virgil
    Riaan Nel
    Freelance Software Development | LinkedIn | Skype

  5. #5
    New Member Arogon's Avatar
    Join Date
    Dec 2010
    Location
    Ellisras
    Posts
    6
    Thanks
    1
    Thanked 1 Time in 1 Post
    rfnel can you give a few links to these's numerous free applications that you r refering to?
    Please.

  6. #6
    Bronze Member rfnel's Avatar
    Join Date
    Jun 2011
    Location
    Germiston
    Posts
    196
    Thanks
    120
    Thanked 41 Times in 31 Posts
    Blog Entries
    4
    Quote Originally Posted by Arogon View Post
    rfnel can you give a few links to these's numerous free applications that you r refering to?
    Please.
    Hi Aragon

    Like I said, it depends on what exactly Scaffold wants, but among others, there's Open ERP, JFire and Free CRM. JFire and OpenERP are full ERP systems, so I suspect that they'll be overkill and that Free CRM is closer to what Scaffold wants. If the requirement is so simple that even Free CRM is overkill, Scaffold could take a look at a very simple application that I wrote some time back.

    Here's a page full of links to free CRM systems; www.smallbizcrm.com/free-single-user-crm.html.

    Disclaimer: I haven't personally used the systems that I listed; my time is almost entirely devoted to another ERP system.
    "Fortune favours the bold" - Virgil
    Riaan Nel
    Freelance Software Development | LinkedIn | Skype

  7. Thanks given for this post:

    Arogon (23-Nov-11)

  8. #7
    Full Member
    Join Date
    Nov 2011
    Location
    Garsfontein
    Posts
    90
    Thanks
    2
    Thanked 11 Times in 11 Posts
    Hey rfnel,

    Thanks for the info. I will look into it asap. I basically need to sort customers from suppliers and group them somehow. I also want to maybe be updated on a daily basis of where we stand with each customer and supplier. We are building contractors and currently do alot of scaffolding. I find it hard to keep track of what one supplier is doing for us and what the customers are waiting for. I sound like a retard. lol

    Thanx

Similar Threads

  1. Event Reminder/Contact Database Software
    By rfnel in forum General Business Forum
    Replies: 2
    Last Post: 15-Jun-11, 07:41 PM
  2. [Question] Changing Database name for Company in Pastel
    By J7J in forum Accounting Forum
    Replies: 1
    Last Post: 14-Apr-11, 01:48 PM
  3. National consumer database
    By Dave A in forum General Business Forum
    Replies: 2
    Last Post: 10-Mar-09, 07:22 AM
  4. CrimeTracer | South African Crime Database
    By CrimeX in forum General Business Forum
    Replies: 0
    Last Post: 09-Dec-08, 09:49 PM
  5. HSPDA problem
    By Dave A in forum Technology Forum
    Replies: 41
    Last Post: 11-Feb-08, 09:11 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

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