Account Ledger

[Guest]

I want to design a databse that ahndle general ledger like msaccess ledger
template but in that template there is no check handling and bank reconcile
process some can tell me the idea of bank reconcile process with tables

 

[John W. Vinson]

I want to design a databse that ahndle general ledger like msaccess ledger
template but in that template there is no check handling and bank reconcile
process some can tell me the idea of bank reconcile process with tables

I'd really suggest not reinventing the wheel here. Microsoft Money, Intuit's
Quicken, and a plethora of other programs already exist to do all this and
much more. They're inexpensive, especially if you put any value on the many
hours you could spend setting up an Access program to do a fraction of what
they can do.

John W. Vinson [MVP]

 

[Guest]

What a strange answer for a person who want to do somthing a man says don't
try to do something and don't polish your skills because others are polished
well. Means that every one should avoid to learn and think that what the
other are doing well i think it may be the thinking of a man who don't want
to do anything in his field and don't want to learn.

 

[John W. Vinson]

What a strange answer for a person who want to do somthing a man says don't
try to do something and don't polish your skills because others are polished
well. Means that every one should avoid to learn and think that what the
other are doing well i think it may be the thinking of a man who don't want
to do anything in his field and don't want to learn.

I'm sorry, Mallick; I didn't get the "backstory" from your post. It sounded
like you wanted a quick and easy way to do account ledgers; my suggestion is
what I would recommend as a way to do account ledgers.

If you're using this as a learning exercise, well and good; it's certainly an
instructive (and nontrivial, as you'll find!) problem space. You may not end
up with the slickest account-ledger program in the world, or you may spend a
great deal of time and actually do so!

To start with, I'd suggest learning the basics of relational design theory.
Identify the "Entities" - real-life persons, things, or events - relevant to
your task; identify their attributes; identify their relationships; identify
the constraints. Create tables and relationships to fit these. It's not clear
to me just what you want the database to accomplish so I can't really suggest
what these would be, but if you'ld like to discuss it, this is a good place to
do so.

Some resources to investigate are:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

John W. Vinson [MVP]

 

[Guest]

Thanks for encouraging reply i have done what you said to do now if you can
help me to find out the actual solution i can send you complete detail of
tables design i have done just put me to the right direction if i am going
wrong. I will be very thankfull to you for that help. let me know please or
tell me the forums where i can disscuss my problems regarding msaccess as
well as mssql i am working on both.

Thanks again

 

[John W. Vinson]

Thanks for encouraging reply i have done what you said to do now if you can
help me to find out the actual solution i can send you complete detail of
tables design i have done just put me to the right direction if i am going
wrong. I will be very thankfull to you for that help. let me know please or
tell me the forums where i can disscuss my problems regarding msaccess as
well as mssql i am working on both.

You can use any newsreader - Outlook Express, Microsoft Mail, Agent or Free
Agent (www.forteinc.com) - to connect to these newsgroups. You needn't use the
Microsoft webpage, many of us don't. There are many Access and SQL server
newsgroups; we're all volunteers donating our time here, nobody's paid to
provide answers; but there are lots of good folks who will see to it that
questions get answered.

If you wish to post a description of your tables in the format

Tablename
Fieldname <Datatype, Primary Key>
Fieldname <datatype>
Fieldname <datatype>

Tablename
<and so on>

along with a description of your table relationships; and any specific
problems that you're having, we'll try to help.

John W. Vinson [MVP]

 

[Guest]

Thanks john i will send you the complete detail what i have and what i want
to do in full description but in that news reply i don't found any atteching
facility how i can attech my document with the reply or please send me your
email address so i can do so or let me know if is there any way to attech
document with that disscussion reply. Right now i am waiting for your answer
and will take action to prepare a complete document and send it to you after
your answer.

Many many thanks to offer your help for me

 

[John W. Vinson]

Thanks john i will send you the complete detail what i have and what i want
to do in full description but in that news reply i don't found any atteching
facility how i can attech my document with the reply or please send me your
email address so i can do so or let me know if is there any way to attech
document with that disscussion reply. Right now i am waiting for your answer
and will take action to prepare a complete document and send it to you after
your answer.

I am a self-employed computer consultant, *volunteering my time free of charge
on these newsgroups*. I do provide private EMail support for paying clients,
but I do not solicit business on the newsgroups.

If you would like free support, please reread my suggestion, and post a text
description of your tables as a message here on the newsgroup. I, or one of
the other volunteers, will be glad to try to help, free of charge. What you're
asking goes beyond what I'm comfortable doing for free.


John W. Vinson [MVP]