1
绗?/p>
4
绔?/p>
鏌ヨ璁捐
_
涔犻
涓�銆?/p>
閫夋嫨棰?/p>
1
锛庝互涓嬪叧浜庢煡璇㈢殑鍙欒堪锛屾纭殑鏄紙
锛?/p>
銆?/p>
C
A
锛庡彧鑳芥牴鎹暟鎹〃鍒涘缓鏌ヨ
B
锛庡彧鑳芥牴鎹凡寤烘煡璇㈠垱寤烘煡璇?/p>
C
锛庡彲浠ユ牴鎹暟鎹〃鍜屽凡寤烘煡璇㈠垱寤烘煡璇?/p>
D
锛庝笉鑳芥牴鎹凡寤烘煡璇㈠垱寤烘煡璇?/p>
2
锛庤嫢鐢ㄢ�滃鐢熲�濊〃涓殑鈥滃嚭鐢熸棩鏈熲�濆瓧娈佃绠楁瘡涓鐢熺殑骞撮緞锛堝彇鏁淬�?/p>
锛岄偅涔堟纭殑璁?/p>
绠楀叕寮忎负锛?/p>
锛?/p>
銆?/p>
A
A
锛?/p>
Year(Date())-Year([
鍑虹敓鏃ユ湡
])
B
锛?/p>
(Date()-[
鍑虹敓鏃ユ湡
])/365
C
锛?/p>
Date()-[
鍑虹敓鏃ユ湡
]/365
D
锛?/p>
Year([
鍑虹敓鏃ユ湡
])/365
3
锛庡鏋滃湪鈥滃鐢熲�濊〃涓煡鎵惧鈥滄潕鈥濆鐢熺殑璁板綍锛屽垯鏌ヨ鏉′欢鏄紙
锛?/p>
銆?/p>
C
A
锛?/p>
Not "
鏉?/p>
*"
B
锛?/p>
Like "
鏉?/p>
"
C
锛?/p>
Like "
鏉?/p>
*"
D
锛?/p>
"
鏉?/p>
脳
脳
"
4
锛庢煡璇㈣璁¤鍥剧獥鍙ｄ腑閫氳繃璁剧疆锛?/p>
锛夎锛屽彲浠ヨ鏌愪釜瀛楁鍙敤浜庤瀹氭潯浠讹紝鑰屼笉
鍑虹幇鍦ㄦ煡璇㈢粨鏋滀腑銆?/p>
B
A
锛庢帓搴?/p>
B
锛庢樉绀?/p>
C
锛庡瓧娈?/p>
D
锛庢潯浠?/p>
5
锛庤嫢缁熻鈥滃鐢熲�濊〃涓悇涓撲笟瀛︾敓浜烘暟锛屽簲鍦ㄦ煡璇㈣璁¤鍥句腑锛屽皢鈥滃鍙封�濆瓧娈碘�滄�?/p>
璁♀�濆崟鍏冩牸璁剧疆涓猴紙
锛?/p>
銆?/p>
B
A
锛?/p>
Sum
B
锛?/p>
Count
C
锛?/p>
Where
D
锛?/p>
Total
6
锛庡湪
Access
鏌ヨ涓紝
锛?/p>
锛夎兘澶熷噺灏戞簮鏁版嵁琛ㄧ殑鏁版嵁銆?/p>
D
A
锛庨�夋嫨鏌ヨ
B
锛庣敓鎴愯〃鏌ヨ
C
锛庤拷鍔犳煡璇?/p>
D
锛庡垹闄ゆ煡璇?/p>
7
锛庡湪鏌ヨ璁捐瑙嗗浘涓紝濡傛灉瑕佷娇琛ㄤ腑鎵�鏈夎褰曠殑鈥滀环鏍尖�濆瓧娈电殑鍊煎鍔?/p>
10%
锛屽簲浣跨敤
锛?/p>
锛夎〃杈惧紡銆?/p>
C
A
锛?/p>
[
浠锋牸
]+10%
B
锛?/p>
[
浠锋牸
]*10/100
C
锛?/p>
[
浠锋牸
]*(1+10/100)
D
锛?/p>
[
浠锋牸
]*(1+10%)
8
锛庡湪鏌ヨ璁捐瑙嗗浘涓紙
锛?/p>
銆?/p>
A
A
锛庡彲浠ユ坊鍔犺〃锛屼篃鍙互娣诲姞鏌ヨ
B
锛庡彧鑳芥坊鍔犺〃
C
锛庡彧鑳芥坊鍔犳煡璇?/p>
D
锛庤〃鍜屾煡璇㈤兘涓嶈兘娣诲姞
9
锛庡湪
Access
涓紝鍒犻櫎鏌ヨ鎿嶄綔涓鍒犻櫎鐨勮褰曞睘浜庯紙
锛?/p>
銆?/p>
B
A
锛庨�昏緫鍒犻櫎
B
锛庣墿鐞嗗垹闄?/p>
C
锛庡彲鎭㈠鍒犻櫎
D
锛庝复鏃跺垹闄?/p>
10
锛庡鏋滅敤鎴峰笇鏈涙牴鎹煇涓彲浠ヤ复鏃跺彉鍖栫殑鍊兼潵鏌ユ壘璁板綍锛屽垯鏈�濂戒娇鐢ㄧ殑鏌ヨ鏄?/p>
锛?/p>
锛?/p>
銆?/p>
C
A
锛庨�夋嫨鏌ヨ
B
锛庝氦鍙夎〃鏌ヨ
C
锛庡弬鏁版煡璇?/p>
D
锛庢搷浣滄煡璇?/p>
浜屻�?/p>
濉┖棰?/p>
1
锛庤嫢瑕佹煡鎵炬渶杩?/p>
20
澶╀箣鍐呭弬鍔犲伐浣滅殑鑱屽伐璁板綍锛屾煡璇㈡潯浠朵负
銆?/p>
Between Date()-20 And Date()
鎴?/p>
Between Now()-20 And Now()
鎴?/p>
>=Date()-20 And
<=Date()
鎴?/p>
>=Now()-20 And <=Now()
2
锛庢煡璇⑩�滄暀甯堚�濊〃涓�滆亴绉扳�濅负鈥滄暀鎺堚�濇垨鈥滃壇鏁欐巿鈥濈殑璁板綍鐨勬潯浠朵负
銆?/p>
"
鏁欐巿
" Or "
鍓暀鎺?/p>
"
3
锛庢搷浣滄煡璇㈠叡鏈?/p>
4
绉嶇被鍨嬶紝鍒嗗埆鏄敓鎴愯〃鏌ヨ銆佸垹闄ゆ煡璇€�佹洿鏂版煡璇㈠拰
銆?/p>
杩?/p>
鍔犳煡璇?/p>
4
锛庡垱寤轰氦鍙夎〃鏌ヨ锛屽繀椤诲琛屾爣棰樺拰琛屾爣棰樿繘琛?/p>
鎿嶄綔銆?/p>
鍒嗙粍
5
锛庤璁℃煡璇㈡椂锛岃缃湪鍚屼竴琛岀殑鏉′欢涔嬮棿鏄?/p>
鐨勫叧绯伙紝璁剧疆鍦ㄤ笉鍚岃鐨勬潯浠朵箣