学习ACCESS心得体会.doc

accessaccessaccess accessaccessmicrosoft office access microsoft jet database engine weba1access.mdb(2)access3access4accessexcelwordaccessbaccessaccess1. access50m2. 1003. 101. accessaccess?2009-9-292. accesssql3. access4. accessidididididididaccessaccessaccess15. 3 4accessaccessaccessaccessaccess () accessaccessaccessaccessaccess():.access50!access2003access2003 :2009-10-21 12:20:22 :bluebird :access2 :accesswordofficeaccessaccessaccess11xxidxxidselect distinctaccess48accessvba90%access1 : int(datediff(d,now()+int(format(now(),mmdd)<format(,mmdd)2=format(datediff(d,now()+int(format(now(),mmdd)<format(,mmdd)/365,standard)32format(datediff(d,forms!txtstartdate,forms!txtenddate),#,#)4=format(21320.32143,$#,#0.00green;($#,#0.00)red)$21,320.325100%=format(0.13980143,%#,#0.00;red)6private sub report_nodata(cancel as integer)msgbox ., vbexclamation, no recordscancel = trueend sub75>=dateadd(yyyy,-5,forms!txtstartdate) and <=forms!txtenddate>=forms!txtstartdate and <=forms!txtenddate8=format(/365,standard)9<=forms!txtenddate>=forms!txtstartdate10dateadd()11=&&2&#,#format(sum(),#,#)= 1985 & format(now(),yyyymmdd) & xxxxx & count() & & & format(sum()+sum(),#,#) & & format(sum()+sum(),#,#) & & format(sum(),#,#) & & format(sum(),#,#) & & format(sum(),#,#) & & format(sum(),#,#) & & format(sum(),#,#) & & format(sum()+sum(),#,#) & & format(sum(),#,#) & & format(sum()/(sum()+sum(),percent)= & format(forms!txtstartdate,yyyymmdd) & & format(forms!txtenddate,yyyymmdd) & & format(datediff(d,forms!txtstartdate,forms!txtenddate)/365,standard) & ( & format(datediff(d,forms!txtstartdate,forms!txtenddate),#,#) & )xxxxx & count() & & & format(sum()+sum(),#,#) & & format(sum()+sum(),#,#) & & format(sum(),#,#) & & format(sum(),#,#) & & format(sum(),#,#) & & format(sum(),#,#) & & format(sum(),#,#) & & format(sum()+sum(),#,#) & & format(sum(),#,#) & & format(sum()/(sum()+sum(),per