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. :-(

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. :-(

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. :-(