Maricopa Community Colleges  BPC107CH   19996-20012 
Official Course Description:   MCCCD Approval:  05/25/99
BPC107CH     19996-20012 LEC 0.50 Credit(s) 0.50 Period(s)
Using ACCESS: Level III
Use of ACCESS features and commands to analyze data by creating complex queries, eliminate repetitive tasks by creating macros, and work with ACCESS on the Internet. Prerequisites: BPC107BH or permission of instructor.
 
 Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC107CH   19996-20012 Using ACCESS: Level III
1. Identify types of queries and their functions. (I)
2. Create various queries. (I)
3. Describe form design enhancements and the process of building a form. (II)
4. Create functional forms and automate tasks by creating macros. (II)
5. Identify and use various report techniques. (III)
6. Create links to Internet sites using ACCESS. (IV)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
BPC107CH   19996-20012 Using ACCESS: Level III
    I. Queries
        A. Parameter
        B. Action
        C. Outer Join
        D. Crosstab
        E. Datasheets
      II. Form Design Enhancements
          A. Building a Form
          B. Functions
          C. Option Groups
          D. Additional Enhancements
          E. Command Buttons
          F. Macros
        III. Report Techniques
            A. Duplicate Data
            B. Grouping Data
            C. Using Functions in Reports
          IV. Internet and ACCESS
              A. Hyperlinks
              B. HTML
          Go to Description    Go to top of Competencies    Go to top of Outline