I (15 pts) Makes some custom modifications to the Expenses database application. A video of form modifications is available (the sound is a little loud ... this was recorded live and disregard the difference in TechPrac number).

What you need to do

1. Use your Expenses database prepared for TechPrac10 (you can retrieve it from Desire2Learn) or download and save the original copy of the Expenses.accdb database application.
2. Add a Departments table to the database with fields for DepartmentName (text of up to 50 characters and primary key), Manager (a number - long integer), and TravelBudget (Currency).
3. Modify the Expense Reports by Employee form so that
   1. Tabbing moves users 'logically' from field to field (First Name & Last Name must be first two fields) and no amount of tabbing will move them off the record they are editing. The View Report Details and Create New Report buttons should not be part of the tab sequence.
   2. There is a Delete Employee button below the Add New Employee but which will delete the current employee record (it's ok if a pop up asks if the user is sure).
   3. The department entry on the form is a pull down (combo box) which allows a selection from the DepartmentName field in the Departments table (see 2 above) and choices are limited to that list.
   4. At the top of the form there is a combo box which shows all the employees and when one is selected the form moves to that employee.
4. Modify the Expense Reports form so
   1. it has a logical tab sequence (note that the Employee Name and Expense Totals fields on this form cannot be tabbed into since they are calculated). Expense Report Name and Department Charged should be the first two fields (the rest is up to you).
   2. The Department Charged field is a pull down like the Department field on the Employee form (e.g., like 3.3 above).
   3. There is a Delete Expense Report button beneath the New Expense Report button.
5. Save the revised database and submit it through your MIS Lab.

II (25 points) Develop a set of PowerPoint slides which proposes a problem or opportunity for improving the expenses database introduced in TechPrac10 and modified earlier in this TechPrac. The show is the basis for a briefing you would provide to management which describes the problem or opportunity and then provides a short assessment of feasibility for the project.

1. Review the online training Create Your First PowerPoint Presentation (this uses the Office 2010 version of the software available on campus computers).
2. Create a slide show with at least 10 slides with content outlined as follows:
   1. A title slide. Develop a title and description which succinctly capture the essence of your proposal. Hint: Consider doing this last after you have created the rest of the slides.
   2. At least one slide which describes the problem or opportunity (and Problem Statement or Opportunity Statement are good titles for this slide (or slides). This slide (or slides) should include at least one image captured while working with the expenses database which illustrates an issue you describe with text or bullets. Hint: Pressing Shift+PrtScrn puts a copy of the computer screen in the clipboard; move into PowerPoint and use Home | Paste to place a copy in the slide show. From there the image can be sized & cropped.
   3. One slide entitled Vision Statement should describe your vision (in text or bullets) for how resolving this issue will help. It should answer the question 'What will things be like when this is implemented'. The best vision statements are SMART: Specific, Measurable, Achievable, Relevant, and Time-based.
   4. One slide entitled Solution Concept should outline what, specifically, you suggest to resolve the problem or take advantage of the opportunity.
   5. Five slides assessing the feasibility of your solution, one each for Economic Feasibility, Technical Feasibility, Operational Feasibility, Legal Feasibility, and Schedule Feasibility. Each slide should contain at least three bullets which address the feasibility component being addressed. Hint: See the textbook chapter 10 for concepts behind assessing feasibility.
   6. A Conclusion & Next Steps slide with a brief conclusion and outline of next steps to take.
3. Save the PowerPoint presentation and submit it through your MIS lab.