Free Essay

Report

In:

Submitted By jtan
Words 901
Pages 4
Queries are those objects in a database that allow us to view, change, and arrange data stored in tables.
Explain: (isa itong parte ng database na kung saan ginagamit para ipakita ang mga data at pwede rin itong baguhin o i-edit.)

Various types of queries exist:
Select queries, Action queries at Crosstab queries
Explain: (ito ang mga query na pwedeng gamitin pero ang sa amin jan ay select query.)
Select queries.
These are the queries that extract or show us data.
They will show data that complies with specific criteria.
Explain: (Ito ang query na nag Eextract ng data o nag papakita ng data galling sa database
At pwede rin itong magpakita ng data na may specific criteria.)

To create a query,
Open the database window where the query will be created.
Explain: (una nga ay buksan natin ang database window)
Click on the Queries object found on the left lateral of the Database window. (click natin yung Queries button at ito ang lalabas)

Explain: (meron tatlong paraan para simulan ang query) * Double click on the Create query by using wizard option.
In this case the wizard window will open in which we are asked from which table we choose to extract the data, the fields we wish to visualize and the title of the query, next it will automatically generate the corresponding query.
Explain: ( sa wizard ay automatically na syang nag eextract ng data papunta sa query galling sa pinili nating database, automatic ng mailalagay yung mga inimput natin sa fields papunta sa grid at pati rin yung title ng query .) * Double click on Create query in Design view.
In this case the Query design window will open on which we will elaborate further on, and within which we can define our query in more detail.
Explain : (sa query design view naman ay mas maidedetalye natin ang query na gagamitin natin) * Click on the new button in the Database window.
Explain: (sa new button naman ay magbubukas lang sya ng new Query window at ito ang gagamitin namin.) Explain: (dito sa New Query window ay mas marami lang ang pagpipilian. Ang;)
Design view, simple query wizard, crosstab query wizard, find duplicates query wizard, find unmatched query wizard. (at ang ginamit naming ay design view at lalabas may lalabas na Show table kapag kinlick natin ang design view.)

On entering the Query design we are firstly asked for which tables the query should extract the data from:
Explain: (pagmagsisimula na nga tayo sa paggawa ng query ay pipili muna tayo kung saan natin kukunin ang data na gagamitin.)
Select the table from which we wish to extract the data and click on the Add button (or double-click on its name).
Explain: (click natin yung tables na gagawin natin then click add. Then click close)
If we wish to extract data from another query, click on Queries tab an select it.
If we wish to extract data from various tables we should continue in the same manner.
Design View
Explain: (dito sa design view, ditto natin Ie-edit ang query natin)
To add fields to the QBE grid we can:
Double click on the name of the field appearing in the table’s area, this will be placed in the first vacant column of the QBE grid.
Explain: (sa paglalagay ng field sa QBE grid. Pwede nating I double-click ang Field sa lumabas na tables at lalabas ito sa unahang bahagi ng grid)
Or Click on the Field row of an empty column in the grid, an arrow will appear to the right with a drop down list with all the fields from all the tables that appear in the tables area.
Explain: (Pwede rin tayong pumili sa grid, sa pagclick nito sa arrow sa gilid ng grid at may lalabas na dropdown list.) We can also type the name of the field directly in the Field: row of an empty column in the grid.
Explain: (pwede rin tayong magtype directly sa grid.)
Changing the order of the fields
If we want to change the order of fields that have been included in the grid we can move a column (or various) either by dragging it.
Explain: (kung gusto naman nating baguhin ang pag kakasunod ng mga fields pwede natin itong idrag )
To move a column by dragging it:
Position the cursor over the extreme top part of the column and when the arrow appears clic, and the column will appear standing out (it is selected).
Explain: (itapat lang ang kursor sa itaas na bahagi ng field at may lalabas na arrow then iclick at mag ba black ito)
Move the cursor slightly so that the arrow appears. Press the mouse button and mantaining it down, drag the column to the desired position.
Explain: (kapag na click na ilagay ulit ito dito at iclick ulit pero kailangang naka maintain ito sa pagclick pagkatapos ay ilagay sa gusting position.)

Run the query
We can run the query from the Query design window or from the Database window.
From the design view of the query:
Click on the icon button on the toolbar.
Explain: (sa query design view naman iclick lang natin itong icon na to.)
From the Database window:
Firstly select the query to run by clicking on it.
Next click on the open button in the database window.
Explain: (sa database window iclick ang query then click your query.)

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. Therefore...

Words: 363 - Pages: 2

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. Santos...

Words: 1815 - Pages: 8

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 capitalized...

Words: 968 - Pages: 4

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 (level...

Words: 690 - Pages: 3

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 with...

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

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 findings:...

Words: 356 - Pages: 2

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 achievement ...

Words: 1025 - Pages: 5

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 together...

Words: 4226 - Pages: 17

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 options...

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) * Overall...

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