BCA-147: Database Applications

School
Business, Entrepreneurship, & Professional Development
Department
Business Software Applications
Academic Level
Undergraduate
Course Subject
Business Computer Applications
Course Number
147
Course Title
Database Applications
Credit Hours
3.00
Instructor Contact Hours Per Semester
47.00 (for 15-week classes)
Student Contact Hours Per Semester
47.00 (for 15-week classes)
Grading Method
A-E
Pre-requisites
CIS-100 with a C grade or better AND ENG-081 eligible
Catalog Course Description

Explores the essential features of Microsoft Access and databases. Studies how to create and modify databases, create queries and forms, create reports and charts, add graphics to forms and reports, import and export data, create macros and command buttons to run macros, and integrate databases.

Goals, Topics, and Objectives

Core Course Topics
  1. Databases

    a. Create databases.
    b. Create tables.
    c. Create input masks.
    d. Create lookup fields.
    e. Format field values.
    f. Use spell check.
    g. Compact and repair a database.
    h. Find and replace data.

  2. Relationships

    a. Create a primary field and foreign key.
    b. Define and enforce referential integrity.
    c. Use cascade update and cascade delete options.

  3. Queries and Filters

    a. Create queries.
    b. Sort fields in a query.
    c. Specify multiple criteria for a query.
    d. Refine a query using filter by selection and filter by form.
    e. Create and apply advanced filters.
    f. Join two tables in a query.
    g. Perform calculations in a query.
    h. Create find-duplicate, parameter, and action queries.

  4. Forms

    a. Create forms.
    b. Add titles and graphics to a form.
    c. Create a calculated control.

  5. Reports and Charts

    a. Create reports and charts.
    b. Sort and group records in a report.
    c. Add graphics to a report.
    d. Use the total and average functions.
    e. Embed a sub-report.

  6. Data Importing and Exporting

    a.Export data from a table.
    b. Import data into a table.

  7. Access Tools

    a. Assign user-level security.
    b. Encode and decode a database.
    c. Set startup options.
    d. Create macros.
    e. Create command buttons that run macros.

  8. Database Applications

    a.Use the database splitter wizard.
    b. Link an external table.
    c. Make a local table from a linked table.

  9. Date Integration

    a. Export records to Microsoft Excel.
    b. Present data in a chart.
    c. Link an Excel workbook to an Access database.
    d. Create a data access page.
    e. Create a lookup field to use sorted data in another table.

Assessment and Requirements

Assessment of Academic Achievement
Students will be assessed through tests, quizzes, homework, and/or class participation.

Credit for Prior College-Level Learning

Options for Credit for Prior College-Level Learning
Other Exam
Minimum Departmental Exam Score
Microsoft Office Specialist Certification for Access
Departmental Exam Details

Microsoft Office Specialist - Access

Approval Dates

Effective Term
Fall 2020
ILT Approval Date
05/03/2019
AALC Approval Date
05/15/2019
Curriculum Committee Approval Date
06/03/2019