Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Simple Inventory Database
Old 03-10-2007, 01:24 PM Simple Inventory Database
Junior Talker

Posts: 1
Name: steve
Trades: 0
Hey, I'm supervisor and a Tool & Die shop and am looking to make a database of Cutters we have in stock for ourselves, I want to be able to have all the feilds u can enter info into to be searchable so multiple entries show up, as well the more feilds u fill out, the more u narrow down the search results. I will teach myself howto do this, but what im asking is what program is the best to do this, i tried access but it doesnt give me much options as i am using the wizard. Should i keep using Access ? or is there somthing better out there?
joanzer is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 03-10-2007, 03:21 PM Re: Simple Inventory Database
tripy's Avatar
Do not try this at home!

Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
Trades: 0
At the sounds it have, you don't seems to have much programming experience.

As far as I know, except if there is a niche firm whose sells something designed to what you need, there will be no generic tools with a wizard that will allow you to make it.

In your case, I think you will use a single computer to do everything, so access looks like a good choice, as long as you don't want to access this db from a web server, or work on it remotely.

If I had to give advices, they would be:
I'm a French speaking person, so please, bear with my poor English.
And some words might be direct translations of French words, so if it's unclear somewhere, ask me. I'll try to describe it better.
  1. Analyze ! What will exactly this tool make.
    Is it an inventory, a stock monitoring, a sales analyzing program ? Each function will have different requirements, even if some can easily be mixed together.
    Try to write it down. It will be a guideline of what you need to take care of. You would be amazed how many peoples want a tool, but cannot explain to the programmers what this tool should do, and how it should do it.
  2. Before starting anything, read, read, read and read.
    There is many free books, online courses and tutorials available on the net. Try to get to your local book store a visit. I'm a 8+ years programmer, but I regularly goes in library, and looks at the books there. You will never know everything, and you can always learn something.
  3. When you know what you want to do, draw it!
    Believe me, when you start programming, if you have a roadmap, things will be way more clear. When you are banging your head on the wall, it helps you keep focused of what you REALLY need to do.
  4. Before putting an interface, build the database.
    An interface needs datas to work. If your database schema is too badly designed, it can makes it impossible to use it later.
    First the datas, then the interface to alter and access them.
  5. Ask for tips, ask a lot.
    You came here looking for help, and that's what you'll get. Willing to go on a self learn base is something rather brave, as it's not an easy task to do. You have a doubt, something you don't understand? Ask for it. If developers works in team, there's a good reason for it. 3 minds are better at solving problems than 1.
  6. If you have 2 ways of doing something, and one simpler than the other, take that one. Many years, I've put "artificial" complexity in my programs, thinking "If I want to do that later, it will be simpler". It's just an illusion. The time you take at first in the design will almost never be used later on.
    In 6 years, only 1 time was this complexity useful. All the other times, it was a time waste.
  7. Write you thoughts in the code.
    A doubt ? Write it. An idea, write it too. Use comments. They will help you a lot, if you need to alter a bit of the code 6 month later.
  8. If you see that it will be too much for you, get some external help.
    Maybe you know someone's kid whose in a computer class?
    It could be a good practice job for him, and he may have already enough experience to help and guide you effectively.
    Or you could try a service like getafreelancer.com. I have worked as a freelance through them sometimes ago. I liked their service.
If you had the courage to read until here, and you don't feel too anxious about all this, then you have already took the first step.
Good luck to you.
__________________
Only a biker knows why a dog sticks his head out the window.
tripy is offline
Reply With Quote
View Public Profile Visit tripy's homepage!
 
Reply     « Reply to Simple Inventory Database
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.58652 seconds with 12 queries