Database and inventory software

      Recommended software for customer databases and inventory tracking. November 21, 2000

What type of software do people use for customer database, mailings, etc? I have Excel 5 but wonder about something like FileMaker Pro.

What do you use to track wood inventory?

Forum Responses
Excel can do what you want but Access would be much better. There is a data base wizard that will build what you want. You don't have to be an expert to do it.

If you forsee a time when you want to share the database with other users over a network, I would go with Filemaker Pro. Access has lots of problems with networked, multi-user systems.

Word is that MS is replacing Access in the near future too (about a year or so), so I would feel more comfortable with Filemaker Pro.

Pardox is good if you want a beefy desktop database, but it isn't as easy to use as Filemaker Pro.

For a good contact manager, you may want to use ACT! or Goldmine. Great for customer databases, without having to learn database concepts.

I would use MS Access. It is very powerful and can be easily modified for other things. I am an Access and Visual Basic Programmer for a hardwoods company.

From the original questioner:
Do you have any tips on using Access for inventory? What about tracking specific logs and planks of logs?

Another alternative is to enter and maintain your customer list and information in Outlook Express of Outlook 2000. Outlook has the capability to customize your database fields.

You can do a mail merge into a MS Word document for mailings.

Outlook also lets you "journal" information about your customers and related information that you want to be able to retrieve by customer.

I am currently working on a tracking/inventory system using Microsoft SQL as the database. It will track each board as an individual entry.

The comments below were added after this Forum discussion was archived as a Knowledge Base article (add your comment).

Comment from contributor A:
Keep in mind that many popular accounting software packages offer those abilities, with the obvious additional advantages. Try and consider your whole information flow, then see where you can consolidate your functionality. It is very simple to tie accounting, job costing, payroll, inventory, estimating, human resources, and customer relations into a unified solution.

In response to the other replies... I would not recommend Access or basic spreadsheets for any system you feel will be growing in the near future. An SQL type database is an excellent choice. Although some applications have excellent proprietary databases also.

If anyone is into playing around with the operating system Linux, try taking a look at some PostgreSQL and MySQL based applications. A real promising, free one is sql-ledger accounting.

Would you like to add information to this article?
Interested in writing or submitting an article?
Have a question about this article?

Have you reviewed the related Knowledge Base areas below?
  • KnowledgeBase: Business: Estimating/Accounting/Profitability

  • KnowledgeBase: Business: Plant Management

  • KnowledgeBase: Computerization: Software

  • KnowledgeBase: Knowledge Base

    Would you like to add information to this article? ... Click Here

    If you have a question regarding a Knowledge Base article, your best chance at uncovering an answer is to search the entire Knowledge Base for related articles or to post your question at the appropriate WOODWEB Forum. Before posting your message, be sure to
    review our Forum Guidelines.

    Questions entered in the Knowledge Base Article comment form will not generate responses! A list of WOODWEB Forums can be found at WOODWEB's Site Map.

    When you post your question at the Forum, be sure to include references to the Knowledge Base article that inspired your question. The more information you provide with your question, the better your chances are of receiving responses.

    Return to beginning of article.

    Refer a Friend || Read This Important Information || Site Map || Privacy Policy || Site User Agreement

    Letters, questions or comments? E-Mail us and let us know what you think. Be sure to review our Frequently Asked Questions page.

    Contact us to discuss advertising or to report problems with this site.

    To report a problem, send an e-mail to our Webmaster

    Copyright © 1996-2019 - WOODWEB ® Inc.
    All rights reserved. No part of this publication may be reproduced in any manner without permission of the Editor.
    Review WOODWEB's Copyright Policy.

    The editors, writers, and staff at WOODWEB try to promote safe practices. What is safe for one woodworker under certain conditions may not be safe for others in different circumstances. Readers should undertake the use of materials and methods discussed at WOODWEB after considerate evaluation, and at their own risk.

    WOODWEB, Inc.
    335 Bedell Road
    Montrose, PA 18801

    Contact WOODWEB

  • WOODWEB - the leading resource for professional woodworkers

      Home » Knowledge Base » Knowledge Base Article