Official Course
Description: MCCCD Approval: 10-22-1991 |
|||||
BPC117AM
1993 Fall – 2011 Fall |
L+L
1.0 Credit(s) 2.0 Period(s) 1.7 Load Occ |
||||
Database
Management: Microsoft Access - Level I |
|||||
Introduction to the basic elements of a current version of
the Microsoft Access database management program, for casual and beginning
users. Prerequisites: None. |
|||||
Cross-References:
CIS117AM
|
|||||
Go to Competencies Go to Outline
MCCCD
Official Course Competencies: |
|
|
|
BPC117AM 1993
Fall – 2011 Fall |
Database Management: Microsoft Access - Level I |
1.
|
Place database programs within the larger context of
recent computer history. (I) |
2.
|
Identify the various types of database management
programs. (I) |
3.
|
Describe the main features, advantages, and limitations of
this specific database program. (II) |
4.
|
Operate the database program and the microcomputer on
which it runs, at an elementary level. (III) |
5.
|
Create database files. (IV) |
6.
|
Add, delete, and alter records within the database files.
(IV) |
7.
|
Retrieve information for screen display and printing. (V) |
Go to Description Go to top of
Competencies
MCCCD
Official Course Outline: |
|
|
|
BPC117AM 1993
Fall – 2011 Fall |
Database Management: Microsoft Access - Level I |
I. Brief introduction to
history and theory of databases A. History of databases and
file management B. Survey of database types
II. Overview of the
specific database being studied A. Main features 1. Files 2. Fields 3. Records 4. Reports 5. Indexes 6. Other unique components
special to this software (memos, catalogs, etc.) B. Advantages and
limitations 1. Capacity 2. User-friendly aids and
shortcuts 3. Frequent problems and disadvantages
III. Running the specific
database program A. Database environment
(keyboard, function keys, screen, etc.) B. Launching and quitting
the program C. Issuing commands and
making menu selections IV. Creation of simple
database files A. Making elementary file
structures B. Filling the file with
appropriate data C. Changing the file 1. Altering the file's
structure 2. Changing, deleting, and
adding records V. Information retrieval A. Retrieving files,
records, and fields 1. Global and selective
retrieval 2. Elementary query methods
B. Viewing and printing the
results 1. Browsing, displaying,
listing data on the screen 2. Sending organized data
to a variety of printers |