Free Essay

Report

In: Business and Management

Submitted By jrodri53
Words 852
Pages 4
Report Exercise

Educational Goals

The purpose of this assignment it to help students learn how to use the report wizard to develop reports and to use the design window to refine the reports and make them more readable. In the process, this assignment should help students learn to establish additional groupings and subtotals in reports, and to control the sort order for the report and entries within groupings. All these issues are covered in the Reports Chapter 11.

Assignment

Implement a Sales Journal in Tom's Trailer Sales database. The Sales Journal should look like the example below. The report has the default page footer that the report wizard creates.

I have added a Chart of Accounts table to the database for you to use to use to get the account names for the report. You also will need to use the "Is Not Null" function as a selection criteria so that your report only picks up orders that have been delivered. Since this is a sales journal, only sales that can be recognized under GAAP's revenue recognition criteria should be included. For Tom's, that means only order that have been delivered to the customer.

The report should look like the example at the end of the assignment.

This is a complex report. I recommend that you follow the following steps in developing it:

1) Start by identifying which tables contain the data you will need for the report.

2) Then, use the report wizard to tell Access™ the fields you need from each table. Lay out your fields in the wizard from top to bottom in the same order they will appear in the report from left to right.

3) You will need two groupings in your report, one for each of the two subtotals in the report: Account and Sales Order Number. You will need to add the Sales Order grouping and make it the second highest grouping in the grouping priority. Unfortunately, Access™ insists on adding additional groupings that we won't need, but we will have to delete in the design view of the report.

4) The wizard will have put the delivery date in the detail field instead of the Sales Order Number group. You will need to move it. First, you will need to reduce the size of the some fields to develop room to move things around. Then, move the Deliver Date label and the Deliver Date text box over next to the order number. Finally, move the Delivery Date text box up into the Sales Order group.

5) The wizard will have created a grouping for merchandise name, which you will need to delete. Move the Merchandise Name text box out of the Merchandise.name group and down into the detail. Then, go to the group options and delete the Merchandise.name group.

6) Next, add a text box that calculates "Amount" and edit the record source to only include orders that have been delivered

a) First, you will need to go the report's Record Source and create a field for "Amount" that multiplies the price times the quantity.

b) While you are editing the record source, add a criterion to the delivery date field that eliminates orders without a delivery date. You can do this by typing in "Is Not Null" in the criteria field.

c) Next, you will need to add a text box and label to show this amount on the face of the report. The simplest way to do this is to copy the Price text box and label; redo the label to say "Amount" and then edit the new text box's Control Source property in the Data tab to tie to the "Amount" field you just created.

7) Add a subtotal for Amount in the footer to the Sales Order Number grouping. The text shows you how to add subtotals to groups. Be sure to include the Grand Total option so that you will get a total at the end of the report. Once you have the text box in the group footer, you may need to move it around.

8) Add the label shown in the sample of the report. However, you will need to use a text box to create the label so that you can show the Sales Order #. Insert a blank text box next to the subtotal in the Sales Order Number footer and use the expression building in the text box's control source to concatenate "Sales Order # " with the value in the Sales Order Number field.

9) Add the line shown in the example report.

10) Add a subtotal in the Account Number group footer for the Amount field and add a label for it as shown in the example report. You can add the line by copying the one you built above.

11) Add lines and a label to the report footer as shown in the example report. The fastest way to do this is copy the label you made for the Sales Order # subtotal as well as the line you made to the Report footer and retype the contents of the label.

[pic]

Similar Documents

Free Essay

Report

...reporting frameworks to disclose sustainability performance, which enable companies to focus on the creation of value over the long term. The article is relevant to the main drivers associated with sustainability reporting. Nevertheless, its relevant is limited to considering the key features of an effective sustainability report. In addition, the author dose not provides sufficient details to explain, develop, and support his position, which is related to six main categories. Despite such limitations, generally it is a relative objective source, which is appropriate for an academic business context. The article is partially relevant to the assessment task, which analyze the motivations that lead companies to engage in Global Reporting initiative (GRI) reporting. NACD (2013) points out existing regulations and related rules such as the conflict minerals already require some disclosure of sustainability information indicating how key business processes are performing. However, the paper contains Principles in order to ensure the quality of reported information NACD (2013), which is not clearly related to the key elements of an effective sustainability report. While the authors focus on the main drivers associated with sustainability reporting is relevant to the assessment task, it is also a limitation of the source because the relevant of key features is limited. Furthermore, the author based on plenty of quotations and provided unambiguous evidence to prove his position.......

