On occasion, employees purchase supplies for the company. These expenses need to be tracked. Create a new table to track employee expenses

  • Open the database start file named EcoMed-4-26. Enable Content in the Security Warning bar. Save the Database as your initialsEcoMed-4-26. Make sure the Navigation Pane is open.
  • In Datasheet View, create a new table and add the following record:
ID: Press TAB
Column 2: 464-4824
Column 3: Supplies
Column 4: 10/15/2011
Column 5: $14.85
Column 6: Cleaning Supplies
Column 7: Trash Bags, Soap, and Paper Towels
  • Save the table as tblEmpExp.
  • Awitsh to Design View. Set Field1 as the primary key and delete the ID field.
  • Rename the field names to the following:
Field1: EmpID
Field2: ExpenseType
Field3: DatePurchased
Field4: AmountSpent
Field5: Purpose
Field6: Description
  • Set the Caption for EmpID to Employee ID.
  • Create appropriate captions, by adding a space between the 2 words, for the fields ExpenseType, DatePurchased, and AmountSpent.
  • Switch to Datasheet View. Enter the following record:
Employee ID: 234-7890
Expense Type: Supplies
Date Purchased: 10/22/2011
Amount Spent: $25.34
Purpose: Office Supplies
Description: Printer Paper, Printer Ink
  • Resize columns so all data is visible.
  • Save the changes to the table. Close the table.
  • Export the Access table to a new Excel workbook for grading in SimGrader.
    • Open the tblEmpExp table, click the External Data tab.
    • In the Export group, click the Excel button. The Export wizard opens.
    • In the Export window, verify that the Export data with formatting and layout check box is checked. If necessary, click the box to add the checkmark.
    • Click the Browse button. Navigate to your desktop.
    • In the File Name box, type the new file name your initialsAccess-4-26.
    • Click the Save button. Click OK. Click Close, to close the Export wizard.
    • Save and close the Database.
  • Submit the Excel file to SimGrader.
    • Do not open the Excel file before submitting.
Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.