Jump to content

Database Applications/Reports

Add links
From Wikiversity
Database Applications
  1. Introduction
  2. Tables
  3. Queries
  4. Advanced Queries
  5. Forms
  6. Reports

This lesson assists users in creating Microsoft Access reports which is a way to organize and display data from an Access database.

Objectives and Skills

[edit | edit source]

Objectives and skills for this lesson include:

Readings

[edit | edit source]
  1. Microsoft Office: Introduction to reports in Access
  2. Microsoft Office: Create a simple report - Access

Multimedia

[edit | edit source]
  1. GCF Global: Access 2016 Creating Reports
  2. GCF Global: Access 2016 Advanced Report Options

Activities

[edit | edit source]
  1. Complete the tutorial GCF Global: Access 2016 Creating Reports.
  2. Complete the tutorial GCF Global: Access 2016 Advanced Report Options.

Lesson Summary

[edit | edit source]
  • A database is an organized collection of data.[1]
  • A report is used to summarize and display the data in your database from tables and queries.[2]
  • The easiest way to create an Access report is to use the Report Wizard tool.
  • A report is an object in Microsoft Access that is used to display and print your data in an organized manner.

Key Terms

[edit | edit source]
grouping level
A report grouping level in Access is the way your data is organized on the report.[3]
page orientation
Page orientation is the way in which a rectangular page is oriented for normal viewing. The two most common types of orientation are portrait and landscape.[4]
sort
Sorting is any process of arranging items in sequence (ascending or descending order).[5]
template
Templates are pre-built files, pages or articles designed for a wide range of uses. In Wikipedia, templates contain repetitive material that might need to show up on any number of articles or pages.[6]

Review Questions

[edit | edit source]
Enable JavaScript to hide answers.
Click on a question to see the answer.
  1. Microsoft Access database file extension is: ________
    Microsoft Access database file extension is: accdb. [7]
  2. The ______________ is a tool that guides you through the process of creating complex reports.
    The Report Wizard is a tool that guides you through the process of creating complex reports.[8]

See Also

[edit | edit source]

References

[edit | edit source]
  1. ↑ Wikipedia: Database
  2. ↑ GCFGlobal: Access 2016: Creating Reports
  3. ↑ GCF Global: Access 2016 Advanced Report Options
  4. ↑ Wikipedia: Page orientation
  5. ↑ Wikipedia: Sort
  6. ↑ Wikipedia: Help: Template
  7. ↑ Wikipedia: Microsoft Access
  8. ↑ [GCFGlobal Access 2016: Advanced Report Options]
Retrieved from "https://en.wikiversity.org/w/index.php?title=Database_Applications/Reports&oldid=2309376"