course title : Computing with Business Applications
You are required to prepare a small program that resembles information systems that human resource managers use in companies. This program will be about keeping a database of company employees with related information, and searching that database when necessary. The project helps you build up your knowledge as the semester progresses.
The idea of the project is simple: your program will allow users to enter information into an excel sheet, and then search this information when required.
The user will press a button to add a record; you will show a window/form where the user can add the ID, name, surname, phone number, and department of an employee.
When the user presses the search button, another window will open that will allow the user to enter the employee ID and the program will search for this employee and display the information.
Report 1
This part of the project is for helping you develop your analytical skills. You know what the program is supposed. Now you have to think of HOW the program should do that. This part of the project is related to chapter one of your logic book.
Think of this project explained above and prepare a flowchart that reflects the steps of the project. Add pseudocode to your flowchart that shows how this program will accomplish what it is supposed to accomplish.
Two flowcharts are required, one for when the user presses the ADD button, and one for when the user presses the Search button. Make sure the pseudocode shows clearly the steps that will be done by the program.
You will be graded on the correctness of your logic (exp. What to do in case the employee ID is not found.) and the correct use of the flowchart symbols. The report to be submitted is a word document (use the MS Word template provided).
we are using these books
Textbook/material
1: Programming Logic and Design (comprehensive); by Joyce Farrell, Eighth Edition, Cengage Learning
2: VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel; by Albright 4th edition, South Western Cengage Learning
PS: VBA excel
