EcoMed 4-26

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.