Database in Visual Studio 2010 - SQL sever

Pls try this in VS 2010 (VB 2010), The tables are Expenses table, Income Table, Transfer Funds table, Budget table. Each table has its own form for data entry. Records in all the tables are the same type (e.g. HR department, Accounts Department, Transport department etc). A budget is assigned to each department for a whole year. When a department is spending, using the expense form, the Income table is reduced .eg, if Transport Dept is spending, the Transport field in the income table should also reduce by the same figure. Again, if money is transferred from one depart to another, the effect should be felt on the other department, ege. if fund is transferred from HR dept to Accounts dept, the HR dept should reduce and the Accounts dept should increase.