2023-2024 Catalog 
    Jun 23, 2024  
2023-2024 Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CMIS 287 - Microsoft Access III

2 Credit: (0 lecture, 2 open-lab, 0 clinical) 2 Contact Hours: [Pre- or co-requisite: CMIS 258 ]

This course provides advanced instruction in Microsoft Access. Students will create advanced reports and queries, design macros, and explore integration with other programs.
OFFERED: every semester

Course Goals/ Objectives/ Competencies:
Goal 1:  Create advanced forms and reports.

  1. Create a split form.
  2. Create a subform.
  3. Create and modify a subreport.

Goal 2:  Manage macros.

  1. Create a standalone macro with one action.
  2. Add multiple actions to a macro.
  3. Create a macro group.

Goal 3:  Integrate access with other applications.

  1. Import data from other applications.
  2. Export data to other applications.

Goal 4:  Administer databases.

  1. Create a navigation form.
  2. Encrypt and decrypt databases.
  3. Use the database splitter.

Goal 5:  Compose SQL statements.

  1. Modify a query in SQL view.
  2. Create a query in SQL view.
  3. Create calculated fields and SQL aggregate functions.

Add to Portfolio (opens a new window)