Modify the program you created for Project 1 as follows:

  1. Use a database instead of a file to hold the data (I have attached an MS Access database that you can use). The relationship window is shown below:

    1. fldEmployeeId is automatically generated.
    2. fldEmployeeSalary, fldSalesSales, and fldSalesPay are currency
    3. fldSalesMonth and fldMonthNumber  are short integers between 1 and 12 (you can also figure out the month if it is in a combobox by adding 1 to the selectedIndex property).
    4. All other fields are strings.
    5. The database has 3 employees, 2 sales reps (Adam Ant, Tom Thumb) and one boss (The Boss) already included.
  1. The high cost checkbox and rules relating to it are eliminated.
  2. You need a form that looks something like this:

  1. The form should show the different employees and their pay for various months.
  2. The summary button displays the following form:

  1. Do as much of this as you can. Start with the ability to display the various employees, then add new employees, then develop the summary form.
  2. Use the Visual Studio help to see how the various database related components work.
  3. On the bindingNavigator (the object at the top of the main form), I have added a save button, I am also including the bitmap for that button in the project. (If you wish you can use regular buttons instead of the bindingNavigator tool, but then you need to handle the record change code yourself).
  4. The following is the PayCalcDataSet designer view for the main form. Note that I have created multiple additional queries.

Fair warning: It took me well over 12 hours to create the project and the program that meets these requirements. If you wait until the last minute on this project, you will not succeed!

If you have any questions, please contact me. Good luck.

    • 10 years ago
    complete solution
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      employees_grosspay_calculator_access.zip