User Account

All Pages

Present data in attractive reports and forms

Assignment Help Computer Engineering
Reference no: EM131070298

PROJECT DESCRIPTION

Great Outdoors Tours is a small business that organizes day-long, guided trips of Massachusetts, Maine, New Hampshire, and Vermont. The company provides customers with a wide variety of hiking, biking, and paddling trips for all levels of experience. With a recent growth in business, Great Outdoors Tours has developed a database in Access 2013 to organize its records. The company would like your help with presenting data in attractive reports and forms that highlight certain information.

GETTING STARTED

Download the following file from the SAM website:

SC_Access2013_C4_P1a_FirstLastName_1.accdb
Open the file you just downloaded and save it with the name:
SC_Access2013_C4_P1a_FirstLastName_2.accdb

Hint: If you do not see the .accdb file extension in the Save file dialog box, do not type it. Access will add the file extension for you automatically.

Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

Open the Basic Trips List report in Layout View. Group the report by the State field, and then sort the report by the TripID field in ascending order. Do not add any additional grouping or sorting options to the report. Save and close the Basic Trips List report.

Modify the Reservations Financial Report to match Figure 1 on the following page by performing the following tasks:

Open the Reservations Financial Report report in Layout View.

Sum the values in the Trip Cost column and the Deposit column for each state's reservations and for all reservations.

Switch to Print Preview to view the report and to check that the values in the subtotal control and the total control are displayed completely.

Return to Layout View and, if necessary, expand the size of the subtotal control and the total control so that they appear completely.

With the Reservations Financial Report report still open in Layout View, apply conditional formatting to the Trip Cost column. If the cost of the trip is greater than $1,000, display the value in bold, Green font (7th column, 1st row in the Standard Colors palette).

Save the report again and close the Reservations Financial Report report.

Open the Reservations by Trips Report report in Layout View, and then create a summary report. (Hint: To create a summary report, hide the detail lines.) Save and close the report.

Open the Guide Phone List report in Layout View. Apply the Facet theme to this object only. Save and close the report.

Use the Label Wizard to create mailing labels for the Guides table, and include the following options:

Use Avery C2163 as the label size.

Use Arial font, 11 pt. font size, Light font weight, and Black (1st column, 6th row in the Basic Colors palette) font color with no special font styles for the labels. (Hint: These formatting options may be the default settings for your label.)

On the first line of the label, include the FirstName field, a space, and the LastName field.

On the second line of the label, include the Address field.

On the third line of the label, include the City field, a comma (,), a space, the State field, a space, and the PostalCode field. Your label should match Figure 2 below.

Sort the labels by the PostalCode field.

Save the labels as Labels Guides (which is the default name).

Confirm that your labels match Figure 3 on the following page, and then close the Labels Guides report.

Use the Report Wizard to create the report shown in Figure 4 on the following page. The report is based on the Guides and Trips tables and should include the following options:

Include the GuideID and LastName fields from the Guides table.

Include the TripID, TripName, and Type fields from the Trips table.

The data will automatically be grouped by the GuideID field but do not add any additional grouping levels.

Sort the report by the TripID field in ascending order.

Use a Stepped layout and Landscape orientation.

Save the report as Guides and Trips.

Preview the report, and then close it.

Reference no: EM131070298

Questions Cloud

Write a short program in python that turns on all leds : Write a short program in Python that turns on all LEDs, one at a time, in a looping fashion. When an LED is on, it should stay on for 1 second.
Scientific research in the field of psychology : Discuss the need for scientific research in the field of psychology. How does psychological research obtain and use empirical evidence - Issues related to sexual orientation have been at the forefront of the current political landscape.
How the gravitational constant was first measured : Who first measured G? Where and when? How was this constant related to Sir Isaac Newton (Newton did not measure G)?
How does using strings like integers alter the o-notation : How does using strings instead of simple types like integers alter the O-notation of operations? Is the ADT given in program 4.7 a first-class ADT? Explain your answer.
Present data in attractive reports and forms : With a recent growth in business, Great Outdoors Tours has developed a database in Access 2013 to organize its records. The company would like your help with presenting data in attractive reports and forms that highlight certain information.
Functional area within a corporate environment : Functional Area Review Your group's task is to study the role of a functional area within a corporate environment. "my functional area is supply chain management" You will need to interview professionals working in a corporate environment and condu..
Find the transfer function of the closed-loop system : Consider the power amplifier model above. Choose a sample time T and obtain the pulse transfer function G (z). Use root locus plot with 'grid' to design a static compensator for ζ = 0.7. Plot the step response.
Who was his first wife : Hercules, a figure of Greek and Roman mythology, was a positively-connoted figure in most myths, but when visited with madness by Juno, committed horrible crimes, including killing his first wife and their two children. Who was his first wife?
Determine the given function : Let f(x) = 2x + 1 and g(x) - 2x2 + x. Determine the following: (g o f)(x - 1)

Reviews

Write a Review

Computer Engineering Questions & Answers

  Design program using switch statements in visual basic

design program using switch statements in Visual Basic.

  Questiontest invoice application with an invalid total like

questiontest invoice application with an invalid total like s1000 and include the dollar sign. this should cause the

  Utilization of authentication

In the 802.11i, authentication always utilizes the SSL/TLS, Outer, Inner, Both A and B, Neither A nor B.

  Calculates and displays the parking charges

Write an application that calculates and displays the parking charges for each customer who parked in the garage yesterday.

  Plan a java class named mypoint to represent a point

create the class, and also write a test program that creates two points (0, 0) and (10, 30.5) and displays the distance between them.

  Should softarc move to a saas provider

Should SoftArc move to a SaaS provider in order to provide email and office automation services for their employees? What are the advantages and disadvantages of moving to a SaaS provider for these services?

  The first step in the design phase is to analyze the srs

your analysis phase of the srs project went well and your team feels good about their functional structural and

  When is a good time to utalize a frame

can the information in the frames have been better presented in a table or links rather than a frame.

  Create logic for application which reads in name of item

Products shown in accompanying table. Create the logic for application which reads in name of the item ordered by the customer and outputs either?

  Explain ram to support a computer screen display

RAM to support a computer screen display, One reason GUIs were initially slow to be adopted was the cost of the hardware needed to support them. How much video RAM is needed to support a 25 line X 80 row character monochrome text screen?

  Express about choosing which server-side scripting language

You've been hired by Company X to create a web site which will include a data-driven component. Describe how you would go about choosing which server-side scripting language

  Compute the dollar amount of money in a piggy bank

Write down a detailed set of instructions, in English, to calculate the dollar amount of money in a piggy bank that contains h half-dollars, q quarters, n nickels, d dimes and p pennies.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd