Title: Introduction to Database (TEMPLATE)

Syllabus
  Syllabus
Textbook
  Required Textbook
Course Schedule
  Course Schedule
Course Orientation
  Welcome Video
  Orientation Learning Objectives
  Read It
  SAM Tutorials
    Getting Started in SAM
    Accessing the SAM Reading
    Completing a SAM Project
    Taking a SAM Exam
    Completing a SAM Training
  Blackboard Tutorials
    Learn to Use Blackboard
  Student Information Sheet
  Self Introduction
  Orientation Quiz
Competency Modules
  Introduction
  Competency 1: Develop Database Models
    Introduction
    Learning Objectives
    Study and Practice It 1.1 - Data
      Read It
      Watch It: Introduction to Database
      Watch It: Database Systems Data
      Practice It 1.1
    Study and Practice It 1.2 - Data Models
      Read It
      Watch It: The Relational Model of Data Storage
      Practice It 1.2
    Study and Practice It 1.3 - Relational Database Models
      Read It
      Watch It: Database Tables, Primary Keys, Foreign Keys, and Relationships
      Practice It 1.3
    Study and Practice It 1.4 - Entity Relationship Modeling
      Read It
      Watch It: Entity Relationship Diagram (ERD)
      Practice It 1.4
    Study and Practice It 1.5 - Database Normalization
      Read It
      Watch It: Database Normalization
      Practice It 1.5
    Review for Assessment 1
      Topics to Review
    Competency 1 Multiple ChoiceAssessment
      Competency 1 MC Assessment
  Competency 2: Build Basic Database
    Introduction
    Competency 2.1 Build an Access Database
      Introduction
      Learning Objectives
      Read and Practice It
      Watch It - Access 2013: Create a Database
      Competency 2.1 Practical Assignment
      Competency 2.1 Quiz
    Competency 2.2 Create Objects in the Database
      Introduction
      Learning Objectives
      Read and Practice It
      Watch It - Access 2013: Create a Table
      Competency 2.2 Practical Assignment
      Competency 2.2 Quiz
    Competency 2.3 Maintain and Query a Database
      Introduction
      Learning Objectives
      Watch It - Access 2010: Repair and Maintain Database
      Read and Practice It
      Competency 2.3 Practical Assignment
      Competency 2.3 Quiz
    Competency 2.4 Create Forms and Reports
      Introduction
      Learning Objectives
      Read and Practice It
      Watch It - Access 2010: Form and Report Layouts
      Competency 2.4 Practical Assignment
      Competency 2.4 Quiz
    Review for Assessment 2
      Topics to Review
    Competency 2 Assessment
  Competency 3: Construct Advanced Database
    Introduction
    Competency 3.1 Create Advanced Queries and Enhance Table Design
      Introduction
      Learning Objectives
      Read and Practice It
      Watch It - Access 2013: Parameter Queries
      Competency 3.1 Practical Assignment
      Competency 3.1 Quiz
    Competency 3.2 Use Form Tools and Create Custom Forms
      Introduction
      Learning Objectives
      Read and Practice It
      Watch It - Using Form Tools (Access 2010/2013)
      Competency 3.2 Practical Assignment
      Competency 3.2 Quiz
    Competency 3.3 Create Custom Reports
      Introduction
      Learning Objectives
      Read and Practice It
      Watch It - Creating Custom Reports (Access 2010/2013)
      Competency 3.3 Practical Assignment
      Competency 3.3 Quiz
    Competency 3.4 Share, Integrate and Analyze Data
      Introduction
      Learning Objectives
      Read and Practice It
      Watch It - Publishing to a Web Browser (Access 2010/2013)
      Competency 3.4 Practical Assignment
      Competency 3.4 Quiz
    Review for Assessment 3
      Topics to Review
    Competency 3 Assessment
  Competency 4: Enhance User Interaction with Database
    Introduction
    Competency 4.1 Use Action Queries and Advanced Table Relationships
      Introduction
      Learning Objectives
      Read and Practice It
      Watch It - Access 2013: Update Queries
      Competency 4.1 Practical Assignment
      Competency 4.1 Quiz
    Competency 4.2 Automate Tasks with Macros
      Introduction
      Learning Objectives
      Read and Practice It
      Watch It - Access 2013: Create Macros
      Competency 4.2 Practical Assignment
      Competency 4.2 Quiz
    Competency 4.3 Use and Write VBA Code
      Introduction
      Learning Objectives
      Read and Practice It
      Watch It - Access 2013: Create VBA Code
      Competency 4.3 Practical Assignment
      Competency 4.3 Quiz
    Competency 4.4 Manage and Secure a Database
      Introduction
      Learning Objectives
      Read and Practice It
      Watch It - Access 2013: Split a Database
      Competency 4.4 Practical Assignment
      Competency 4.4 Quiz
    Review for Assessment 4
      Topics to Review
    Competency 4 Assessment
  Capstone Competency
    Capstone Project Part 1
    Capstone Project Part 2
    Capstone Project Part 3
Course Disclaimers
  U. S. Department of Labor Disclaimer
  Creative Commons License