Mar 28, 2024  
2020-2021 Course Catalog 
    
2020-2021 Course Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

BCA 164 - Basic Databases

Credits: 1
Lecture Hours: 0
Lab Hours: 2
Practicum Hours: 0
Work Experience: 0
Course Type: Voc/Tech
Introduce Microsoft Access to understand and work with relational databases. Students will be introduced to how to design related tables, build and use queries, create and use forms and reports, create lookup fields, modify the database structure, and analyze data with reports.
Competencies
  1. Describe Microsoft Access features and terminology.
    1. Use panes, ribbons and buttons.
    2. Use the help feature.
    3. Identify Windows features.
  2. Design a simple database table.
    1. Separate needed fields into specific subject areas.
    2. Demonstrate how to open and close a database and a database table.
    3. Create and modify a database and a table.
    4. Create a primary key.
    5. Show how to add, edit, move, and delete records
    6. Demonstrate how to navigate among records.
    7. Explain adjusting column widths and hiding columns.
    8. Sort and filter records.
    9. Relate two or more tables.
  3. Prepare a query.
    1. Create and modify a query.
    2. Use sorting options within a query.
    3. Use criteria in a query.
    4. Create multiple-table queries.
    5. Apply the AND and OR criteria.
    6. Use the wildcard character.
    7. Create a Calculated field.
    8. Use Summary queries.
    9. Create a crosstab query.
  4. Produce forms.
    1. Create a new form from scratch.
    2. Create a split form.
    3. Use Form Layout view to create forms.
    4. Add bound and unbound controls.
    5. Insert an image.
    6. Add subforms.
    7. Add headers and labels.
    8. Use a form to add, edit, and delete records.
  5. Produce a report.
    1. Develop a report using report wizards.
    2. Preview and modify a report design.
    3. Apply group and sort orders.
    4. Resize and align controls.
    5. Create mailing labels.
    6. Add subreports.
    7. Apply conditional formatting.
  6. Customize a database.
    1. Add controls to forms and reports.
    2. Connect tables by setting relationships.
    3. Use properties for tables, queries, forms, reports.
    4. Perform calculations in queries, forms and reports.
    5. Copy database objects.
    6. Copy data using the clipboard.
    7. Import data from other applications.
    8. Apply various data type features.
    9. Apply formatting techniques.
  7. Modify the database structure.
    1. Use many-to-many relationships.
    2. Enforce referential integrity.
    3. Create Lookup fields.
    4. Use Input Mask properties in a table.
    5. Create attachment fields.



Add to Portfolio (opens a new window)