Maricopa Community Colleges  BPC217AA   19886-19925 
Official Course Description: MCCCD Approval: 05/12/87
BPC217AA 19886-19925 L+L 3 Credit(s) 4 Period(s)
Advanced Micro-Database Management: dBase III
Advanced topics in micro-database management including a combination of advanced programming techniques, complex business applications, and finished system applications compiling, utilizing one or more dBase III compilers. Prerequisites: BPC/CIS 117 or instructor approval.
Cross-References: CIS217AA
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC217AA   19886-19925 Advanced Micro-Database Management: dBase III
1. Write appropriate program documentation. (I)
2. Apply efficient coding skills. (II)
3. Write application modules using structured programming. (III)
4. Identify standards for and create PROCEDURE files. (IV)
5. Utilize advanced and rare commands. (V)
6. Utilize hardware and software configurations. (VI)
7. Compile a turnkey system. (VII)
8. Create an integrated system using import and export data. (VIII)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
BPC217AA   19886-19925 Advanced Micro-Database Management: dBase III
    I. Compact code writing
        A. Blocking style
        B. Self documenting variable requirement
      II. Basic coding
          A. Flowchart and pseudo-code techniques
          B. Coding from pseudo-code
          C. Subroutine and linking functions
          D. Input screens
          E. Random and sequential access
        III. Module coding
            A. Structured programming
            B. Subroutine combining
            C. Library building
          IV. PROCEDURE files
              A. PROCEDURE file standards and creation
              B. PROCEDURE file features
            V. Advanced and rare commands
                A. POKE and PEEK
                B. STRING in place of LOGICAL
                C. SEEK and FIND
                D. RANGE delimiter
              VI. Hardware and software considerations
                  A. CONFIG.SYS file
                  B. AUTOEXEC.BAT file
                  C. BATch files
                  D. CONFIG.DB file
                VII. Turnkey systems
                    A. Compiling
                    B. Documenting
                  VIII. Data importing and exporting
                      A. Wordprocessing/mailmerge module template
                      B. Tracking template
                  Go to Description    Go to top of Competencies    Go to top of Outline