Recent (New) Announcements (at the BEGINNING)

Old (outdated) Announcements
 

Contents:
Chapter 4 – Complete Chapter

Database Topics – Selected topics from Chapter 2, Chapter 11 & Lecture Notes/ Slides
   * Chapter 2 (page 43 to 45)
   * Chapter 11 (pages 290, 291, 294, 295, 301 - 303)
   * from Lec10 to  Lec21 (all are included)

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 Reports in Microsoft Access - Brief Discussion