access buttons and macros - microsoft office training

《access buttons and macros - microsoft office training》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Accessbuttonsandmacros(acc-t10)AccessbuttonsandmacrosPracticalworkbookAimsandLearningObjectivesBytheendofthiscourseyouwillbeableto:·createbuttonsonaformtoautomateyourdatabase;·createsimplemacros;·createconditionalmacros;·runthemacrosindifferentwaysdependingonthesituation.Accessbuttonsandmacros

2、(acc-t10)DocumentinformationCoursedocumentsandfilesIfyouareworkinginthetrainingroomthefilesyouneedareinC:UserAccessMacros.Ifyouwanttoworkthroughthepracticaltasksshowninthisdocumentonyourownsystem,obtainthenecessaryfilesfrom:www.bristol.ac.uk/is/learning/documentation/docs-current.html#acc-t

3、10.YouwillseealinktoPracticefiles.Thiscontainsthefilesyouneedtoworkthroughthecoursenotes.InInternetExploreryouextractthefilesasfollows:·ClickonPracticefiles;·ChooseSave.·BrowsetowhereyouwanttosavethefileandclickonSave(thepracticefilesaregroupedtogether,andyouneedtoextractthemtobeabletousethein

4、dividualfiles);·Gotothefileyouhavejustsaved,andOpenorRunittoshowtheSelf-extractingArchivebox;·Selectwheretoextract(save)thefilesonyoursystemusingthebrowsebutton(asshownopposite);·ClickStarttosavethefiles.RelateddocumentationOtherrelateddocumentsareavailablefromthewebat:www.bristol.ac.uk/is/lea

5、rning/documentation/docs-by-category.html#db.Accessbuttonsandmacros(acc-t10)IntroductionButtonsonAccessformsperformanactionwhenyouclicktheminformview.Macrosconsistofalistofactionsdesignedtoperformasingletaskoraseriesofcommontasksautomatically,suchasopeningaformorprintingareport.Thiscourseguide

6、syouthroughtheprocessesneededtocreatebuttonsandmacrosandthereforebegintoautomateyourdatabase.PrerequisitesAttendanceonInformationServicescourseUsinganddesigningAccessdatabases(codeCC1ACC).Accessbuttonsandmacros(acc-t10)ContentsDocumentinformationTask1Lookatsamplebuttons1Task2Howtocreateabutton

7、2Task3Runningamacro4Macrotoolbar4Task4Creatingasimplemacro6Openingaformusingamacro7Task5Runmacrosusingbuttons9Task6Displayingmessages11Task7Changingpropertiesandvalues12Task8Conditionalmacros14Usefuladditionalmacros15Task9Refresh/Repain