By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,982 Members | 1,738 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,982 IT Pros & Developers. It's quick & easy.

Just Learning and Need Guidance! Please!

P: n/a
Hello,
I am just reading up and learning how to use Access. I have always
made Excel work for me in the past. I want to create a db that will
allow me to track expenses at my job. I want to be able to input the
Dept. that is billed and the item numbers that we are charging to them
from our supplier. I would like the db to be able to them take that
and automatically associate that item number with a description and
cost. Quantity would be nice as well.
I am not sure how to even start this, and I have been searching the
web and reading for two weeks now and have just confused myself a
great deal!
THANK YOU to all who could help me get started! I would like to learn
to better utilize this program!

Mar 14 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
It sounds like to get started you will need a table with your item
number, description, and cost. You'll probably also want a form that
will allow you to input the department number, item number, and
quantity used. Are you tracking inventory as well with this? If so,
you'll probably want a table with your "current inventory" that gets
updated as items are used, and a "details" table that has what was
used by which department. You can use the item number as your common
field between the tables. I'm not sure if this really helps you get
started or not...

Mar 14 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.