try using "like" and wild card "%"

"SELECT Data_T.Projektnummer, Data_T.Klant, Data_T.Projektnaam, Data_T.Aard, Data_T.Status "
& _
"FROM Data_T " & _
"WHERE Klant like '%Test'"