[ Pobierz całość w formacie PDF ]
. If not, you can create a code module yourself and enter programs into it.To create thecode module:1.Select the Modules tab when the Library database is open in the Databasewindow.2.Click on the New button to create a new code module.3.When Access opens a new code module (which it will usually name Module1,unless your database already contains code modules saved with their defaultnames), click on the Save button on the toolbar.4.When Access displays the Save As dialog, enter the name of your new codemodule, Examples, in the Module Name text box and click OK.You can then begin entering code for each of the program examples.To do this, for eachcode example:1.Select the Procedure option from the Insert menu.2.When Access opens the Insert Procedure dialog, enter the name of the procedurein the Name text box.Since all of the programs listed in the book are subroutines,you don't have to worry about the dialog's other options.Just click OK.To run a program:1.Select the Modules tab in the Database window, and open the Examples module.2.Select the Debug Window option from theView menu.3.When Access opens the Debug window, simply type in the name of the programyou'd like to run.Appendix E.Suggestions for Further ReadingHere is a brief list of some books on database theory:Atzeni, P.and De Antonellis, V., Relational Database Theory, Benjamin Cummings,1993, 389 pages.A highly theoretical and mathematical treatment of the subject.Codd, E.F., The Relational Model for Database Management: Version 2, Addison-Wesley, 1990, 538 pages.The classic exposition of the relational model by one of itscreators and chief proponents.Date, C.J., An Introduction to Database Systems, 6th Edition, Addison-Wesley, 1995,839 pages.A less formal and highly readable book.Simovici, D.and Tenney, R., Relational Database Systems, Academic Press, 1995, 485pages.This is a very mathematical treatment of the subject.Much better written than theAtzeni and De Antonellis book. Ullman, J., Principles of Database and Knowledge-Base Systems, Volume 1: ClassicalDatabase Systems, Computer Science Press, 1988, 631 pages.A book with a somewhatdifferent point of view.Not as mathematical as Atzeni or Simovici, but moremathematical than Date.ColophonOur look is the result of reader comments, our own experimentation, and feedback fromdistribution channels.Distinctive covers complement our distinctive approach totechnical topics, breathing personality and life into potentially dry subjects.The animal on the cover of Access Database Design & Programming is a tamandua, oneof three species comprising the anteater family.The tamandua is also known as thecollared anteater (although vested anteater might be a better name).Tamanduas live inthe tropical rainforest.They spend much of their time in the forest canopy, feasting onants and termites; they often move awkwardly when they descend to the ground.Tamanduas use their powerful forearms for self defense.When attacked they will back upagainst a rock or cling to a tree branch with their hind legs while fighting and clawingwith their forearms.Amazonian Indians sometimes use tamanduas to clear their homes ofants and termites.Despite this useful trait, the tamandua is an endangered species.Theyare often killed for their tails, the tendons of which are used to make ropes.Clairemarie Fisher O'Leary was the production editor and copyeditor for AccessDatabase Design & Programming; Maureen Dempsey and Nancy Kotary providedquality control; Colleen Gorman and Anna Snow provided production assistance; RobertRomano created the illustrations using Adobe Photoshop 5 and Macromedia FreeHand 8;Mike Sierra provided FrameMaker technical support; Brenda Miller wrote the index.Edie Freeman designed the cover of this book using a 19th-century engraving from theDover Pictorial Archive.The cover layout was produced by Kathleen Wilson, usingQuarkXpress 3.3 and the ITC Garamond font.The inside layout was designed by AliciaCech, based on a series design by Nancy Priest, and implemented in FrameMaker 5.5 byMike Sierra.The text and heading fonts are ITC Garamond Light and Garamond Book.This colophon was written by Clairemarie Fisher O'Leary [ Pobierz całość w formacie PDF ]