Welcome to Database Application Development Course May 2012

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: 3 D 27 E-mail: y. chen@uwinnipeg. ca home-page: http: //www. uwinnipeg. ca/~ychen 2 phone: 786 -9417 Meeting time: 10: 30 - 12: 30 Mondays & Wednesdays Lab Meeting Time: Mondays 15: 45 – 17: 45 Meeting and lab location: 3 D 03 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