Maricopa Community Colleges  BPC107BC   19926-19956 
Official Course Description: MCCCD Approval: 12/12/95
BPC107BC 19926-19956 LEC 0.50 Credit(s) 0.50 Period(s)
Using Smart DataBase: Level II
Use of Smart DataBase commands to manipulate data files, generate dataentry screens, generate complex reports with multiple level totals, transport data between a computer database program and other programs. Creation and use of command files. Prerequisites: BPC107AC or permission of instructor.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC107BC   19926-19956 Using Smart DataBase: Level II
1. Generate data entry form screens. (I)
2. Generate multiple level reports. (II)
3. Create memory variables to store data. (III)
4. Update multiple files. (IV)
5. Perform file copying and deleting commands. (V)
6. Create command files. (VI)
7. Use logical structures in command files. (VII)
8. Integrate data to and from other programs. (VIII)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
BPC107BC   19926-19956 Using Smart DataBase: Level II
    I. Generate Data Entry Form Screens
        A. Design data entry forms
        B. Create data entry forms
        C. Enter data
      II. Generate Multiple Level Reports
          A. Create report layouts with multiple level totals
          B. Index a data file
          C. Run reports with multiple control levels
        III. Create Memory Variables to Store Data
            A. Store data from records to memory variables
            B. Replace data in records from memory variables
          IV. Update Multiple Files
              A. Create new file structure from existing files
              B. Add data to the new file
              C. Join two file structures
              D. Update from one file to another
            V. Perform File Copying and Deleting Commands
                A. Backup file with same or different name
                B. Delete files
              VI. Create Command Files
                  A. Create a DO program file
                  B. Execute program file
                  C. Edit program file
                VII. Use Logical Structure in Command File
                    A. Repeat commands using DO WHILE
                    B. Structuring IF's
                  VIII. Integrate Data To and From Other Programs
                      A. Copy data to ASCII files
                      B. Copy data from ASCII files
                  Go to Description    Go to top of Competencies    Go to top of Outline