Budget Table
Hi Duane,
This is fabulous advice. Thank you for your input. I may have questions
down the road but this will definitely help me to get started. Thanks a
million!
"Duane Hookom" wrote:
First, I would remove all spaces from field names. The AmountSaved I expect
is the difference between the ProjectedCost and ActualCost so there is no
reason to create this field and/or save the value.
I use a naming convention that would create a table like:
tblExpenses
===============
expExpID
expExCID link to tblExpenseCategories.ecaExCID
expDate
expItem
expProjectedCost
expActualCost
expComments
tblExpenseCategories
==================
excExCID autonumber primary key
excTitle name of category like "Rent","Groceries","Entertainment", "Beer"
--
Duane Hookom
Microsoft Access MVP
"Jazz" wrote:
I am creating a database to track what I spend my money on. I am planning to
include the following fields in my table.
Expense ID
Expense Category
Purchase date
Expense Item Description
Projected Cost
Actual Cost
Amount Saved
Comments
Considering my intention to track what I spend my money on,what do you think
of my table design? Would you recommend different field names, additional
field names, or keep the ones I have?
|