Can a staff member with permission "no access" can be assigned an appointment ?

Yes, absolutely. The term no access means access to the HUB, which is not necessary for everyone.