当前位置:首页 > IT计算机/网络 > 计算机应用/办公自动化 > 数据库ACCESS 理论课电子教案
2201691()Access2010(1)(2)(3)ACCESSOFFICEWORD|EXCEL|POWERPOINTACCESSOFFICE2010OFFICE201035031%1103201691()2Access2010(1)(2)Access201012Setup.exeAccessAccess4201694()34(1)(2)(3)12121:DataBaseDBMS(DBS)5(DBA)23.12(,)356201698()56models=r2DBMS1Access273456712345121.482016911()78ACCESS2010Access2010Access2010Access2010Access20102.1Access20101Access20101.2.2Access2010Alt+f42.2Access20101232.3AccessAccess20101Access2010234567VBA2.4Access9122.512342.6Access20102.7Access1255264000309+-P412.34/8526123Access47/Yes/NoTure/FalseOn/Off8OLEOLEWord910102016915()910Access2010Access2010Access2010a1~64b1234/567/8OLEword/Excel//9101112c11abc/0--0-99--2.5p40deandorfg122016918()1112Access2010Access2010Access2010123451213370%+30%[]*0.7+[]*0.345123/44.14.2142016922()1314Access2010Access2010Access20101AccessAccessAccessNullAccess32Access3:Access151Ctrl2162016925()15163121P692.923456117234563.212Null3121OLE23;;/12345182016929()1718ACCESSACCESSACCESSACCESS*A*SACCESS,ABSBASS,ASSA?A?CABC,AAC,A3CAACC,A22C#1#3103,113,1231a3,1223,1333[]A[BC]DABD,ACDABCD,AAD,ADD!A[!BC]DAAD,AEDABD,ACD19-A[a-c]DAaD,AbD,AcDAdD,AeD,AfDA[1-3]DA1D,A2D,A3DA4D,A5D,A6D1Access23;;;;;4Delete202016109()1920ACCESSACCESSACCESS7SQLSQLSQLSQL211211L01()L012,L0223:L03(,4L04,5L052220161013()2122ACCESS.SQL4.212*4-67504.316232*7507504.4123456*116L0671823L072420161016()2324ACCESSAccessAccess128-3.2872'''3#:#2006-10-25#2008914True/On/YesFalse/Off/No5isNullisNotNull6![][]![]Access1234561+-Modmod(10,3)=1mod(4,2)=0mod(2,3)=2\*/-^2^3=8225+&+&+&23233+-4===81990L084and23and24or23or24not92090L09102008L105betweenandbetween20and30between#2007-1-1#and#2007-1-31#112022L11inin(18,20,21,25)in(,)1218202123L12likelike*like**13L1314L142620161020()2526AccessAccessACCESSAccess1231AbsSqrSgn1,0,-1Int2Left15200803L1527Right16L16Mid117L17Len18L18SpaceString3Date19100L19Year2010L20MonthDay2191L21Weekday122L22Hour2820161023()2728AccessAccessAccessAccess123123L23:24L2422925L2526L2627L2728L2829L2930L3031L3132L3233s_dataL3334L3435s_data,L3536L3637L373020161027()2930AccessAccessAccessAccess38L3812313439L39)40L40Access3220161030()3132AccessAccessAccessAccess[]41L4142L424390L4344tOfficeL4433123Where4545L4546200803L461234547L47488L4849200804200802L491234,550t2L5051t1L51Access342016113()3334SQLAccessSQLAccessSQLAccessSQLAccessSQLSQLSQLSQLSQLSQLSQL1.Create2.Alter3.Drop4.Insert5.Update6.Delete7.Select1.CreateCREATETABLE(11[1][22[2]][,,][,nn[n]])[,1]52CREATETABLESMALLINTPrimaryKey,CHAR(4)NotNull,CHAR(1),DATE,CHAR(20),MEMO2.Alter35ALTERTABLE[ADD[]][DROP[][ALTER]5381SQLALTERTABLEADDCHAR(10)2SQLALTERTABLEDROP3SQLALTERTABLEALTERCHAR(8)3.DropDROPTABLE54DROPTABLE4.InsertINSERTINSERTINTO[(1[,2])]VALUES(1[,2]55INSERTINTOVALUES(0001,,,#1960-1-1#,)#560002INSERTINTO(,,)VALUES(0002,,)AccessSQL362016116()3536SQLAccessSQLAccessSQLAccessSQLAccessSQL5.UpdateUPDATEUPDATESET1=1[,2=2][WHERE]571960-1-11UPDATESET=#1960-1-11#WHERE=6.DeleteDELETEDELETEFROM[WHERE]580002DELETEFROMWHERE=00027.SelectSQLSELECT37SELECT[ALL|DISTINCT]*|FROMWHEREGROUPBYORDERBY[ASC|DESC]1:,*:2ALL:DISTINCT:3FROM4WHERE5GROUPBY6ORDERBY:ASCDESC7,8FROM9SELECT596061199262As6364AccessSQL3820161110()3738SQLAccessSQLAccessSQLAccessSQLAccessSQLSQL1.2.3.4.SQLSelectSelectSelect6839SELECT10AccessSQL4020161113()3912Access,.:Access4120161113()4012Access4220161117()4143Access4420161117()421LR01452LR023LR034LR045LR05Access4620161120()436LR067LR078200803LR08selectAccess4720161120()4445*rReader:1rReaderbTitle220.522rReadertSex489LR09*LR19*.mdbtBandtLinerBand1bTitle222tName3IDbCount4*.mdbtEmployeetGroupqEmployee()rEmployee1bTitle20.15.2tSex3tDepttGroup=DLookUp(,tGroup,=,&[]&,)Access4920161124()464712341010LR10123411LR11*501/12LR122*2LR12*samp3.mdbtStudqStudqStudrStud1bTitle20.15.2tSex3tSex1240.24.5tAvg*samp4.mdb1salarysavgssum2++++--Access5120161127()4849OLE524.Access532016121()505111.2.2LF02543LF034LF045LF051.2.3.6LF06Access552016124()5253123SQL3.121234567568OLE9OLE1011121231231211232*LF07*Select*7LF07Access572016128()547LF071..2..3..4..5..6.:8LF08.7..8.9.==9LF095820161211()555610LF07123Tab11LF07bTitle31615918*fEdit1Lremark255234cmdquit128*fs1bTitle2tSex30.23.8bMem4bOkbQuit5*fStaff1bTitle2optbopt3opt1opt2bopt1bopt24bOkbQuit5Access6020161215()5758.12345612LF1261*h1h2h3Lj25Access6220161218()5913LF0714LF1431891011Access6320161218()60ACCESS___A)B)C)D)______A)B)C)D)4.OpenTableOpenQueryOpenFormOpenReportCloseAccessQuitGotoRecordSetValueMaximizeMinimizeRestoreBeepMsgBoxAccess6420161222()61ACCESS17AccessForms![]![]Reports![]![]2LM02ttt1t2t1t2t1t2121.2AutoExecShiftAccess6520161225()62ACCESS3Access6620161225()63ACCESSVBAVisualBasicVisualBasic1LM012LM02Access6720161229()64VBAACCESSVBAVBAVBAVBEVisualBasic..VBE()VBEVB()VBE3LM02VisualBasicVisualBasicVBEVisualBaiscEditorVBAVBEAccessVBA68201714()6566ACCESSVBAVBA1.2.TrueFalseTrue-1False00FalseTrue2./##2008-7-4#3.VBAVBAAccessTrue)FalseConst=12TrueFalseYesNoOnOffNullac694VBA1[]=Dim[as]1234OptionExplicit2[Let]=5VBA121Dim[to][as]to02Dim[1to]1[2to]2[as]11221,2Access70201715()6768VBAACCE
本文标题:数据库ACCESS 理论课电子教案
链接地址:https://www.777doc.com/doc-8527800 .html