Access Bankng Solution

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 Tue May 03 2005 - 03:59:14 CDT