RDBMS (BSC-IT 2nd)

Section I

Introduction to Office 2000: Introduction Microsoft Office 2000, Benefits of Office

2000, What

is New in Office 2000, Overview of Office 2000, Launching Office 2000 Applications,

Switching

between Office 2000 Applications, Office 2000 Help System, Detect & Repair Windows,

Menus

and Toolbars, Closing (Existing) Office Applications, Windows, Menus, Dialog Boxes

and

Toolbars, Application Windows, The Application’s Workplace, Document Navigation,

Working

with Several Document Windows, Menus and Dialog Boxes, Dialog Box

Options,Toolbars,

Printing Documents, Exercises.

Introduction to Databases, DBMS and RDBMS : Introduction, Information, Quality of

Information, Information Processing, What is a Database?,Why a Database?,

Charateristics of

Data in a Database, What is a Database Management System (DBMS)?, Need for DBMS,

Types of DBMS, Relational Database Management Systems (RDBMS), RDBMS

Terminology,

Relational Data Structure, Relational Data Intergrity, Conclusion, Review Questions.

Section II

Access 2000 Basics : Introduction, Starting Access 2000, Access Startup Dialog Box,

Menus

and Toolbars, Using Toolbar Buttons, Arranging Buttons on the Toolbar, Viewing Data,

Creating

an Access 2000 Database and Tables, Database Properties, Modifying Tables, Creating

Forms,

Entering and Updating Data Using Forms, Navigating between Records in a Form,

Finding,

Editing and Deleting Data in a Form, Using Access 2000 Help, Using Answer Wizard,

Using the

Contents Tab to Get Help, Using the Index Tab to ger Help, Exercises.

Report and Queries : Introduction, Sorting and Filtering Records, Creating and Printing

Reports,

Creating and Using Queries.

Section III

Introduction to Structured Query Language (SQL) : Introduction, Characteristics of

SQL,

Advanges of SQL, Types of SQL Tables, Create Table, NULLS, Data Manipulation,

Update

Operations, SQL in Access.

Query by Example (QBE) : Introduction, SELECT Queries in QBE, Make-Table

Query,

DELETE Query, UPDATE Query, APPEND Query, Conclusion, Exercises.