+
GO! - Access Chapter 3: Assessment Project 1 Workshop Rooms

GO! - Access Chapter 3: Assessment Project 1 Workshop Rooms

Rating:
Rating
(0)
Author: matthew stock
Description:

http://homework.plus/go-access-chapter-3-assessment-project-1-workshop-rooms/

Workshop Rooms
 
Project Description:
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.
 
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step

Instructions

Points Possible

1

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.

0

2

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

8

3

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.

2

4

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.

4

5

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.

12

6

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.

5

7

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.

3

8

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.

4


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial