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 Summer 2018

Currently no courses scheduled for this term.

Class 1

  • Introduction to Relational Database Systems
  • Data Normalization and Integrity Rules
  • Introduction to MS Access
  • Table Design
  • Setting Up Relationships

Class 2

  • Introduction to Queries
  • Select Queries
  • Advanced Select Queries
  • Parameter Queries
  • 1st Quiz (9:15am)

Class 3

  • Total Queries
  • Crosstab Queries
  • Forms in MS Access
  • Main/Sub Form
  • Combo and Listbox Controls
  • 2nd Quiz (9:15am)

Class 4

  • Introduction to Reports
  • Creating Reports using Wizards
  • Advanced Forms and Reports
  • Building Navigation Systems
  • User-Defined Data Formats
  • 3rd Quiz (9:15am)

Class 5

  • Introduction to Functions
  • MS Access Built-In Functions
  • Building a Simple Database Application
  • 4th Quiz(9:15am)