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
|
|||
|
|||
Have to design database - no idea where to start
I have to design a database that will be used to do Bussines Plans.
I know how to create the tables , I am just not sure if what I am planning will work. I need to have various fields that will be text fields that the client will have to complete. My big concern which I am not certain about is: If I create a lot of tables and I set the relationship, is the best way to set it going to be the That the client Number will have to be put into every table? |
#3
|
|||
|
|||
Have to design database - no idea where to start
Knowing "how to create the tables" is not as important as knowing "when".
Any pile of facts can be put into a table. To get the most out of Access' features and functions, you need to spend the time to normalize your data. This is best accomplished by first turning off the computer, then picking up pencil and paper and drawing boxes and lines. Each box represents a different "entity" (a concept about which you wish to store information). Take a look at the topic of normalization to get the entities down. Then look for how the entities are related. These are the lines. For example, if you were building an Order Entry system, one Person (an entity) could have zero, one or more Orders (another entity). And one Order could have one or more Order Items (another entity). Good luck on your project. Jeff Boyce Microsoft Office/Access MVP "Access Africa" Access wrote in message ... I have to design a database that will be used to do Bussines Plans. I know how to create the tables , I am just not sure if what I am planning will work. I need to have various fields that will be text fields that the client will have to complete. My big concern which I am not certain about is: If I create a lot of tables and I set the relationship, is the best way to set it going to be the That the client Number will have to be put into every table? |
#4
|
|||
|
|||
Have to design database - no idea where to start
The idea behind the database is that we brake the standard bussiness plan down in simple questions and that the answers get pulled through to a standard report , which will cover all the sections of s business plan. I took the basic Bussiness Plan template from Word and I am using some of the info from there. My Switch Board Items will be: Executive summary and table of contents................. Personal information.... Details of personal assets... Details of personal liabilities. Business description............ Market analysis.................... Marketing and sales activities..... Products and services.. Operations................... Source and application of funding...... Financial data..................................... Notes......... Appendices or exhibits............. Administrative considerations... Market Analysis......................... Marketing and Sales Activities My big thing is that I am just not sure how to link all the tables up , so that each record (Single Client) will be linked to all the tables. I also have to design it so that it can generate finacials (cash-flow, income statement and balance sheet) from data the client provides. The idea behind this is to help young business, who does not have any knowledge on business plans to be able to complete the questions and have a business plan that they understand and that the banks will consider for funding as well. |
#5
|
|||
|
|||
Have to design database - no idea where to start
Please re-read my response.
How you present the tasks to the user is not limited to how you've organized the data. But failing to spend the time normalizing your data structure will seriously constrain how/if you are able to present the data for your users' benefit. -- Regards Jeff Boyce Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ "Access Africa" wrote in message ... The idea behind the database is that we brake the standard bussiness plan down in simple questions and that the answers get pulled through to a standard report , which will cover all the sections of s business plan. I took the basic Bussiness Plan template from Word and I am using some of the info from there. My Switch Board Items will be: Executive summary and table of contents................. Personal information.... Details of personal assets... Details of personal liabilities. Business description............ Market analysis.................... Marketing and sales activities..... Products and services.. Operations................... Source and application of funding...... Financial data..................................... Notes......... Appendices or exhibits............. Administrative considerations... Market Analysis......................... Marketing and Sales Activities My big thing is that I am just not sure how to link all the tables up , so that each record (Single Client) will be linked to all the tables. I also have to design it so that it can generate finacials (cash-flow, income statement and balance sheet) from data the client provides. The idea behind this is to help young business, who does not have any knowledge on business plans to be able to complete the questions and have a business plan that they understand and that the banks will consider for funding as well. |
#6
|
|||
|
|||
Have to design database - no idea where to start
"Jeff Boyce" wrote: Jeff, I am looking into the normalization of the data at the moment. I understand what you are saying, and I busy reading up on it at the moment. Thanks for your help. |
#7
|
|||
|
|||
Have to design database - no idea where to start
The business plan template from Word, *will not give you* the design of
the table structures in Access. To design the table structures in Access, you need to use a non-trivial, non-intuitive process called "database normalization". If you do not know what this is, you need to learn about it *before you go any further*. Google the Access groups for that term, there will be lots of references HTH, TC (MVP Access) http://tc2.atspace.com |
#8
|
|||
|
|||
Have to design database - no idea where to start
TC
I am using the template only as a starting point to gather information , I am also using various other sources to make sure that I have all aspects of the BP covered. I have found a few links to Database Normaliszation, thanks for your reply "TC" wrote: The business plan template from Word, *will not give you* the design of the table structures in Access. To design the table structures in Access, you need to use a non-trivial, non-intuitive process called "database normalization". If you do not know what this is, you need to learn about it *before you go any further*. Google the Access groups for that term, there will be lots of references HTH, TC (MVP Access) http://tc2.atspace.com |
#9
|
|||
|
|||
Have to design database - no idea where to start
Ok, glad I could help.
"Database Normalization" truly is the essential thing to understand here. Feel free to post back to this group, if you have any further questions. Cheers, TC (MVP Access) http://tc2.atspace.com |
#10
|
|||
|
|||
Have to design database - no idea where to start
take a look at http://home.att.net/~california.db/tips.html, which is
focused specifically on helping newbies start off on the right foot, and be sure to follow the link in Tip#1. hth "Access Africa" wrote in message ... TC I am using the template only as a starting point to gather information , I am also using various other sources to make sure that I have all aspects of the BP covered. I have found a few links to Database Normaliszation, thanks for your reply "TC" wrote: The business plan template from Word, *will not give you* the design of the table structures in Access. To design the table structures in Access, you need to use a non-trivial, non-intuitive process called "database normalization". If you do not know what this is, you need to learn about it *before you go any further*. Google the Access groups for that term, there will be lots of references HTH, TC (MVP Access) http://tc2.atspace.com |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combo Box AfterUpdate Help | Harry Thomas | Database Design | 21 | January 9th, 2006 12:16 AM |
Database Design Tools | Thomas Kroljic | Database Design | 12 | October 25th, 2005 03:34 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Access Error Message when opening database | eah | General Discussion | 3 | January 26th, 2005 10:04 AM |
Exclusive access to the database | Steve Huff | General Discussion | 17 | December 24th, 2004 06:23 PM |