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
|
|||
|
|||
How should I design this Information
I have to create a DB that contains the following fields and criteria, but I
haven't been successful since my knowledge of Access is very little. I have checked couple of websites and look into the way their setup the DB but none of them fit my need. Label Field Type Comments Person Reporting Text Default with authors name PNA IT Group Pull Down Values should be each It Dept name ) Category Pull Down Values: Hardware, Software, Contract Savings Type Pull Down Values: Savings, Cost Avoidance Title Short Description - S/B a brief description like a title Action Taken Text Ability to enter what action was taken Date Savings Starts Date Format of MMYY Attachments Available to put in additional attachments for detail information __________________________________________________ ______________ Table for people to enter $$ into (bottom of form) Fiscal Year Mthly Amount Yearly Amount 8 9 10 ----------------------------------------------------------------------------------------- If anybody can give a hand on this, I will truly appreciated. I have been struggling with this for a while. :-( |
#2
|
|||
|
|||
How should I design this Information
It would be difficult for anyone here to give you specific advice on
how to set up your tables because we don't know how the different entities of your data relate to one another. The best advice I could offer right now is that you should look at the following resources. They will provide you with excellent advice on normalization and table design in the relational model. You should start with the tutorial by Crystal. It is a vey good starting point. 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 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 -- _________ Sean Bailey "naja" wrote: I have to create a DB that contains the following fields and criteria, but I haven't been successful since my knowledge of Access is very little. I have checked couple of websites and look into the way their setup the DB but none of them fit my need. Label Field Type Comments Person Reporting Text Default with authors name PNA IT Group Pull Down Values should be each It Dept name ) Category Pull Down Values: Hardware, Software, Contract Savings Type Pull Down Values: Savings, Cost Avoidance Title Short Description - S/B a brief description like a title Action Taken Text Ability to enter what action was taken Date Savings Starts Date Format of MMYY Attachments Available to put in additional attachments for detail information __________________________________________________ ______________ Table for people to enter $$ into (bottom of form) Fiscal Year Mthly Amount Yearly Amount 8 9 10 ----------------------------------------------------------------------------------------- If anybody can give a hand on this, I will truly appreciated. I have been struggling with this for a while. :-( |
#3
|
|||
|
|||
How should I design this Information
based on your comment fields, here's what I think you are after
Table IT_Groups ID key field Group_name Table Savings_Types ID Type Table Savings_Category ID Category Table Savings_proposals ID key Person_reporting as you describe IT_Group (lookup from IT_Groups.ID) Category (lookup from Savings_Category.ID) Type (lookup from Savings_Type.ID) Title as you describe Action_taken as you describe Start_date as you describe Attachements as you describe Table Savings_amounts Proposal_ID (from Savings_proposals.ID) Fiscal_Year Monthly_amount Yearly_amount "naja" wrote: I have to create a DB that contains the following fields and criteria, but I haven't been successful since my knowledge of Access is very little. I have checked couple of websites and look into the way their setup the DB but none of them fit my need. Label Field Type Comments Person Reporting Text Default with authors name PNA IT Group Pull Down Values should be each It Dept name ) Category Pull Down Values: Hardware, Software, Contract Savings Type Pull Down Values: Savings, Cost Avoidance Title Short Description - S/B a brief description like a title Action Taken Text Ability to enter what action was taken Date Savings Starts Date Format of MMYY Attachments Available to put in additional attachments for detail information __________________________________________________ ______________ Table for people to enter $$ into (bottom of form) Fiscal Year Mthly Amount Yearly Amount 8 9 10 ----------------------------------------------------------------------------------------- If anybody can give a hand on this, I will truly appreciated. I have been struggling with this for a while. :-( |
Thread Tools | |
Display Modes | |
|
|