Search

Alan C.

Microsoft Access/VBA and Systems Design tutor

Microsoft Access/VBA and Systems Design tutor

$50/hour

  • 33 hours tutoring

  • Guilford, CT 06437

About Alan


Bio

Greetings -

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...

Greetings -

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.


Education

Fordham University - Lincoln Center
undergrad

Policies

  • Hourly rate: $50
  • Tutor’s lessons: In-person
  • Travel policy: Within 30 miles of Guilford, CT 06437
  • Lesson cancellation: 24 hours notice required
  • Background check passed on 5/29/2014

  • Your first lesson is backed by our Good Fit Guarantee

Schedule

Alan hasn’t set a schedule.


Subjects

Business

Microsoft Word

Computer

Microsoft Access,

Microsoft Access

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.
Microsoft Project,

Microsoft Project

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.
General Computer, Microsoft Word

Corporate Training

Microsoft Project,

Microsoft Project

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.
General Computer, Microsoft Word

Ratings and Reviews


Rating

5.0 (20 ratings)
5 star
(19)
4 star
(1)
3 star
(0)
2 star
(0)
1 star
(0)

Reviews

Great Access Tutor

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!

Terry, 2 lessons with Alan

Knowledgeable Tutor

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.

Richard, 13 lessons with Alan

Great Tutor for MS Access

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!

Bob, 2 lessons with Alan

I would recommend Alan!

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.

Emily, 1 lesson with Alan

$50/hour

Alan C.

$50/hour

  • No subscriptions or upfront payments

  • Only pay for the time you need

  • Find the right fit, or your first hour is free

Contact Alan