How do I create a database?

Question

I have used databases before, many years ago, but now I'm very rusty and can't remember where to begin!
I have a group of customers who all order different types of stationery at different prices and I would like to keep a detailed record of all the relevant information all in one place without creating loads of paperwork.
All ideas and advice would be gratefully received.
My motto is KISS (keep it simple stupid!!!)
Thanks.

Answer 1

Excel?

Answer 2

What program are you using? Access is a great tool for databases. You can use the database wizard which will help you set up fields for your database. Write out all the different fields you can think off for your database. Keep everything seperate. Meaning Last and First name seperate. Street adddress seperate from state and seperate from Zip. Etc Etc. This helps later when you want to search for things and create reports. Buy Access for Dummies or a simple looking Access book. That should be all you need unless you want to consider a class (if you are computer saavy you shouldn't need onee) Hope this helps. Good luck.

Answer 3

Why dont u use access...Mirosoft access is quite good using tht...but u do need to have knowledge about it..I am not sure wht u hav used earlier...but to start with...Excel wud b very helpful...

when u jot down all the list of things and prices ....u can laways import the data in access and use it

u have to write down prices of each n every customer first and then use it as template for others ...

I think access is quite good as it can simply use wizard and create the database where u can enter details...

if u need further information or want someone to do it for u for some cash...then do contact me..send me an email thru answers n i will give u my email address...goodluck!

Answer 4

A simple relational database, very much like an invoicing system, have a check out of the following for simple to use :

FileMaker
Alpha5
DataEase

Personally I would suggest Alpha5, its simple at its basic form, but can be programmed into something compex if you have time to learn xBasic etc. Also included is a simple invoicing database.

If you want a simple invoicing system ready made, try InvoiceIt! from scrambledcard software.

Answer 5

I am teaching database right now for a college course, so having said that, let me give you a crash corse in "Access". If you don't have it, then dont bother and don't pick me as your winner, but if you do go to:

http://www.fgcu.edu/support/office2000/access/index.html

Also see:

http://www.microsoft.com/Education/AccessTutorial.mspx

Good luck in your quest.