Question Details

(Solved by Expert Tutors) Hello. ProfShini02? helped with a previous table for me in Access,>


I was hoping you could help me for my next one. Next homework assignment needs to be done using that previous table that we did .(See attachment)? Please see instructions below:
Instructions are attached too, the 2013 Technology PlugIn T8 attachment.

Thank you so much for your help!

OverviewUsing the database file you created in the previous Tutorial Assignment you will create a multi-table query and report.
InstructionsFirst save your database file from the previous tutorial assignment under a new name as?"TA5_Lastname_Firstname" where Lastname is your last name and Firstname is your first name.
Part 1: Create a query that spans both tables.?
Part 2: Modify the Query to select only those Customers that had service dates in 2 specific months (e.g. Jan & Feb 2007).
Part 3: Create a report that display the results of your query. This report should list customer information, and under each customer record should list all related customer service records.
To complete Part 3, you will need to:

-Read plug-in T8
-Use the Report Wizard
-Select an appropriate field for the Grouping parameter in the Report wizard. (This is probably the most challenging part of this assignment). ?Your goal is that for the listing of each customer record, the associated Customer Service records (i.e. the records from the "Customer (service) ?Record" table should be listed below it, but only displaying the Service date and Weight fields (not repeating the Customer ID). ? As a final step, once you have completed your report, please switch to Design View and then type in you name (first name and last name) into the report's page header. Then upload your database file to the appropriate dropbox.
PS. The previous homework was great, however, there were 14 additional names that were supposed to be added, not sure if we need to add them now so the new homework is done correctly?

in case other attachment wont open here is the Plug In T8 instructions:

Decision Making Using 1. Describe the steps for creating a form using the Form Wizard in Access. 2. Describe the steps for creating and saving Forms using Access. 3. Describe the steps to modify the properties of a form using Access. 4. Describe the steps for creating a report using the Report Wizard in Access. 5. Describe the steps to modify the properties of a report using Access. Introduction This plug-in focuses on the two functions of decision making using Access 2013 : creating forms and creating reports. A form is nothing more than a graphical repre-sentation of a table. You can add, update, and delete records in your table by using a form. Although a form can be named differently from its corresponding table, they both still manipulate the same information and the same data. Hence, if you change a record in a form, it will be changed in the table as well. A form is useful when you have numerous fields in a table. It allows you to see all the fields in one screen, whereas if you were in the table view (datasheet) you would have to keep scrolling to get to the field you desire. A report is an effective way to present your data in a printed format. Because you have control over the size and appearance of everything on a report, you can dis- play the information the way you want to see it. Forms An Access form is a window, similar to a dialog box, that contains a set of controls (such as labels, text boxes, and check boxes) to view, enter, or edit database infor- mation, typically one record at a time. In a form, data are obtained directly from one or more tables or from data that have been extracted using a query. Although it is possible to directly enter and edit the information in tables in Datasheet View, a database usually includes a set of forms that can make entering and editing data considerably easier and can limit the fields that can be viewed or modified. LEARNING OUTCOMES bal76744_plugint08_002-012.indd T8-2 2/23/08 12:08:17 PM

* Plug-In T8 Decision Making Using Access 2013 * T8- 2 CREATING A FORM USING THE FORM WIZARD Forms allow you to enter data one record at a time. Often, it is easier to enter data in a well-designed form rather than in a wide datasheet. You can create a form that has fields from more than one table or query. Like other wizards, the Form Wizard walks you step-by-step through the process of creating a form. To create a form using the Form Wizard: 1 . Open the file T8_SlopesideBikes_Data.mdb from the data file that accompanies this text. 2 . C li ck the Create tab. Click Form Wizard. 3 . Click the Tables/Queries drop-down arrow and select Table: BIKE. 4 . Add all BIKE fields by clicking on the double right arrow ( >> ). Click Next to go to the next step. 5 . Select the Columnar form layout. Click Next. 6 . 7 . Type in BIKE FORM for a form title. Click Finish to open the form and begin entering data (see Figure T8.1 ). Accessing Several Tables or Queries in a Form When you select the fields for your form in the first Form Wizard dialog box, you can add fields from several tables or queries. To add fields from each table or query, select it in the Tables/Queries drop-down list and then use the buttons to move the fields you want to the Selected Fields list. If you add fields from several forms or queries, the wizard will display one or two additional dialog boxes that were not shown in the previous section: one dialog box in which you specify the form or query by which you want to view your data (for example, if you selected fields from the CUSTOMER and the BIKE tables, you would choose to view your data either ?by Customer? or ?by Bike?) and possibly another dialog box in which you select a layout for a subform. The choices you make deter- mine the form?s record source. FIGURE T8.1 Create a Form by Using the Form Wizard bal76744_plugint08_002-012.indd T8-3 2/23/08 12:08:18 PM
If your form includes fields from two tables that are related in a one-to-many
relationship and if you selected to view your data by the primary table, the wizard
will let you display the records from the related table in a subform contained within
the form. As an alternative, the wizard will let you set up a linked form, which is a
separate form that displays the related data and which you open by clicking a but-
ton on the main form.
On the other hand, if you chose to view your data by the related table in the one-
to-many relationship, when the form displays a record in the related table, it will
simply display the unique matching fields from the primary table along with the
fields from the current record in the related table.
A form that accesses data from several tables or queries can be complex to design
from scratch or to modify. However, if you create the form using the Form Wizard,
almost everything is set up for you.
CREATING AND SAVING FORMS
To create a simple form in Access, you can use the form buttons available on the
Create tab. You can create a basic form, split form, tabular form using multiple
items, blank form, or Pivot?Chart.
To create a form:
1 .In the Navigation Pane, select the CUSTOMER?table.
2 .?Click on the Create?tab, and then click on the Form?button (refer to Figure T8.2 ).
3 .Access automatically creates a Columnar Form based on the CUSTOMER
table you selected. Since the CUSTOMER table has a linked relationship to the
RENTAL table, Access displays the RENTAL table contents associated with the
CUSTOMER information.
4 .Close the form by clicking the Close?box in the upper-right corner.
5 .Access will automatically prompt you to save the form. Save it as ?CUSTOMER.
**Using the Report Wizard
Like other wizards, the Report Wizard walks you step-by-step through the process
of creating a report. Unlike forms, which are designed for on-screen data entry,
reports are designed for print.
To create a report using the Report Wizard:
1 . Click the Create?tab, and then click the Report Wizard?button in the Reports
group.
2 . Click the Tables/Queries?drop-down arrow. Select the CUSTOMER
table and select all the fields except the Drivers License, Telephone, and Credit Card No.
Then select the RENTAL table and select the? Date field. Lastly, select the
BIKE table and select the Description field.
3 .? Click Next to go to the next step. ?Note: If you selected fields from more than one
table or query in the previous step, the second Report Wizard dialog box asks
you to choose one table or query that will be used for grouping the information
in the report, if possible.
4 . ?The next step asks how you want to view the report. Double-click
BIKE.? Click Next.?
5 . Make? Date the first grouping level. (Note:?Use a grouping level to organize the
data into subgroups by the value of a specific field.) Click Next.
6 . Next, for sort order, specify State as the primary data sort. Click
Next.
7 . Select the Stepped report layout and Landscape
orientation. Click Next.
8 . Select the ?Office style for the report. Click Next.
9 . Type in Customer Rental by State Report for the title and select
Preview the report.
10. Click Finish.
Figure T8.6 displays the results.
MODIFYING THE REPORT DESIGN
Once you create a report, you can modify the report?s design to make it more visu-
ally attractive. As with forms, be careful not to overdesign your report. A poorly
designed report can distract from the information being presented. To modify the
design, you must have the report open in Design View.
To modify the report design:
1 .
Preview the report first. Double-click the
Customer Rental by State Report
in the Navigation Pane. Notice that the columns and data do not align correctly,
some columns are much bigger than they need to be, and we can?t even see the
date field (refer to Figure T8.6 ).
2 . Switch to Design View by clicking the View?button (under the
Home tab).
3 . Click the Description control under the Bike_Id
Header section, and then drag the sizing right handle
to increase the width of the control box (this will allow more
characters to be visible in the report). You can also select
Size from the Format menu. Select To Fit
to automatically resize the label or control to fit your data.
4. Make sure that you can see the Date column control. You may have to adjust the
width of that control. Select the State column heading and resize that control to
have fewer spaces.?
5 . Switch to Report View via the ?View toolbar button to see your changes. You may
have to toggle back and forth from the Design View to the Report View several
times before you get the results you desire. Figure T8.7 displays the modified
report.
Note:?Change the graphic style of the report by clicking the
Arrange tab, then clicking the Auto?Format button.


CHANGING MARGINS AND PAGE ORIENTATION FOR REPORTS The default page orientation for a report is portrait. This means the height of the page is greater than the width. You may want to change this orientation to land- scape to accommodate multiple columns of data so they fit on one page.
Margins are the blank spaces at the top, bottom, left, and right of a report.
By adjusting the page margins, you can control the number of records printed on each page.
Use the dialog box to adjust margins and page orientation for your reports. To change the margins for a report:
1 . Open the report in Design View.
2 . Click the Page Setup tab, and then click the Page Setup button in the Page Layout group.
3 . Select the Print Options tab in the Page Setup dialog box. 4 . Change the values for the top, bottom, left, or right margin. 5 . Click OK. To change the page orientation for a report:
1 . Open the report in Design View.
2 . Click the Page Setup tab, and then click the Page Setup button.
3 . Select the Page tab in the Page Setup dialog box. Click the radio button for Portrait or Landscape orientation. 4 . Click OK. FIGURE T8.7 Modified Report Properties Data are aligned, viewable, and printable.
WasteNot Recycling
WasteNot Recycling, introduced in Plug-In T6 and reintroduced in T7, picks up recyclables
from homeowners in Boulder, Colorado. The owners of WasteNot Recycling have asked
you to assist with creating a form and several reports. They have provided you with an
updated database file,
T8_WasteNotRecycling_Data.mdb.
Specifically they want you to do
the following:
1 .
Create a form that will allow the owners to enter data into the CUSTOMER and the
CUSTOMER RECORD tables. They have left the design (i.e., aesthetics) up to you.
However, they have asked that you locate an appropriate graphic to include on the form.
You will want to use the Internet to find such a graphic. Make sure you align all the con-
trols and adjust the size of all the controls to fit the data. Save the form as
Customers.
2 .
Create a report that groups the records by customer. The report should include data on
the customer first and last name, service date of pickup, weight of paper, and weight of
other. The report should be sorted by customer last name. You will need to create a sub-
total for the weights for each customer. Create a report title called
Customer Weights.








 


Solution details:

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Apr 19, 2020

EXPERT

Tutor

ANSWER RATING

YES, THIS IS LEGAL

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now