I need to set up a database in Access that allows me to put my customer
information in, as well as my vendor information.
This way I can see how much each job costs, without having to also put the
info in excel

Not sure what is the problem ?

Basically you'll have to list the name and type of each set of related
information you want to record in the DB. Watch out also tutorials to see
how to best establish relationships between tables inside a database...

--
Patrice

"database construction company" <database construction
(E-Mail Removed)> a écrit dans le message de news:
AD041D26-8555-42DD-9E30-(E-Mail Removed)...
>I need to set up a database in Access that allows me to put my customer
> information in, as well as my vendor information.
> This way I can see how much each job costs, without having to also put the
> info in excel

I suggest making at least 2 tables - on with customer information, one with
vendor information, and link those.

"database construction company" wrote:

> I need to set up a database in Access that allows me to put my customer
> information in, as well as my vendor information.
> This way I can see how much each job costs, without having to also put the
> info in excel

This is not a trivial exercise.

You'll need to be able to record/calculate the following:-

Customer details
Vendor details
Purchase
Sales
Stock
Labour costs
Project details
Project items
Labour items

and all the other stuff that doesn't come off the top of my head.

You are better off seeing if there is an off the shelf package which will do
what you want or getting someone to write a bespoke system for you.



--

Terry Kreft


"database construction company" <database construction
(E-Mail Removed)> wrote in message
news:AD041D26-8555-42DD-9E30-(E-Mail Removed)...
> I need to set up a database in Access that allows me to put my customer
> information in, as well as my vendor information.
> This way I can see how much each job costs, without having to also put the
> info in excel