1 / 8

Welcome to Database Application Development Course

Join Professor Yangjun Chen in this course to learn relational database design, development, and programming using Microsoft Access. Covering Entity-Relationship modeling, normalization, SQL, and more. Stay updated on important dates, exam schedule, textbook, and evaluation criteria.

vdunford
Download Presentation

Welcome to Database Application Development Course

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Welcome to Database Application Development Course ACS-2814/3 Yangjun Chen

  2. 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 ACS-2814/3 Yangjun Chen

  3. Professor: Dr. Y. Chen Office: 3D27 E-mail: y.chen@uwinnipeg.ca 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 ACS-2814/3 Yangjun Chen

  4. 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 ACS-2814/3 Yangjun Chen

  5. 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. ACS-2814/3 Yangjun Chen

  6. 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 PrototypingCh 8. Introduction to VBA Lecture Notes Dr. Yangjun Chen ACS-2814/3 Yangjun Chen

  7. Course Evaluation: • 4 assignments   20% • 1 midterm examination   30% • 1 final examination   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. ACS-2814/3 Yangjun Chen

  8. 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. ACS-2814/3 Yangjun Chen

More Related