Words: 363 - Pages: 2

Free Essay

Practicum Report

...Practicum REPORT The culmination of the student’s practicum training is the preparation of their individual practicum report. This report will contain a summary of what was learned in their training hotel/restaurant, and an analysis of the procedure coupled with the appropriate recommendations. A. Suggested Outline 1. Title Page Center type on the first page the following: 8th line : “PRACTICUM REPORT 10th line : “on” 11th line : NAME OF Practicum Training Institution 12th line : Address of practicum training institution 20th line : “In partial fulfillment of the requirements for the course” 22nd line : indicate program enrolled 24th line : “Lyceum of the Philippines University 25th line : “College of International Tourism and Hospitality Management” 26h line : “Intramuros, Manila” 30th line : “SUBMITTED TO” 31st line : Name of Practicum Faculty 34th line : “SUBMITTED BY” 35th line : Complete Name of Student 36th line : Address 40th line : “SUBMITTED ON” 41st line : date of submission 42nd line : TRAINING PERIOD (inclusive dates) All phrases enclosed in quotation marks should be printed as is, and the correct information should be given for the others. 2. Table of Contents Indicate all major sections or chapters, and appropriate paging. All Chapter headings should be......

Words: 968 - Pages: 4

Premium Essay

Write a Report

...A Guide to Report Writing September 2008 CONTENTS Page 1. 2 INTRODUCTION ..............................................................................................................................1 PREPARATION ................................................................................................................................2 2.1 2.2 2.3 2.4 3 INTRODUCTION .......................................................................................................................2 PURPOSE ..............................................................................................................................2 PLANNING ..............................................................................................................................2 RESEARCH ............................................................................................................................2 CONTENTS OF A REPORT ............................................................................................................3 3.1 3.2 3.3 3.4 3.5 3.6 3.7 3.8 3.9 3.10 INTRODUCTION .......................................................................................................................3 TITLE PAGE ...........................................................................................................................3 CONTENTS PAGE ...................................................................................................................3 THE SUMMARY ....

Words: 4543 - Pages: 19

Premium Essay

Sample Report

...BLUE BOOK SERVICES 845 E. GENEVA ROAD CAROL STREAM, IL 60188 Phone 630 668-3500 FAX 630 668-0303 Email info@bluebookservices.com Web Site www.bluebookservices.com BLUE BOOK SERVICES Business Report on Santos Produce of America, Inc. *SAMPLE* Information available through 7/01/2014 © Blue Book Services, Inc. This COMPLETE BUSINESS REPORT is provided to the subscriber under the terms of the Membership Agreement and is IN CONFIDENCE, for the subscriber’s exclusive use, without recourse and without guarantee of correctness. Trade experience information may include disputed items, skipped invoices or other extenuating circumstances. This SAMPLE Business Report mimics the Blue Book Business Report. The Guest Reports show a sub-set of this report depending upon the level of report purchased (Blue Book Scores and Equifax information are available only to Members). BB #987654 Santos Produce of America, Inc. P.O. Box 12345 Laredo, TX 78041 USA 2876 Waterfall Dr. Dallas, TX 75201 Phone: 956 555-9878 Fax: 956 555-1619 info@santosproduceofamer.net www.santosproduceofamer.net Credit Snapshot: Current HQ Rating: Current Blue Book Score: Last Financial Statement Date: Net Worth: Avg Integrity/Ability (‘X’) Reports: (past 6 months) 2500M XXXX A 868 12/31/2013 $8,670,144 3.99 (Industry Avg: 3.43) (scale: 1=poor, 4=excellent) Business Snapshot: Incorporation Date: Incorporated In: PACA License Number: March 6, 1986 Texas 123456 Business Ownership: Richard L.......

Words: 1815 - Pages: 8

Premium Essay

Weekly Report

