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.