...EMPLOYEE INFORMATION SYSTEM A Project Presented to the Faculty of Computer Engineering Department in Partial Fulfilment for the Requirements in CS525 - Software Engineering Submitted By: BSCpE-V Submitted To: Computer Instructor Date: October 13, 2014 INTRODUCTION Employees are the most valuable and dynamic assets of an organization. The Employee Information System is an extensive and comprehensive system that maintains and tracks information pertaining to all the employees in an organization. This system has a wide range of masters, which provide high degree of customization and allow the user to setup the system as per the requirements of the organization. It captures comprehensive details pertaining to all the employees in the organization. It maintains the skill inventory of an organization. There is a provision for keeping track of various types of transfers, including inter-location, inter-circle and inter-company transfers; the workflow involved during the transfer process is also automated. The system also tracks exit of an employee from the company along with the reasons for the exit. The system also keeps track of appraisals and promotions. There is provision for leave and attendance maintenance. The system is fully integrated with Recruitment, Payroll and Training Systems. Extensive and effective reporting functions provide a snapshot of employee information. The “EMPLOYEE INFORMATION SYSTEM (EIS)” has been developed to override the problems...
Words: 1096 - Pages: 5
...Napkins Company Table of Contents Introduction 3 Benefits of Implementing Microsoft Access 3 Sales and Collaborative Software 4 Table……………………………………………………………………………………………....5 Conclusion 5 References...………………………………………………………………………………….……6 Proposal: Implementation of Microsoft Access Database Introduction Our party plates manufacturing business is growing and our customer base numbers are increasing every month therefore I am writing this proposal to implement a “Relational Database Management system”. The system we are proposing is Microsoft Access. The reason we are proposing to implement this new system is because since our business is growing it is getting cumbersome and time consuming to manage multiple “Excel” files to analyze company’s data. According to article by CPA Janet Samuels and Robert wood they suggest “Data handling and reporting capabilities of access are more efficient” (Samuels, Woods 2007). Excel should be used when we need to create a onetime report by plugging in data, however in access you will have to setup a database to form reports. Therefore, we should implement the relational database so information is forever stored and accessible by employees to create different multiple reports. The benefits of implementing Microsoft Access over Excel are listed below. Benefits of Implementing Microsoft Access 1. We can easily import all of our Excel files in to access by using the External data ribbon. This imported data will be saved as one of...
Words: 831 - Pages: 4
...technology for their Human resources database. We shall follow the five phases of the system development life cycle to upgrade the existing system with a new web application that employees can use to access and make changes to their employee records. The five phases are: Investigation, Analysis, Design, Testing, and Maintenance. Riordan Manufacturing Human resources Information System (HRIS) was installed in 1992. HR is currently responsible for: employee information( personal information, pay rate, personal tax exemptions, hire date, seniority date, department information, and Vacation hours), Training and development records, Resume files, workers compensation records, Employee file’s(currently with employee’s individual manager), Compensation files, and employee relations files. Currently the 7 HR records are scattered amongst the HR department and employee managers, these files need to be consolidated. It is time to upgrade and modernize the system. An integrated system will increase productivity, reduce the need for specialized highly paid positions and improve employee understanding of the HR benefit process. During the Analysis phase of the System development life cycle it is important to meet with the stakeholders, people and groups of people that have interest or concern in the project (“Business Dictionary”, 2013). I will need to meet with people in the following departments: Accounting, Marketing, Legal, HR, operations and IT. Even though it is an HR system, departments like...
Words: 1166 - Pages: 5
...efficient sales department. Internet and programmer based evaluations along with employee knowledge base of programs should provide a good data sets for both reviewed programs. The report finds that Microsoft Excel offers the employees easier input options that perform similar tasks as Microsoft Access. This allows ABC Sales to develop the most robust data sets for the lowest cost, with minimal additional training requirements to existing staff. It is clear that ABC Sales Department needs to choose Microsoft Excel. Problem Statement The ABC Sales Department has an organizational problem. ABC Sales Department does not keep a record of annual inventory renewal schedules for their special projects. The sales department needs to start to keep these records in order to properly plan future budgets, set realistic goals for employees to reach, and be able to forecast proper pricing for renewals. The sales director needs to implement an easy to use and cost affective tracker for the managers to use. The managers need to start tracking these items in order to increase revenue so that the ABC Company can be successful in the market. Overview of Alternatives The following two alternatives considered in this report meet the ABC Company requirements: Alternative A-Microsoft Excel Spreadsheets In order to understand and track the revenue and dates of prior existing orders, databases can be exported...
Words: 2025 - Pages: 9
...DeVry University Keller Graduate School of Management Creating a Database for Storing and Managing Church Members’ Record for R.C.C.G. Heaven’s Gate Gbolade O. Soneyin gsoneyin@my.keller.edu (770) 598-5006 MIS-535-18371 Managerial Applications of Information Technology Professor Tanya Cannon Thursday, February 12, 2015 Table of Contents Subject of Course Project 3 Business Problem Stated 3 Name of the Organization 3 Proposed Solution 3 General Benefits 4 Audience 4 References 5 Abstract To help Heaven’s Gate move away from tracking its members on spreadsheets and paper, move to a database application that will not only track members, but also track department activities, members contributions, and do it all via the least economically, but yet effective, easily accessible and requiring limited technical or IT expertise to maintain. Keywords: RCCG, Database, Church, Heaven’s Gate, Application, Church Management Company Background Heaven’s Gate is one of many parishes of the Redeemed Christian Church of God (RCCG), headquartered in Lagos, Nigeria; finding out exactly how many parishes of the church existed was next to impossible. In her well-detailed article on the church, Olufunke Adeboye wrote about the church from 1952-2005. Founded by Josiah Olufemi Akindayomi in 1952, after receiving vision to write down the church’s name on a wooden board, this despite the fact the man was unschooled at the time; he cannot read nor know how to write. After writing...
Words: 1607 - Pages: 7
...Efficiency and Collaboration Proposal BIS/220 Microsoft Access has become more user friendly over the past few years; it has more tools and is very simple for a person to learn, even if they have never used the program before. The system has easier add, subtracting, and also is easier to change data that has previously been entered. Access gives the ability for more than one user to update tables at the same time, and gives the option to create more than one report from the same data. Access stores data in tables that look like worksheets, but are designed for complex querying in relation to data stores in other tables and locations. Access also allows you to use structured query language, to quickly retrieve just certain rows and columns of data that you may want for a report, even if that particular data is part of another table. By converting our data that we currently have in Microsoft Excel to Microsoft Access it will give us the opportunity to track different areas of our business in more ways than one. It will also allow us to effectively maintain our reports to ensure better production and customer satisfaction. Using Microsoft Access as the database for our company is beneficial for so many reasons. For instance, with an access database file, several users can work in the same file at the same time, multiple users, from different computers; can work on an Access database simultaneously. One person could add records to the Customer table while another could create...
Words: 527 - Pages: 3
...password to use to access the systems. Each student had separate accounts for email, the VLE and for access to their student record. University of West London wanted to create a platform that would allow students to interact with each other in a safe, secure and academically driven environment.” (UCISA, 2012). Rather than develop a basic gateway for students to access the institution’s services, the University decided to build a personalized, interactive, social platform allowing students to combine social learning with academic study. The staff was established to explore options for collaborative working. There were three different approaches that were being considered: an in house developed bespoke solution; an off the shelf on premise solution and a solution hosted entirely in the Cloud. The in-house bespoke solution was ruled out because of the high development, support and infrastructure costs. It would also take too long to implement as the University had set a go live target date of the last week of August 2012, to coincide with the start of enrolment. The off the shelf solution hosted was ruled about because of the high infrastructure, support and maintenance costs. Most of the off the shelf solutions also lacked the modern messaging and collaboration tools that were essential for the success of the project. Therefore it was decided to opt for a free solution hosted entirely in the Cloud. Given our existing investment and skills in using Microsoft technology it made...
Words: 752 - Pages: 4
...efficient sales department. Internet and programmer based evaluations along with employee knowledge base of programs should provide a good data sets for both reviewed programs. The report finds that Microsoft Excel offers the employees easier input options that perform similar tasks as Microsoft Access. This allows ABC Sales to develop the most robust data sets for the lowest cost, with minimal additional training requirements to existing staff. It is clear that ABC Sales Department needs to choose Microsoft Excel. Problem Statement The ABC Sales Department has an organizational problem. ABC Sales Department does not keep a record of annual inventory renewal schedules for their special projects. The sales department needs to start to keep these records in order to properly plan future budgets, set realistic goals for employees to reach, and be able to forecast proper pricing for renewals. The sales director needs to implement an easy to use and cost affective tracker for the managers to use. The managers need to start tracking these items in order to increase revenue so that the ABC Company can be successful in the market. Overview of Alternatives The following two alternatives considered in this report meet the ABC Company requirements: Alternative A-Microsoft Excel Spreadsheets In order to understand and track the revenue and dates of prior existing orders, databases can...
Words: 2026 - Pages: 9
...This student project developed by students from DVS College, Shimoga. This system will maintain and manage day to day operation very smoothly with minimum errors. This software provides facility for searching a particular vehicles detail. In all the forms we have created options to create New record, Save record, Modify, Delete, Find record and close button. This source code of this software developed using Visual basic 6.0 and the backend is Microsoft Access driver. Project modules: Vehicle registration module: Two wheeler, Three Wheeler, Light motor Vehicle(LMV) and Heavy motor vehicle(HMV) and others. To register a vehicle through this software user has to provide all the details of vehicles including vehicle number, makers name, body type, Vehicle owner, address, chasis number, registration date, etc Licence module: Learner licence, Driving licence, Changing address of licence. It has options to apply the license and renew the license. Tax module: This module is used to entry the records of tax. Renewal module: This module helps to renew vehicle registration records. Transfer module: This is a vehicle transfer module which is used to change the ownership of the vehicle. Project database: The name of the database is RTOData. It has 8 tables that is: COAMain, CVMain, DLMain, LLMain, MVMain, TaxMain, TWMain, VRMain. Front End: Visual basic 6.0 Back End: Microsoft Access Driver 2003 Download project code: download link all Video Demostration: ...
Words: 289 - Pages: 2
...E&C PROPOSAL Converting data currently held in Microsoft® Excel® spreadsheets into a rational database using Microsoft® Access® can be useful in creating reports. These reports can be run at any time by users. “With Office Access 2007, you can link tables to your database from other Access databases, Excel spreadsheets, Windows SharePoint Services sites, ODBC data sources, Microsoft SQL Server databases, and other data sources. You can then use these linked tables to easily create reports so you can base your decisions on a more comprehensive set of information” (Microsoft Office Access benefits). Access can be used by multiple users working on the data at the same time; even several users can work on the same data at the same time. Access locks in a record only while the user changes it; when users use Excel workbook it can be shared, but users should change data in Excel at separate times for the process to work best. “If you need to connect to several data sources and edit the data directly in those sources, then Access is your choice. You can view external data with Excel, but you can't change that data” (Office Microsoft). Wireless to IT uses The benefits of using Microsoft Access in the work place for the company would be one of the easier ways to create contacts, assets tracking, issue tracking, project tracking. With the program it would keep up with current customers, and their previous order. The company with and using this program can also share or forecast their...
Words: 813 - Pages: 4
...following questions: Based on the article by Samuels and Wood (2007), what are the five basic steps required for analyzing data using Microsoft® Access? How could these steps help you diagnose and troubleshoot Microsoft® Access errors? Which of the five steps presents the greatest possibility for user error and why? Explain your answer. According to Samuel and Wood (2007) The five basic steps required for analyzing data using Microsoft Access is gather the data, create a database, edit and validate data, connect data files, and perform queries. I think using the five basic steps helps diagnose problems because if a user is having problems they can always back over each steps to diagnose the problem, for example, let's say you are putting together a shelve and it doesn't look like the picture on the box, most likely you will return to the instruction manual and read the instructions step by step to see where you could have went wrong on your project. I think Edit and Validate Data could pose a problem for example when a user tries to edit field that has been set using validation rules you cannot edit that field, for example if a field is set to currency, you can’t put text in that field, you will then receive a error message, this can be annoying when Access is being used by multiple users working on the same table, like my assistant works with Access and she often has to edit the tables, if I set validation rules to my liking and she doesn’t have any knowledge that I have done...
Words: 290 - Pages: 2
...Transportation Command Firewall Modification Request System Student Name Individual Project IS316 - Systems Analysis and Design Professor: Erlan Burk Park University Fall II 2005 12 December 2005 Table of Contents System Description 2-3 Functional Description 4-5 Data Dictionary 6-7 Context Level Diagram and Child Diagram 8-9 System Input, Output Forms, and Interfaces 10-14 Testing, Maintenance and Auditing 15-16 System Description System Name US Transportation Command Firewall Modification Request System (FMRS) Type of System FMRS is a Management Information System using a Microsoft Access Database and front end application. The system provides an avenue for customers to request firewall modifications and for the firewall maintenance team (Operation Information Security – OIS) to validate, track, and process requests in systematic fashion. Key System Benefits * User friendly interface available to users at any time * Request tracking and history * Report generation of prior activity * Improved firewall manageability * Improved customer response time * Reduction in man hours spent duplicating and researching firewall maintenance efforts Existing System Currently there is no automated request or tracking system for firewall modifications and accountability. Requests are made via email to the OIS group email account and are processed from there. With the current...
Words: 2252 - Pages: 10
...the collaboration tools. If you are using a program from Microsoft, Access is the best one to use in the business because of its ability to process information using a relational database system. However, the collaboration tool that a business uses is equally important. This tool whether it is an inter- or intra-net type system is critical when working with other team members or employees to process work efficiently and effectively for the business and its customers. While currently at Party Plates we utilize Microsoft Excel, there is good reason to incorporate Microsoft Access as well. On many occasions, you will want and possibly need to take advantage of the benefits that both programs have to offer. For example, you created a spreadsheet in Excel in which you can calculate and analyze the data, and it has become unmanageable due to size and complexity, and now that data needs to be accessed by many more users than you. One example would be to, import or link your worksheet into Access and use it as a database as an option to working with it in Excel. Whether you use excel or access first, the data is always interchangeable you can go from one to the other seamlessly. You can bring data into Access from Excel (and vice versa) by, importing copying, or exporting it. No data connection required to complete these tasks. Microsoft Access is an essential part of most businesses today. This database allows personal to access and manage a vast amount of...
Words: 701 - Pages: 3
...INFORMATION TECHNOLOGY CAPSTONE PROJECT PROPOSAL Name of the Proponents: Ramirez, John Joseph F. Verzosa, Edwinalyn Camille P. School Year/Trimester: 2015-2016 / 1st Trimester Proposed Title: Product Management with MIS and TPS functions for Yrollanne Enterprises utilizing Local Area Network (LAN) based technology Area of Investigation: Yrollanne Enterprises is a seller of gravel, sand and mix located in Biga, Calapan, Oriental Mindoro. It was established in March 2013 and currently owned by Mr. Leandro Y. Dela Cruz. The company primarily clients are construction companies. They are using manual operation for their product management. The way of monitoring the products and deliveries of the company are done manually, hence it is difficult to manage and it usually prone to errors. One of those problems are storage and retrieval because everything was stored in their computer files and in the filing cabinet on which it is arrange in such way where its having a hard time to locate files. Security is also one their problem because unauthorized persons might be able to access their files due to the way it was stored. During the interview with the proprietor, the proponents have discovered that the company was experiencing some difficulties with the distribution and delivery of their products. The proponents proposed an automated system that will first, help the company in terms of computation for the bills of the customer will be accurate, the...
Words: 1547 - Pages: 7
...Human Resources Data Migration Project Implementation Plan Human Resources Data Migration Project Implementation Plan Project Group 1: Information Technology Group March 4, 2013 Project Group 1: Information Technology Group March 4, 2013 VERSION HISTORY Version # | ImplementedBy | RevisionDate | RequestedBy | ApprovedBy | Description of Change | 1.0 | student | 03-04-2013 | | | Preliminary draft | | | | | | | | | | | | | | | | | | | Table of Contents 1.1 Purpose 4 1.2 System Overview 4 1.2.1 System Description 4 1.2.2 Assumptions and Constraints 4 1.2.3 System Organization 5 2 Management Overview 5 2.1 Problem Statement 5 2.2 Description of Implementation 6 2.3 Points-of-Contact 6 2.4 Major Tasks 7 2.4.1 Project Tasks 7 2.4.2 MS Access to Oracle Tasks 7 2.4.3 Oracle to Mongo Tasks 7 2.5 Implementation Schedule 8 2.6 Security and Privacy 8 2.6.1 System Security Features 8 2.6.2 Security Set Up During Implementation 8 3 Implementation Support 8 3.1 Hardware, Software, Facilities, and Materials 9 3.1.1 Hardware 9 3.1.2 Software 9 3.1.3 Facility 9 3.1.4 Materials 9 3.2 Documentation 9 3.3 Personnel 9 3.3.1 Staffing Requirements 9 3.3.2 Training of Implementation staff 9 3.4 Outstanding Issues 10 3.5 Implementation Impact 10 3.6 Communications Plan 10 3.7 Change Management 12 4 Implementation Risks and Contingencies 13 4.1 Technical Risks and Contingencies 13 5 Acceptance Criteria 14 ...
Words: 4932 - Pages: 20
