Segmenting data securely on a access/SQL Server application

[weegee]

Hi

I have built an MS Access application with data on SQL Server. Its
comprised of Employee data. The data contains a category for Division.

Divisions are for example:

ECT
ECT Asia
PCT

However, I want to be able to put security on the data so that users
from each division only have access to their data.

Ie users from ECT will only see employee data for ECT, users from ECT
Asia only see ECT Asia only

What would be the best way for me to provide this level of security?

Can I set permissions for users on subsets of data?

thanks in advance!