BCA-147: Database Applications

This course is INACTIVE
School
Business, Entrepreneurship, and Professional Development
Division
Business & Economics
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 Eligible to take ENG courses at HFC
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.

General Information

This course is being deactivated because the only program that it is required for is the Computer Software Applications Certificate, which is being deactivated. Students currently in need of this course will have a completion plan written.

Assessment and Requirements

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

Outcomes

Satisfies Wellness Requirement
No

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

Effective Term
Winter 2024