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