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.
For the purpose of grading the project you are required to perform the following tasks:
Start Access. Open the downloaded file namedgo_a03_grader_h1_Textbook_Publishers 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.
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.
Using the Publisher Form, add the following new record to the underlying Publishers table:
Publisher ID PUB-1008
Publisher Name Hidden Hills Publishing Co
Address 5100 Live Oak St
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. 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.
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 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.
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.
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.