BCA-147: Database Applications

School
Business, Entrepreneurship, & Professional Development
Department
Business Software Applications
Academic Level
Undergraduate
Course Subject
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
BCA-140 with a C grade or better OR 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

Upon successful completion of this course, students should be able to:

  1. Databases
    1. Create databases.*
    2. Create tables.
    3. Create input masks.
    4. Create lookup fields.
    5. Format field values.
    6. Use spell check.
    7. Compact and repair a database.
    8. Find and replace data.
  2. Relationships
    1. Create a primary field and foreign key.*
    2. Define and enforce referential integrity.
    3. Use cascade update and cascade delete options.
  3. Queries and Filters
    1. Create queries.*
    2. Sort fields in a query.
    3. Specify multiple criteria for a query.*
    4. Refine a query using filter by selection and filter by form.
    5. Create and apply advanced filters.*
    6. Join two tables in a query.
    7. Perform calculations in a query.
    8. Create find-duplicate, parameter, and action queries.
  4. Forms
    1. Create forms.*
    2. Add titles and graphics to a form.
    3. Create a calculated control.
  5. Reports and Charts
    1. Create reports and charts.*
    2. Sort and group records in a report.
    3. Add graphics to a report.
    4. Use the total and average functions.*
    5. Embed a sub-report.
  6. Data Importing and Exporting
    1. Export data from a table.
    2. Import data into a table.
  7. Access Tools
    1. Assign user-level security.
    2. Encode and decode a database.
    3. Set startup options.
    4. Create macros.
    5. Create command buttons that run macros.
  8. Database Applications
    1. Use the database splitter wizard.
    2. Link an external table.
    3. Make a local table from a linked table.
  9. Date Integration
    1. Export records to Microsoft Excel.
    2. Present data in a chart.
    3. Link an Excel workbook to an Access database.
    4. Create a data access page.
    5. Create a lookup field to use sorted data in another table.*
    6. Create PivotTables and PivotCharts.

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

Approval Dates

Effective Term
Fall 2015
ILT Approval Date
08/26/2015
Curriculum Committee Approval Date
10/05/2015