| |
|
|
Information Technology Programmes
Duration: 1 day
Training date: TBA
Venue:
IT Learning Lab, UNESCAP Learning Centre
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:
|
Introduction to SQL
Use of Aggregate functions in Queries
Writing sub queries in SQL
Concept of indexing, implementation in MS Access
Parameters for query Optimization
Creating Forms
......- Columnar Forms
......- Tabular Forms
......- Datasheet forms
Using the Form Wizard
Designing Forms without Wizard
......- Using the Tool Box
......- Property Sheet
Working with Controls
......- Text boxes
......- Labels
......- Options Boxes and Check boxes
......- Data bound Controls
Practice Sessions |
Contact person: Ms.
Woranan Thoophom, ext. 2693
|
|