powered by
Center for Curriculum and Transfer Articulation
Database Management: Microsoft Access - Level II
Course: CIS117BM

First Term: 2012 Spring
 Lec + Lab   1 Credit(s)   2 Period(s)   1.7 Load  
Subject Type: Occupational
Load Formula: S


Description: Exploration of additional components of the Microsoft Access database management program



MCCCD Official Course Competencies
1. Use a full complement of additional database commands and selection tools. (I)
2. Access multiple files simultaneously (as supported by specific database software.) (II)
3. Compose varied numerical, character, data, and logical expressions. (III)
4. Present database files and their records in various organized ways (alphabetic, numerical, by date, etc.) (IV)
MCCCD Official Course Competencies must be coordinated with the content outline so that each major point in the outline serves one or more competencies. MCCCD faculty retains authority in determining the pedagogical approach, methodology, content sequencing, and assessment metrics for student work. Please see individual course syllabi for additional information, including specific course requirements.
 
MCCCD Official Course Outline
I. Additional commands and selections
II. Accessing multiple files
III. Creating varied expressions
   A. Mathematical computations
   B. String manipulation
   C. Dates and their uses
   D. Logical operators
   E. Sums, averages, counts, and other statistics
   F. Functions
IV. Reordering the database
   A. Permanent reorganization (sorting, etc.)
   B. Indexing
      1. Simple indexes
      2. Compound indexes
   C. Filtering
 
MCCCD Governing Board Approval Date:  10/22/1991

All information published is subject to change without notice. Every effort has been made to ensure the accuracy of information presented, but based on the dynamic nature of the curricular process, course and program information is subject to change in order to reflect the most current information available.