1 / 9

6 . Database Reports

This guide provides an overview of database reports, emphasizing their importance in presenting data in a clear manner. It discusses various reporting tools such as Access, MS SQL, Oracle Reports, and independent software like Crystal Reports. The process of creating an effective database report is outlined, focusing on understanding the report's purpose, identifying data sources, and designing the layout. Readers will learn about common operations in report creation, such as modifying fields, sorting data, and converting reports to different formats for accessibility. Ideal for managers and decision makers who need structured data insights.

ardice
Télécharger la présentation

6 . Database Reports

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CSCI N207 Data Analysis Using Spreadsheets 6. Database Reports Lingma Acheson Department of Computer and Information Science IUPUI

  2. What are Database Reports • Printed documents that display information from a database in a clear and well-organized manner. • E.g. Catalogs, telephone directory, financial statement, quarterly sales summary, letter to customers. • Who read database reports: • Managers • Decision makers • Administrators • Anybody who needs to see data but not good at using databases

  3. What are Database Reports • Examples: • Customers.pdf • RevenueReport.pdf

  4. Reporting Tools • Reporting tools: • Access build-in tool • MS SQL build-in tool • Oracle Reports (a software for Oracle database) • Independent software tools • Crystal Reports • Toad for Data Analysis • Windward Reports • …

  5. Reporting Tools • Reporting tools: • Access build-in tool • MS SQL build-in tool • Oracle Reports (a software for Oracle database) • Independent software tools • Crystal Reports • Toad for Data Analysis • Windward Reports • …

  6. Process • Design • Understand the task • What is the purpose of the report? • Who uses the report? • Identify data sources • What table(s) provide data for this report? • Should a query be created first? • What fields and records should be used? • Any calculation necessary? • Sketch out the report layout on paper • Headers, footers, column headers, …

  7. Process • Create • Create the report using a build-in or independent tool. • Convert • Concert the report to a common file format • WORD document (.doc, .docx) • Text files (.rtf, .txt) • PDF (the converted file is generally the most similar to the report) • HTML • Image files

  8. Create a Database Report • Using the Report tool: • Select a table • Create -> Report • Modify using Layout View and Design View • Common operations • Delete or add fields (Layout View) • Resize the column width (Layout View) • Change fonts (Layout View and Design View) • Select a format (Layout View, AutoFormat) • Add Logos (Layout View) • Sorting (Layout View) • Add Report header and footer (Design View)

  9. Create a Database Report • Common operations • Change row space (Design View) • Add extra labels (Design View) • Filter out rows (Layout View, select column, right click) • Using the Report Wizard • Follow the step by step instructions. • Will be able to edit in Layout View and Design View.

More Related