| |
|
|
Information Technology Programmes
Duration:
1 day, from 8:30 am to 4:30 pm
Training dates:
Thai: Tue., 3 June 2008
English: Thu., 5 June 2008
Venue: IT Learning Lab, UNESCAP Learning Centre, 3 rd floor of UNCC
Facilitator: APTECH Education
Target audience: Staff from UNESCAP and participating UN agencies in the Common IT Training initiative of the Operations Management Team - Bangkok
Course outline:
|
• List of computerizing of data
• Need for DBMS
• Database evolution & various models
• RDBMS
• Concept of Front End and Back End
• ERD Model
• Construction of the ERD model for the application
• Evolving tables from the ERD
• Components of a table
• Common data types for fields in tables
• Constraints like Primary Key, Check, Not NULL and Default Constraint
• Implementation of such constraints
• Input masks and validations
• Need for Relationships
• Relate tables in MS Access
• Queries
• Work with SQL view in MS Access
• Joins and types of Table Joins
• Practice Sessions |
Contact person: Ms. Vanviva Bhumibhanit, extension no. 2020
|
|
