Question
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.
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started