2019 - 2020 Catalog 
    
    Oct 25, 2020  
2019 - 2020 Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CMIS 258 - Microsoft Access II

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


This course provides experience using intermediate features of Microsoft Access. Students will create, manipulate, and manage databases.
OFFERED: every semester

Course Goals/ Objectives/ Competencies:
Goal 1:  Enhance Microsoft Access table objects.

  1. Modify existing tables.
  2. Create a lookup field.
  3. Manage field properties.

Goal 2:  Enhance Microsoft Access query objects.

  1. Create calculated fields in a query.
  2. Create a crosstab query.
  3. Construct a make table query.
  4. Create an append query.

Goal 3:  Customize forms and reports.

  1. Create a form in design view.
  2. Format a form.
  3. Make a form user friendly.
  4. Create a report in design view.
  5. Add controls to a report.
  6. Group, sort, and total records.



Add to Portfolio (opens a new window)