Maricopa Community Colleges  BPC106AA   19886-19925 
Official Course Description: MCCCD Approval: 06/03/86
BPC106AA 19886-19925 LEC 0.50 Credit(s) 0.50 Period(s)
Beginning dBase II/III
Use of dBase II or dBase III to create, edit and selectively report data. Prerequisites: None.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC106AA   19886-19925 Beginning dBase II/III
1. Design and create a data file.
2. Locate, insert, delete, edit and view records in a data file.
3. View all or selected portions of a data file.
4. Reorganize data file.
5. Modify viewing and editing commands with the use of string and numeric functions.
6. Set devices and parameter defaults.
7. Generate report forms from data files.
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
BPC106AA   19886-19925 Beginning dBase II/III
    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 throught 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 form 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 on/off
                VII. Generage 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