change the Microsoft Access file following these steps, really simple
I will attach the steps using a picture. this is a really simple task
like this:
- Open the start file AC2019-ChallengeYourself-4-3.
- If the database opens in Protected View, click the Enable Content button in the Message Bar at the top of the database so you can modify it.
- The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
- Create a Single Record form using the Plants table as the record source. Save the form with the name PlantsSingleForm and close it.
- Create a Multiple Items form using the Plants table as the record source. Save the form with the name PlantsMultipleForm and close it.
- Create a Split form using the MaintenanceLog table as the record source. Save it with the name MaintenanceLogSplit and close it.
- Use the Form Wizard button to create a form showing employee information in the main form with a subform showing related maintenance records.
- Add the following fields to the form in this order:
From the Employees table: EmployeeID, LastName, FirstName, WeeklyHours
From the MaintenanceLog table: MaintenanceDate, Plant, Watered, Inspected, Pruned - Organize the form by the Employees table with data from the Main
- Add the following fields to the form in this order: