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

  Amazon kindle changed the number of print books

Has popularity of the Amazon Kindle changed number of print books Kindle users buy.

  Difference between the padding and margin properties

In your own words, explain the box model and the difference between the "padding" and "margin" properties. What is the benefit of using a fixed-width layout in web design? What are some cons

  Give difference between standard forms, mdi parent forms

define the difference between standard forms, MDI parent forms, and MDI child forms in an MDI application. How is each type of form created? Give examples of when to use each type of form.

  Describe the mapping of c stream functions

Describe the mapping of C stream functions (fopen, fread, fwrite, fclose) to device driver interfaces?

  Present managers of the economy are determined to ensure

by far the biggest development in the economy in recent years is the mining boom and its likely to roll on for at least

  Create class named counter that has one string field

create a Main class that has the normal main method that you need to start the program. The main method should ask the user for the name of a local input file.

  Information system prototyping builds an experimental

1.determine the correlation between a problem-solving ability and programming proficiency and how you would use

  Show the total amount of accounts in the jtextfield

Sort the files according to which JCheckBox the user selects. (If a user selects another checkbox the previous becomes unselected).

  Custom decision support system for an international airline

A major international airline (of your choice) wants to upgrade its rostering tool, which has had many upgrades and still used some manual input. A salesman from CSIRO has convinced them to consider a new Intelligent Automated Rostering Toolkit

  Illustrate the difference between the throwing an exception

question 1 what is the difference between throwing an exception and catching an exception?question 2 how does a method

  How to calculate the bmi of a team player

how to calculate the BMI of a team player.the formula to calculate the BMI is as follows.

  Preliminary project plan for an important internal project

You have been hired by the Client to provide a preliminary Project Plan for an important internal project. Client staff support the project and have secured Board approval for MIT Consulting to take the project to the next phase.

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