In this project, you will use a database to track workshops and the rooms where the workshops are held at a college. You will create forms, add and delete records by using a form, filter records, and modify a form in Layout view and Design view. You will create reports, modify a report in Layout view and Design view, group data in a report, and keep grouped data together for a printed report.
For the purpose of grading the project you are required to perform the following tasks:
Start Access. Open the downloaded file namedgo_a03_grader_a3_Workshop_Rooms, and then enable the content. View the relationship between the Rooms table and the Workshops table. One room can be used for many workshops. Close the Relationships window.
Use the Form tool to create a form based on the Workshops table. Save the form as Workshop Form and then display the form in Form view. Using the Workshop Form, add the following new record to the underlying Workshops table:Field Data
Workshop ID W-5034
Workshop Name Job Portfolio
Room ID RM-208
# Registrations 23
Workshop Category Guide to Finding a Job
Find the record for the Workshop ID of W-5020 and then delete the record. Find the record for the Workshop ID of W-5034. From the Print dialog box and the Setup option, change the column size width of a printed form to 7.5 inches. Save the form.
Use the Filter By Form tool to create a filter for the Workshop Form that displays records with a Workshop Category ofGuide to Finding a Job or Keeping a Job. After verifying that 15 records match the filter criteria, toggle the filter off to display all 24 records. Save and close the form.
Use the Form Wizard to create a form based on the Rooms table. Add the following fields (in this order) to the form: Rental Fee, Capacity, Equipment, Podium, and Internet. Apply a columnar layout and name the form Room Form.
With the Room Form displayed in Layout view, apply the Stacked layout to all of the controls. Apply the Integral theme to this form only. Select the title—Room Form. Change the font size to 24, apply bold, and change the font color to Dark Teal, Text 2, Darker 50% (under Theme Colors, in the fourth column, the last color). Save the form.
With the Room Form displayed in Layout view, from the Field List pane, add the Room ID field to the form directly above the Rental Fee controls. Close the Field List pane. In the form, move the Internet controls directly above the Equipment controls. Change the width of the Equipment text box control to 2.5 inches. Save the form.
With the Room Form displayed in Layout view, select all six text box controls, and change the background color to Turquoise, Accent 1, Lighter 80% (under Theme Colors, in the fifth column, the second color). Select all six label controls, and change the font color to Dark Teal, Text 2, Darker 50% (under Theme Colors, in the fourth column the last color). For the same controls, apply bold and change the width to 1.25 inches.