Recent (New) Announcements (at the BEGINNING)

Old (outdated) Announcements
 

TIME: 7:30 AM
DATE: January 5, 2005
DAY: Wednesday
LOCATION: Gymnasium (Building 11)

Exam Coverage

Old Topics
   -Spreadsheets (Lecture Slides 4 till 10)
   -Databases (Lecture Slides 13 till 20)

New Topics
  -Chapter 8 (Lecture Slides 23 till 26 + All pages in chapter 8)
  - Chapter 14 (Lecture Slides 27 till 28 + Pages 368 -382, 384-386)
  - Chapter 5 (Lecturer Slides 29 + all pages in chapter 5)

Exam Contents

Chapter8...Internet   - 30%         
Chapter14...Progamming  - 40%   (covered in both lec & lab)
Chapter5..Input and Output – 20%
Old topics (database  + spreadsheets) – 10% (Database Forms also included)

Number of questions = 80
T/F  = 40 Q
MCQ = 40 Q

* Database Topics (as follows)
Database Concepts & Definitions

Data Organization in databases –Files, Records, Fields
Concept of Key Field

Main activities in Database Maintenance
  -Defining data
  -Creating data
  -Manipulating data

Applications of Databases in Businesses

Database Implementation Approaches
  -Flat file approach (using a single file)    -Benefits/ Drawbacks
  -Integrated file approach (using table relationships)   -Benefits/ Drawbacks

Concept of Data Structural Independence & Data Dictionary

Users in a DBMS Environment – DBA, End Users, System Analysts, Database Designer

Example DBMS packages – including ACCESS, ORACLE, SQL SERVER, COREL PARADOC etc.

Introducing Microsoft Access
Details of Access Interface Objects – Brief discussion of Table, Query, Form, Report, Page, Macro, Module
 
Table Object Functionalities
 - Data Definition (Design view)
 - Data Manipulation (Datasheet view)
 - Data Analysis (Pivot table view)

Data Type Details-   -Character/ Number/ DateTime/ YesNo/ Binary Data/ OLE/ Hyperlink etc.
Field Property Details – Indexing/ Validation Rule/ Format/ Input mask (brief discussions)

Use of Filtering and Sorting on Table datasheet view
  -Filter by selection
  -Filter by form
  -Sorting with more than one field

Concepts of Data Integrity
  -Single Table Integrity Constraints
  -Referential Integrity Constraints

Significance of Table Relationships
  -Controlling Referential Integrity
  -Building Queries

Referential Integrity Maintenance Approaches
  -One-to-One Relationship Maintenance 
  -One-to-Many Relationship Maintenance

Database Queries
 Available Query Types in Microsoft Access
   -Data Manipulation Queries
   -Data Definition Queries

Creating Queries in Access
  -QBE (Query By Example)
  -SQL (Structured Query Language)

Working with SELECT Queries
  -Single Table / Multiple Table Queries

  -Parametric Query

  -Field Computation Queries

  -Summary Queries

  -Use of Groups in Summary Queries

 Update Queries

 Delete Queries

 Crosstab Queries (Brief discussion)

Append Queries (Brief discussion)

Create Table Queries (Brief discussion)

Use of Forms and report in Access  - Brief Discussion

Contents of Exam
 - Lecture Slides  (from Lecture 02  till Lecture 10)

Book Page Numbers
 -Chapter 1 (all pages)
 -Chapter 2 (pages 28,29,30,31,36,37,38,39,40,41,42)
 

New Time:  Sunday, 5:15pm - 7:15pm
Location:  Room 278