Transcript Course outline - The University of Winnipeg

Welcome to Database Application
Development Course
May 2012
ACS-2814/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
Full Prof.: University of Winnipeg, from 2009/7
May 2012
ACS-2814/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: 10:30 - 12:30 Mondays & Wednesdays
Lab Meeting Time: Mondays 15:45 – 17:45
Meeting and lab location: 3D03
Office hours: 13:00 - 16:00 Wednesday
10:00 – 14:00 Friday
May 2012
ACS-2814/3
Yangjun Chen
3
Important dates:
Monday May 02, 2012
First class
Wednesday May 30, 2012
Midterm examination
June 05, 2012
Final date to withdraw without academic penalty from a
course that begins on May 01 and ends on June 27 of
the 2012 Spring Term
Wednesday June 27, 2012
Last class
Date for the Final examination
to be announced
May 2012
ACS-2814/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.
May 2012
ACS-2814/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
May 2012
ACS-2814/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.
May 2012
ACS-2814/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
Regulations and Policies, #8 in the 2011-2012 UW Calendar.
May 2012
ACS-2814/3
Yangjun Chen
8