powered by
Center for Curriculum and Transfer Articulation
Microsoft Access: Database Management
Course: CIS117DM

First Term: 2021 Spring
 Lec + Lab   3.0 Credit(s)   4.0 Period(s)   4.0 Load  
Subject Type: Occupational
Load Formula: T - Lab Load


Description: Introduction to Microsoft Access. Emphasis on features, design, and database management.



MCCCD Official Course Competencies
1. Identify the purposes of various types of databases. (I)
2. Describe the main features, advantages, and limitations of Microsoft Access. (I, II)
3. Operate Microsoft Access at an introductory level. (II-X)
4. Apply normalization processes to database design. (III)
5. Create databases and database objects. (IV-X)
6. Manipulate data within database objects. (IV-X)
7. Retrieve data for reporting and analysis. (VIII)
8. Use various operators and functions in expressions. (IV, V)
9. Organize database records. (V-X)
10. Develop solutions for common data management problems. (III, VI, IX)
MCCCD Official Course Competencies must be coordinated with the content outline so that each major point in the outline serves one or more competencies. MCCCD faculty retains authority in determining the pedagogical approach, methodology, content sequencing, and assessment metrics for student work. Please see individual course syllabi for additional information, including specific course requirements.
 
MCCCD Official Course Outline
I. Purposes of databases
   A. History of databases
   B. Applicability of common relational and non-relational databases
      1. Current database applications
      2. Emerging database applications
   C. Scalability of databases: Advantages and limitations
      1. Cost - deployability
      2. Capacity
      3. Common problems
II. Microsoft Access features
   A. Starting/exiting the program
   B. Microsoft Access interface
      1. Screen layout
      2. Keyboard functions
      3. Object views
III. Introduction to database design
   A. Data relationships
      1. One to one
      2. One to many
      3. Many to many
   B. Entity relationship diagrams
   C. Integrity constraints
      1. Entity integrity (Primary Key)
      2. Referential integrity (Foreign Key)
      3. Domain integrity
   D. Insert, update, and delete anomalies
   E. Functional and partial dependencies
   F. Requirements of first, second, and third normal forms
IV. Database file management
   A. Backup
   B. Copy
   C. Import
   D. Export
V. Tables
   A. Views
      1. Datasheet
      2. Design
   B. Record maintenance
   C. Fields
      1. Data types
      2. Properties
   D. Properties
   E. Sort
   F. Filter
   G. Relationships
   H. Creating table indexes
VI. Queries
   A. Views
      1. Datasheet
      2. Design
      3. SQL
   B. Criteria
   C. Operators and functions
      1. Mathematical computations
      2. String manipulations
      3. Dates and their uses
      4. Comparison operators
      5. Logical operators
      6. Aggregate functions
      7. Built-in functions
   D. Select
      1. Join
      2. Crosstab
      3. Totals
   E. Action
      1. Update
      2. Delete
      3. Insert
   F. Specialized queries
      1. Find unmatched query
      2. Find duplicates query
VII. Forms
   A. Views
      1. Form
      2. Layout
      3. Design
   B. Basic design
   C. Controls and properties
VIII. Reports
   A. Views
      1. Report
      2. Layout
      3. Design
      4. Print preview
   B. Basic design
   C. Reporting techniques
      1. Group
      2. Sort
      3. Total
IX. Macros
   A. Stand-alone
   B. Embedded
   C. Data macros
X. Modules
   A. Class
   B. Standard
 
MCCCD Governing Board Approval Date: November 24, 2020

All information published is subject to change without notice. Every effort has been made to ensure the accuracy of information presented, but based on the dynamic nature of the curricular process, course and program information is subject to change in order to reflect the most current information available.