Query 2

1. SELECT KBM.NIM,Mahasiswa.Nama,KBM.Nilai
FROM KBM, Mahasiswa
WHERE KBM.NIM=Mahasiswa.NIM

2. SELECT Mahasiswa.Nama,MataKuliah.Nama,KBM.Nilai
FROM Mahasiswa,MataKuliah,KBM
WHERE KBM.NIM=Mahasiswa.NIM AND KBM.KodeMK=MataKuliah.KodeMK

3. SELECT NIM,Nama, IIF(Nama="Budi","laki-laki","perempuan") AS JenisKelamin
FROM Mahasiswa

4. SELECT IIf(DATEDIFF("m",TanggalLahir,Now()) > 11,DATEDIFF("yyyy",TanggalLahir,Now()),"belum genap 1 tahun")
FROM Mahasiswa;

Materi Query Ms.Access

Buat tiga tabel

lakukan query berikut:
1. SELECT NIM, Nama FROM Mahasiswa
2. SELECT NIM, Nama, TanggalLahir AS Umur FROM Mahasiswa
3. SELECT * FROM Mahasiswa
4. SELECT * FROM Mahasiswa, MataKuliah, KBM
5. SELECT * FROM KBM LEFT JOIN MataKuliah ON KBM.KodeMK = MataKuliah.KodeMK
6. SELECT * FROM KBM RIGHT JOIN MataKuliah ON KBM.KodeMK = MataKuliah.KodeMK
7. SELECT * FROM KBM INNER JOIN MataKuliah ON KBM.KodeMK = MataKuliah.KodeMK
8. SELECT * FROM KBM, MataKuliah ORDER BY KBM.NIM, MataKuliah.KodeMK
9. SELECT NIM, Nama, (YEAR(NOW()) - YEAR(TanggalLahir)) AS Umur FROM Mahasiswa
10. SELECT NIM, Nama, IIF(Nama="nama mahasiswa tertentu", Nama, "bukan mahasiswa yang dicari") FROM Mahasiswa

11. SELECT NIM, Nama, DATEDIFF("yyyy",TanggalLahir,Now()) AS Umur FROM Mahasiswa
12. SELECT NIM, Nama, DATEDIFF("m",TanggalLahir,Now()) AS Umur FROM Mahasiswa