Course Overview
Introduces databases, terminology and an overview of various database models. Topics include relational database design, cardinality, normalization, structured query language (SQL), and customization using VBA. Examples will be GIS-based and use Microsoft Access.
Prerequisite(s)
- 50% in GIST 5001† († may be taken concurrently)
Credits
3.0
- Retired
- This course has been retired and is no longer offered. Find other Flexible Learning courses that may interest you.
Learning Outcomes
Upon successful completion, the student should be able to:
- Navigate the Microsoft Access 2002 graphical user interface.
- Import and export various data formats into and out of Microsoft Access.
- Normalize data into the first, second and third normal forms.
- Compare the hierarchically, network and relational database models.
- Create database queries using the Structure Query Language (SQL).
- Create programs using visual basic for applications (VBA).
- Create VBA programs that integrate Data Access Objects (DAO).
- Create VBA programs that integrate Active Data Objects (ADO).
- Create VBA programs that integrate Extended Active Data Objects (ADOX).
- Create Microsoft Access forms with sub-forms.
Effective as of Fall 2003
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.