|
Official Course
Description: MCCCD Approval: 10-22-1991 |
|||||
|
CIS117BM
1993 Fall – 2011 Fall |
L+L 1.0 Credit(s) 2.0 Period(s) 1.7 Load Occ |
||||
|
Database
Management: Microsoft Access - Level II |
|||||
|
Exploration
of additional components of the Microsoft Access database management program.
Prerequisites: BPC/CIS117AM or permission
of Instructor. |
|||||
|
Cross-References:
BPC117BM
|
|||||
Go to Competencies Go to Outline
|
MCCCD
Official Course Competencies: |
|
|
|
|
|
CIS117BM 1993
Fall – 2011 Fall |
Database Management: Microsoft Access - Level II |
|
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) |
Go to Description Go to top of
Competencies
|
MCCCD
Official Course Outline: |
|
|
|
|
|
CIS117BM 1993
Fall – 2011 Fall |
Database Management: Microsoft Access - Level II |
|
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 |