University of Houston (Accounting)
I've tutored Excel & Access students via Skype and at work. My Skype work has connected me to people geographically diverse from New York City to 6 students at Florida Gulf Coast University assisting them with their Finance MIS class practice set. My New York City student helped me get hired on for a project with Fannie May in the Washington DC area to create a custom MS Access application.
I do find that working with Excel & VBA is the most fun because it is so flexible and you can do almost anything you want. Don't forget that whatever your working in, business users will want the data output available in an Excel spreadsheet XLS format.
I've used Spreadsheets and Databases in automating my work since 1990. In 2001 I started creating templates and applications for other people to use. In 1990 I studied and learned SQL (Structure Query Language) so I could query the company's data warehouse to do my work quicker and better.
I find that the easiest way for someone to learn Excel or Access is to work with them to design a spreadsheet or database that solves an issue that they need. I can quickly get you over a solution hurdle with either Excel or Access. I've tutored Excel & Access students via Skype and at work. My Skype work has connected me to people geographically diverse from New York City to 6 students at Florida Gulf Coast University assisting them with their Finance MIS class practice set. My New York City student helped me get hired on for a project with Fannie May in the Washington DC
In most cases, tutors gain approval in a subject by passing a proficiency exam. For some subject areas, like music and art, tutors submit written requests to demonstrate their proficiency to potential students. If a tutor is interested but not yet approved in a subject, the subject will appear in non-bold font. Tutors need to be approved in a subject prior to beginning lessons.
I have been using Access since 1998 to retain and query business financial data. After learning SQL at work in 1990 and becoming a company power user, I was attracted at the ability in MS Access to display a query in the SQL Format. Access became especially important for solving business information problems because it handled more than the 64,000 rows of data limit of Excel until the Excel 2007 version came out with the capability of over 1,000,000 rows.
I also found MS Access more structured than Excel and started creating applications in Access before Excel. I've made Access applications that connected directly with Accounting Systems information on both AS400 platforms and Linux platforms to DB2 and RDBMS via ODBC. I've used Access to create membership and billing systems and to automate disparate data sets for account reconciliations and Treasury information systems. I spent a summer creating a Risk management system in Access for Fannie Mae in Fairfax, VA on summer that consolidated their IT departments divisional management report to quantify periods when IT applications upgrades and changes problems are at a heightened state.
I believe my greatest strengths are with writing queries, but forms creation with drop down boxes that start other processes is also one of my strengths.
I have also converted my applications to the MS Run-time version scenario, but is a way to create an application that you can run that doesn't require having a copy of MS Access on your PC.
I have been working with financial data and am a CPA for over 20 years. I became an expert with Spreadsheets, Databases & SQL syntax in order to make my job easier and maintain the integrity of the financial data.
My teaching approach is to use real world problems my students are having and work through them.