六:Forms(form)
1.form的引用:Count;Forms!formname ;Forms![form name];Forms ("formname");Forms(index);Controls; Forms!OrderForm.ctlSubForm.Form!Controls.NewData
2.Form方法:Recalc重新計算控件;Refresh;Requery;Gotopage;Undo;setfocus
3.Form屬性:recordsource;Allowedits;Timerinterval;Visible
4.Form事件:Open/Close;current;Timer;Beforeupdate/afterupdate;Click/dblclick
七:Docmd
1.Openform 2.Openreport 3.Clos 4.Printout 5.Requery 6.Runcommand 7.Restore/Maximize/Minimize 8.Outputto 9.Runsql 10.Movesize 11.selectobject 12.showallrecords
八:Reports
1.Format 2.Print 3.Open 4.nodata
九:其他對象的使用
1.screen對象:Activecontrol;activeform;activereport;activedatasheet;Mousepointer;Previouscontrol
2.CurrentProjecallforms;allreports;Path;name;fullnameConnectionBaseconnectionstring
3.Currentdata
Alltables;allquerys;Accessobject;Isloaded;Name;Type
十:使用Ado對象模型訪問數(shù)據(jù)庫
1.Connection 2.Command 3.Recordset 4.Connection 5.創(chuàng)建記錄集的方法 6.Recordset的編輯 7.事務處理 8.窗體記錄的定位 9.窗體記錄的移動