Grader – InstructionsAccess 2016 Project
GO16_AC_CH03_GRADER_3E_HW – Textbook Publishers
Project Description:
In this project, you will use a database to track textbooks and publishers for science courses. You will create forms, add and
delete records by using a form, filter records, and modify a form in Layout view and Design view.
Steps to Perform:
Points
Possible
Step
Instructions
1
Start Access. Open the downloaded file named go_a03_grader_h1_Textbook_Publishers.accdb
and enable the content. View the relationship between the Publishers table and the Science
Textbooks table. One publisher can provide many textbooks for science courses. Close the
Relationships window.
0
2
Use the Form tool to create a form based on the Publishers table. Save the form as Publisher
Form and then display the form in Form view.
8
3
Using the Publisher Form, add the following new record to the underlying Publishers table:
8
Field
Data
Publisher ID
Publisher Name
Address
City
State
Postal Code
Phone Number
Publisher Web Site
PUB-1008
Hidden Hills Publishing Co
5100 Live Oak St
Dallas
TX
75201
(214) 555-0857
http://www.hhpubco.pub
4
4
Find the record for the Publisher ID of PUB-1006, and then delete the record. Find the record
for the Publisher ID of PUB-1008. Using the Print dialog box and the Setup option, change the
column size width of a printed form to 7.5 inches. Save the form.
5
Use the Filter By Form tool to create a filter for the Publisher Form that displays records with a
State of CA Or TX. After verifying that three records match the filter criteria, toggle the filter
off to display all seven records. Save and close the form.
8
6
Use the Form Wizard to create a form based on the Science Textbooks table. Add the
following fields (in this order) to the form: Course(s), Textbook Name, Publisher ID, Price Per
Book, and # Books. Apply a columnar layout, and name the form Science Textbook Form.
14
7
With the Science Textbook Form displayed in Layout view, apply the Stacked layout to all of
the controls. Apply the Ion Boardroom theme to this form only.
6
8
With the Science Textbook Form displayed in Layout view, select the title—Science Textbook
Form. Change the font size to 16, apply bold, and change the font color to Dark Purple, Text 2
(under Theme Colors, in the fourth column, the first color). Save the form.
6
9
8
With the Science Textbook Form displayed in Layout view, from the Field List pane, add the
Textbook ID field to the form directly above the Textbook Name controls. Close the Field List
pane. In the form, move the # Books controls directly above the Price Per Book controls.
Created On: 07/05/2019
1
GO16_AC_CH03_GRADER_3E_HW – Textbook Publishers
Grader – Instructions
Access 2016 Project
Points
Possible
Step
Instructions
10
With the Science Textbook Form displayed in Layout view, display Record 9. Change the width
of the Textbook Name text box control to 4 inches (the widths of all of the text box controls
change). Save the form.
3
11
With the Science Textbook Form displayed in Layout view, select all six text box controls, and
change the background color to Orange, Accent 4, Lighter 80% (under Theme Colors, in the
eighth column, the second color).
3
12
With the Science Textbook Form displayed in Layout view, select all six label controls, and
change the font color to Orange, Accent 4, Darker 50% (under Theme Colors, in the eighth
column, the last color). For the same controls, change the width to 1.75 inches.
6
13
With the Science Textbook Form displayed in Layout view, select the six label controls and the
six text box controls. Change the font size to 12, and change the height to 0.25 inch. Save
the form.
8
14
With the Science Textbook Form displayed in Design view, change the height of the Form
Footer section to 0.5 inch. Add a label control to the Form Footer section that displays Texas
Lakes Science Books.
8
15
Still in Design view and with the label control in the Form Footer section selected, change the
font color to Orange, Accent 4, Darker 50% (under Theme Colors, in the eighth column, the
last color). Apply bold to the label control and change the width to 2.2 inches. For the same
label control, set the Top property to 0.1 inch and the Left property to 1.95 inches. Close the
Property Sheet, save the form, and then close the form.
10
16
If necessary, close all database objects and open the Navigation Pane. Close Access and
submit the database as directed.
0
Total Points
Created On: 07/05/2019
2
100
GO16_AC_CH03_GRADER_3E_HW – Textbook Publishers