Course Outlines
University of Winnipeg Continuing Education
DIT 15547 Database Technologies Level 1: Intro to Databases with MS Access
|
Course: |
DIT 15547 Database Technologies Level 1: Intro to Databases with MS Access This course introduces the student to Microsoft Access. The course discusses what a database is and the components that are used within a database such as tables, queries, and data. |
|---|---|
|
Dates: |
|
|
Time: |
18:00 - 21:00 (12 hours total) |
|
Cost: |
$275 (Cost includes resource material which is provided at first class) |
|
Instructor: |
DIT 15547 0901 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: |
MasterTrak Standard Microsoft Office Access 2003 - Level Courseware 6256 ISBN 155332-042-5 |
|
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: |
University of Winnipeg
Division of Continuing Education Buhler Centre: 460 Portage Avenue (Google Map) Winnipeg, MB Canada R3C 0E8 Phone: (204) 982-6633 For more information, including floor plans and classroom locations, please visit the Location and Hours page on dce.UWinnipegCourses.ca. |
Learning Outcomes
- Knowledge of how to create a database in Microsoft Access
- Knowledge of how to create and modify tables in Microsoft Access
- Ability to manipulate data using the tools provided by Access
- Knowledge of how to create and modify queries
- Using the Wizards to create forms and reports
Prerequisites
The following or equivalent is required before taking this course:- General Understanding of information technology
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
There will be one in-class assignment distributed in the second or third period to confirm practical skills exercised in classroom demonstrations. Details of the assignment will be presented in class, discussed and clarified, and then students will complete the assignment individually.
Evaluation
- Quiz 1: 20%
- Quiz 2: 20 %
- In-class Assignment: 10%
- Notes: 10%
- Final Test: 40%
Topic Outline
- Database Terminology and Introduction to Access
- Creating and Modifying Tables
- Data Manipulation
- Simple Select Queries
- Table Relationships
- Forms and Reports
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.
Coming Soon:
- Feb 13
- ISSD 24 - XML
- Feb 21
- ISSD 23 - Web 2.0 Technology
- Feb 23
-
Facebook for Business
Hours: 2
Cost: Free!
- Feb 25
-
Search Engine Optimization (SEO)
Hours: 2
Cost: Free!
- Feb 25
-
Search Engine Marketing (SEM)
Hours: 2
Cost: Free!
- Mar 05
- ISSD 23 - Ajax
Course Outlines - University of Winnipeg Continuing Education - Database Administration Diploma - [ DIT 15547 Database Technologies Level 1: Intro to Databases with MS Access ] -
Description - Outcomes - Prerequisites -
