Membuat Tabel Biodata

Tabel biodata merupakan file induk yang memuat daftar riwayat hidup seorang pegawai secara lengkap, mulai dari saat masuk sampai dengan berhenti bekerja di sebuah perusahaan. Tabel ini menjadi pusat data, di mana user bisa melihat profil pegawai secara menyeluruh.

Tabel biodata berisi data pribadi pegawai atau karyawan. Tabel ini merupakan tabel master (induk) yang di dalamnya berisi juga berbagai macam tabel slave (anak). Sebagai kesepakatan bersama, kita namai tabel biodata itu sebagai tblBiodata. Kita akan membuat tabel tblBiodata dengan rincian field dan properti seperti di bawah. Adapun yang menjadi primary key adalah field NIP atau Nomor Identitas Pegawai.

Nama tabel: tblBiodata

1. 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
2. Field Name = foto
   
   1. Data Type = OLE Objet
   2. Description = Foto pegawai terdaftar
   3. Field Properties - General Tab:
      
      1. Caption = Foto
3. Field Name = namaPegawai
   
   1. Data Type = Short Text
   2. Description = Nama lengkap pegawai
   3. Field Properties - General Tab:
      
      1. Field Size = 255
      2. Caption = Nama Lengkap
4. Field Name = namaPanggilan
   
   1. Data Type = Short Text
   2. Description = Nama panggilan si pegawai
   3. Field Properties - General Tab:
      
      1. Field Size = 25
      2. Caption = Nama Panggilan
5. Field Name = bagian
   
   1. Data Type = Short Text
   2. Description = Bagian, departemen, atau divisi
   3. Field Properties - General Tab:
      
      1. Field Size = 255
      2. Caption = Bagian
6. Field Name = posisiSekarang
   
   1. Data Type = Short Text
   2. Description = Posisi atau jabatan sekarang
   3. Field Properties - General Tab:
      
      1. Field Size = 255
      2. Caption = Posisi/Jabatan
7. Field Name = tglMasuk
   
   1. Data Type = Date
   2. Description = Tanggal pertama kali masuk bergabung di perusahaan
   3. Field Properties - General Tab:
      
      1. Field Size = 8
      2. Format = General Date
      3. Caption = Tanggal Masuk
8. Field Name = tglKeluar
   
   1. Data Type = Date
   2. Description = Tanggal keluar dari perusahaan
   3. Field Properties - General Tab:
      
      1. Field Size = 8
      2. Format = Short Date
      3. Caption = Tanggal Keluar
9. Field Name = statusKepegawaian
   
   1. Data Type = Short Text
   2. Description = Status kepegawaian
   3. Field Properties - General Tab:
      
      1. Field Size = 3
      2. Caption = Status Kepegawaian
   4. Field Properties - Lookup Tab:
      
      1. DisplayControl = Combo Box
      2. RowSourceType = Value List
      3. RowSource = T;Permanen/Karyawan Tetap;K;Kontrak;P;Percobaan;D;Diperbantukan;H;Honorer;L;Karyawan Lepas;X;Keluar/Tidak Bekerja Lagi
      4. BoundColumn = 1
      5. Column Widths = 0,5";2,5"
      6. Column Count = 2
      7. Column Heads = No
10. Field Name = posisiAwal
    
    1. Data Type = Short Text
    2. Description = Posisi atau jabatan saat terdaftar pertama kalinya
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = Posisi/Jabatan Awal
11. Field Name = tempatLahir
    
    1. Data Type = Short Text
    2. Description = Kota tempat lahir si pegawai
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = Tempat Lahir
12. Field Name = tglLahir
    
    1. Data Type = Date
    2. Description = Tanggal kelahiran si pegawai
    3. Field Properties - General Tab:
       
       1. Field Size = 8
       2. Format = Short Date
       3. Caption = Tanggal Lahir
13. Field Name = kartuIdentitas
    
    1. Data Type = Short Text
    2. Description = Jenis kartu identitas sah yang digunakan
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = Kartu Identitas yang Digunakan
    4. Field Properties - Lookup Tab:
       
       1. DisplayControl = Combo Box
       2. RowSourceType = Value List
       3. RowSource = KTP;SIM;Paspor
       4. BoundColumn = 1
       5. Column Widths = 1"
       6. Column Count = 1
       7. Column Heads = No
14. Field Name = kartuIdentitasNo
    
    1. Data Type = Short Text
    2. Description = Nomor kartu identitas sah yang digunakan
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = No Kartu Identitas
15. Field Name = jenisKelamin
    
    1. Data Type = Short Text
    2. Description = Jenis kelamin
    3. Field Properties - General Tab:
       
       1. Field Size = 2
       2. Caption = Jenis Kelamin
    4. Field Properties - Lookup Tab:
       
       1. DisplayControl = Combo Box
       2. RowSourceType = Value List
       3. RowSource = Kode;Jenis Kelamin;L;Pria;P;Perempuan
       4. BoundColumn = 1
       5. Column Widths = 0,4";1,6"
       6. Column Count = 2
       7. Column Heads = Yes
