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 ... [more]
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.