Assignment task: You are the Director of the HIM Department of a Skilled Nursing Facility. You constantly have to ask Human Resources for reports on your staff. Because of the frequency of these requests, you have asked for access to the Human Resources system. Unfortunately, their response is that the system will not allow you to access only your HIM staff but would instead provide you access to all employees, and therefore they cannot provide you access. Because of this, you have decided to create your own database of key information regarding your staff. This database will help you in many ways.
The following are examples of how you will use this database:
- Track salaries
- Track open positions
- Track when performance evaluations are due
- Track anniversary dates
- Track birth dates
- Identify employees on probation
Please create a database using MySQL or Microsoft Access. Design a data entry screen that utilizes good screen design. Populate the database with six test employees and generate two reports: a list of all employees by anniversary date and a list of employees on probation. You will be required to upload your database to BrightSpace.