Maricopa Community Colleges  BPC117BJ   19916-19992 
Official Course Description:   MCCCD Approval:  12/08/98  
BPC117BJ     19916-19992 L+L 1 Credit(s) 1 Period(s)
DATABASE MANAGEMENT: FileMaker Pro - LEVEL II
Exploration of additional components of the FileMaker Pro database management program. Prerequisites: BPC117AJ or CIS117AJ or permission of instructor.
Cross-References:   CIS117BJ
 
 Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC117BJ   19916-19992 DATABASE MANAGEMENT: FileMaker Pro - 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:
 
BPC117BJ   19916-19992 DATABASE MANAGEMENT: FileMaker Pro - 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
          Go to Description    Go to top of Competencies    Go to top of Outline