Introductio
Access2003isanimportantpartofMicrosoft'sOffice2003officesoftware.Itisasimple,easy-to-use,fastandconvenientdatabasemanagementtool.Thebookfocusesondataprocessingflow,transformingcomplexdatabasetheoryintomultipleeasy-to-understandtasks.EachtaskisrealizedwiththehelpofAccess2003,adevelopmenttool,andfinallysummarizedintoalargecomprehensiveexample.Thebookisdividedinto6modules,andeachmoduleissubdividedintomultipletasks.Eachtaskisguidedbyexamples.Theoperationstepsareclear.Itishelpfulforbeginnerstolearnthebasicknowledgeofthedatabasesystematically,andmasterthedevelopmentmethodsandmethodsofthedatabasemanagementsystem.Theprocesscanalsobeusedasareferenceforothercomputerprofessionals.
Catalogueofworks
Module1Firstunderstandingofthedatabase
Task1UsetheDongdongflowershopmanagementsystem
Task2Collectandorganizedata
Task3UnderstandAccessdatabasemanagementsystem
Module2Createadatabase
Task1Createadatabase
Task2Createatablebyinputtingdata
Task3Usethewizardtocreateatable
Task4Createatableinthedesignview
Task5Createarelationshipbetweentables
Module3Maintainthedatabase
Task1Maintainthetablestructure
Task2Edittablerecords
Task3Maintainthedatabase
Task4DataimportandExport
Module4Querydata
Task1Querydatabasis
Task2Queryorderinformationonthedayofcreation
Task4Create, modifyandsendCargoidentificationquery
Module5Outputdata
Task1Createdeliveredstatisticalreport
Module6Integrateddesignsystem
Task1Createadeliveryinformationbrowsingform
Task2Createagiftandflowermanagementform
Task4Createamain/subform
Appendix
AppendixACommonlyusedmacrooperationcommands
AppendixBCommonpropertiesofformsandreports
Objectdetectionquetions