16. Field Name = tinggiBadan
    
    1. Data Type = Number
    2. Description = Tinggi badan
    3. Field Properties - General Tab:
       
       1. Field Size = Integer
       2. Caption = Tinggi Badan (Cm)
17. Field Name = beratBadan
    
    1. Data Type = Number
    2. Description = Berat badan
    3. Field Properties - General Tab:
       
       1. Field Size = Integer
       2. Caption = Berat Badan (Kg)
18. Field Name = golonganDarah
    
    1. Data Type = Short Text
    2. Description = Golongan darah
    3. Field Properties - General Tab:
       
       1. Field Size = 50
       2. Caption = Golongan Darah
    4. Field Properties - Lookup Tab:
       
       1. DisplayControl = Combo Box
       2. RowSourceType = Value List
       3. RowSource = A;B;AB;O
       4. BoundColumn = 1
       5. Column Widths = 0,5"
       6. Column Count = 1
       7. Column Heads = No
19. Field Name = statusPerkawinan
    
    1. Data Type = Short Text
    2. Description = Status perkawinan
    3. Field Properties - General Tab:
       
       1. Field Size = 3
       2. Caption = Status Perkawinan
    4. Field Properties - Lookup Tab:
       
       1. DisplayControl = Combo Box
       2. RowSourceType = Value List
       3. RowSource = Kode;Satus;L;Lajang/Single;M;Menikah;J;Janda;D;Duda
       4. BoundColumn = 1
       5. Column Widths = 0,4";1,6"
       6. Column Count = 2
       7. Column Heads = Yes
20. Field Name = jumlahAnak
    
    1. Data Type = Number
    2. Description = Jumlah anak, bila ada
    3. Field Properties - General Tab:
       
       1. Field Size = Byte
       2. Caption = Jumlah Anak
21. Field Name = PTKP
    
    1. Data Type = Short Text
    2. Description = Golongan penghasilan tidak kena pajak
    3. Field Properties - General Tab:
       
       1. Field Size = 10
       2. Caption = P T K P
    4. Field Properties - Lookup Tab:
       
       1. DisplayControl = Combo Box
       2. RowSourceType = Table/Query
       3. RowSource = SELECT tblPTKP.[PTKP], tblPTKP.keterangan, tblPTKP.jumlahSetahun, tblPTKP.jumlahSebulan FROM tblPTKP ORDER BY tblPTKP.[PTKP];
       4. BoundColumn = 1
       5. Column Widths = 0,4";1,4";1,1";1,1"
       6. Column Count = 4
       7. Column Heads = Yes
22. Field Name = iDBPJS
    
    1. Data Type = Short Text
    2. Description = Nomor identitas jaminan sosial yang dimiliki
    3. Field Properties - General Tab:
       
       1. Field Size = 50
       2. Caption = Nomor BPJS
23. Field Name = skemaBPJS
    
    1. Data Type = Number
    2. Description = Skema BPJS yang diadopsi oleh pegawai
    3. Field Properties - General Tab:
       
       1. Field Size = Integer
       2. Caption = Skema BPJS
    4. Field Properties - Lookup Tab:
       
       1. DisplayControl = Combo Box
       2. RowSourceType = Table/Query
       3. RowSource = tblBPJSSkema
       4. BoundColumn = 1
       5. Column Widths = 0,5";1";1,5";1";1";1"
       6. Column Count = 6
       7. Column Heads = Yes
24. Field Name = wargaNegara
    
    1. Data Type = Short Text
    2. Description = Warga negara
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = Warga Negara
25. Field Name = agamaKepercayaan
    
    1. Data Type = Short Text
    2. Description = Agama atau kepercayaan yang dianut
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = Agama/Kepercayaan
    4. Field Properties - Lookup Tab:
       
       1. DisplayControl = Combo Box
       2. RowSourceType = Value List
       3. RowSource = Islam;Kristen Katolik;Kristen Protestan;Budha;Hindu;Lainnya (tulis)
       4. BoundColumn = 1
       5. Column Widths = 1,5"
       6. Column Count = 1
       7. Column Heads = No
26. Field Name = agamaKepercayaanLainnya
    
    1. Data Type = Short Text
    2. Description = Agama atau kepercayaan selain yang terdaftar
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = Agama/Kepercayaan Lainnya
27. Field Name = alamatRumah
    
    1. Data Type = Short Text
    2. Description = Alamat rumah sekarang
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = Alamat Rumah
28. Field Name = kota
    
    1. Data Type = Short Text
    2. Description = Kota
    3. Field Properties - General Tab:
       
       1. Field Size = 50
       2. Caption = Kota
29. Field Name = kodePos
    
    1. Data Type = Short Text
    2. Description = Kode pos
    3. Field Properties - General Tab:
       
       1. Field Size = 50
       2. Input Mask = 99999;;#
       3. Caption = Kode Pos
