Access1Access11.database,databasesystems2.(databasemanagementsystem)Access2dbms3.4.5.2SQL1.SQLSQLSQLAccess3SQLSQLSQLSQL2.SQL?SQL4DDL-DataDefinitionLanguageDQL-DataQueryLanguageDML-DataManipulationLanguageDCL-DataControlLanguage3.31=Access42LEFTOUTER3Access54Access20101.Access20102.Access2010Access20103.Access2010123456Access651.Access201012342.33.Access74.Access2010Access2010//OLE61.312()32.Access83.4.ACCESS()()()5.Access9Access6.71.()Access102.5SQLSQLSQL3.AccessAccess114.SQLSQLSQLAccess2010SQL12SQLAccess2010Access12ADOSQL3SQLDDL4SQLSQLSelectSQLSelect5.81.Access131232.Access12343.123Access144564./91.1232.AccessAccess15Access412343.4.AccessAccess16101.1232.OpenForm3.RunMacro4.MsgBoxAccess175.11VBA1.AccessAccessVBAAccess2.3.12Access1834.VBAVBA5.VisualBasicVBA3ForWhileDoForWhileDo121Access2010Access192Backstage2./Access20Access213.MicrosoftAccessMicrosoftAccess4.1Access2010BackstageAccess22234Access2010Backstage55.1ACCESS20102Backstage3WindowsAccess234MicrosoftAccess5