...SUMMER INTERNSHIP- SIB BANGALORE WEEKLY REPORT – No. 2 ( April 16th 2012-April 22nd 2012) Submitted To : Prof. Saji George Submitted By :- Neetha Kurian Roll No.176 MBA-A SUMMER INTERNSHIP AT SIB, BANGALORE DAILY ACTIVITY REPORT Sl No. | Date | Activity Description | 1 | 09.04.2012, Monday | * Reported to SIB, Regional Office. * Topic for Problem centric Study * Discussion with Saji sir regarding the topic and how to go about it * Instructed to Change the topic by Saji Sir | 2 | 10.04.2012, Tuesday | * Data collection for Organization study | 3 | 11.04.2012,Wednesday | * Reported to SIB, Regional Office. * Discussion with Mr. Nirmal Staff of SIB, about the value added service-SIB M-Pay, as per the instruction of the guide. * Was detailed about the new Value added Service- SIB –M-Pay * The new service SIB M-Pay, has been recommended by them for the purpose of the problem centric study * Suggested to me that customer perception and awareness would be a good topic | 4 | 12.04.2012, Thursday | * Data collection for organization Study | 5 | 13.04.2012,Friday | * Reported to SIB, regional Office. * Review with guide Ms. Suguna about SIM M-Pay * Topic Finalization “a study on the perception and awareness of customers with respect to SIB M-Pay service of South Indian Bank Ltd” * Sample size, target audience selection. * Region wise Listing of Customers of SIB M-Pay provided by Mr...

Words: 304 - Pages: 2

Premium Essay

Group Report

...About Miloni we already knew that she has an artistic personality and would do the task allotted to her with perfection. We knew that conflicts would be there when a new group is formed because people feel it difficult to get out of their comfort zone and for introverts it’s even more difficult. So all of us knew to avoid conflicts we focused on our individual strengths and we aligned our goals with the goals of the group. We focussed on being the group that delivers the best performance as we were one of the groups who were underrated. All of us kept our group’s interest above our own individual interest. And no matter what we finished all of our group reports on time , every time . The members of the group didn’t bother even if our individual reports are not submitted. Members prioritised the group report above individual reports which helped better functioning and performance of the group. This seems quite an ideal situation but this is how it happened. It seems like magic. There was forming, No storming (only brainstorming) , Norming and...

Words: 334 - Pages: 2

Free Essay

How to Write a Report

...ENHANCE YOUR REPORT IMAGE Whether in school or on the job, you must prepare and present reports. Written reports create an image of you – on paper. To achieve the most positive image, written reports must be prepared carefully and presented forcefully. To prepare an excellent report, Clippinger (1995, 11-12) suggest five equally vital steps that must be taken in the order listed: (1) plan; (2) draft; (3) revise; (4) edit; (5) format. Plan the Report To plan, ask: What is my purpose for writing, and what is the reader’s purpose for reading what I write? The answers become the core of the message. Compose and key the core idea. Then as they come to mind through listening, reading, and thinking, jot (on the computer screen) ideas and facts that related to the core idea. Next, check the list for missing items (and add them), unneeded items (and delete them), and redundant items (and combine them). Put the items in psychological order (main point followed by details, usually) and arranged them logically (in chronological, geographical, or importance order, for example). Finally, check the list to see that the items are tied together and related to the core idea. When appropriate, use tables, charts, or graphs to condense data; then list only summaries of what the visuals reveal in greater detail. Draft the Message To draft or compose the message, pretend that the reader is sitting before you. Write (at the keyboard) as you would talk with that person......

Words: 690 - Pages: 3

Premium Essay

Financial Accounting Report

...SUMMER SCHOOL 2015 BUSINESS REPORT Content Executive summary Introduction Background and achievement Recent trends and approach taken by South Africa Analysis of implication and impediments of <IR> and a position statement Executive Summary The purpose of this report is to provide a concise background on the objective and technical development of Integrated Reporting and key achievement to date, a summary of recent trends in adoption of Integrated Reporting which including the approach taken by South Africa, an analysis of any implications and impediments of Integrated Reporting and a positon statement of how these might affect adoption in Australia. Introduction Integrated Reporting is a process in which the value creation of a periodic integrated thinking, in a periodic report, is created by the value creation of the periodic report of the value creation (Adams & Simnett, 2011). The organization uses the integrated report to convey a clear, concise, and complete story, stating that all of their resources are of value creation. Integrated Reporting is to help companies carefully consider their strategies and plans to make informed decisions and management of key risks, to establish the confidence of investors and stakeholders and improve future performance (INTEGRATED REPORTING<IR>, 2015). This is a diverse alliance, including the evolution of business leaders and investors to promote the global business report. Background and......

