04
online
Jakarta
09:00 -
15:00
Rp. 3.500.000,-
Development of Relational Database Management with Access for IT & non IT
|
TRAINING SYLLABUS
- The concept of databases, tables, records and fields.Functions of databases, tables, records and fields.
- Terms - conditions for writing database names, tables, records and fields.
- Create a Field Name by using the data types.
- Creating Databases, Tables, Records and Fields
- Creating the Index Primary Key
- Entering data into database with standard method
- Entering data into the database with the import file method
- The concept of database normalization with its advantages and disadvantages.
- Master table concept and transaction
- Master and transaction table functions
- Requirements in making Relational Data Table.
- Database normalization process
- Create master tables and transactions using SQL – Distinct
- Create and design standard queries with certain criteria
- Run a standard query with certain criteria
- Create and design updated queries using arithmetic functions
- Running an updated query using arithmetic functions
- Create and design updated queries using logical functions
- Menjalankan updated query dengan menggunakan fungsi logika
- Running an updated query using logical functions
- Create and Design Form data
- Create and design Report data
|