Membuat Tabel Pengalaman Kerja

Tabel pengalaman kerja berisi daftar rincian pengalaman kerja seorang karyawan. Daftar ini berisi rincian pengalaman kerja karyawan sebelum diterima di perusahaan.

Adapun nama field dan properti yang dibutuhkan untuk tabel pengalaman kerja adalah sebagai berikut:

Nama tabel: tblPengalamanKerja

1. Field Name = no
   
   1. Data Type = Numeric
   2. Description = Nomor urut
   3. Field Properties - General Tab:
      
      1. Field Size = 4
      2. Caption = Nomor Urut
2. Field Name = NIP
   
   1. Data Type = Short Text
   2. Description = Nomor identitas pegawai
   3. Field Properties - General Tab:
      
      1. Field Size = 10
      2. Caption = N I P
3. Field Name = PeriodeDr
   
   1. Data Type = Date
   2. Description = Periode awal bekerja
   3. Field Properties - General Tab:
      
      1. Field Size = 8
      2. Caption = Periode Awal
4. Field Name = periodeSd
   
   1. Data Type = Date
   2. Description = Periode akhir bekerja
   3. Field Properties - General Tab:
      
      1. Field Size = 8
      2. Caption = Periode Akhir
5. Field Name = namaPerusahaan
   
   1. Data Type = Short Text
   2. Description = Nama perusahaan
   3. Field Properties - General Tab:
      
      1. Field Size = 50
      2. Caption = Nama Perusahaan
6. Field Name = jenisUsaha
   
   1. Data Type = Short Text
   2. Description = Jenis usaha
   3. Field Properties - General Tab:
      
      1. Field Size = 50
      2. Caption = Jenis Usaha
7. Field Name = kota
   
   1. Data Type = Short Text
   2. Description = Kota
   3. Field Properties - General Tab:
      
      1. Field Size = 50
      2. Caption = Kota
8. Field Name = posisiAwal
   
   1. Data Type = Short Text
   2. Description = Posisi awal saat bekerja
   3. Field Properties - General Tab:
      
      1. Field Size = 255
      2. Caption = Posisi Awal
9. Field Name = posisiAkhir
   
   1. Data Type = Short Text
   2. Description = Posisi akhir saat bekerja
   3. Field Properties - General Tab:
      
      1. Field Size = 255
      2. Caption = Posisi Akhir
10. Field Name = namaAtasanLangsung
    
    1. Data Type = Short Text
    2. Description = Nama atasan langsung
    3. Field Properties - General Tab:
       
       1. Field Size = 50
       2. Caption = Nama Atasan Langsung
11. Field Name = jumlahKaryawan
    
    1. Data Type = Numeric
    2. Description = Jumlah karyawan
    3. Field Properties - General Tab:
       
       1. Field Size = 4
       2. Caption = Jumlah Karyawan
12. Field Name = alasanBerhenti
    
    1. Data Type = Short Text
    2. Description = Alasan berhenti
    3. Field Properties - General Tab:
       
       1. Field Size = 50
       2. Caption = AlasanBerhenti
13. Field Name = gajiTerakhir
    
    1. Data Type = Numeric
    2. Description = Gaji terakhir di perusahaan
    3. Field Properties - General Tab:
       
       1. Field Size = 4
       2. Caption = Gaji Terakhir
14. Field Name = deskripsiPekerjaan
    
    1. Data Type = Short Text
    2. Description = Deskripsi ringkas tentang pekerjaan terakhir
    3. Field Properties - General Tab:
       
       1. Field Size = 200
       2. Caption = Deskripsi Pekerjaan
15. Primary Key = no
16. Foreign Key = NIP