Maricopa Community Colleges  BPC107BH   19952-20012 
Official Course Description:   MCCCD Approval:  10/22/91
BPC107BH     19952-20012 LEC 0.50 Credit(s) 0.50 Period(s)
Using Access: Level II
Use of Access commands to manipulate data files, generate data entry 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: BPC107AH or permission of instructor.
 
 Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC107BH   19952-20012 Using Access: 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:
 
BPC107BH   19952-20012 Using Access: 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