Lecture notes

This page is a collection of the visuals used in Poynor's MIS 333k lectures. Some students find it helpful to print out selected documents before lectures on the same topics and use the pages to take notes on. Because the notes are updated frequently, postpone printing until a day or two before the scheduled lecture. New lecture notes are added to this page occasionally. The lectures are not in strict chapter sequence.

  • N-tier analysis
  • Overview Access2002. An MIS steering committee meets at least once yearly to reiview our MIS curriculum coverage. Committee members are MIS graduauates, current students and the present faculty. This analysis shows the view from 30,000 feet.
  • Database design
  • dB Review Access2002. Fundamentals of dB design: normalization. Covered on first test. This is a review of MIS325.
  • Application design
  • Planning Access2002. Documentation that defines the project objectives should guide all software projects. Reprogramming is usually 50 times more expensive that original programming. It pays to plan and document.
  • Introduction to IDE
  • Chapter 2 Access2002. Introduction to the VBA Integrated Development Environment (IDE). You will be spending a lot of time here.
  • VBA Events
  • Chapter 2 Access2002. Learning to use events is very important to your VBA skills, and events are a major part of all our assignments.
  • Scope and Procedures
  • Chapters 7-9 Access2002. Introduction to procedures, modules and the variables in them. This is very basic information for the remainder of the course. Includes tips on Assignment 2 modules.
  • Control structures
  • Chapters 7-9 Access2002. Loops, arrays, If controls, case, and string functions.
  • Errors and debugging tips
  • Chapter 10 Access2002. This will be covered (and tested) early in the course because deadbugging skills help you learn new programming languages much faster.
  • Advanced programming
  • Chapter 7-10 Access2002. Parts of this chapter will be covered (and tested) earlier than you might think by the chapter number.
  • Recordset programming
  • Chapters 6,11 Access2002. This topic is one of the most important in the course. It will appear again in our Web database work. Check here for further recordset information.

    Return to MIS 333k Syllabus