B
Boomer
In responses to your advice below I have the paper and
drawings out and I can get some of the entitys to match
with the attributes some are obvious but I have fields
(like, list any local schools or historic sites or any
enviromental issues of concern) another example (Is there
a well within 500 ft of open dumpsite??) how do i make
these logical entities or attribute and accomplish the
same results....As for external paid help not in the
budget its up to me to figure out...so in response to
your answer about( there will have to be a _lot_ of
information gathering in order to understand your
business scenario well enough to design it at a distance)
WHAT DO I NEED TO DO OR CAN I EMAIL YOU SOMETHING TO HELP
ME GET THIS MAPPED OUT. JUST TELL ME WHAT I NEED TO DO TO
get the info you need to assist me I am diligently
working on my end. Is there a quicker way of contacting
you email...IM maybe rather than a 24 hour turn around on
this news board? Here is the info again
I do appreciate your help and time
John Cossiboom
1. Location/Name= This is the name of the road or a
persons name
2. Incident # = the number that it assign as they
are called in
3. Directions from the court house= name of road
where site is
4. Latitude and Longitude this is a question
5. Dump Size = (ft) Width x (ft)Length x (ft)
Depth = (ft)to the 3rd power volume How do I make this a
field?
6. How Many Single Axle Dump truck loads ?
7. Is there a well within 500 ft. of an open dump ?
(this is a yes no box)
8. Date Dumpsite Identified
9. Date to Clean
10. List any local schools or historic sites
11. Responsible Party (yes/no)
12. Enforcement actions Underway (Yes/No)
13. County
14. Nearest road
Contents (All Yes/No Boxes) Do I make this a lookup box
for all this?
1. Household
2. CD/D Building Material
3. CD/D Concrete
4. Brush/Landscape
5. Appliances
6. Tires
7. Hazardous Material
8. Other / List
Accessibility is another question with Y/N Boxes make
this lookups ?
1. Paved
2. Gravel/dirt
3. steep slope
4. trees surrounding site
5. water surrounding site
6. other/ List
Type of setting is another question with these
selections Y/N Boxes .
1. Public Property
2. flood plain/floodway
3. open field
4. sink hole
5. cliff
6. hillside
7. woods
8. creek/river
9. old quarry pit
10. roadside
11. other/list
Digital Photos Table I think I understand how to do
this? I found a picture example within the Northwind
Database VB code under event procedure...i will work with
it. may have questions later
Equipment Cost is another field with these questions for
the surveyor
1. Equipment Type has multiple listings under it
like bulldozer 8 different kinds also dump trucks,
backhoes just depends on what is needed to cleanup sites
2. Max Hourly Rate = how much we charge for our
equipment use
3. actual hourly rate= same as max
4. hours used.
5. total= a formula of actual x hours used
Disposal Fee = when the site is cleaned and the waste is
hauled off and dumped at the main dump site (which by the
we have a contract with them) .
1. Facility Name and location = where we dump it at
2. Tons estimated = how much the load is on scales
3. Per ton cost =
4. total
Labor Cost = this part of the form is where we figure our
labor cost for the job site.
1. Employee Title= this is made up of 4 different
titles do I put this in a lookup box?
2. estimated work hours
3. hourly wage
4. total
Miscellaneous Supplies
1. Specific Item
2. quantity
3. per unit cost
4. total
Please help me with any advice as to line these out...
Thanks John
One good way to start modelling is to create a piece of
paper (or a Post-It
note) for each entity and write the attributes you want
to keep on each of
them; and then start drawing lines between them for how
they interact. For
example, you would have a line between Dumpsite and
Contract, and then one
from Contracts to FeesPaid, and Contracts to LabourCosts
and so on. Take a
long time over this: about 75% to 90% of your overall
development time is
common, and don't go near a keyboard or start Access
until you have all
this straight.
I have to say that this does not look like a trivial
project, especially
for a beginner. Have you considered the costs/ benefits
of external paid
help? No, I am not touting for business as I have a real
job to go to! We
are always happy to support specific questions here, but
there is going to
have to be a _lot_ of information gathering in order to
understand your
business scenario well enough to design it at a distance.
Hope that helps
drawings out and I can get some of the entitys to match
with the attributes some are obvious but I have fields
(like, list any local schools or historic sites or any
enviromental issues of concern) another example (Is there
a well within 500 ft of open dumpsite??) how do i make
these logical entities or attribute and accomplish the
same results....As for external paid help not in the
budget its up to me to figure out...so in response to
your answer about( there will have to be a _lot_ of
information gathering in order to understand your
business scenario well enough to design it at a distance)
WHAT DO I NEED TO DO OR CAN I EMAIL YOU SOMETHING TO HELP
ME GET THIS MAPPED OUT. JUST TELL ME WHAT I NEED TO DO TO
get the info you need to assist me I am diligently
working on my end. Is there a quicker way of contacting
you email...IM maybe rather than a 24 hour turn around on
this news board? Here is the info again
I do appreciate your help and time
John Cossiboom
1. Location/Name= This is the name of the road or a
persons name
2. Incident # = the number that it assign as they
are called in
3. Directions from the court house= name of road
where site is
4. Latitude and Longitude this is a question
5. Dump Size = (ft) Width x (ft)Length x (ft)
Depth = (ft)to the 3rd power volume How do I make this a
field?
6. How Many Single Axle Dump truck loads ?
7. Is there a well within 500 ft. of an open dump ?
(this is a yes no box)
8. Date Dumpsite Identified
9. Date to Clean
10. List any local schools or historic sites
11. Responsible Party (yes/no)
12. Enforcement actions Underway (Yes/No)
13. County
14. Nearest road
Contents (All Yes/No Boxes) Do I make this a lookup box
for all this?
1. Household
2. CD/D Building Material
3. CD/D Concrete
4. Brush/Landscape
5. Appliances
6. Tires
7. Hazardous Material
8. Other / List
Accessibility is another question with Y/N Boxes make
this lookups ?
1. Paved
2. Gravel/dirt
3. steep slope
4. trees surrounding site
5. water surrounding site
6. other/ List
Type of setting is another question with these
selections Y/N Boxes .
1. Public Property
2. flood plain/floodway
3. open field
4. sink hole
5. cliff
6. hillside
7. woods
8. creek/river
9. old quarry pit
10. roadside
11. other/list
Digital Photos Table I think I understand how to do
this? I found a picture example within the Northwind
Database VB code under event procedure...i will work with
it. may have questions later
Equipment Cost is another field with these questions for
the surveyor
1. Equipment Type has multiple listings under it
like bulldozer 8 different kinds also dump trucks,
backhoes just depends on what is needed to cleanup sites
2. Max Hourly Rate = how much we charge for our
equipment use
3. actual hourly rate= same as max
4. hours used.
5. total= a formula of actual x hours used
Disposal Fee = when the site is cleaned and the waste is
hauled off and dumped at the main dump site (which by the
we have a contract with them) .
1. Facility Name and location = where we dump it at
2. Tons estimated = how much the load is on scales
3. Per ton cost =
4. total
Labor Cost = this part of the form is where we figure our
labor cost for the job site.
1. Employee Title= this is made up of 4 different
titles do I put this in a lookup box?
2. estimated work hours
3. hourly wage
4. total
Miscellaneous Supplies
1. Specific Item
2. quantity
3. per unit cost
4. total
Please help me with any advice as to line these out...
Thanks John
One good way to start modelling is to create a piece of
paper (or a Post-It
note) for each entity and write the attributes you want
to keep on each of
them; and then start drawing lines between them for how
they interact. For
example, you would have a line between Dumpsite and
Contract, and then one
from Contracts to FeesPaid, and Contracts to LabourCosts
and so on. Take a
long time over this: about 75% to 90% of your overall
development time is
common, and don't go near a keyboard or start Access
until you have all
this straight.
I have to say that this does not look like a trivial
project, especially
for a beginner. Have you considered the costs/ benefits
of external paid
help? No, I am not touting for business as I have a real
job to go to! We
are always happy to support specific questions here, but
there is going to
have to be a _lot_ of information gathering in order to
understand your
business scenario well enough to design it at a distance.
Hope that helps