Go19_ac_ch03_grader_3g_hw – career books 1.0

Go19_ac_ch03_grader_3g_hw – career books 1.0

GO19_AC_CH03_GRADER_3G_HW – Career Books 1.0

Project Description:

In this project, you will use a database to track publishers and book titles that assist students in finding employment. You will create forms, add and delete records by using a form, filter records, and modify a form in Layout view and Design view. You will create reports, modify a report in Layout view and Design view, group data in a report, and keep grouped data together for a printed report.

Open the file Student_Access_3G_Career_Books.accdb downloaded with this project. View   the relationship between the 3G Publishers table and the 3G Career Books   table. One publisher can publish many career books. Close the Relationships   window.

Use   the Form tool to create a form based on the 3G Career Books table. Save the   form as 3G Career Book Form and display the form in Form view.   Using the Career Book Form, add the following new record to the underlying   Career Books table:

Field

Data

Title ID

T-25

Title

Effective Networking

Author Last Name

Nunez

Author First Name

Charlene

Publisher ID

PUB-109

Category

Job Search

Copies On Hand

6

Value of Books

180

Find the record for the Title ID of T-19   and delete it. Find the record for the Title ID of T-25. From 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 3G Career Book Form that   displays records with a Category of Interviewing   Strategies or Resumes.   After verifying that 10 records match the filter criteria, toggle the filter   off to display all 24 records. Save and close the form.

Use   the Form Wizard to create a form based on the 3G Publishers table. Add the   following fields (in this order) to the form: Company Name, Rep Last Name,   Rep First Name, Job Title, and Phone Number. Apply a columnar layout and name   the form 3G Publisher Form.

With   the 3G Publisher Form displayed in Layout view, apply the Stacked layout to   all of the controls. Apply the Integral theme to this form only. Select the   title—3G Publisher Form. Change the font   size to 16, apply bold, and change the font color to Dark Teal, Text 2,   Darker 50% (under Theme Colors, in the fourth column, the last color). Save   the form.

With the 3G Publisher Form displayed in Layout view, from the Field List   pane, add the Publisher ID field to the form directly above the Company Name   controls. Close the Field List pane. In the form, move the Rep First Name   controls directly above the Rep Last Name controls. Change the width of the   Job Title text box control to 2.5   inches. Save the form.

With   the 3G Publisher Form displayed in Layout view, select all six text box   controls and change the background color to Turquoise, Accent 1, Lighter 80%   (under Theme Colors, in the fifth column, the second color). Select all six   label controls and change the font color to Dark Teal, Text 2, Darker 50%   (under Theme Colors, in the fourth column, the last color). For the same   controls, apply bold and change the width to 1.75   inches. Save the form.

