About Our Project
|
The primary purpose of our database is to keep resident information easily accessible and retrievable through one place rather than trying to find the information through paper files or spreadsheets. All of the residents information will be stored under the residents table which will include personal information and health specifications. Additionally, there is a table specifically for information held regarding when residents leave the building for any reason, referred to as the temporary leave table. Next, there is a table specifically for all employee information such as personal information, hiring specifications, and their photo ID's. Lastly, all information regarding maintenance requests from the past two years that contains information such as the work order processing time, department name, and elaboration on the request can be found in the maintenance requests table. The information contained in these tables are what makes it possible to create the forms, queries, and reports.
Both the forms and reports are beneficial towards those with managerial power. The forms easily allow the nursing department, maintenance department, and the administration department to add or manipulate data held in the forms relating to both the residents, maintenance requests, and employees, respectively. The reports are also used and will benefit management most. The reports allow all departments, and employees in those departments, to view specific criteria needed to do their jobs well and accurately. Ultimately, this database will not only significantly benefit upper management but also those working directly with the residents.
|