Words: 1025 - Pages: 5

Free Essay

Writing Report Format

...KOLEJ PROFESIONAL MARA BERANANG REPORT WRITING FORMAT Prepared by: Roselena Mansor Deputy Director (Academic Affairs) 10 December 2009 1 This report format contains guideline on word-processed report writing for all programmes in KPM Beranang. 1.0 Language The entire report should be written in English except for courses which the medium of instruction is not in English. Language use d must be simple and direct to the related course. 2.0 Font Use Arial as font type of size 12 for all text in the report. 3.0 Title and subtitle All titles and subtitles must be numbered and bold. The subtitles should not be indented but arranged in a structured manner not more than three levels as follow: 1.0 First level (Title of the topic) level 1 1.1 Second level (Title of the subtopic) level 2 1.1.1 Third level (Title of the sub-subtopic) level 3 Sub -topics beyond level three are not allowed and should be labeled using alphabets (a, b, c, ) and Romans. Numbering using Roman style (i, ii, iii, .) is only allowed after the alphabets have been used. Example: 1.1.1 a. .. i. .. b. . 2 All numbering should be left aligned. 4.0 Line/Body Text Spacing Use JUSTIFY alignment with 1.5 spacing for the entire body text throughout the report. The text body should not be indented for each paragraph, but hit the enter key twice before stating the following new paragraph. 5.0 Captions Captions must be written at the top of any table or figure. 6.0 Margins All pages should be set......

Words: 2132 - Pages: 9

Premium Essay

Incident Report Administration

...to promote a culture that promotes patient safety, the hospital’s Incident Reporting Policy is based upon a foundation of nonpunitive approach to incident/occurrence reporting. The hospital leadership will encourage open and honest reporting of injuries and hazards to patients, visitors and staff, this process will be nonpunitive in nature for all persons reporting incidents throughout the organization. Incidence/occurrence investigations will be viewed as an opportunity for education/process improvement, and will focus on processes and systems, rather than human error. Disciplinary action will be limited to only those employees who engage in willful or malicious misconduct, or those occurrences in which the employee failed to report an incident or hazard to patients in a timely manner. II. Responsibility A. All hospital employees, medical staff members, volunteers, and contract service members will participate in the hospital-wide incident reporting program. All incidents such as those listed as follows will be reported to the department of quality management: 1. Incidents involving inconsistencies with written hospital policies and procedures—informed consent, bedrails, patient...

Words: 3611 - Pages: 15

Premium Essay

Guide for Report Writing

...What is a report? A report ‘reports’ on something in a concise, formal way using clearly defined sections presented in a standard format, which tell the reader what you did, why and how you did it and what you found. It is the formal writing up of a practical experiment, project or research investigation. A report is written in a way which presumes that the reader knows nothing about your experiment or research. It is usually written more concisely than an essay, with headings and sub-headings and perhaps bullet-point recommendations, etc. A research report must be written in sufficient detail so that someone reading it would be able to replicate your research exactly. It usually contains arguments and critical evaluation to support a proposed course of action, or to evaluate a business issue. BEFORE YOU START WRITING… • Firstly, check with your lecturer and the module handbook for precise instructions, i.e. the prescribed report structure, word count, deadline. All UHBS reports are module and assignment specific, so this guide only gives a very general idea of structure and content. • Be very detail minded. All UHBS reports will require accurate referencing, good clear English, professional presentation, i.e. clear structure, coherent, free of spelling, grammatical and punctuation errors. • If you are compiling a group report, assign roles. One person in the group could be assigned the role of ‘editor’ to finally ensure the report is put......

Words: 4226 - Pages: 17

Free Essay

How to Write a Report

...Writing Reports: According to Oxford English Dictionary, a report is a statement of the results of an investigation or any matter in which definite information is required. Different Types of Report: Depending upon the subject area it might would be: laboratory reports, technical reports, and reports of a work placement or industrial visit, reports of a field trip of field work. For writing a proper reports following material should considered: • Plan your report and divide the platform in a various stages, • Careful planning of reports will give a clear concise and effective results, • Collecting the information from various truthful sources and organizing the information, • Finally structuring the reports that vary according to the various types of reports said earlier. Following are the common elements can be found in many different reports: o Title page: The authors name, module, course and the date. o Acknowledgements: Give thanks to the librarians, technicians or computer centre staff. o Contents: List all the main sections in a sequence with page numbers. o Abstract of Summary: It should be concise informative and independent of the report. o Introduction: It will include context, scope of the report, terms of reference as well as define the limits of report, give a brief general background. o Methodology: Show the way of inquiry like interviews or questionnaires. o Results or......

