Course Outlines
University of Winnipeg Continuing Education
DIT 15549 Database Technologies Level 3: Application Development with MS Access
|
Course: |
DIT 15549 0701 Database Technologies Level 3: Application Development with MS Access
|
|---|---|
|
Dates: |
|
|
Time: |
18:00 - 21:00 (18 hours total) |
|
Cost: |
$380 |
|
Instructor: |
Steve Jurkowski holds a computer engineering degree from the University of Manitoba, and an Internet Systems Specialist Diploma at the University of Winnipeg Division of Continuing Education. He has over 10 years programming experience in various structured, object-oriented, and web scripting languages in an assortment of environments. Steve has previously instructed student pilots in the air and in the classroom. He is currently employed as a Web Developer at a marketing firm in Winnipeg. |
|
Materials: |
A text book will be required: New Perspectives on Microsoft Access 2000 Comprehensive/Enhanced, by Adamski, Hommel and Finnegan, published by Course Technologies Students should read chapter 1 of the notes before starting the first class. Optional book resources are here. Optional online resources: |
|
Related Jobs: |
Monster.ca job search. |
|
Additional Information: |
|
|
Register Now: |
Seating is limited. Call The University of Winnipeg Continuing Education Front Desk to register: (204) 982-6633. |
|
Location and Hours: |
Classes for Information Technology are at Main Campus, 480 Ellice Avenue on the 2nd floor of Lockhart Hall (rooms 2L13A & 2L13B) and the 3rd floor of Manitoba Hall (room 3M58). Proceed to room 2L13 in Lockhart Hall to find out which room your class will be in. Stevi Dram's office is on the 2nd floor, Lockhart Hall: 2L13C The DCE Registration Office is located at 275 Portage Avenue on the 14th floor. Their phone number is (204) 982-6633. Registration Office Hours:
Lost? Here is a map of Main Campus showing Lockhart Hall and Manitoba Hall. |
|
DCE IT Twitter Updates |
Follow uwinnipegDCE_IT on Twitter... |
|
DCE Delicious Bookmarks |
|
|
DCE Facebook Page |
Follow University of Winnipeg Division of Continuing Education on Facebook... |
Learning Outcomes
Specific skills learned in this course:
- Customizing reports
- Designing and creating custom reports
- Adding subreports to reports
- Using domain aggregate functions in a report
- Exporting tables as HTML documents
- Creating and modifying data access pages
- Importing and exporting XML files
- Creating PivotTables and PivotCharts
- Creating action queries
- Defining relationships
- Joining a table using a self-join
- Running and adding actions to macros
- Creating a macro group
- Using Switchboard Manager to create a switchboard
Prerequisites
The following may be required before taking this course:
Application Programming Technologies
- 15969 Programming Technologies Level 1.1: Introduction to Programming
-
This is intended for use as an introduction to programming concepts for students who have no prior experience. It is required knowledge for several other topics, such as JavaScript, PERL, PHP, Visual Basic, Java and more. While code examples for several different languages will be shown, this course is language-neutral, and can be used as a basis of learning many different programming languages.
- Learn more about the Programming Technologies Level 1.1: Introduction to Programming course.
Course Format
This course follows a lecture format. During class time, we will present material, draw your attention to key points that you should pay attention to, answer questions you may have, and manage class discussions, demonstrations, and hands-on exercises.
There are often daily quizzes or assignments. It is the responsibility of the student to be on time and to get copies of any assignments missed due to absence. Missed quizzes cannot be made up later.
Students are strongly advised to use the reference material. For every hour of class time the student should budget at least two hours of self study to cover all the material in this course.
Only material that is covered in class lectures will be testable.
Student Deliverables and Pace
- To be announced.
Evaluation
During the course, each student will complete two assignments for a total of 60% of the total mark (breakdown of marks is below):
- Assignment #1: 30% of total mark
- Assignment #2: 30% of total mark
- There will be a final test, worth 40% of the total mark, on the last class
Grades:
Letter Graded Courses:
A+ = 96 - 100% Outstanding A = 91 - 95% A- = 83 - 90% Very Good B+ = 75 - 82% B = 70 - 74% Average C+ = 66 - 69% C = 57 - 65% Pass D = 50 - 56% F = Failure VW = Voluntary Withdrawal
Pass/Fail Courses:
P = Pass F = Failure I = Incomplete VW = Voluntary Withdrawal
Audited Courses:
CP = Certificate of Participation (based on >75% attendance) NCP = No Certificate of Participation (based on <75% attendance)
Note: Final percentages containing a half-point will be rounded up to the next full point (e.g., 69.5 would be rounded up to 70), and then converted to the letter grade (i.e., from C+ to B).
Late Assignments
Unless otherwise stated, late assignments are penalized 10% per calendar day. No assignments will be accepted more than 2 days late without permission.
Quizzes
Quizzes may be given during classes and could be time limited. They may be fill in the blank, short answer, code, or multiple choice and may be given online, verbally, or on paper. Missed quizzes cannot be made up if absent or if you are late for class.
Attendance
While class attendance may not be taken for marks, your attendance is required for each class to participate in quizzes, homework, and assignments.
Considerations
Please consider turning off any cell phones and pagers while in lectures or seminars. If you need to be available (on call for work, for example) please set your cell/pager to vibrate. Also, please remember that checking email, typing instant messages, or surfing the Web may be distracting to others.
A Statement on Plagiarism and Cheating
The Modern Language Association Handbook for Writers of Research Papers defines plagiarism as:
the act of using another person's ideas or expressions in your writing without acknowledging the source.
Copying words or ideas from any source, including another student, constitutes academic 'theft', and may result in loss of marks for the assignment, loss of marks for the entire course, or even expulsion. The same penalties will result if a student is found guilty of cheating or contributing to cheating on any test, exam or assignment.
Students should familiarize themselves with University of Winnipeg policy concerning plagiarism and academic honesty.
Other Plagiarism Resources
More Information
Here are links to more information that you may find helpful:
- Winnipeg Transit
- The Winnipeg Transit site includes links for fares, the free Downtown Spirit service, schedules and more.
- Exchange District BIZ
- The Winnipeg Exchange District BIZ site has maps and information about the area around our campus.
- Downtown Winnipeg BIZ
- The Downtown Winnipeg BIZ site includes links for parking, restaurants, and the BIZ Patrol.
Notice
The contents of this page are given as a guideline only and are subject to change.
Course Outlines - University of Winnipeg Continuing Education - Database Administration Diploma - [ DIT 15549 Database Technologies Level 3: Application Development with MS Access ] -
Description - Outcomes - Prerequisites -
