RE: How do I set up a data base that filters special info?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

so the "compare" is something you do in your head......it isn't a programming
function....

what you really want from the db is to look at data - and of course have it
organized.

the advice from the other person is good. there are a variety of online
tutorials for Access around the net you can google for.

really it comes down to defining your fields clearly i.e. contractor , task
(painting), cost, date, etc etc.

a single table is identical to a spread*** in many ways....easier to sort,
easier to filter, easier to make reports off of....but not as good for
financial calcs that run thru the whole system....

but a single table will may end up having you repeat the same info over and
over - depending on your situation. For example - perhaps in some place you
must have the complete Contractor's contact info i.e. address, tel , etc
etc..... you would not want to repeat that non-changing minutia with every
record of a job they do. In the Jobs Table you could just put their name or
maybe a unique ID for them - along with the task (i.e. painting) , cost,
date, etc..... Where over in the Contractors Table you have only their
complete contact info i.e. street address etc. These two Tables are then
cross referenced by the unique name or ID assigned to them. This is typical.
--
NTC


"jrcicirello39" wrote:

Smartin,

What I am trying to do is take impirical data (in spread *** format) of
different types of construction projects (new construction and renovations,
multi family and single family) and match up the contractors that performed a
specific job and the amount the project was charged for that service.
(example: New constrution - Apartment complex- 100 units - roofing - ABC
Roofing Company - Jan 2005 - $275,000.00 or New Construction - 36 Single
Family Residents - Concrete - XYZ Concrete - Feb. 2006 - $655,000.00)
I then want to take that information for all the different diciplines
(concrete, framing, roofing, mechanical) and be able to compare it to current
pricing on a similar type construction project, better know as
pre-construction estimating. This information will allow us to make a better
decission as well as a quicker decission whether or not to go forward with a
proposed project. It will also allow us to see if there are anomalies in
sub-constractor bids from the past to the current and allow us to look into
any increase or decrease in pricing on labor or materials.

This task is for my new job ( only my second day) and I really need to
understand how I can set this database up as soon as possible. I have looked
on the help site just to get confused and frustrated for I feel the pressure
(if only in my head) of time.

I am not looking for someone to provide me with step by step info, just
where do I look to learn how to set this up.
Thanks
"NetworkTrade" wrote:

define what you mean by "compare".....

--
NTC


"jrcicirello39" wrote:

I need to set up a data base that will allow me to track empirical data and
compare it to current real-time data. I am sure Excel can perform this task,
but I am unsure how to set up the program. Please help.
.

Quantcast