Certification in Database Administrator(Course Content)

Part I - AN OVERVIEWING OF ACCESS ( 1hr. )  
Getting Started and Getting Around
  • Understanding Database
  • About Access
  • Why ACCESS is different from other DBMS Packages.

    • Part II - CREATING A DATABASE ( 10hrs. )
  • Creating a Database
  • Creating Access Tables(using/without Wizards)
  • Defining Relationship among Tables
  • Modifying Table Structure,Deleting/Droping the Tables
  • Linking,Importing & Exporting Data(Interacting with other Database)
  • Adding,Editing,Deleting & Viewing Data
  • Sorting,Searching,Filtering & Printing

    • Part III - QUERYING YOUR TABLES ( 10hrs. )
  • What is Query
  • Using Query Wizards
  • Creating,Running,Saving and Changing a Query
  • Opening a Saved Query
  • Joining Tables
  • Viewing SQL Statement behind a Query
  • Creating Action Queries(Update,Append,Delete & Make Table Queries)

    • Part IV - FORMS & REPORTS ( 10hrs. )
  • Creating Forms with Form Wizards
  • Creating Reports with Report Wizards
  • Creating Custom Forms & Reports
  • Using the Controlls in Forms & Reports


    • Part V - ACCESS PAGE ( 4hrs. )
  • Data Access Pages Basic
  • Creating the Pages using Page Wizards
  • Creating the Pages Yourself
  • Diffrences Between Access Pages & Access Forms

    • Part VI - DATABASE TUNING AND ADMINISTRATION ( 2hrs. )
  • Personalizing Your Work Environment
  • Personalizing a Database
  • Backing Up a Database
  • Restoring a Database From Backups
  • Compacting and Repairing a Database


    • Part VII - NETWORKING AND SECURITY ( 5hrs. )
  • Allowing User to Share Data
  • Editing/ Refreshing Data on Network
  • Securing Your Database
  • Password Security
  • Separating Tables
  • Tweaking Multiuser Settings
  • Access Logons
  • Workgroup Files
  • Viewing Ownership &Permissions
  • User Level Security Wizards

    • Part VIII - REFINING A CUSTOM APPLICATION ( 15hrs. )
  • Introducing Visual Basic
  • Why Use Visual Basic
  • How VB is used as a Front End In Access
  • Data Connectivity from VB to Access


    • Part IX - MS-ACCESS With SQL-SERVER ( 15hrs. )
  • What is SQL-Server and how it Supports MS-ACCESS
  • How to Create Table in SQL-Server and some Basic operation on Table......
  • Connecting with SQL-Server
  • How to Include/ Install MSDE(Micro Soft Database Engine)
  • What is SQL Service Manager ?How to start It
  • What is Project ? Difference Between Database & Project
  • Elements of an Access Project
  • The Northwind CS Project
  • Create New Project with Existing Tables/ New Tables
    • Part X - PROJECT TIPS ( 3hrs. )