SPIT 003 : Effective Database Management

SPIT 003 : Effective Database Management

Mr. Fazal Pasha
  • course description:

    This course prepares the participants to understand the principles and the elements of Database Management and design simple databases using MS Access.

  • course learning outcomes:

    At the end of the course, the participants will be able to;
    - Understand what Database Management.
    - Understand the usage of different objects in MS-Access.
    - Create tables, Queries Forms.
    - Use different objects.
    - Develop Reports.
    - Create applications using MS Access features and functions.

  • Course outlines:

    - Role of Database in the business applications.
    - Usage of different objects in MS-Access.
    - Different Data types of table.
    - Create tables, and knowing the concept of relationship in tables.
    - Create Queries (Select, update, delete, append, make table).
    - Usage of Forms and Create different Forms.
    - Create forms using Wizard and also by using Design View.
    - Use Query to create a Form.
    - Use different objects in form like text box, buttons, labels, combo box, list box, and image.
    - Develop Reports using wizards.
    - Create and using Macros in forms.
    - Develop an application using MS-Access program, with above functions and features.

  • practical aspects of the course:

    - All training hours will be conducted in a computer lab equipped with MS Access DBMS software and smart projector.

  • who should attend?

    - Should have minimal computer basic knowledge

  • duration:

    4 Days


    Click here