|
Official Course
Description: MCCCD Approval: 12/09/03 |
|||||
|
CIS217AM
2004 Fall – 2011 Summer II |
L+L 3.0 Credit(s) 4.0 Period(s) 3.7 Load Occ |
||||
|
Advanced
Microsoft Access: Database Management |
|||||
|
Advanced database concepts including database design,
primary and secondary key selection and relationships between tables.
Queries, sub forms, macros, events, Visual Basic modules and Access Internet
features also covered. Prerequisites: (BPC/CIS117DM or BPC/CIS117CM).
|
|||||
|
Cross-References:
BPC217AM
|
|||||
Go to Competencies Go to Outline
|
MCCCD
Official Course Competencies: |
|
|
|
|
|
CIS217AM 2004
Fall – 2011 Summer II |
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: |
|
|
|
|
|
CIS217AM 2004
Fall – 2011 Summer II |
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. Limitations 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
|