Employee Data form-VBForums
Results 1 to 3 of 3

Thread: Employee Data form

  1. #1

    Thread Starter
    New Member
    Join Date
    Oct 2011
    Posts
    15

    Employee Data form

    Can anyone help me out with part2 of this project?



    Employee Data Application
    Part 1: Recording employee data
    For Games‐R‐Us, create an application that allows a user to enter the following employee data:
    Table 1. Employee Data
    Employee Data**
    First Name
    Middle Name
    Last Name
    Employee ID**
    Department
    Hourly Wage
    Married
    Dependents
    The Employee ID should be exactly 5 characters and/or digits long. The Department field can only be
    equal to Accounting, Administration, Marketing, MIS, or Sales.**The Hourly Wage can be any number
    that is a Single data type. Married will be True or False. Dependents will be an integer number
    representing the number of children or dependents the employee declares on their taxes.**
    The user should be able to append the employee data to a file containing similar employee data.**
    Part 2: Reading Employee Data
    Allow the user to specify an Employee data file (using an Open dialog box) and read in the employee
    data (as written in part 1). Read the information into arrays. Allow the user to select any of the
    employees by name from a combo box to edit the information. Populate text boxes with all the
    information from Table 1 when an employee is edited.**After the user has completed changes to all the
    employee information, write a new employee data file containing all the employees with all the updated
    information. Allow the user to select the location and name of the new output file.
    Part 3: Wages
    Games‐R‐Us is located in Texas where there is no state tax. Allow the user to enter the number of hours
    worked by each employee then calculate the employee wages and taxes. Employees are paid on an
    hourly basis with time and one‐half for hours over 40. FICA deductions are 7.65% of each employee’s
    gross pay.**Multiply the number of dependents times 70.19, then subtract that from the weekly grosspay to get the weekly taxable wages.**The federal withholding is then calculated based on the tables
    below:
    Table 2. Federal Withholding
    Single
    Wages Weekly Tax
    Greater
    than
    But less
    than
    Base Tax
    Amount Plus % of Taxable Wages
    0 200 8.4 10%
    200 1302 82.35 15%
    1302 1687 321.54 27%
    1687 7225 440.44 28%
    7225* ** 2085.13 35%
    Married
    Wages Weekly Tax
    Greater
    than
    But less
    than
    Base Tax
    Amount Plus % of Taxable Wages
    0 471 0 10%
    471 1809 168.8 15%
    1809 2789 412.39 27%
    2789 7335 900.66 28%
    7335* ** 1944.12 35%
    After all employees hours have been entered and taxes (FICA & Federal) calculated, allow the user to
    print a report containing each employees First Name, Last Name, Employee ID, Department, Hourly
    Wage, Hours Worked, Gross Pay, FICA Taxes, Federal Taxes, and Net Pay.**
    Attached Files Attached Files

  2. #2

    Thread Starter
    New Member
    Join Date
    Oct 2011
    Posts
    15

    Re: Employee Data form

    calculation
    Attached Files Attached Files

  3. #3
    Hyperactive Member
    Join Date
    Jul 2011
    Posts
    278

    Re: Employee Data form

    These forums aren't here to do your homework for you, if they were you'd learn nothing.

    I'd suggest having a go yourself (complete as many of the steps below as you can), if it doesn't work then post what code you have here and you'll be nudged in the right direction.


    All you're being requested to do, is work from the data stored in part 1 and complete the following:

    - Using an Open Dialog Box allow a user to select a date file and load it's contents into the form.

    - When loading the data arrange it in an array.

    - Create a ComboBox which contains the Surnames.

    - Allow the user to select a surname from that list and load the associated information into the form.

    - Allow the user to edit and save.

    - Allow the user to select where to save (this has not been specified as making use of a Save As Dialog Box, instead the user could, for example, write the path in an input box)

    Hopefully that's a more logical breakdown of the steps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.