1
绗崄浜岀珷缂栧啓
ACCESS
搴旂敤绋嬪簭
涓�銆佸崟椤归�夋嫨棰?/p>
1
銆?/p>
浠庡瓧绗︿覆
S("ABCDEFG")
涓繑鍥炲瓙涓?/p>
B("CD")
鐨勬纭〃杈惧紡鏄紙
D
锛夈�?/p>
A
銆?/p>
Mid
锛?/p>
S
锛?/p>
3
锛?/p>
2
锛?/p>
B
銆?/p>
Right(Left(S,4),2)
C
銆?/p>
Left(right(S,5),2)
D
銆佷互涓婇兘鍙互
2
銆?/p>
涓嬪垪璁＄畻姝ｇ‘鐨勬槸锛?/p>
A
锛夈�?/p>
A
銆?/p>
int
锛?/p>
3.2
锛?/p>
=3
B
銆?/p>
int
锛?/p>
2.6
锛?/p>
=3
C
銆?/p>
int
锛?/p>
3.2
锛?/p>
=3.2
D
銆?/p>
int
锛?/p>
2.6)=0.6
3
銆?/p>
杩愯涓嬮潰绋嬪簭娈碉細
For k=5 to 10 step 2
k=k*2
Next k
鍒欏惊鐜殑娆℃暟鏄紙
A
锛夈�?/p>
A
銆?/p>
1
B
銆?/p>
2
C
銆?/p>
3
D
銆?/p>
4
4
銆?/p>
涓嬮潰閫昏緫琛ㄨ揪寮忎腑锛?/p>
鑳藉鍑嗙‘琛ㄧず
鈥?/p>
x
鍜?/p>
y
閮芥槸濂囨暟鈥?/p>
鐨?/p>
VBA
琛ㄨ揪寮忔槸
锛?/p>
C
锛?/p>
銆?/p>
A
銆?/p>
x mod 2=1 or y mod 2=1
B
銆?/p>
x mod 2=0 not y mod 2=0
C
銆?/p>
x mod 2=1 and y mod2=1
D
銆?/p>
x mod2=0 and y mod 2=0
5
銆?/p>
VBA
琛ㄨ揪寮?/p>
iif("
鍛?/p>
"<"
鍒?/p>
",20,30)
鐨勫�兼槸锛?/p>
B
锛夈�?/p>
A
銆?/p>
20
B
銆?/p>
30
C
銆?/p>
10
D
銆?/p>
50
6
銆?/p>
VBA
涓畾涔夎繃绋嬬骇绗﹀彿鍙橀噺鍙互浣跨敤鍏抽敭瀛楋紙
B
锛夈�?/p>
A
銆?/p>
Const
B
銆?/p>
Dim
C
銆?/p>
Public
D
銆?/p>
Static
7
銆?/p>
宸插畾涔夊ソ鍑芥暟
F(m),
鍏朵腑褰㈠弬
m
鏄暣鍨嬮噺銆?/p>
涓嬮潰璋冪敤璇ュ嚱鏁帮紝
浼犻�掑疄鍙備负
5
锛?
灏嗚繑鍥炵殑鍑芥暟鍊艰祴缁欏彉閲?/p>
t
銆備互涓嬫纭殑鏄紙
C
锛夈�?/p>
A
銆?/p>
t=F(m)
B
銆?/p>
t=Call F(m)
C
銆?/p>
t=F(5)
D
銆?/p>
t=call F(5)
8
銆?/p>
鍦?/p>
VBA
浠ｇ爜璋冭瘯涓紝鑳芥樉绀哄嚭鎵�鏈夊湪褰撳墠杩囩▼涓殑鍙橀噺鍙婂彉閲忓�间俊鎭殑鏄?
锛?/p>
C
锛夈�?/p>
A
銆佺洃瑙嗙獥鍙?/p>
B
銆佺珛鍗崇獥鍙?/p>
C
銆佹湰鍦扮獥鍙?/p>
D
銆佸揩閫熺洃瑙嗙獥鍙?/p>
9
銆?/p>
涓嬪垪鍐呭涓笉灞炰簬
VBA
鎻愪緵鐨勬暟鎹獙璇佸嚱鏁版槸锛?/p>
A
锛夈�?/p>
A
銆?/p>
IsText
锛堬級
B
銆?/p>
IsDate
锛堬級
C
銆?/p>
IsNumeric
锛堬級
D
銆?/p>
IsNull
锛堬級
10
銆?/p>
VBA
涓笉鑳借繘琛岄敊璇鐞嗙殑璇彞缁撴瀯鏄紙
A
锛夈�?/p>
A
銆?/p>
On Error Then
鏍囧彿
B
銆?/p>
On Error Goto
鏍囧彿
C
銆?/p>
On error Resume Next
D
銆?/p>
On Error Goto 0
11
銆?/p>
宸茬煡绋嬪簭娈碉細
s=0
fori=0 to 10 step 2
s=s+1
i=i*2
nexti
褰撳惊鐜粨鏉熷悗锛屽彉閲?/p>
i
銆?/p>
s
鍊煎垎鍒负锛?/p>
B
锛夈�?/p>
A
銆?/p>
12
銆?/p>
3
B
銆?/p>
14
銆?/p>
3
C
銆?/p>
12
銆?/p>
4
D
銆?/p>
14
銆?/p>
4
12
銆?/p>
ADO
瀵硅薄涓昏鏈?/p>
Connection
銆?/p>
Command
銆侊紙
D
锛夈�?/p>
Field
鍜?/p>
Error 5
涓
璞°�?/p>