在Access查询中使用IIF、Switch、Choose函数可以实现不同值的选择：

使用IIF函数：

Select Name AS 姓名, iif([Sex]="1" ,"男" , "女") AS 性别, Class AS 班级, Score AS 成绩
FROM Students
Where Score >= 60;

使用Switch函数：

Select Name AS 姓名, Switch([Sex] = "1","男",[Sex] = "2", "女") AS 性别, Class AS 班级, Score AS 成绩
FROM Students
Where Score >= 60;

使用Choose函数：

Select Name AS 姓名, choose([Sex] ,"男" , "女") AS 性别, Class AS 班级, Score AS 成绩
FROM Students
Where Score >= 60;