G
Guest
Could someone help me with a jumpstart on the basic structure of this
database? It’s been a few years since I’ve worked with Access.
This database is for a small home inspection company. A buyer or seller of
a home hires the home inspector to provide a report on the condition of the
property. The data base has these components.
Major areas of the property consist of:
Grounds
Exterior
Foundation
Roof
Plumbing
Heating
Electrical
Interior
Garage
Kitchen
Bathrooms
Pool/Spa
Each of these major areas has specific categories that are inspected. For
example, the Grounds would have these things:
Driveway
Sidewalks
Retaining walls
Patio
Decks
Fences and gates
Each of these specific Categories need to be reported on. Using the
Driveway as an example, there are observations that the inspector needs to
call to the attention of the client through this report. These are some of
the observations he might comment on using a checklist approach and using a
check box approach to add the item to the final report:
( ) Appears serviceable
( ) Not functional
( ) Unsafe
( ) Near end of life span
( ) Eroded asphalt
( ) No cracks found
( ) Major cracks
( ) Evidence of poor drainage
Each of the above comments would be added to the Driveway part of the report
by activating the check box. For each of these items in the data base, the
item would not only have the checkbox for automatically adding it to the
report but also a description field attached to it so the inspector can add
whatever comment he deems necessary to describe his findings of that checked
item.
All of the above would be tied to a Customer ID, name, address, etc.
I envision a FORM for each section of the final report. For example GROUNDS
would be the title of a form and the title of a page in the report. Then
under GROUNDS, a sub section titled “Drivewayâ€. Then below that would be the
check box items applicable to the condition of the Driveway: i.e. “Appears
serviceable†(with a memo field), “Not functional†(with a memo field), etc.
He’d then check those appropriate conditions and add his comments to each.
Just those conditions would appear in the Driveway part of the GROUNDS page
of the report.
My problem is I can’t visualize how to set up the tables.
I suppose I’d have individual tables for the major areas, i.e. a table for
GROUNDS, FOUNDATION, ROOF, ETC. But then how do I incorporate for the
GROUNDS table the Driveway information versus the Sidewalks information, etc.
And then one layer deeper, how do I incorporate the check list items
appropriate to the Driveway with an appropriate memo fields for a freeform
narrative?
Any guidance would be much appreciated!
Jerry
database? It’s been a few years since I’ve worked with Access.
This database is for a small home inspection company. A buyer or seller of
a home hires the home inspector to provide a report on the condition of the
property. The data base has these components.
Major areas of the property consist of:
Grounds
Exterior
Foundation
Roof
Plumbing
Heating
Electrical
Interior
Garage
Kitchen
Bathrooms
Pool/Spa
Each of these major areas has specific categories that are inspected. For
example, the Grounds would have these things:
Driveway
Sidewalks
Retaining walls
Patio
Decks
Fences and gates
Each of these specific Categories need to be reported on. Using the
Driveway as an example, there are observations that the inspector needs to
call to the attention of the client through this report. These are some of
the observations he might comment on using a checklist approach and using a
check box approach to add the item to the final report:
( ) Appears serviceable
( ) Not functional
( ) Unsafe
( ) Near end of life span
( ) Eroded asphalt
( ) No cracks found
( ) Major cracks
( ) Evidence of poor drainage
Each of the above comments would be added to the Driveway part of the report
by activating the check box. For each of these items in the data base, the
item would not only have the checkbox for automatically adding it to the
report but also a description field attached to it so the inspector can add
whatever comment he deems necessary to describe his findings of that checked
item.
All of the above would be tied to a Customer ID, name, address, etc.
I envision a FORM for each section of the final report. For example GROUNDS
would be the title of a form and the title of a page in the report. Then
under GROUNDS, a sub section titled “Drivewayâ€. Then below that would be the
check box items applicable to the condition of the Driveway: i.e. “Appears
serviceable†(with a memo field), “Not functional†(with a memo field), etc.
He’d then check those appropriate conditions and add his comments to each.
Just those conditions would appear in the Driveway part of the GROUNDS page
of the report.
My problem is I can’t visualize how to set up the tables.
I suppose I’d have individual tables for the major areas, i.e. a table for
GROUNDS, FOUNDATION, ROOF, ETC. But then how do I incorporate for the
GROUNDS table the Driveway information versus the Sidewalks information, etc.
And then one layer deeper, how do I incorporate the check list items
appropriate to the Driveway with an appropriate memo fields for a freeform
narrative?
Any guidance would be much appreciated!
Jerry