Liberty BUSI 201 Assignment 23 Access 2016 Challenge Yourself 3.3 Answers Solutions
Complete many different versions to get an A on your grade!
Download it for more and ace on your assignments!
Challenge Yourself 3.3
1. Open the start file AC2016-ChallengeYourself-3-3.
2. If necessary, enable active content by clicking the Enable Content button in the Message Bar.
3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor.
4. Create a Single Record form using the Plants table as the record source. Save the form with the name PlantsSingleRecord and close it.
5. Create a Multiple Items Form using the Plants table as the record source. Save the form with the name PlantsMultipleItems and close it.
6. Create a Split Form using the MaintenanceLog table as the record source. Save it with the name MaintenanceLogSplit and close it.
Name: Jennifer Lucas
Status: Online ⬤
Classes Taken: 3878
7. Use the Form Wizard button to create a form showing employee information in the main form with a subform showing related maintenance records.
a. 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
b. Organize the form by the Employees table with data from the MaintenanceLog table as a subform.
c. Format the subform as a Datasheet form.
d. Name the main form: EmployeeWorkLog
e. Name the subform: EmployeeWorkLogSubform
f. Review the form in Form view, and then close it.
8. Create a form from scratch in Layout view.