The tutorial example program, DaoEnrol, manages a student registration database similar to, but simpler than, a college registration system. It will help you to follow the tutorial if you understand the structure of the student registration database.
DaoEnrol is based on the same student registration database, StdReg32.mdb, that you use with the Enroll tutorial. However, it is not necessary to register this data source with the ODBC Administrator to use it with the DAO database classes in the DaoEnrol tutorial.
The following table lists the database tables, what they store, and the columns in them.
Tables in the Student Registration Database
Table name | Contents | Column list |
Course | Think of each record as an entry in a course catalog. Example: the MATH101 course. | CourseID* CourseTitle Hours |
Section† | A section record is a specific offering of a course at a specific time. For example, MATH101 may have many sections. | SectionNo* CourseID* InstructorID Schedule RoomNo |
Student | A record for each student at the school. | StudentID* Name GradYear |
Enrollment | A record for each student in a particular section of a course. For a given student, there is an Enrollment record for each course the student is taking. | CourseID* SectionNo* StudentID* Grade |
Instructor | A record for each instructor at the school. | InstructorID* Name RoomNo |
* Indicates the column (or columns) that comprise the table’s primary key.
† The Dynabind_Section table is used in the Dynabind sample, but not in the DaoEnrol tutorial.
DaoEnrol lets you use a “form” — a view with dialog-style controls — to view registration information for courses, section by section. Section information displayed includes the course name, section number, instructor, room, and schedule (such as “MWF 10-11”). For example, you can view section 1 of the course MATH 101, then section 2, and so on. The initial tutorial step provides read-only viewing of all sections. Steps 2 and 3 add more capabilities, including updates. The following figure shows what the DaoEnrol application looks like at the end of the tutorial.
The Completed DaoEnrol Tutorial Application