Dear Lazyweb,

Jun 15, 2008 20:27

Anyone out there know how to use Access ( Read more... )

Leave a comment

Comments 3

nemene June 16 2008, 15:46:04 UTC
Access is a database not a spreedsheet, so having calulated values based on another value is actually a very complicated task, not an easy one.

Reply


mandyessa June 18 2008, 01:16:32 UTC
I have used Access alot, and he is right, it is a database, so you can put information in and pull up reports; however, interdependent information is not neccessarily desirable in a database, usually you want to be able to pull up raw data to compare or analize. What is your goal? I would feel better telling you if you could use it to reach your goal and the easiest way to do that.

Reply

sillygoosegirl June 22 2008, 03:37:36 UTC
There are a few things I'm trying to do, but the easiest and probably most important to me is to copy data out of a template table into a line in the database. So, for example, rent is always $900 paid to Kathy with a check and part of the housing budget category, and I have that information stored in the template, so I want to be able to just enter a mnemonic of "rent" and auto populate the database based on that (leaving me only needing to type in the date). I want to actually copy the data in because even though rent is always $900 this year, it'll be something a little different next year. Some transactions will be entered completely from scratch, and a lot will have a less complete template (phone bill is the same company each month from the same account and the same budget category, but a varying amount).

Reply


Leave a comment

Up