How should I design this Information

  • Thread starter Thread starter naja
  • Start date Start date
N

naja

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
 
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
 
Back
Top