I (10pts) Explore using an expenses tracking database application. This exercise simply walks thru using the application on the client-user end.

What you need to do:

1. Download, save and open the original copy of the Expenses.accdb database in Access.
2. From the Expense Reports by Employee form (which should pop up when you open the database), use Add or Delete Expense Categories and create the following Expense Categories, exiting the subform when done:
   • Meals (Expense Account # 51121)
   • Lodging (Expense Account # 51122)
   • Travel (Expense Account # 51123)
   • Registration (Expense Account # 51131)
   • Publications (Expense Account #51141)
3. Using the Employee Form create four employee records:
   • Rebecca Fitzgerald:  address is 814 Nathan Street, Deptown, GA  30999; phone is 706-654-3210; title is IT Consultant; employee number is rfitzger, social security number is not used, other fields are up to you
   • Gary Smith:  address is 2020 Oak Avenue, Apt B2, Deptown GA 31000; phone is 706-345-6789; title is Manager; employee number is gsmith, social security number is not used, other fields are up to you
   • Ivan Michael Baws:  address is 1 Bigshot Towers, Deptown GA 31001; phone is unlisted; title is President & CEO; empoyee number is ibaws, social security number is not used, other fields are up to you
   • You.  You don't have to use your own address and phone, but put something in.  Your title is IT Development Assistant, your employee number is your ASU login ID.
4. From the appropriate employee record, use the Create New Report button to create the following expense reports:
   • For Rebecca Fitzgerald:  On January 3-5 of this year she traveled to a Microsoft Conference but the expense report was submitted Jan 18.  She received a $100 advance, the expenses should be charged to the Processing department, and the expense report is unpaid.  Name the expense report MSConf; details are the following:
         Jan 3 Travel for $35.00 (Drive to conference)
         Jan 3 Meals for $25.00 (Lunch & supper)
         Jan 3 Lodging for $85.50 (1 night at Comfort Inn)
         Jan 4 Meals for $22.00 (Breakfast & supper)
         Jan 4 lodging for $85.50 (1 night at Comfort Inn)
         Jan 5 Travel for $35.00 (Drive from conference)
         Jan 5 Meals of $15 (Breakfast & lunch)
         Dec 28 (last year) Registration of $250 (Conference Registration)
   • For Gary Smith:  On January 12 of this year he hosted a luncheon for the Deptown CPA Society and pre-submitted an expense on Dec 29 (last year).  He received no advance, the expenses should be charged to the Accounting department, and the expense report is paid.  Name the expense report CPALunch; details are the following:
         Jan 12 Meals of $180 (lunch service for 12 @ $15)
         Jan 12 Publications for $26.50 (CPA Today subscription for Deptown CPA of the year)
   • For Gary Smith:  On Dec 18 (last year) he attended a workshop on using MAS 90 (accounting software) and the expense report was filed on Dec 22.  He received a $75 advance, the expenses should be charged to the Accounting department, and the expense report is unpaid.  Name the expense report AccWorkshop; details are the following:
         Dec 18 Travel for $6.50 (Drive to and from workshop)
         Dec 18 Registration for $100
   • For Michael Baws:  On January 2 he entertained two menagers from Burger Jockeys, Inc. a potential client. In addition to a meal, he also paid plane fare for them to travel into town as well as hotel costs for them to spend the night. He forgot to submit the report until January 29th. The expenses should be charged to the Executive department, and the expense report is unpaid.  Name the expense report BurgerJockeyFun; details are the following:
         Jan 2 Travel for $652.32 (Plane Ticket for clients)
         Jan 2 Meals for $232.45 (Dinner for Baws and clients)
         Jan 2 Lodging for $187.95 (Hotel for clients)
         Jan 3 Meals for $37.83 (Client breakfast)
   • For you:  On your birthday (this year, even if it hasn't come yet) you had a trip at the company's expense and are filing the expense report today (all the expenses occur on your birthday).  Charge expenses to the Sales department and, unless you have already received a check (LOL) the expense report is unpaid.  Name the expense report MyBirthday and the details are up to you.
5. Save the Access file and submit through your MIS lab.