Cash-back offer from March 22nd to 31st, 2024: Get a flat 10% cash-back credited to your account for a minimum transaction of $50.Post Your Questions Today!

Question DetailsNormal
$ 28.00

Office 2013 Textbook Publishers | Complete Solution

Question posted by
Online Tutor Profile
request

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.

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

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    8
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.    4
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    
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.    8
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    100

 

Available Answer
$ 28.00

[Solved] Office 2013 Textbook Publishers | Complete Solution

  • This Solution has been Purchased 1 time
  • Average Rating for this solution is A+
  • Submitted On 02 Mar, 2016 03:19:58
Answer posted by
Online Tutor Profile
solution
This Tutorial is rated A+ p...
Buy now to view the complete solution
Other Similar Questions
User Profile
Exper...

Office 2013 Textbook Publishers | Complete Solution

This Tutorial is rated A+ previously,if you have any questions regarding this tutorial then you can contact me....
User Profile
Acade...

Exploring Microsoft Office 2019 Introductory 1st Edition by Poatsy Test Bank

Exploring Microsoft Office 2019 Introductory 1st Edition by Poatsy Test Bank...
User Profile
NUMBE...

Test Bank Shelly Cashman Series Microsoft Office 365 & Office 2019 Introductory, 1st Edition Sandra

Description 1. Pressing DELETE removes the character after the insertion point. a. True b. False ANSWER: True POINTS: 1 REFERENCES: SCWD 1-6 QUESTION TYPE: True / False HAS VARIABLES: ...
User Profile
TestB...

Enhanced Computer Concepts And Microsoft Office 2013 Illustrated 1st Edition By by June Jamrich

1. An Excel complex formula uses more than one arithmetic operator. a. True b. False ANSWER: True POINTS: 1 REFERENCES: Excel 26 LEARNING OBJECTIVES: ENHC.PARS.16.106 – Create a complex formula by pointing 2. Accordi...
User Profile
Grade...

Enhanced Computer Concepts And Microsoft Office 2013 Illustrated 1st Edition test bank

Enhanced Computer Concepts And Microsoft Office 2013 Illustrated 1st Edition By by June Jamrich Parsons -Test Bank...

The benefits of buying study notes from CourseMerits

homeworkhelptime
Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
tutoring
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
tutorsupport
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
closebutton

$ 629.35