How do I set up a database with special filters 2

[jrcicirello39]

Smartin,

What I am trying to do is take impirical data (in spread sheet 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. Please help?

I hope this is enough information for you to help answer my quest.

Many Thanks

 

[strive4peace]

A new job, what an exciting time!

first, it helps to get your hands around the tool...

send me an email and request my 30-page Word document on Access Basics
(for Programming) -- it doesn't cover VBA, but prepares you for it
because it covers essentials in Access.

Be sure to put "Access Basics" in the subject line so that I see your
message...


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[jrcicirello39]

Crystal,
Thank you very much for your offer, unfortunately, my company does not have
access at this time. do you think I can use the 30 page Access Basics
priciples for Excel?

 

[strive4peace]

If you are setting up a database, Access is the best place to do it...

The Access Basics document won't help you much with Excel, but I do send
out the first 3 chapters of a book I am writing on VBA to all who
request it -- and that is good for Excel or Access.

if you hurry, you can download the beta version of Access (good till
March I believe) and by the time it expires, you will be able to see if
Access would be a useful tool to buy.


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*