Words: 356 - Pages: 2

Free Essay

Project Status Report

...[PROJECT STATUS REPORT] Rev. 1.0, 25/10/2013 Company here Bi-weekly Project Status Report GENERAL INFORMATION Project Name Project Manager Project ID Number Prepared by Project Sponsor Reporting Period Ending Date [DD/MM/YYYY] Report Number Section I TASKS/MILESTONES COMPLETED This section only includes tasks/milestones that are completed since last reporting period (Report Number CT-BWR-09, dated 23/05/2012). [Insert rows as needed] Description of Task/Milestone Baseline Finish Date [DD/MM/YYYY] Current Status* Actual Finish Date [DD/MM/YYYY] Remarks [PROJECT STATUS REPORT] Rev. 1.0, 25/10/2013 Section II Company here ISSUES IDENTIFIED [Insert rows as needed] Description of Issue Reported by Reported Date [DD/MM/YYYY] Estimated Resolution Date [DD/MM/YYYY] Remarks Section III PROJECT CHANGES [Insert rows as needed] Change Reques t ID No. Description of Change Change Requestor Approval Status Action Steps Actual Resolution Date [DD/MM/YYYY] Current Change Status* [PROJECT STATUS REPORT] Rev. 1.0, 25/10/2013 Section IV Company here UPCOMING TASKS/MILESTONES This section only includes tasks/milestones that are to be completed by next reporting period, ending 06/06/2012. [Insert rows as needed] Description of Task/Milestone Baseline Finish Date [DD/MM/YYYY] Current Status* Remarks *Key: This column should be populated with the task/milestone current status. Valid......

Words: 386 - Pages: 2

Premium Essay

Management Report Format

...For whatever research you intend to do in your law enforcement profession, always plan to record enough information so that people outside of your agency can understand and interpret what you’re researching, why, and how. * Title Page (name of the agency, product, program, or service that is being researched; date) * Table of Contents * Executive Summary (one-page, concise overview of findings and recommendations) * Purpose of the Report (what type of research was conducted, what decisions are being aided by the findings of the research, who is making the decision, etc.) * Background About Agency/Product/Service/Program that is being researched       a) Organization Description/History       b) Product/Service/Program Description (that is being researched)                   i) Problem Statement                   ii) Overall Goal(s) of Product/Service/Program                    iii) Outcomes (or client/customer impacts) and Performance                                            Measures (that can be measured as indicators toward the outcomes)                   iv) Activities/Technologies of the Product/Service/Program                                            (general description of how the product/service/program is developed and delivered)                   v) Staffing (description of the number of personnel and roles in the organization that are relevant to developing and delivering                        the product/service/program) *......

Words: 310 - Pages: 2

Free Essay

Report Writing Guidelines

...REPORT WRITING GUIDELINES ACADEMY OF HOTEL MANAGEMENT & FACILITY MANAGEMENT NHTV BREDA UNIVERSITY OF APPLIED SCIENCES By Marina Brinkman (Brinkman.M@nhtv.nl) Alinda Kokkinou (Kokkinou.A@nhtv.nl) Jelmer Weijschedé (Weijschede.J@nhtv.nl) Version 1.0 08 September 2011 Summary The purpose of this document is to provide you with information on report writing and serve as an illustration of what your report should look like. The document also addresses the content and style of your report and how you should reference others’ ideas and information. Table of Contents Acknowledgments ................................................................................................................................................................... 4  1.  2.  3.  3.1.  3.2.  3.3.  3.4.  3.5.  3.6.  3.7.  3.8.  3.9.  4.  5.  5.1.  5.2.  5.3.  5.4.  5.5.  5.6.  5.7.  6.  Introduction ..................................................................................................................................................................... 5  Types of Reports ............................................................................................................................................................ 5  Structure of a Report .................................................................................................................................................... 5  Cover Page, Title of the Report,...

Words: 4884 - Pages: 20