Maricopa Community Colleges  BPC217AM   20026-20045 
Official Course Description: MCCCD Approval: 06/25/02
BPC217AM 20026-20045 L+L 3 Credit(s) 4 Period(s)
Advanced Microsoft Access: Database Management
Basic database concepts including database design, primary and secondary key selection and relationships between tables. Queries, subforms, macros, events, Visual Basic modules and Access '97 Internet features also covered. Prerequisites: (BPC/CIS117DM or BPC/CIS117CM).
Cross-References: CIS217AM
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
BPC217AM   20026-20045 Advanced Microsoft Access: Database Management
1. Review the basics of database concepts: relational vs. flat database, database design techniques, relational database structure, and data retrieval. (I)
2. Identify primary keys, foreign keys, relationships between tables and referential integrity. (II)
3. Explain creating, deleting and adding relationships. (I, III)
4. Define creating relations and join in queries. (IV)
5. Differentiate between select queries and crosstab queries. (V)
6. Demonstrate creating action queries. (V)
7. Explain macros and events. (VI)
8. Apply Visual Basic modules. (VII)
9. Explain and demonstrate Internet features of Access. (VIII)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
BPC217AM   20026-20045 Advanced Microsoft Access: Database Management
    I. Databases
        A. Relational
        B. Flat
        C. Seven-step method for database design
        D. Database structure: relationships between tables
        E. Types of queries
        F. Using queries
      II. Keys
          A. Primary
            1. Creating
            2. Benefits
          B. Foreign
          C. Referential integrity
        III. Table Relationships
            A. Types
              1. One-to-one
              2. One-to many
              3. Many-to-one
              4. Many-to-many
            B. Creating relationships between tables
            C. Creating links between tables
            D. Existing relationships
              1. Adding
              2. Deleting
            E. Analyze tables
          IV. Tables and queries
              A. Adding more than one table
              B. Removing a table
              C. Adding fields from more than one table
              D. Limitiations of multiple-table queries
              E. Creating query joins
                1. Joining tables
                2. Deleting joins
              F. Table join types
                1. Inner
                2. Outer
              G. Join properties
            V. Queries
                A. Calculate totals
                B. Total Row options
                C. Total on all records
                D. Total query criteria
                E. Crosstab query
                  1. Concept
                  2. Creating
                F. Parameter query
                G. Action query
                  1. Types
                  2. Concept
                  3. Creating
                  4. Application
              VI. Macros and events
                  A. Purpose
                  B. How used
                  C. Creating
                  D. Adding multiple actions
                  E. Running
                  F. Troubleshooting
                VII. Visual Basic module
                    A. Definition
                    B. Basics
                    C. Use
                    D. Application
                  VIII. Internet Features
                      A. Web toolbar
                      B. Web Wizard
                      C. HTML template files
                      D. Creating a home page
                      E. Exporting to HTML format
                  Go to Description    Go to top of Competencies    Go to top of Outline