Course Outlines

University of Winnipeg Continuing Education

DIT 15548 Database Technologies Level 2: Multi-Table Access Databases

Course:	DIT 15548 Database Technologies Level 2: Multi-Table Access Databases This course demonstrate how to enhance database design, create more advanced tables and use forms and reports.
Dates:	DIT 15548 0901: 2009 Sep 22 - 2009 Oct 8 6 Classes (Tue/Thu)
Time:	18:00 - 21:00 (18 Hours)
Cost:	$380
Instructor:	DIT 15548 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.
Resources:	New Perspectives on Microsoft Office Access 2003 Paperback: 792 pages Publisher: Course Technology; 2 edition (Feb 14 2005) Language: English ISBN-10: 0619268115 ISBN-13: 978-0619268114
Related Jobs:	Monster.ca job search.
Additional Information:	UWinnipeg DCE-IT Part-Time MS Access Facebook page The University of Winnipeg Continuing Education web site. The DCE.UWinnipegCourses.ca web site. The UWinnipeg.ca web site. The UWinnipeg WebAdvisor. While not required, it is a good idea to bring a portable USB flash drive or other storage media for your files. Some instructors may ask you to email assignments as attachments. There are many free compression (zip/archive) programs available, including "7-Zip" (Windows) and "Zip Mac Files For PC" (Macintosh).
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: Monday through Thursday: 8:30 a.m. to 7:00 p.m. Fridays 8:30 a.m. to 4:30 p.m. Saturdays 9:00 a.m. to 1:00 p.m. Offices closed on Saturday of long weekends. Lost? Here is a map of Main Campus showing Lockhart Hall and Manitoba Hall. If you're driving, you may also find the traffic map and the parking map useful.
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:

creating and running multiple table queries using both inner and outer joins
creation of relations between tables and enforcing referential integrity in those relations
using advanced data bound controls on forms and reports
inserting graphics into forms and reports
inserting calculated fields into queries, and calculated controls onto forms and reports
insertion of 'lookups' into table field definitions
creating and inserting subforms into forms
setting up groupings into reports
creating parameter queries
using multiple And/Or criteria in queries
setting up aggregate (summary) functions

Prerequisites

The following or equivalent is required before taking this course:

Database Administration Diploma

DIT 15547 Database Technologies Level 1: Introduction 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.

Learn more about the Database Technologies Level 1: Introduction to Databases with MS Access 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

There will be three assignments, each due at the class following the one assigned. Some class time will be allotted to working on the assignments with some guidance.

Evaluation

Quiz #1: 10%
Quiz #2: 10%
Assignment #1: 20%
Assignment #2: 20%
Assignment #3: 20%
Final test (last class): 20%

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 15548 Database Technologies Level 2: Multi-Table Access Databases ] -
Description - Outcomes - Prerequisites -