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

  Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

  Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

  Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

  Realize business and organizational data storage

Realize business and organizational data storage and fast access times are much more important than they have ever been. Compare and contrast magnetic tapes, magnetic disks, optical discs

  What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

  Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

  Define open and closed loop control systems

Define open and closed loop cotrol systems.Explain difference between time varying and time invariant control system wth suitable example.

  Prepare a proposal to deploy windows server

Prepare a proposal to deploy Windows Server onto an existing network based on the provided scenario.

  Security policy document project

Analyze security requirements and develop a security policy

  Write a procedure that produces independent stack objects

Write a procedure (make-stack) that produces independent stack objects, using a message-passing style, e.g.

  Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

  Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices

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!

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