Revised 5/2018

ITE 150 - Desktop Database Software (3 CR.)

Course Description

Incorporates instruction in planning, defining, and using a database; performing queries; producing reports; working with multiple files; and concepts of database programming. Includes database concepts, principles of table design and table relationships, entering data, creating and using forms, using data from different sources, filtering, creating mailing labels. Lecture 3 hours per week.

General Course Purpose

This course is designed to provide student with a working knowledge of a major microcomputer database program. Emphasis is on the functional rather that the technical approach to understanding, using, and managing electronic database management systems.

Course Prerequisites/Corequisites

None.

Course Objectives

Upon completion of this course, the student will be able to:

  • Plan, define and use databases
  • Perform queries
  • Produce reports, tables, forms and mailing labels

Major Topics to Be Included

  • Creating and Using Databases
  • Creating and Modifying Tables
  • Creating and Modifying Queries
  • Creating and Modifying Forms
  • Viewing and Organizing Data
  • Defining Relationships
  • Producing Reports
  • Integrating with other Applications

Student Learning Outcomes

 Creating and Using Databases

  • Identify and describe database techniques (relational, hierarchical, etc.)
  • Describe microcomputer DBMS fundamentals, capabilities, limitations, applications and problems
  • Describe the features of the database window
  • Plan and define a database structure (tables and fields)
  • Create a databases using database software
  • Open a database objects in multiple views
  • Move data among records in a database
  • Add formatting to a datasheet

Creating and Modifying Tables

  • Create and modify a database table
  • Add records to a table
  • Add a predefined input mask to a field
  • Create Lookup fields to view information stored in a table
  • Modify table field properties
  • Specifying referential integrity and validation rules to view records in a table
  • Print the contents of a table

Creating and Modifying Queries

  • Create queries in Design view
  • Include fields in the design grid
  • Use text and numeric data in criteria
  • Save a query and use the saved query
  • Create and use parameter queries
  • Use compound criteria in queries
  • Sort data in queries
  • Join tables in queries
  • Searching the database
  • Add calculated fields to Select queries
  • Perform calculations and calculate statistics in queries
  • Create crosstab queries

Creating and Modifying Forms

  • Create and use a form
  • Display a form
  • Modify form properties
  • Create a form from a query

Viewing and Organizing Data

  • Enter, edit and delete records
  • Create queries
  • Sort database records
  • Create an index for a record
  • Create a filter for a record

Defining Relationships

  • Recognize the need for and work with multiple databases
  • Combining and summarizing tables

Producing Reports

  • Produce and print formatted reports from database records
  • Modify a report in Layout view
  • Create a report from a query

Integrating with other Applications

  • Interchange data with other applications
  • Creating and using OLE objects
  • Export data from a query into another application

Required Time Allocation per Topic

In order to standardize the core topics of ITE 150 so that a course taught at one campus is equivalent to the same course taught at another campus, the following student contact hours per topic are required. Each syllabus should be created to adhere as closely as possible to these allocations. Of course, the topics cannot be followed sequentially. Many topics are taught best as an integrated whole, often revisiting the topic several times, each time at a higher level. There are normally 45 student contact-hours per semester for a three credit course. (This includes 15 weeks of instruction and does not include the final exam week so 15* 3 = 45 hours. Sections of the course that are given

in alternative formats from the standard 16 week section still meet for the same number of contact hours.) The final exam time is not included in the time table. The category, Other Optional Content, leaves ample time for an instructor to tailor the course to special needs or resources

Topic Hours Percentage
Creating and Using Databases 5 11%
Creating and Modifying Tables 5 11%
Creating and Modifying Queries 6 14%
Creating and Modifying Forms 5 11%
Viewing and Organizing Data 5 11%
Defining Relationships 6 14%
Producing Reports 5 11%
Integrating with Other Applications 5 11%
Testing to include quizzes, tests, exams 3 6%
Total 45 100%