Homework answers / question archive / Lab#4: (130 points) Use the database you created in lab#3

Lab#4: (130 points) Use the database you created in lab#3

MS Access

Share With

Lab#4: (130 points)

1. Use the database you created in lab#3. Rename the database to Lab#4.
2. Create a form that allows a user to add, delete, and navigate through the records of Employee table.  

1. 1. Create the form and set properties. Follow the steps below:

1. 2. Create the form buttons: 
      • Go back to Form Design View.
      • If you would like to move the header and footer of the form in design view, follow the directions in the following YouTube video: https://youtu.be/Nta1DJNTqIU.
      • Create the following buttons by following the directions below:
        1. Clear Form
        2. Find Record
        3. Add Record
        4. Delete Record
        5. Go To Next Record
        6. Go To Previous Record
      • If you need additional help adding buttons, you can follow the directions in the following YouTube video https://youtu.be/nNVD4AK-eV8.

3. Go back to Form View and test all the button operations, then add 10 records to the database (A total of 20 records) The completed form in Form view should look like the picture to the right.
4. Save and close the database. Attach your database (Lab#4) as a file to Lab#4 Assignment.