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

Tổng quan các chủ đề

  • Database Software 2: Querying a Database

    Database Image created by Dr. Jennifer Lavergne

    In this module we will be introduced to creating, adding, and querying database objects. We will be using Microsoft Access, © Microsoft Simple Query Wizard and Design View. Both of these tools will allow students to manipulate the objects and their contents for summarization and knowledge generation. 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. Basic knowledge creating, adding, and querying database objects.
    2. Basic knowledge of MS Access Simple Query Wizard and Design View

    Topics covered will include:
    1. Create Databases
    2. Create Tables in Datasheet View
    3. Enter Data into Datasheets
    4. Import Data into Tables
    5. Filter and Sort Datasheets
    6. Preview and Print Datasheets
    7. Create Queries with the Simple Query Wizard
    8. Create Queries in Design View

    Upon completion of the MS Access Project 2: Querying a Database activity listed below, you will gain a practical knowledge of the following student learning outcomes:
    1. Create, design, and modify databases, tables, and records 
    2. Apply database and table knowledge to create/modify database records. 
    3. Apply database and table knowledge in order to query a database and create information


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

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


    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.