| Course Name |
Introduction to Databases (CMPT 110) |
| Course Description |
This course introduces students to the basics of using a database to store data. Microsoft Access is used as the interface to access the database. The course mainly introduces the main concepts of database management and using access, but also takes a brief look at some more advanced concepts like SQL. |
| Artifact Description |
This artifact is the final project of the course. For the project, we needed to create a database that contained the following:
- At least 2 tables
- At least 2 forms
- At least 2 reports
- A switchboard (menu) to access each element of the database
- At least one relationship between 2 fields in different tables
|
| Assignment Grade |
A |
| Course Grade |
A |
| Course Reflection |
Prior to taking this course, I had taken a Computer Applications course in high school which covered Microsoft Office 2000 (including Access). The year before I also took CMPT 101, an intoduction to Microsoft Office 2007 which did not cover Access. While I had seen most of the things learned in the course before, they were things that I had rarely used so I felt like I was learning them for the first time. I don't know how helpful the Access-specific concepts will be, because I don't think many companies use Access to store their databases. However, the fundamentals of designing and maintaining the database are very important and apply to any database regardless of the software, and I feel that that is an important skill. |
| Assignment |
CMPT 110 Final Project
|