Re: Access Bankng Solution

Take a look over at www.databaseanswers.com

They probably have a model of your application.

<mazubair_at_gmail.com> wrote in message news:1115110754.686745.154440_at_o13g2000cwo.googlegroups.com...
> Hi All,
>
> I am going to develop a Banking Solution for very small branches of a
> Bank. The branches are standalone and no remote transactions will be
> made i.e. only the individual branch will be under networking and there
> will be no networking between the branches. The branches have maximum
> 10000 (ten thousand) customer accounts, maximum 200 daily transactions
> (120000 yearly including processed transactions i.e. interest, charges
> etc.) and maximum 3 to 4 concurrent users. The solution will provide
> voucher generation, interest calculation and interest anticipation,
> batch posting etc. facility. The system will generate over 100 reports,
> some of them are too complex (manipulate data from several tables,
> calculate, summaries, make group etc.).
>
> The expertise level of the user of the solution is very low. High end
> Database will not be suitable for them.
>
>
> I intend to develop the solution with MS Access as Database, Visual
> Basic as Tool and Crystal Report as Report Builder.
>
>
> Should I ?
>
> 1) Proceed with the Idea.
> 2) For better performance should I split the Transactions Table for
> different types of Accounts. There will be maximum 200000 records in
> whole yearly.
> 3) Split the Cheque information Table (Account Type wise or Year wise)
> which will store 500000 yearly records.
> 4) Some one are suggesting using different databases for different
> types of account. Should I go for that.
>
>
> Your valued suggestion will help me a lot to take decision.
>
>
> M. A. Zubair
> mazubair_at_gmail.com
>
Received on Sat May 07 2005 - 22:00:14 CEST