Employee Database Pro
The Employee Records application allows you to keep track of all of your employees. For each employee, you can maintain basic information such as name, address, department, title, manager etc.
The Employee Records application allows you to keep track of all of your employees. For each employee, you can maintain basic information such as name, address, department, title, manager etc. You can also maintain a history of the employee's salary, reviews, vacation days taken, sick days taken and training courses taken. This application uses several tables: Employees - contains the name, address and other information about each employee. Vacation Taken - contains a record with the start and end date of each vacation taken by each employee. Sick Days Taken - contains a record with the start and end date of each period of sick leave taken by each employee. Salaries - contains a record of salary changes showing salary amount and effective date. Reviews - lists all reviews received by each employee Training Classes - lists all of the training classes that are offered by your company. Classes Taken - contains a record for each training class taken by an employee. Employee Records Menu - a dummy file. The application menu screens are forms that have been designed for this table. Also, the help information is contained in a Rich Text memo in this table. The application also uses two sets: Master - this is the main set for the application. It links the Employee table to the Salaries, Reviews, Vacation Taken, Sick Days Taken and Classes Taken tables in one-many links. Salary Analysis - this set links Employees to Salaries in a one-last link. This is a one-one link that links to the last matching salary record for each employee. This set shows the current salary for each employee and is used in these reports: Salary Analysis and Salary Report. Entering and Viewing Employee Information To view or enter employee information, select 'View/enter employees' from the main menu. This displays the Employee Records form for the Master set. To enter new information for an employee, first find the employee, then click the appropriate tab. Printing Reports To print reports, select the 'Reports' option from the main menu. This displays a sub-menu of reports. Select the report type. The application then displays a read only form showing the records in your database. Use Query by Form, or Quick Filter to select the records that you would like to include in the report. Then click the 'Print' button. To include all records in the report, click the 'Show all' icon before running the report. The following reports are included: Employee Listing - prints a listing of the employees in your company Employee Review Summary - prints a summary of all previous reviews received by each employee Employee Time Off Summary - lists all of the time off, vacation and sick days, taken by employees Employee Training Summary - lists all of the training courses taken by each employee Salary Analysis - analyzes salaries showing salaries for each employee as a percentage of company and department totals and as a ratio to department and company averages. Salary Report - lists the current salary for each employee Scheduled Reviews Report - lists upcoming review dates for each employee. Design Notes How the main menu is displayed: When you open the Employee Records database, the main menu is automatically displayed. The main menu is a form called Main Menu. You can specify that a particular form in the database is automatically opened when the database is opened by activating the control panel, selecting File, Database properties and selecting the startup form. How reports are designed: When you print a report, you typically want to select a subset of the records to appear in the report. Alpha Five's Query by Form provides an ideal way to select the records to be included in the report. For each report, a corresponding record selection form is designed. This form is used to select the records for the report. Since the form is to be used for selecting records only, the record selection form disallows editing records and entering new records. The record selection form has a button on it to preview the report. The button is placed on the form using the Button Genie. Also, this form has a Filter/Order property. The Order property displays the records in a particular order and the Filter property is blank, ensuring that every time the record selection form is opened, all records are shown. If the Filter/Order property was not set, the form would display the records found by the most recent query. When you design reports in Alpha Five you can: - fully specify the record selection and ordering criteria in the report definition - base the report on the current selection of records - prompt the user for criteria at print time.
|
