GO Access Ch. 03, H1 Textbook Publishers

GO Access Ch. 03, H1 Textbook Publishers

Author: matthew stock


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.
For the purpose of grading the project you are required to perform the following tasks:


Points Possible


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:
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. 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.


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.

226 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 21 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.