Can you help me set up a database / or make me a temlplate

P

PLShelpME

I need help making a database to track all my financial account info.
I want to keep track of all my accounts payable and receivable.

I have already set up 2 tables.
1) The contact information for my accounts
2)The specific account information (Acct #, monthly payment amt, due dates,
current/delinquent credit reporting status, account type)

I still need a table for all the receipts I have, and a table for my job
incomes.

I want to be able to enter new information as needed, and also be able to
search through the information. Such as all the accounts that I have at one
place or all the accounts in a negative status... etc.

Is there anyone willing to create a template?

I have tried doing it on my own, but I cannot get past the tables.

I hit really bad financial times, and am starting to clear up my debts. The
database will be for my personal reference. PLEASE HELP ME... THANK YOU!
 
L

Larry Linson

Accounting software packages are so inexpensive that it really is not
worthwhile to create one in Access. Perhaps you do not realize that even
simple accounting software packages require deep knowledge of accounting and
thousands of hours of effort? That is far too much to ask of the volunteers
who answer questions here.

That type of help is not what newsgroups are for -- newsgroups are for
helping with specific problems people encounter using the subject software,
and they are very good for that purpose.

You might search at Source Forge or other sites for open source accounting
packages if you can't even afford the least of the commercial packages.

Larry Linson
Microsoft Office Access MVP
 
P

PLShelpME

I don't need anything that does computations.
I just need a basic data entry form. Something that can keep track of all my
accounts and their credit agency reporting status, as well as the basic
account info.

I want to be able to search through my account statuses, and also add or
delete accounts with one form.

I am a fast learner, if someone can explain it to me without using all the
codes or at least breaking the codes down first, I might be able to do it on
my own. I've tried the tutorials & trainings... all week, but then it was a
lot of coding.

But Thank you Larry!
 
J

Jeff Boyce

"Easy" ... is HARD!

You are asking for something that is easy to use and has some specific
features. As Larry points out, that will take considerable time to do.

Why save yourself $50 by not buying some accounting software, but cost
yourself 100's of hours to learn enough to make yourself an "easy to use"
"accounting" application?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
S

Steve

I provide help with Access, Excel and Word applications for a small fee. I
could work with you to create what you want for a very modest cost. Contact
me if you want to work together.

Steve
(e-mail address removed)
 
J

John... Visio MVP

Steve said:
I provide help with Access, Excel and Word applications for a small fee. I
could work with you to create what you want for a very modest cost. Contact
me if you want to work together.

Steve




Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP
 
J

Jeff Boyce

These newsgroups provide FREE assistance. The Code of Conduct prohibits
solicitation.

Before you sign up with someone who offers fee-for-service here, consider
whether you want to work with someone who knowingly disregards the rules...

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
P

PLShelpME

Thanks for the help. Sorry to waste your time.

Finally had it done, my brother was able to show me!
 
L

Larry Linson

PLShelpME said:
Thanks for the help. Sorry to waste your time.

Finally had it done, my brother was able to show me!

Then we must have a severe language barrier, because there has not even been
sufficient time for you to describe in detail what you want, in sufficient
detail, to perform accounting software functions as you described -- much
less for your brother to show you (what?) and you to do it.

Larry Linson
Microsoft Office Access MVP
 
P

PLShelpME

No,there is no language barrier.

I said I just needed a form to search through all the account info,
basically applying filters. So that, if I needed info for all the accounts at
one bank, or all my student loans, I'd have it by running the search

So, with the assistance of my brother (who wasn't home the other day), he
walked me through setting up the form's controls.

I didn't need any accounting calculations.
The database contains basic account information, as well as a listing of all
the receipts I have... just in case I lose the actual one.
 
D

De Jager

Larry Linson said:
Then we must have a severe language barrier, because there has not even
been sufficient time for you to describe in detail what you want, in
sufficient detail, to perform accounting software functions as you
described -- much less for your brother to show you (what?) and you to do
it.

Larry Linson
Microsoft Office Access MVP
 
W

Woody Buresh

PLShelpME said:
I need help making a database to track all my financial account info.
I want to keep track of all my accounts payable and receivable.

I have already set up 2 tables.
1) The contact information for my accounts
2)The specific account information (Acct #, monthly payment amt, due
dates,
current/delinquent credit reporting status, account type)

I still need a table for all the receipts I have, and a table for my job
incomes.

I want to be able to enter new information as needed, and also be able to
search through the information. Such as all the accounts that I have at
one
place or all the accounts in a negative status... etc.

Is there anyone willing to create a template?

I have tried doing it on my own, but I cannot get past the tables.

I hit really bad financial times, and am starting to clear up my debts.
The
database will be for my personal reference. PLEASE HELP ME... THANK YOU!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top