Maricopa Community Colleges  BPC107AC   19926-19956 
Official Course Description: MCCCD Approval: 12/12/95
BPC107AC 19926-19956 LEC 0.50 Credit(s) 0.50 Period(s)
Using Smart Database: Level I
Use of Smart Database to create, edit and selectively report data. Prerequisites: None.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC107AC   19926-19956 Using Smart Database: Level I
1. Design and create a data file. (I)
2. Locate, insert, delete, edit and view records in a data file. (II)
3. View all or selected portions of a data file. (III)
4. Reorganize a data file. (IV)
5. Modify viewing and editing commands with the use of string and numeric functions. (V)
6. Set devices and parameter defaults. (VI)
7. Generate report forms from data files. (VII)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
BPC107AC   19926-19956 Using Smart Database: Level I
    I. Design and Create a Data File
        A. Plan field names, data types and data width for records
        B. Create file structures
        C. Modify file structures
        D. Enter data records
      II. Locate, Insert, Delete, Edit, Replace and View Records in a Data File
          A. Edit and browse through file
          B. Delete error records
          C. Insert missing records
          D. Recall incorrectly deleted records
          E. Replace or change data in fields
          F. List or display records in data file for viewing
        III. View All or Selected Portions of a Data File
            A. List all records
            B. List records meeting criteria
            C. List selected number of records
          IV. Reorganize the Data File
              A. Create index files to sort data
              B. List data files using indexes
              C. Locate records in an indexed file using the find command
            V. Modify Viewing and Editing Commands With the Use of String and Numeric Functions
                A. List records using the search function
                B. List partial data from fields using the string functions
              VI. Set Devices and Parameter Defaults
                  A. Set the printer to echo commands and displays
                  B. Set indexes to active status
                  C. Set devices to on/off
                VII. Generate Report Forms from Data Files
                    A. Create a report layout
                    B. Modify report layout
                    C. Retrieve report layout
                    D. Run a report layout
                Go to Description    Go to top of Competencies    Go to top of Outline