NEW FEATURES MORE

Search
Over 5 tutoring hours

Alan C.

Guilford, CT

$50/hour

Microsoft Access/VBA and Systems Design tutor

In-person lessons
Background check passed as of 5/29/14
4.8 average from 6 ratings
Great Tutor for MS Access
— Bob, Wallingford, CT on 5/10/15

$50/Hour


Send a message explaining your needs and Alan will reply soon.

Response time:

Contact Alan

Fordham University - Lincoln Center

Education

Fordham University - Lincoln Center

About Alan

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

Policies
Cancellation
24 hours notice required
Travel Radius
Travels within 30 miles of Guilford, CT 06437
Background Check: Passed
In-person lessons

"Great Tutor for MS Access"

- Bob, Wallingford, CT on 5/10/15

"I would recommend Alan!"

- Emily, New Haven, CT on 12/6/14
Computer:
General Computer, Microsoft Access,
Microsoft Project,
Microsoft Word
Business:
Microsoft Word

Approved subjects are in bold.

Approved subjects

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.

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

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.

Fordham University - Lincoln Center

Education

Fordham University - Lincoln Center

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 fo

— Bob, Wallingford, CT on 5/10/15

Hourly rate

Standard Hourly Rate: $50.00

Cancellation: 24 hours notice required

Travel policy

Alan will travel within 30 miles of Guilford, CT 06437.