计算机二级ACCESS(笔试).doc

:_ :_ :_ 计算机二级ACCESS(笔试)228(270) ABCD 1.( )A: B: C: D: 2.( )A: B: C: D: 3.Cfloat4double( )A: 1B: 2C: 8D: 44.e1e2e3e4( )A: e3e1e4e2B: e2e4e3e1C: e3e4e2D: 5.(DBMS)( )A: CB: BasicC: DDLD: DML6.3( )A: B: C: D: 7.( )A: B: C: D: 8.( )A: B: C: D: 9.( )A: B: C: D: 10.( )A: B: C: D: 11.( )A: B: C: D: 12.Access( )A: B: C: /D: 13.( )A: B: C: D: 14.( )A: B: C: D: 15.Access( )A: B: C: D: 16.(NULL)( )A: SUMB: AVGC: MAXD: COUNT17.( )A: B: C: D: Access18.( )A: (?)(*)B: C: Like6/*/98*D: M*sMorrrisMastersMiller Peters19.Access( )A: ()B: C: D: 20.SQL( )20.A: SelectFrom sc Where(Select avg()From sc)B: SelectWhere(Select avg()From sc)C: Selectavg()From SCD: Select(Select avg()From sc)21.Access( )A: AutoB: AutoExecC: Auto.batD: AutoExec.bat22.Access( )A: B: C: D: 23.( )23.A: .=80 AND .=90B: .=80 AND .90C: 80=.=90D: 80.9024.( )A: B: C: D: 25.( )A: B: C: D: 26.Requery( )A: B: C: D: 27.( )A: B: C: D: 28.VBA3*33/3( )A: 0B: 1C: 3D: 929.DAO( )A: B: C: D: Active30.Access()( )A: DefaultB: CancelC: EnabledD: Visible31.( )A: Rnd09B: IntFixC: StrD: ChrASCII32.Dim Newarray(10)As Integer( )A: 10B: 10C: 11D: 1033.( )A: Day(Date)B: Year(Date)C: Year(Day(Date)D: Day(Year(Date)34.(Command1)Private Sub Command1_Click()For i=1 To 4x=4For j=1 To 3x=3For k=1 To 2x=x+6Next kNext jNext iMsgBox xEnd Sub( )A: 7B: 15C: 157D: 52835.Lb1Command1Option Com pare DatabaseDim a As String*10Private Sub Command1_Click()a=1234b=Len(a)Me.Lb1.Caption=bEnd Sub( )A: 4B: 5C: 10D: 40(230)36.n_37._38.4_39.500_40.32front=3rear=2_41._42.VBA_43.Right(4)_44.SQL_45._46.Command1Private Sub Command1_Click()Dim siFor i=1 To 10s=s+iNext iMsgBox sEnd Sub_47._Private Sub Form_Click()Dim Str As StringStr=S=AccessFor i=Len(S)To 1 Step-1Str=Str & Mid(Si1)Next iMsgBox StrEnd sub48.Array8Text1Option Base 1Private Sub Command1_Click()Dim arr1()Dim Min As Integer, i As Integerarr1=Array(1243576-24785486643)Min=_For i=2 To 8If art1(i)Min Then _Next iText1=Min49.x=0Dox=x+1Loop While x=_4:0.0/35.0:0/35:0/14.0:0/14()Section 0.0/35.00/350.0/0.00/00.0/0.00/00.0/14.00/141 :B:2 :C:3 :C:C16int2float4double84 :B:()e1B5 :C:Data Definition Language(DDL)SQL6 :B:(1)(2)(3)7 :A:C8 :D:9 :A:A(Array)10 :C:711 :D:12 :B:AccessAccess/OLE/OLEAccess25564000/8413 :B:Access14 :A:()()(-)15 :D:16 :D:AccessSUMAVGMAXMINCOUNTCOUNT17 :B:18 :C:*?!-#?*#19 :B:Access20 :A:sc(select avg()from sc)21 :B:AccessAutoExecAutoExec.bat22 :A:Access23 :A:BetweenAnd=And=24 :C:Access25 :B:26 :A:Access50RequeryFindRecordFindNextGoToRecord27 :B:Access28 :D:VBA(3*3)(3/3)=929 :B:VBA3(ODBC)(DAO)Active(ADO)ADOConneclionCommandRecordSETFieldError530 :C:VBADefaultCancelEnableVisible31 :D:VBARnd01IntFixStrChrASCII32 :C:Dim Dim(to) 0=-+133 :B:Year(date)34 :B:x4x3x3x=3+6+6=1535 :C:VBAStringa10Len(a)=1036 :n/237 :38 :439 :250:nint(n/2)40 :31:mrearfrontrear-frontrearfrontm+(rear-front)rearfrontm=32+(2-3)=3141 :Time:DateTimeNow42 :Variant:VBA(Variant)VBAVariant43 :VBALeft()nRight()nMid()24Mid(s24)44 :RunSQL:RunSQLSQLRunAPP45 :46 :55:s010s1105547 :sseceA:StrSii48 :arr1(1) Min=arr1(i):2