Designing, Building, and Using Databases(Beginning MS Access)


You are here: [Designing, Building, and Using Databases(Beginning MS Access) Syllabus]

Printable Version

Designing, Building, and Using Databases(Beginning MS Access): Course Syllabus Spring 2018

Class 1: Saturday, January 20, 2018
  • Introduction to Relational Database Systems
  • Data Normalization and Integrity Rules
  • Introduction to MS Access
  • Table Design
  • Setting Up Relationships
Homework 1 Due Date/Time: Friday, January 26, 2018 (Noon)

Class 2: Saturday, January 27, 2018
  • Quiz 1(closed book)
  • Introduction to Queries
  • Select Queries
  • Advanced Select Queries
  • Parameter Queries
  • 1st Quiz (9:15am)
Homework 2 Due Date/Time: Friday, February 02, 2018 (Noon)

Class 3: Saturday, February 03, 2018
  • Quiz 2(closed book)
  • Total Queries
  • Crosstab Queries
  • Forms in MS Access
  • Main/Sub Form
  • Combo and Listbox Controls
  • 2nd Quiz (9:15am)
Homework 3 Due Date/Time: Friday, February 09, 2018 (Noon)

Class 4: Saturday, February 10, 2018
  • Quiz 3(closed book)
  • Introduction to Reports
  • Creating Reports using Wizards
  • Advanced Forms and Reports
  • Building Navigation Systems
  • User-Defined Data Formats
  • 3rd Quiz (9:15am)
Homework 4 Due Date/Time: Friday, February 23, 2018 (Noon)

Final Take-Home Exam Due Date/Time: Saturday, February 24, 2018 (before Class)
Class 5: Saturday, February 24, 2018
  • Quiz 4(closed book)
  • Introduction to Functions
  • MS Access Built-In Functions
  • Building a Simple Database Application
  • 4th Quiz(9:15am)
Grading:
Best 3 out of 4 Quizzes
Best 3 out of 4 Homework assignments
Weighting of Grades:
Quizzes: 50%
Homework 25%
Take-Home Final 25%