If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Designing a DB for Tract Home Models w/ Many Options and Categorie
I’m relatively new to Access but I have a fairly good understanding of the
basics. What I am faced with is creating an application to create, maintain and modify “Base House” information for tract home projects. Our customers give us “rack sets” of plans of houses that they build. We build floor system, wall systems and roof systems for these houses. I have looked for a similar template to modify to what I need but just about all the specific information I need has slightly different criteria based on the Customer, the Design Category (Floors, Walls, or Roofs) the Model, the options for each Model and many more. I can’t find anything that even closely represents what I need. I have attempted to teach myself how to create what I need and I’m frankly overwhelmed. Models, and Options, and DesignCategories, and ID’s and multiple options for multiple design departments and on and on. What would be my best approach to creating what I need as quickly and painlessly as I can? |
#3
|
|||
|
|||
Designing a DB for Tract Home Models w/ Many Options and Categorie
On Tue, 24 Jul 2007 14:34:01 -0700, billyradd
wrote: Im relatively new to Access but I have a fairly good understanding of the basics. What I am faced with is creating an application to create, maintain and modify Base House information for tract home projects. Our customers give us rack sets of plans of houses that they build. We build floor system, wall systems and roof systems for these houses. I have looked for a similar template to modify to what I need but just about all the specific information I need has slightly different criteria based on the Customer, the Design Category (Floors, Walls, or Roofs) the Model, the options for each Model and many more. I cant find anything that even closely represents what I need. I have attempted to teach myself how to create what I need and Im frankly overwhelmed. Models, and Options, and DesignCategories, and IDs and multiple options for multiple design departments and on and on. What would be my best approach to creating what I need as quickly and painlessly as I can? Sounds like several many to many relationships... which aren't all that bad. It sounds like you have many Houses, each of which can have many Options; you can handle this with a table of Houses, a table of Options, and a table of OptionsChosen. The options table might have a field for the design category, or you might have separate tables for floors, walls, roofs etc. - I don't know enough about the structure of your data to say. Take a look at some of these references, particularly Crystal's tutorial and the Database Design 101 link on Jeff's webpage. Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP): http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials John W. Vinson [MVP] |
#4
|
|||
|
|||
Designing a DB for Tract Home Models w/ Many Options and Categ
Yes, thank you, very quick and painless and I'm sure you'd do a great job too.
"Steve" wrote: Quick and Painless!!! I will build the database for you for a very reasonable fee. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications "billyradd" wrote in message ... I'm relatively new to Access but I have a fairly good understanding of the basics. What I am faced with is creating an application to create, maintain and modify "Base House" information for tract home projects. Our customers give us "rack sets" of plans of houses that they build. We build floor system, wall systems and roof systems for these houses. I have looked for a similar template to modify to what I need but just about all the specific information I need has slightly different criteria based on the Customer, the Design Category (Floors, Walls, or Roofs) the Model, the options for each Model and many more. I can't find anything that even closely represents what I need. I have attempted to teach myself how to create what I need and I'm frankly overwhelmed. Models, and Options, and DesignCategories, and ID's and multiple options for multiple design departments and on and on. What would be my best approach to creating what I need as quickly and painlessly as I can? |
#5
|
|||
|
|||
Designing a DB for Tract Home Models w/ Many Options and Categ
Thank you very much John. I'll let you know how I make out.
"John W. Vinson" wrote: On Tue, 24 Jul 2007 14:34:01 -0700, billyradd wrote: I’m relatively new to Access but I have a fairly good understanding of the basics. What I am faced with is creating an application to create, maintain and modify “Base House” information for tract home projects. Our customers give us “rack sets” of plans of houses that they build. We build floor system, wall systems and roof systems for these houses. I have looked for a similar template to modify to what I need but just about all the specific information I need has slightly different criteria based on the Customer, the Design Category (Floors, Walls, or Roofs) the Model, the options for each Model and many more. I can’t find anything that even closely represents what I need. I have attempted to teach myself how to create what I need and I’m frankly overwhelmed. Models, and Options, and DesignCategories, and ID’s and multiple options for multiple design departments and on and on. What would be my best approach to creating what I need as quickly and painlessly as I can? Sounds like several many to many relationships... which aren't all that bad. It sounds like you have many Houses, each of which can have many Options; you can handle this with a table of Houses, a table of Options, and a table of OptionsChosen. The options table might have a field for the design category, or you might have separate tables for floors, walls, roofs etc. - I don't know enough about the structure of your data to say. Take a look at some of these references, particularly Crystal's tutorial and the Database Design 101 link on Jeff's webpage. Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP): http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials John W. Vinson [MVP] |
#6
|
|||
|
|||
Designing a DB for Tract Home Models w/ Many Options and Categ
I did an application like this for a customer who does the same thing you do
which I would modify for what you need. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications "billyradd" wrote in message ... Yes, thank you, very quick and painless and I'm sure you'd do a great job too. "Steve" wrote: Quick and Painless!!! I will build the database for you for a very reasonable fee. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications "billyradd" wrote in message ... I'm relatively new to Access but I have a fairly good understanding of the basics. What I am faced with is creating an application to create, maintain and modify "Base House" information for tract home projects. Our customers give us "rack sets" of plans of houses that they build. We build floor system, wall systems and roof systems for these houses. I have looked for a similar template to modify to what I need but just about all the specific information I need has slightly different criteria based on the Customer, the Design Category (Floors, Walls, or Roofs) the Model, the options for each Model and many more. I can't find anything that even closely represents what I need. I have attempted to teach myself how to create what I need and I'm frankly overwhelmed. Models, and Options, and DesignCategories, and ID's and multiple options for multiple design departments and on and on. What would be my best approach to creating what I need as quickly and painlessly as I can? |
#7
|
|||
|
|||
Designing a DB for Tract Home Models w/ Many Options and Categ
On Tue, 24 Jul 2007 17:42:02 -0700, billyradd
wrote: Yes, thank you, very quick and painless and I'm sure you'd do a great job too. Billyrad, you may want to do a quick http://groups.google.com advanced search for Steve's postings on the newsgroup. At the very least get references from previous customers and talk to them. Steve's reputation is not very high around here. John W. Vinson [MVP] |
#8
|
|||
|
|||
Designing a DB for Tract Home Models w/ Many Options and Categ
John,
I am really surprised that you would stoop to the level of Arno R, John Marshall and Keith Wilby!! Steve "John W. Vinson" wrote in message ... On Tue, 24 Jul 2007 17:42:02 -0700, billyradd wrote: Yes, thank you, very quick and painless and I'm sure you'd do a great job too. Billyrad, you may want to do a quick http://groups.google.com advanced search for Steve's postings on the newsgroup. At the very least get references from previous customers and talk to them. Steve's reputation is not very high around here. John W. Vinson [MVP] |
#9
|
|||
|
|||
Designing a DB for Tract Home Models w/ Many Options and Categ
Well, I see discussion groups aren't much different no matter where you go.
My reply to Steve is a bit of sarcasm. I need to build this thing myself or I would have already paid someone to do it. Don't worry about having a reputation Steve, good or bad; it will only take your concentration away from you goals, unless your goal is to have a bad reputation, then in that case... Flame away John! billyradd "Steve" wrote: John, I am really surprised that you would stoop to the level of Arno R, John Marshall and Keith Wilby!! Steve "John W. Vinson" wrote in message ... On Tue, 24 Jul 2007 17:42:02 -0700, billyradd wrote: Yes, thank you, very quick and painless and I'm sure you'd do a great job too. Billyrad, you may want to do a quick http://groups.google.com advanced search for Steve's postings on the newsgroup. At the very least get references from previous customers and talk to them. Steve's reputation is not very high around here. John W. Vinson [MVP] |
#10
|
|||
|
|||
Designing a DB for Tract Home Models w/ Many Options and Categ
On Wed, 25 Jul 2007 15:26:39 GMT, "Steve" wrote:
John, I am really surprised that you would stoop to the level of Arno R, John Marshall and Keith Wilby!! shrug If I were offering my own services (which I'm not) I would advise him to get references and check my posting history. If you have good references and satisfied customers, let him know. John W. Vinson [MVP] |
|
Thread Tools | |
Display Modes | |
|
|