How to get only one record from group of records in ms access database

See more:

MS-Access

I have three tables and its design is as below.

SCHEMETRN1:

ID	SCHEME_ID	FAMILYCODE	SCHEME_YEAR
5500	    7	             1	            2013

SCHEMETRN2:

FAMILYCODE	SCHEME_ID	      SCHEME_YEAR
1	           9	                  2013
1	           9	                  2013
2	           1	                  2013
2	           1	                  2013
8	           1	                  2013
277	           9	                  2013
277	           9	                  2013
277	           9	                  2013

DATAFILE:

FAMILYCODE   NAME     AGE
     1       ABC       25
     1       PQR       70
     2       XYZ       35
     2       SDH       45

Output should be as below:
FAMILYCODE NAME No of Scheme Used
1 ABC 2
2 XYZ 1


Now what I want is to display from DATAFILE table only one record per familycode i.e
schemetrn2 table has familycode 1 so I want to display only one record for familycode 1 from Datafile table.

Also Schemetrn1 and schemetrn2 has familycode 1 so I want to get no of counts as 2 for familycode 1 with the above query.
Can any1 help me please.