Call us
{+62 21} 7191612
27
Aug
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

 


Contact Us at
{+62 21} 7191612
Send Email
reg@aspriseminar.com
Or go to our Contact Page