< Database Applications

Database Applications/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

Objectives and skills for this lesson include:

    Readings

    1. Microsoft Office: Introduction to reports in Access
    2. Microsoft Office: Create a simple report - Access

    Multimedia

    1. GCF Global: Access 2016 Creating Reports
    2. GCF Global: Access 2016 Advanced Report Options

    Activities

    1. Complete the tutorial GCF Global: Access 2016 Creating Reports.
    2. Complete the tutorial GCF Global: Access 2016 Advanced Report Options.

    Lesson Summary

    • 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

    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

    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

    References

    This article is issued from Wikiversity. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.