By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Access 2002 Database Design Help

P: n/a
I am trying to develop a access database version 2002 from scratch
and I am a novice programmer and need much direction. I have been
researching and studying about relational database design and
normalization I am including the 9 tables and there fields that I
have already developed. I have and I am not sure what to name the
tables and I am thinking of making the incident # field the pimary
key?? Can I put that in all the tables? I am determined to develop
this and do it well. We are a Refuse Disposal site , is there any
Disposal Management Database examples out there….. If not can I get
some free advice and help in designing this database . Are my tables
looking okay? Can I use the( Incident # )as the primary key for all
the tables to connect them ? In one of the tables I want to put
digital pictures of the dump sites can I develop a table for this to
get them to show up on the form..or do I need another database?? There
are about a 100 pic's.. in all. I have to scan them in using the
..bmp ext. is this okay???. My OS is Win Xp Home Editon and Office Xp
Pro 2002 I only have 128 Mb memory….Do I need more? Here are the
tables with the fields: I have gathered the following information from
the 3 forms that the staff fills out by hand and then the secretary
takes 3months worth and then types them out to look better. I am
confused on how to design the table logic and make it relational

Customer
1. Location/Name
2. Incident #
3. Directions from the court house
4. Latitude and Longitude
5. Dump Size = (ft) Width x (ft)Length x (ft) Depth = (ft)to the
3rd power volume
6. Single Axle Dump trucks
7. A water Well within the dumpsite (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 Fields are Yes/No Boxes)
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 Y/N Boxes

1. Paved
2. Gravel/dirt
3. steep slope
4. trees surrounding site
5. water surrounding site
6. other/ List

Type of setting 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

Equipment Cost Table
1. Equipment Type
2. Max Hourly Rate
3. actual hourly rate
4. hours used
5. total
Disposal Fee table

1. Facility Name and location
2. Tons estimated
3. Per ton cost
4. total

Labor Cost table

1. Employee Title
2. estimated work hours
3. hourly wage
4. total

Miscellaneous Supplies
1. Specific Item
2. quantity
3. per unit cost
4. total

Thanks John
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
It's funny, because I gave you some solid information in response to you
posting this exact same thing on tek-tips.com, and you responded to someone
else's post and ignored mine. Now you're over here wasting more people's
time.

Have fun.

--
Jeremy Wallace
AlphaBet City Dataworks
http://www.ABCDataworks.com
"John C" <jo***********@hotmail.com> wrote in message
news:57**************************@posting.google.c om...
I am trying to develop a access database version 2002 from scratch
and I am a novice programmer and need much direction. I have been
researching and studying about relational database design and
normalization I am including the 9 tables and there fields that I
have already developed. I have and I am not sure what to name the
tables and I am thinking of making the incident # field the pimary
key?? Can I put that in all the tables? I am determined to develop
this and do it well. We are a Refuse Disposal site , is there any
Disposal Management Database examples out there... If not can I get
some free advice and help in designing this database . Are my tables
looking okay? Can I use the( Incident # )as the primary key for all
the tables to connect them ? In one of the tables I want to put
digital pictures of the dump sites can I develop a table for this to
get them to show up on the form..or do I need another database?? There
are about a 100 pic's.. in all. I have to scan them in using the
.bmp ext. is this okay???. My OS is Win Xp Home Editon and Office Xp
Pro 2002 I only have 128 Mb memory..Do I need more? Here are the
tables with the fields: I have gathered the following information from
the 3 forms that the staff fills out by hand and then the secretary
takes 3months worth and then types them out to look better. I am
confused on how to design the table logic and make it relational

Customer
1. Location/Name
2. Incident #
3. Directions from the court house
4. Latitude and Longitude
5. Dump Size = (ft) Width x (ft)Length x (ft) Depth = (ft)to the
3rd power volume
6. Single Axle Dump trucks
7. A water Well within the dumpsite (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 Fields are Yes/No Boxes)
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 Y/N Boxes

1. Paved
2. Gravel/dirt
3. steep slope
4. trees surrounding site
5. water surrounding site
6. other/ List

Type of setting 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

Equipment Cost Table
1. Equipment Type
2. Max Hourly Rate
3. actual hourly rate
4. hours used
5. total
Disposal Fee table

1. Facility Name and location
2. Tons estimated
3. Per ton cost
4. total

Labor Cost table

1. Employee Title
2. estimated work hours
3. hourly wage
4. total

Miscellaneous Supplies
1. Specific Item
2. quantity
3. per unit cost
4. total

Thanks John

Nov 12 '05 #2

P: n/a
Mr. Wallace I apologize, so much is going on I thought you meant post
over here to and get some more opinions. I am taking you advice and
reading the article by Paul Litwin... Also the access naming
coventions...please bare with me and thanks a 1000 times for you
help. One question about Mr. Litwins article its for an older version
of access will that confuse me since I am using access 2002?
Thanks
John Cossiboom


"Jeremy Wallace" <ab**********@AlphaBetCityDataworks.com> wrote in message news:<Ne********************@speakeasy.net>...
It's funny, because I gave you some solid information in response to you
posting this exact same thing on tek-tips.com, and you responded to someone
else's post and ignored mine. Now you're over here wasting more people's
time.

Have fun.

--
Jeremy Wallace
AlphaBet City Dataworks
http://www.ABCDataworks.com
"John C" <jo***********@hotmail.com> wrote in message
news:57**************************@posting.google.c om...
I am trying to develop a access database version 2002 from scratch
and I am a novice programmer and need much direction. I have been
researching and studying about relational database design and
normalization I am including the 9 tables and there fields that I
have already developed. I have and I am not sure what to name the
tables and I am thinking of making the incident # field the pimary
key?? Can I put that in all the tables? I am determined to develop
this and do it well. We are a Refuse Disposal site , is there any
Disposal Management Database examples out there... If not can I get
some free advice and help in designing this database . Are my tables
looking okay? Can I use the( Incident # )as the primary key for all
the tables to connect them ? In one of the tables I want to put
digital pictures of the dump sites can I develop a table for this to
get them to show up on the form..or do I need another database?? There
are about a 100 pic's.. in all. I have to scan them in using the
.bmp ext. is this okay???. My OS is Win Xp Home Editon and Office Xp
Pro 2002 I only have 128 Mb memory..Do I need more? Here are the
tables with the fields: I have gathered the following information from
the 3 forms that the staff fills out by hand and then the secretary
takes 3months worth and then types them out to look better. I am
confused on how to design the table logic and make it relational

Customer
1. Location/Name
2. Incident #
3. Directions from the court house
4. Latitude and Longitude
5. Dump Size = (ft) Width x (ft)Length x (ft) Depth = (ft)to the
3rd power volume
6. Single Axle Dump trucks
7. A water Well within the dumpsite (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 Fields are Yes/No Boxes)
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 Y/N Boxes

1. Paved
2. Gravel/dirt
3. steep slope
4. trees surrounding site
5. water surrounding site
6. other/ List

Type of setting 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

Equipment Cost Table
1. Equipment Type
2. Max Hourly Rate
3. actual hourly rate
4. hours used
5. total
Disposal Fee table

1. Facility Name and location
2. Tons estimated
3. Per ton cost
4. total

Labor Cost table

1. Employee Title
2. estimated work hours
3. hourly wage
4. total

Miscellaneous Supplies
1. Specific Item
2. quantity
3. per unit cost
4. total

Thanks John

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.