Assignment Instructions (scenario):

Assignment Rationale: As a new HIM professional, you will be responsible for maintaining a record of your continuing education as well as your employees.

Scenario:

You are the new supervisor of an HIM department. Develop a database (Access or Excel) to track the education/training information for employees in your department. Include in the database the following information:

1, The name, title, year of hire, and credential (if applicable) for each employee.

2, Columns for internal in-service programs dates, topics, number of contact hours.

3, Column for outside continuing education activities dates, topics, number of contact hours, location and sponsoring organization.

4, Complete the two (2) rows of your database with a fictitious name and information for that employee and yourself.

5, Name three (3) type of reports can you generate from this database (Note: add the titles at the bottom of the database report).

6, Select one of the report types identified in step #5 and create a report format of the information you would to capture. The results are the skeleton of the report (column headings and other required data elements).