Access Database

tech

HI there

I would like to get a access database designed, nothing hugh would need the following fields

Name:
Address:
Tel No.
Mobile NO.
e-mail
Distance

Job Type
Part Sold
Date Sold
Cost Price
Sell Price

Work CArried out

I have no clue on access, I have tried a few template I found on line and no of them seem to fit

does anyone know where I can find some on line

thansk

Sposs

Does it have to be access? if you intend to use it for a web based project i would recommend you have a look at MySql or PostgreSql.

You can find decent access tutorial here http://databases.about.com/od/tutorials/Tutorials.htm

tech

no its doesnt have to be access, I would like a search function and to be able to add extra detail down the road, I supppose excel or something might work for me. I have no clue of SQL

Seth Brundle

Hang on.
Access is by far the simplest database when you are starting off and I reckon it would suit the OP better than a full blown SQL database like MySQL.

OP try reading this for a start:
http://cisnet.baruch.cuny.edu/holowczak/classes/2200/access/accessall.html

However, what exactly are you trying to achieve with your database? Do you need data entry forms? Do you need a reporting system?

tech

i just need to be able to keep track of the above info, and seach by customer, I think access is the way to go, But I just need to read up on access design ?

ChippingSodbury

Here's a start: three tables with relationships.
Having a part table and a custoemr table allow you to have a dropdown for both on your "Job" form.
Make 3 forms with one table as the recordsource for each form.
On the "Job" form, create an unbound dropdown using the wizard to select a customer: this is an easy way to allow you to search.
There are plenty of tutorials out there as to how to make the forms/ reports etc: the most important thing is to ensure that you start off with a good data structure.

Seth Brundle

Which version of Access have you? (click Help > About). I presume that its Access 2000 or 2003.

Access 2003 Tutorials:
http://www.teacherclick.com/access2003/t_1_1.htm
http://www.ischool.utexas.edu/technology/tutorials/office/access03/index.php
http://www.hostitwise.com/microsoft_access_2003.html

DOC09UNAM

Made up the database for you, nothing flashy, but after you type a name in there, go to query and double click search by name, type in the name and it should come up.

just unzip it and open it with access and see if that's the kind of thing you need.

tech

cool thanks

just had a quick mess with it, I suppose one of these front panels is a big task? I'll need to add in more details also.

But i'll have a read of the links posted and see what I can come up.

Thanks

tech

its Access 2007 im using!