Chuyển tới nội dung chính

Tổng quan các chủ đề

  • Database Software 3: Creating Reports and Forms

    Database Image created by Dr. Jennifer Lavergne

    In this module first, we will be exploring information and why its important. We will cover data as input and output to answer questions requested by the user. Second, we will be introduced to designing and creating forms for a user to input information into the database. This allows dynamic changes to be applied to the database in real time. Finally, we will design and implement a report that can be dynamically generated at need to address questions asked by the user. (I.e. expense reports, employee time reports, etc.) Similar to the previous chapter, both theoretical knowledge, as well as the hands on database management projects, will be explored. These will prepare the student to not only utilize these tools in the Microsoft Access database software, but will also to be able to translate this knowledge to other database design software commonly used in industry. 

    Database image created by Dr. Jennifer Lavergne, CC. 

    When you complete this module, you can add the following to your resume:

    1. Basics understanding of creating knowledge and formatting it for the user's consumption
    2. Basic knowledge of using MS Access to create database forms and reports using the Design View.

    Topics covered will include:
    1. Exploring "What is information" 
    2. Creating a report 
    3. Creating a form

    Upon completion of the MS Access Project 3: Reports and Forms activity listed below, you will gain a practical knowledge of the following student learning outcomes:
    1. Use database software to create database forms for user input.
    2. Use database software to create database reports for displaying information.


    To achieve the learning objectives listed above, you will need to complete the following instructional materials and assessment: 

    1. Read the Database Software 3 Introduction 
    2. Read and view the materials in the Database Software 3 in the Computer Applications Pressbooks book
    3. Complete the assignment MS Access Project 3: Reports and Forms

    Module Pressbooks Resources and Activities

    You will find the following resources and activities in this module at the Pressbooks website. Click on the links below to access or complete each item.