A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can you help me make a simple database / template



 
 
Thread Tools Display Modes
  #1  
Old March 7th, 2010, 05:20 AM posted to microsoft.public.access.tablesdbdesign
PLShelpME
external usenet poster
 
Posts: 7
Default Can you help me make a simple database / template

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!
  #2  
Old March 7th, 2010, 06:06 AM posted to microsoft.public.access.tablesdbdesign
John... Visio MVP
external usenet poster
 
Posts: 900
Default Can you help me make a simple database / template

Any reason why you did not try one of the commercially available packages
like Quicken? Unless there is something special in your needs it may not be
wise to try and reinvent the wheel.

These newsgroups are for free peer to peer help, you may get solicited by
someone offering to do it for a reasonable fee. Be careful. Thoroughly check
the individuals references. We have a pet troll who likes to offer
questionable work at unreasonable prices.

John... Visio MVP
"PLShelpME" wrote in message
...
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!



  #3  
Old March 7th, 2010, 10:15 AM posted to microsoft.public.access.tablesdbdesign
PLShelpME
external usenet poster
 
Posts: 7
Default Can you help me make a simple database / template

I didn't try an accounting program because I do not have one... but maybe
soon I can get one.

I do have Access 2007, and I can do all the tables.
I just can't figure out how to make the forms and queries so I can search
for specific or certain details.
I also want to include the credit agency reporting status and other
information that probably won't be in an accounting program, like maybe
assets related to the accounts.

I'm a really fast learner, but I just get lost with all the codes in the
tutorials & trainings. If anyone can show or explain it to me... I'd be MORE
THAN happy to do it myself.

Thanks for the tip about the "helpers"


THANKS AGAIN!

"John... Visio MVP" wrote:

Any reason why you did not try one of the commercially available packages
like Quicken? Unless there is something special in your needs it may not be
wise to try and reinvent the wheel.

These newsgroups are for free peer to peer help, you may get solicited by
someone offering to do it for a reasonable fee. Be careful. Thoroughly check
the individuals references. We have a pet troll who likes to offer
questionable work at unreasonable prices.

John... Visio MVP
"PLShelpME" wrote in message
...
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!



.

  #4  
Old March 7th, 2010, 10:24 AM posted to microsoft.public.access.tablesdbdesign
PLShelpME
external usenet poster
 
Posts: 7
Default Can you help me make a simple database / template

Also, I don't need it to do any calculations
  #5  
Old March 7th, 2010, 04:32 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default Can you help me make a simple database / template

You posted this same request in another newsgroup. Not only does this
require you to look in multiple places to see if you have an answer, it
causes those folks here in the groups to 'step on' each other's work, not
realizing that your question was already answered.

If you feel you must post to more than one group (rarely necessary), put all
the groups in the To: or News Server: field. That way, an answer in one
shows up in all.

--

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.

"PLShelpME" wrote in message
...
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!



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.