Fordham University - Lincoln Center
I have had the opportunity to tutor individuals of all skill levels in the use of Microsoft's Access, VBA (Visual Basic for Applications), Word, PowerPoint, and Excel for the past decade. During that time I have also been teaching project management, system design and systems development life cycle, and Microsoft Project to groups at the corporate level.
Since I remember what it was like for me starting out as a "newbie", I am keenly aware of the need to uniquely relate to each student's experience and concerns. I can proudly say that my 86 year old mother is now a regular wonder with her PC.
I really enjoy taking the mystery out of these subjects for the newer student and providing a more in-depth education for the "power user".
I am looking forward to discussing how I can help you understand these tools and use them to be more productive.
I have had the opportunity to tutor individuals of all skill levels in the use of Microsoft's Access, VBA (Visual Basic for Applications), Word, PowerPoint, and Excel for the past decade. During that time I have also been teaching project management, system design and systems development life cycle, and Microsoft Project to
Alan knows his stuff, is easy to work with, and goes the extra mile. He's a flexible problem-solver, who explores alternatives to come up with the best solution. Thanks, ALan!
Quite knowledgeable about what the subject was at hand. I think that with this kind of tutor, where it was his business to know this kind of things, a student can go far.
I had the pleasure of meeting and having Al assist me with an Access database I am building this past weekend. Al was tremendously responsive and knowledgeable in turning around my technical needs within a couple of days. Al displayed an excellent knowledge of MS Access and I really appreciated working with Al and being a partner to his fine character and professionalism. A five star experience for me. Thanks Al!
Alan is very patient and earnest in finding the best way to help you understand whatever topic you are working on. He's professional and friendly to boot--would recommend.
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 most recently implemented an Access Timesheet Entry and Invoicing Application for the consulting arm of a UMass Medical School. The application gathers hourly time for work performed on various project within a weekly reporting period. Reports for each employee/period, as well as monthly invoices for internal and external clients, are generated by department administrators.
As a multi-user application Optimistic Locking was used since users only have read/write access to their own records. Additional security is provided by splitting into an .MDE file distributed to the users as a front-end database for entry and processing, and a second database stored on the network drive for the 11 normalized tables.
This event-driven application contains –
- Combo Box controls containing the valid data where needed,
- Text box controls allowing free form text where appropriate,
- Command button controls for adding, deleting, and updating timesheet records, as well as copying Previous Pay Periods,
- List box control where each timesheet line item is displayed and from which individual items are selected for updating or deleting.
SQL (Structures Query Language) is used for generating the supporting queries for timesheet manipulation and reporting, as well as for the invoicing. DAO recordset definitions are also used to navigate by individual record.
Extensive editing code in VBA (Visual Basic for Application) prevents inaccurate timesheet data (ex. – excessive hours, missing hours, etc.) from being entered into the system as well as incorrect invoices being produced.
Finally, application version control ensures that all users are using the correct version of the application.
As the Senior Project Manager for the Enterprise Project Management Office at the UMass Medical School, I was responsible for tutoring project managers throughout the organization in the use of MS Project.
By explaining the “Triple Constraint” of Time, Resources, and Budget and how each relates to the project we begin by outlining specific, measurable tasks, and their duration. We determine any tasks that are dependent on others being completed and then assign resources to each task. MS Project can then calculate the estimated duration of the entire project.
We then use the application to add or delete tasks, their duration, and the number of resources assigned in order to make the project duration longer or shorter, based on the business’s requirement.
Resource leveling displays aid us in determining problem areas for resource over-allocation and Earned Value reports provide a more accurate picture of the health of the project than just eyeballing an end date.