When testing an application you need to run every menu option to be sure they all work as expected. To test skyApp for employee processing you're going to display and modify data, and print an employee list.
Remember that during the testing you are working with the actual database and any changes made will be saved.
Entering New Data in the Employee Table
When SkyWrite Ink hires a new employee, you use the Add Employee option on the Employees menu to enter information about the new employee.
To add a new employee:
| 1. | In the SkyWriteApp application, choose Employees. |
R:BASE displays the pull-down menu.
| 2. | Choose Add Employee. |
EmployeeForm, the form you created in Lesson Four, is displayed.
R:BASE automatically assigned an employee number.
In Lesson Four you tested the form by adding new data, so there's no need to test it again. Now that we know the Add option works, we can exit the form.
| 3. | Close the form using the "X" in the top right corner or the "Close" button on the DB Navigator. |
| 4. | When you are prompted to save changes, click the No button. |
Printing Data from the Employee Table
To look at the employee records, you can print an employee list on the screen.
To print the employee list report:
| 1. | In the SkyWriteApp application, choose Employees: Print Employee List. |
The report is displayed on the screen in a window.
| 2. | Maximize the screen |
After viewing the rows, you realize that Charles Short's phone number is incorrect-it has been entered as 564-9123 and should be 564-9124.
| 3. | Press the "Close" button to clear the report from the screen. |
Modifying Existing Data in the Employee Table
To correct Mr. Short's row, use the Edit option on the Employees menu.
To change data for an employee:
| 1. | In the SkyWriteApp application, choose Employees: Modify Employee. |
You are prompted for the last name of the person to be edited. R:BASE accepts any combination of lower and upper case letters. Earlier, wildcard were discussed when being prompted for data. Use the many wildcard character, percent (%), to only enter a few characters of Mr. Short's last name.
| 2. | Enter "Sho%" |
| 3. | Click the OK button. |
R:BASE displays EmployeeForm with the information for Charles Short.
| 4. | Press the [Tab] key down to the phone number field. |
| 5. | Change the last digit from "3" to "4." |
| 6. | Hover your cursor over the check mark button. "Save" will appear. |
| 7. | Click the "Save" button. |
R:BASE replaces the row in the table with the changes you've made.
| 8. | Close the form. |
