Technology Tutorials

The purpose of the the technogogy tutorials is to give you some hands-on experience with a number of core business technologies, such as databases, visual programming languages, OLAP tools, and web applications. Please contact Michael Brydon (mjbrydon@sfu.ca) if you have any difficulty accessing the tutorials.

Links to individual lessons are provided below. The support files required to complete the tutorials can be found near the bottom of this page.

Stand-alone lessons

Topic	Background and theory	Core lessons	Advanced material
Background	1. Preface
	2. Scenario
	3. Data modeling
Transaction processing systems		4. Introduction to Access
		5. Tables
		6. Foreign keys
		7. Relationships
		8. Importing and linking
			9. ODBC
		10. Basic QBE
		11. Calculated fields
		12. Basic SQL
		13. Forms
		14. Subforms
		15. Bound controls
		16. Parameter queries
		17. Action queries
		18. Visual Basic
		19. Event-driven programming
			20. Shipments
			21. Backorders
Decision support systems		22. Data warehousing
Decision support systems		23. OLAP
Electronic commerce		24. HTML
		25. HTML forms
		26. Server-side scripting
		27. Sessions
		28. ADO
		29. Business objects
	*** Topics with a grey background are not required for Bus 756

Printer-friendly version

printable version (> 460 pages; > 4 MB)

Assignment package

download the entire package
- package.zip
or just selected parts:
- list of orders (orders.pdf)
- list of backorders and shipments (backship.pdf) **not required for Bus 756
- the database for your web-based system (OrderEntryWeb.mdb)
- full installation package for OrderObjects