I'm Ron, a corporate finance professional in NYC

[Ron in NYC]

I was first introduced to databases in 1987 with Paradox - a nice DOS based and powerful relational database. I started using ACCESS a few years later. I was working as an economic analyst and used it to analyze the housing market, labor forces, and other data. I later used it in my work in healthcare to analyze "SPARCS" data. SPARCS is a NYS database of ALL hospital admissions and includes facility, age, admittance and 10, or so, post admission diagnoses. It was hundreds of thousands of records.

I'm the only professional, I know of, in my area that uses ACCESS for financial analysis and reporting, allocating costs by many cost centers, and a host of other purposes. I see many many people using Excel for things that would be much better in a database application.

ACCESS sometimes leave me :banghead:, but I think that's mostly the fault of inadequate documentation. Still, I do tasks much faster. For example, I join payroll data downloaded from our provider, and timesheet data, to allocate costs across jobs, and prepare the journal entry right out of ACCESS. I had a staffer who did this, but I now do it myself. What took him the better part of a day, I do in less than a half hour. If everything is good, ten minutes.

 

[Ron in NYC]

I should add that while I took a VBA course, I barely remember it. I would like to see solutions for people that don't know VBA. This may be somewhat limited, but works for the way I use ACCESS.

 

[pbaldy]

Welcome Ron! One of my daughters lives in NYC.

 

[Ron in NYC]

I hope she loves it.

 

[Rx_]

Welcome. Last century I use to go to NYC several times a year and teach the MS Certified Course: Excel Object Model Programming. We covered connecting to multiple data sources primarily for traders to develop custom rule middle ware and create trading dashboards.
Kind of the pre-2000 HFT of its day.
Last August my son graduated from the USMMA at Kings Point.
Was out there many times a year any time he was on break.
A few trips ago, he got me on the Red Head (wiki it) the Billy Joel's "little" yacht.
The Frick Collection is one of my favorites during the day and the Gotham Comedy at night.
Welcome aboard