30. Field Name = propinsi
    
    1. Data Type = Short Text
    2. Description = Propinsi
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = Propinsi
31. Field Name = alamatRumahAsal
    
    1. Data Type = Short Text
    2. Description = Alamat rumah asal
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = Alamat Rumah
32. Field Name = kotaAsal
    
    1. Data Type = Short Text
    2. Description = Kota asal
    3. Field Properties - General Tab:
       
       1. Field Size = 50
       2. Caption = Kota
33. Field Name = kodePosAsal
    
    1. Data Type = Short Text
    2. Description = Kode pos asal
    3. Field Properties - General Tab:
       
       1. Field Size = 50
       2. Input Mask = #####
       3. Caption = Kode Pos
34. Field Name = propinsiAsal
    
    1. Data Type = Short Text
    2. Description = Propinsi asal
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = Propinsi
35. Field Name = negaraAsal
    
    1. Data Type = Short Text
    2. Description = Negara asal
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = Negara
36. Field Name = telpRumah
    
    1. Data Type = Short Text
    2. Description = Telepon rumah yang bisa dihubungi
    3. Field Properties - General Tab:
       
       1. Field Size = 50
       2. Input Mask = \(####") "####\-####;;_
       3. Caption = Telp Rumah
37. Field Name = telpSeluler
    
    1. Data Type = Short Text
    2. Description = Telepon seluler yang bisa dihubungi
    3. Field Properties - General Tab:
       
       1. Field Size = 50
       2. Input Mask = \(9999") "9999\-9999!;1;-
       3. Caption = Telp Seluler
38. Field Name = alamatEmail
    
    1. Data Type = Short Text
    2. Description = Alamat email lain yang bisa digunakan
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = Alamat Email
39. Field Name = hobi
    
    1. Data Type = Short Text
    2. Description = Hobi atau kegiatan di waktu senggang yang bermanfaat
    3. Field Properties - General Tab:
       
       1. Field Size = 50
       2. Caption = Hobi
40. Field Name = penghargaan
    
    1. Data Type = Short Text
    2. Description = Penghargaan yang pernah diraih
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = Penghargaan yang Pernah Diraih
41. Field Name = NPWP
    
    1. Data Type = Short Text
    2. Description = Nomor pokok wajib pajak yang dimiliki
    3. Field Properties - General Tab:
       
       1. Field Size = 50
       2. Caption = N P W P
42. Field Name = jamMasuk
    
    1. Data Type = Date
    2. Description = Jam masuk
    3. Field Properties - General Tab:
       
       1. Field Size = 8
       2. Format = Short Time
       3. Caption = Jam Masuk
43. Field Name = jamKeluar
    
    1. Data Type = Date
    2. Description = Jam keluar
    3. Field Properties - General Tab:
       
       1. Field Size = 8
       2. Format = Short Time
       3. Caption = Jam Keluar
44. Field Name = namaRekening
    
    1. Data Type = Short Text
    2. Description = Nama rekening
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = Nama Rekening
45. Field Name = nomorRekening
    
    1. Data Type = Short Text
    2. Description = Nomor rekening
    3. Field Properties - General Tab:
       
       1. Field Size = 255
       2. Caption = Nomor Rekening
46. Field Name = SIM
    
    1. Data Type = Short Text
    2. Description = Jenis SIM (Surat Ijin Mengemudi) yang dimiliki
    3. Field Properties - General Tab:
       
       1. Field Size = 50
       2. Caption = Jenis SIM
47. Field Name = pendidikanTerakhir
    
    1. Data Type = Short Text
    2. Description = Pendidikan terakhir saat masuk kerja
    3. Field Properties - General Tab:
       
       1. Field Size = 50
       2. Caption = Pendidikan Terakhir
48. Field Name = jurusanStudi
    
    1. Data Type = Short Text
    2. Description = Jurusan yang diambil yang pendidikan terakhir
    3. Field Properties - General Tab:
       
       1. Field Size = 50
       2. Caption = Jurusan Studi
49. Field Name = sosmedFB
    
    1. Data Type = Hyperlink
    2. Description = Akun sosial media Facebook
    3. Field Properties - General Tab:
       
       1. Caption = Akun Facebook
50. Field Name = sosmedTwitter
    
    1. Data Type = Hyperlink
    2. Description = Akun sosial media Twitter
    3. Field Properties - General Tab:
       
       1. Caption = Akun Twitter
51. Field Name = sosmedLinkedin
    
    1. Data Type = Hyperlink
    2. Description = Akun sosial media Linkedin
    3. Field Properties - General Tab:
       
       1. Caption = Akun Linkedin
52. Primary Key = NIP

Dari keseluruhan field di atas, ada beberapa field yang mempunyai properti DisplayControl berupa Combo Box. Beberapa field di atas mempunyai properti RowSourceType = Value List dan Table/Query. Untuk field dengan RowSourceType = Table/Query, kita harus membuat tabel atau query terlebih dulu. Untuk saat ini, terima saja dulu Row Sources yang ada di atas. Di posting selanjutnya, kita akan membuat tabel yang menjadi Row Source dari field yang ada di tblBioData ini.