In this project, you will use a database to track textbooks and publishers for science courses.
GO19_AC_CH03_GRADER_3E_HW – Textbook Publishers 1.0
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.
Start Access. Open the file Student_Access_3E_Textbook_Publishers.accdb downloaded with this project. View the relationship between the 3E Publishers table and the 3E Science Textbooks table. One publisher can provide many textbooks for science courses. Close the Relationships window.
Use the Form tool to create a form based on the 3E Publishers table. Save the form as 3E Publisher Form and then display the form in Form view.
Using the 3E Publisher Form, add the following new record to the underlying 3E Publishers table:
Field
Data
Publisher ID
PUB-1008
Publisher Name
Hidden Hills Publishing Co
Address
5100 Live Oak St
City
Dallas
State
TX
Postal Code
75201
Phone Number
(214) 555-0857
Publisher Web Site
http://www.hhpubco.pub
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, and change the Column Size Width in the Print dialog box to 7.5 inches. Save the form.
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.
Use the Form Wizard to create a form based on the 3E 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 3E Science Textbook Form.
With the 3E 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.
With the 3E Science Textbook Form displayed in Layout view, select the title—3E 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.
With the 3E 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.
With the 3E 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.
With the 3E 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).
With the 3E 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.
With the 3E 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.
With the 3E 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.
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.
Save and close the database, and then submit for grading.
"96% of our customers have reported a 90% and above score. You might want to place an order with us."
