VBA / Access work for a bank?

[TinaP]

So is most of the work you do in a bank analysing the savings/loan book or is it reporting commercial expenditure much like any other industry (i.e. payroll, advertising, marketing, overheads etc)

Mostly I analyze savings and loan data, but occasionally I'm called upon to prepare reports much like any other business. Analyze payroll costs, branch profitability, etc.

I don't know of any books out there other than textbooks. While in college, I took some business and finance courses and they've helped me, but most of my banking knowledge comes from asking lots of questions of the end-users and listening very intently.

 

[TinaP]

Tina, you'd love how easy it is to use Access to manage AS/400 data. I used to download millions of records a week into Access, then further query the data into Excel. And now that you have PowerPivot, you could link directly to the AS/400 from Excel.

I know enough about Access to salivate over the possibilities, but it really isn't practical since only three others have it in the bank. I'm in the IT department, so I don't analyze the data so much as put it in a meaningful format for others.