Transcript Course outline

Welcome to Database Application
Development Course
Sept. 2007
91.3902/3
Yangjun Chen
1
Name: Yangjun Chen
Birthplace: China
P.h..D: University of Kaiserslautern, Germany, in 1995
Post Doctor.: University of Chemnitz, Germany, 1995/7 - 1997/8
Senior engineer: Germany Research Center for Information Technology,
1997/9 - 2000/2
Post-Doc.: University of Alberta, 2000/2 - 2000/6
Assistant Prof.: Winnipeg University, from 2000/7
Associate Prof.: Winnipeg University, from 2004/7
Sept. 2007
91.3902/3
Yangjun Chen
2
Professor: Dr. Y. Chen
Office: 3D27
E-mail: [email protected]
home-page: http://www.uwinnipeg.ca/~ychen2
phone: 786-9417
Meeting time: 11:30 - 12:45 Mondays & Wednesdays
Lab Meeting Time: Fridays 14:30 – 15:45
Meeting and lab location: 3D03
Office hours: 13:00 - 16:00 Thursday
10:00 – 14:00 Friday
Sept. 2007
91.3902/3
Yangjun Chen
3
Important dates:
Monday Sept. 05, 2007
First class
Wednesday Oct. 24, 2007
Midterm examination
Oct. 20, 2007
Final date to withdraw without academic penalty from a
course that begins in Sept. and ends in Nov. of the 2007
Fall Term
Monday, Nov. 26
Last class
Thursday, Dec. 13
Final examination at 13:30
Sept. 2007
91.3902/3
Yangjun Chen
4
Course objectives:
The course introduces relational database design, development and
programming using Microsoft Access. Specifically it:
 introduces Entity-Relationship modeling, relational databases, and
normalization
 focuses on introductory issues of creating tables, indexes, relationships,
forms, reports of lists and grouped data, selection queries and action
queries, macros
 emphasizes hands-on experience through classroom lectures, weekly
labs for practice and exploration, SQL, and assignments.
Sept. 2007
91.3902/3
Yangjun Chen
5
Required textbook:
Exploring Microsoft Access 2003 with VBA By Robert T. Grauer and
Maryann Barber, ISBN 0-13-0187741-0
Lecture Notes By Dr. Yangjun Chen
Required reading:
Ch 1. Introduction to Microsoft Access: What Is A Database?
Ch 2. Tables and Forms: Design, Properties, Views, and Wizards
Ch 3. Information From the Database: Reports and Queries
Ch 4. Relational Databases, External Data, Charts, and the
Switchboard
Ch 5. One-to-Many Relationships: Subforms and Multiple Table
Queries
Ch 6. Many-to-Many Relationships: A More Complex System
Ch 7. Building Applications: The Switchboard, Macros, and
Prototyping
Ch 8. Introduction to VBA
Lecture Notes Dr. Yangjun Chen
Sept. 2007
91.3902/3
Yangjun Chen
6
Course Evaluation:
4 assignments
1 midterm examination
1 final examination
20%
30%
50%
•All assignments are handed in at class on the due date.
•All works must be prepared using a word processor and
placed in a folder.
•Late assignments are accepted (up to 1 day late) and receive
a 25% penalty.
Sept. 2007
91.3902/3
Yangjun Chen
7
Academic dishonesty:
•Academic dishonesty is a very serious offense and will be
dealt with in accordance with the University's discipline
bylaw. Be sure that you have read and understood section
7a in the 2007 - 08 UW General Calendar.
Sept. 2007
91.3902/3
Yangjun Chen
8