CIS 1150-01 Intro to Access

Syllabus Tentative Calendar
[For contact info please go to Shiaoling Peng's Home Page]

CIS 1150-01 Introduction to Microsoft Access (1 credit) Fall 2009
T 4:00 pm - 5:50 pm, Room B114 (8/25-10/13/09)

Announcements


10/13
  1. The final class grades for this class will be posted on Tuesday, 10/20.
10/6
  1. Today we will cover Tutorial 5: Creating Advanced Queries and Enhancing Table Design.
  2. In-Class assignment: Upload the modified database from today to D2L using the "In-Class 6" drop box.
  3. Take home assignment (Due Monday 10/12): Case problem 2 for Tutorial 5 (pages AC 253-255). You can download the data file needed for the assignment from the Take-Home-T5 drop box ad D2L. 
  4. The final exam covering Tutorial 1-5 will be given on Tuesday 10/13. Here is a list of the topics on the test: Access Study.
9/29
  1. We will finish Tutorial 4.
  2. Quiz #4 on Tutorial 4 will be given on Tuesday, 10/6.
  3. In-Class assignment: Upload the modified database from today to D2L using the "In-Class 5" drop box.
  4. Take home assignment (Due Monday 10/5): Case problem 2 for Tutorial 4 (pages AC 193-194). You will continue your work on the file you created for previous assignments. In addition, you need to download the image file: Weights.bmp. You can download the file by right clicking the link and choose "Save Target as".
  5. The due date of take home assignment for Tutorial 3 is postponed to 10/5. I will correct any mistakes you have in Tutorial 1 and 2 before 10/1 so that you can work on Tutorial 3 properly.
     
9/22
  1. We will finish Tutorial 3 and start Tutorial 4.
  2. There is no quiz today. Quiz #3 on Tutorial 3 will be given on Tuesday, 9/29.
  3. In-Class assignment: Upload the modified database from today to D2L using the "In-Class 4" drop box.
  4. Take home assignment (Due Monday 9/28): Case problem 2 for Tutorial 3 (pages AC 147-148). Please note you will continue your work on the database you created and modified for Tutorial 1 and 2. No extra data files are needed for this assignment.
9/15
  1. We will cover Tutorial 3 to add queries to the database from previous tutorial.
  2. Quiz #3 on Tutorial 3 will be given on Tuesday, 9/22.
  3. In-Class assignment: Upload the modified database to D2L using the "In-Class 3" drop box.
  4. Take home assignment (Due Monday 9/21): Case problem 2 for Tutorial 3 (pages AC 147-148). Please note you will continue your work on the database you created and modified for Tutorial 1 and 2. No extra data files are needed for this assignment.
9/8/09
  1. We will continue our work on the file created for Tutorial 1.
  2. In-Class assignment: Upload the modified database to D2L using the "In-Class 2" drop box.
  3. Quiz #2 on Tutorial 2 will be given on Tuesday, 9/15.
  4. Take home assignment (Due Monday 9/14): Case problem 2 on page AC 92. You will continue your work on the file you created for the last assignment. In addition, you need to download the Excel file: Center.xlsx. You can download the file by right clicking the link and choose "Save Target as".
     
9/1/09
  1. We will be working on our first tutorial on Access today to create an Access database.
  2. Quiz #1 on Tutorial 1 will be given on Tuesday, 9/8.
  3. In-Class assignment: upload the database Belmont to D2L using the "In-Class 1" drop box before 3:55pm, Tuesday 9/8.
  4. Take home assignment (Due Monday 9/7): case problem 2 on page AC 39. Upload the database file to D2L using the drop box labeled "Take-Home T1".

    The data file you need for this assignment is Health.accdb. You can download the file by right clicking the link and choose "Save Target as".
8/25/09
  1. Please read the Syllabus and the Calendar for course information and class contents.

  2. Today we will cover:
    • Managing Your Files (FM)
    • Getting Started with Microsoft Office 2007 (OFF)
  3. Assignment for today (Due 11:55pm, 8/31):
    • Purchase textbooks and/or software for the class.
    • Get your IHCC network account set up.
  4. To prepare for the next class:
    • Read Tutorial 1: Creating a Database
  5. The following is a link where you can purchase the Office 2007 suit with a good student discount. This is offered by Microsoft.

    http://www.microsoft.com/student/discounts/theultimatesteal-us/default.aspx

    You can read the eligibilities at

    http://www.microsoft.com/student/discounts/theultimatesteal-us/terms.aspx

 Hit Counter