With   the 3G Publisher 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 3G Publisher 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 Southwest   Campus.   For the selected label control, change the font color to Dark Teal, Text 2,   Darker 50% (under Theme Colors, in the fourth 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.25 inches. Close the Property Sheet and   save the form.

With   the 3G Publisher Form displayed in Form view, add the following new record to   the underlying Publishers table:

Field

Data

Publisher ID

PUB-111

Company Name

Associated Publishers

Rep First Name

Marquis

Rep Last Name

Sullivan

Job Title

Sales Associate

Phone Number

(512) 555-7373

Use   the Report tool to create a report based on the 3G Resume or Interview Books   Query object. With the report displayed in Layout view, apply the Retrospect   theme to only this report. Delete the Publisher ID, Category, and Company   Name fields from the report. Change the width of the Title text box controls   to 3 inches. Sort the records in ascending   order by the Title field. Change the width of the Author Last Name and Author   First Name text box controls to 1.5   inches.

With   the report displayed in Layout view, add a calculated control to the Title   field that counts the number of records. Change the height of the calculated   control that displays 10 to 0.25   inch. For the page number control, set the Left property to 5 inches. Select the title of the report   and change the font size to 14. In the title, change the word Query to Report.   In the body of the report, for the Title label control, set the Left property   to 0.75 inch (the Title text box controls move   to the right, and all of the other fields also move to the right). Save the report as 3G Resume or   Interview Books Report, close the Property Sheet and the   report.

Use   the Report Wizard to create a report based on the 3G Career Books table. Add   the following fields (in this order) to the report: Category, Title, and   Value of Books. Group the data by the Category field and sort the records in   ascending order by the Title field. Summarize the report by summing the Value   of Books field. Be sure the layout is Stepped and the orientation is   Portrait. Name the report 3G Book Values by   Category Report, then finish the wizard.

Display   the 3G Book Values by Category Report in Layout view. Apply the Ion Boardroom   theme to this report only. Select the title of the report, change the font   size to 14 and apply bold. Delete the controls that begin with Summary for ‘Category’. At the top of   the report, apply bold to the three label controls that display the field   names. In the body of the report, change the width of the Title text box   controls to 3.5   inches. Set the Left property of the Value of Books label control to 6 inches. Save the report.

With   the 3G Book Values by Category Report displayed in Layout view, at the bottom   of the report, in the last column, select the following three controls: text   box control that displays $420, calculated control that displays $945, and   the calculated control that displays 7,730. Change the width of the selected   controls to 1.25   inches and the Left property to 6   inches. Change the width of the Grand Total label control to 1 inch. Change the text in the label   control that displays Sum to Total Value of Books by   Category.   In the body of the report, change the height of the Title text box controls   to 0.35 inch. Close the Property Sheet and   save the report.

Display   the 3G Book Values by Category Report in Design view. Select the following   two controls: the Total Value of Books by Category label control (in the   Category Footer section) and the Grand Total label control (in the Report   Footer section). Align the left edges of the two selected controls. Save the   report.

Display   the 3G Book Values by Category Report in Print Preview as two pages and   notice how the groupings break across the pages. Display the report in Layout   view and open the Group, Sort, and Total pane. Set the grouping option so   that each group of category records is kept together on one page when the   report is printed. Close the Group, Sort, and Total pane. Display the report   in Print Preview and notice that the groupings are not split between   pages. Save and close the report.

Save   and close the database, and then submit for grading.

Calculate the price of your order

Select your paper details and see how much our professional writing services will cost.

We`ll send you the first draft for approval by at
Price: $36
  • Freebies
  • Format
  • Formatting (MLA, APA, Chicago, custom, etc.)
  • Title page & bibliography
  • 24/7 customer support
  • Amendments to your paper when they are needed
  • Chat with your writer
  • 275 word/double-spaced page
  • 12 point Arial/Times New Roman
  • Double, single, and custom spacing
  • We care about originality

    Our custom human-written papers from top essay writers are always free from plagiarism.

  • We protect your privacy

    Your data and payment info stay secured every time you get our help from an essay writer.

  • You control your money

    Your money is safe with us. If your plans change, you can get it sent back to your card.

How it works

  1. 1
    You give us the details
    Complete a brief order form to tell us what kind of paper you need.
  2. 2
    We find you a top writer
    One of the best experts in your discipline starts working on your essay.
  3. 3
    You get the paper done
    Enjoy writing that meets your demands and high academic standards!

Samples from our advanced writers

Check out some essay pieces from our best essay writers before your place an order. They will help you better understand what our service can do for you.

Get your own paper from top experts

Order now

Perks of our essay writing service

We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.

  • Swift delivery
    Our writing service can deliver your short and urgent papers in just 4 hours!
  • Professional touch
    We find you a pro writer who knows all the ins and outs of your subject.
  • Easy order placing/tracking
    Create a new order and check on its progress at any time in your dashboard.
  • Help with any kind of paper
    Need a PhD thesis, research project, or a two-page essay? For you, we can do it all.
  • Experts in 80+ subjects
    Our pro writers can help you with anything, from nursing to business studies.
  • Calculations and code
    We also do math, write code, and solve problems in 30+ STEM disciplines.

Frequently asked questions

Get instant answers to the questions that students ask most often.

See full FAQ
    See full FAQ

    Take your studies to the next level with our experienced specialists

    Chat
    Chat
    Hello, we are online 24/7. Leave a message we will reply instantly