Primary Navigation
  • About
  • Academics
  • Continuing Education
  • Admission
  • Student Life
  • Student Services
  • Library
  • News and Events
  • Giving

I.     Course Prefix/Number: CAB 140


       Credits: 3 (3 lecture; 1 lab)

II.    Prerequisite

Introductory microcomputer coursework or comparable work experience or consent of instructor or chairperson.

III.   Course (Catalog) Description

Course offers hands-on instruction in using Microsoft Access, a relational database management software package, used primarily on personal computers. Content includes database design and creating and modifying tables, queries, forms, reports.  Macros, Visual Basic for Applications, and interface development will be introduced.

IV.   Learning Objectives

  1. Achieve an understanding of relational database concepts including types of relationships, referential integrity, and primary, foreign, and composite keys
  2. Learn how to create and manage a fields, records, and tables within a relational database
  3. Learn how to manage and update data stored in tables
  4. Learn how to create, maintain and execute queries and advanced queries
  5. Learn how to create, maintain and execute standard forms and reports and custom forms and reports using various design tools
  6. Become familiar with how external data is imported and exported
  7. Learn how different joins impact the display of data
  8. Create simple macros that automate basic tasks
  9. Design and develop basic program code using Visual Basic for Applications
  10. Learn how to manage and secure a database
  11. Learn how to display data in a database on a web page

V.    Academic Integrity

Students and employees at Oakton Community College are required to demonstrate academic integrity and follow Oakton's Code of Academic Conduct. This code prohibits:

• cheating,
• plagiarism (turning in work not written by you, or lacking proper citation),
• falsification and fabrication (lying or distorting the truth),
• helping others to cheat,
• unauthorized changes on official documents,
• pretending to be someone else or having someone else pretend to be you,
• making or accepting bribes, special favors, or threats, and
• any other behavior that violates academic integrity.

There are serious consequences to violations of the academic integrity policy. Oakton's policies and procedures provide students a fair hearing if a complaint is made against you. If you are found to have violated the policy, the minimum penalty is failure on the assignment and, a disciplinary record will be established and kept on file in the office of the Vice President for Student Affairs for a period of 3 years.
Details of the Code of Academic Conduct can be found in the Student Handbook.

VI.   Sequence of Topics

A.    Creating a Database
   1.    Introduction to Database Concepts
   2.    Table Design
   3.    Creating a Table in Datasheet view
   4.    Create a Table in Design view
   5.    Copy Records from Another Access Database
   6.    Copy Records from an Excel Spreadsheet

B.    Building a Database and Defining Table Relationships
   1.    Guidelines for Designing Databases
   2.    Guidelines for Setting Field Properties
   3.    Viewing and Modifying Field Data Types
   4.    Formatting Data
   5.    Modifying the Structure of an Access Table
   6.    Creating a Table by Importing an Existing Table Structure
   7.    Adding Data to a Table by Importing a Text File
   8.    Defining Table Relationships
      a     Referential Integrity
      b.    Cascade Updates
      c.     Cascade Deletes
      d.     Updating Data

C.    Maintaining and Querying a Database
   1.    Updating Data using a Query
   2.    Sorting Data in a Query
   3.    Filtering Data
   4.    Defining Selection Criteria for all data types
   5.    Multiple Selection Criteria
   6.    Creating a Calculated Field
   7.    Using Aggregate Functions
   8.    Using Record Group Calculations

D.    Creating Forms and Reports
   1.    Creating a Form Using the Form Wizard
   2.    Creating a Form Using Autoformat
   3.    Modifying a Form’s Design in Layout View
   4.    Creating a Form with a Main Form and a Subform
   5.    Creating a Report Using the Report Wizard
   6.    Modifying a Report’s Design in Layout View
   7.    Using Conditional Formatting in a Report

E.    Creating Advanced Queries and Enhancing Data Entry
   1.    Creating a Parameter Query
   2.    Creating a Crosstab Query
   3.    Creating a Find Duplicates Query
   4.    Creating a Find Unmatched Query
   5.    Creating a Top Values Query
   6.    Creating a Lookup Field
   7.    Using the Input Mask Wizard
   8.    Identifying Object Dependencies
   9.    Defining Data Validation Rules

F.    Using Form Tools and Creating Custom Forms
   1.    Designing Forms
   2.    Creating Forms Using Form Tools
   3.    Creating Forms Using the Split Form Tool
   4.    Planning and Designing a Custom Form
   5.    Adding a Subform to a  Custom Form

G.    Creating Custom Reports
   1.    Customizing Existing Reports
   2.    Designing a Custom Report
   3.    Creating a Query for a Custom Report
   4.    Creating a Custom Report
   5.    Enhancing a Custom Report

H.    Sharing, Integrating, and Analyzing Data
   1.    Access Data in a Database From a Web Page
   2.    Importing a CSV file
   3.    Using XML
   4.    Integrating Access with Other Programs
   5.    Creating and Using a Pivot Table
   5.    Linking Data from an Excel Worksheet

I.    Using Action Queries and Advanced Table Relationships
   1.    Action Queries
   2.    Relationships Between Database Tables
   3.    Joining Tables Using Queries

J.    Designing, Developing, and Formatting Switchboards

K.    Automating Tasks with Macros
   1.    What is a  Macro?
   2.    Create a Macro That Executes When Using a Command Button

L.    Viewing and Using  SQL

M.    Introduction to Visual Basic for Applications (VBA)
   1.    Creating Functions
   2.    Creating an Event Procedure

N.    Managing and Securing a Database
   1.    Analyzing Database Performance
   2.    Securing a Database
   3.    Startup Options

VII.  Methods of Instruction

Lecture, class discussion, hands-on activities, demonstrations, lab projects

Course may be taught as face-to-face, media-based, hybrid or online course.

VIII. Course Practices Required

Students will complete at least one project in which they will create a database structure, input data, update data, query the data, generate a form with an embedded macro, create reports, create a switchboard (interface), and write VBA code

IX.   Instructional Materials

Note: Current textbook information for each course and section is available on Oakton's Schedule of Classes.

X.    Methods of Evaluating Student Progress

At least one exams and a minimum of five (5) computer lab projects using DBMS

XI.   Other Course Information

If you have a documented learning, psychological, or physical disability you may be entitled to reasonable academic accommodations or services. To request accommodations or services, contact the Access and Disability Resource Center at the Des Plaines or Skokie campus. All students are expected to fulfill essential course requirements. The College will not waive any essential skill or requirement of a course or degree program.