аЯрЁБс>ўџ 35ўџџџ2џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџьЅС` №ПВbjbjц‡ц‡ . „э„эВ џџџџџџЄЄЄЄЄЄЄЄИР Р Р Р д ИЖќ ќ ќ ќ ќ з з з ƒ … … … … … … $Кh"xЉ Єз з з з з Љ ЄЄќ ќ лО Г Г Г з "Єќ Єќ ƒ Г з ƒ Г Г ЄЄГ ќ № ЇляоХР љ .Г ƒ д 0Г š' ‚šГ šЄГ аз з Г з з з з з Љ Љ Љ з з з з з з з ИИИ„< „ИИИ< ИИИЄЄЄЄЄЄџџџџ Dr. Bordoloi MICROSOFT ACCESS LAB 1 ANSWERS Task8: Use One-Table Queries Query A: List all the author names with a last name beginning with one of the letters A, C or H. 1. With Query 1 highlighted, click on Design. 2. Leave what you already have in the first column alone. Still in the first column, go to the line below Like “C*” and type in A*. Go to the line below A* and type H*. Placing different conditions on different lines of a query is the way to get an “or” condition to work in Access. 3. Click on the Exclamation Point. Query B: List the Author Numbers of any second authors from the WROTE table. 1. Close answer table. 2. At the database window, click on Queries, then New. 3. Click on Design view, then OK. 4. Select WROTE table, then Add, then Close. 5. This time drag the Author Number name from the top part of the window to the first column below. 6. Then drag the Sequence Number name from the top part of the window to the second column below. 7. In the criteria row of the Sequence Number (second) column, type the number 2. 8. Click on the Exclamation Point. Task 9: Use Two-Table Queries Query C: List the Author Names of any second authors. 1. Close answer table and get back to the database window. 2. Click on Queries, then New. 3. Click on Design View, then OK. 4. Select AUTHOR table, then Add. Select WROTE table, then Add, then Close. 5. Drag the Author Name name from the AUTHOR table box in the top part of the window to the first column below. 6. Drag the Sequence Number name from the WROTE table box in the top part of the window to the second column below. 7. In the criteria row of the Sequence Number (second) column, type the number 2. 8. Click on the Exclamation Point. Query D: How many books in this list has Dick Francis written? (It makes no difference whether as author or co-author.) No detailed instructions here, but you will want to use the same two tables as above. Drag the Author Name name to the first column, and type Francis* in the criteria row. This entry says to match on Francis plus any other characters and spaces that may follow. An alternative way of entering this criterion is to type “Francis, Dick”. Drag the Book Code name to the second column. Now something new; Click on the big sigma icon on the toolbar. Click on Total row of the Book Code column, click on the drop-down arrow and choose count. This will give us a count of all the Book Codes corresponding to Francis, Dick. To add a more meaningful heading to the answer table, type Count of Books, then a colon, before Book Code in the first row of the second column. Query E: What authors have authored or co-authored two or more books? One solution: Select AUTHOR and WROTE tables Drag Author Name from AUTHOR table to first column Drag Book Code from WROTE table to second column Click on Totals icon (sigma) In the Total row of Book Code column, click on drop-down arrow and select Count In the Criteria row of Book Code column, enter >=2  "$,-.0QSZД" ( ) J P Q " $ % I l m t † ‹ Є ŸЁЂѕьузЫТЙЕАЈА œ˜‹˜ƒ‹˜{‹˜so kck˜[T h†sph•%hŸKh•%5hLh#!5h#!h†sph#!h#!5h#!h•%5h†sph•%5 h•%5h•%h•%5h•%hkzвh•%hиdо5hhuRhhuR5 hhuR5h1Рh\Ў5CJaJh•%5CJaJh1Рh1Р5CJaJh1Рha-–5CJaJha-–5CJaJh ;т5CJaJh ;тh ;тCJaJ  -./0RSДЕуў ! " o p ‡ О р q г % H њђђэсссссеееееееееееееее $ Ц№€a$gd•% $ Ц№€a$gdЏ @gd1Р$a$gd1Рgd ;тВ§H I l m Ѓ Є п ў l м PЂХ=>78~Ќп-mѓччччѓѓѓѓѓѓѓѓччѓчтчйййййй„8`„8gd•%gdиdо $ Ц№€a$gdЏ @ $ Ц№€a$gd•%ЂХЬ=>8?БВќє№ьќєьќшh/kRhиdоhŸKh•%hиdо5h•% m~БВііц$ Ц№€„8`„8a$gd•%„8`„8gd•%,1hАа/ Ар=!А"А# $ %ААаАа а†œ@@ёџ@ NormalCJ_HaJmH sH tH DAђџЁD Default Paragraph FontRiѓџГR  Table Normalі4ж l4жaі (kєџС(No ListВ  џџџџ -./0RSДЕуў!"op‡Ор qг%HIlmЃЄпў lмPЂХ=>7 8 ~   Ќ п  - m ~ Б Д ˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€=8 ~ Д {‰00~{‰00|A0š0€€\MЂВ H mВ В №8№@ёџџџ€€€ї№’№№0№( № №№B №S №ПЫџ ?№„ˆЉ­Д ŠŒ[^m p Д 333"$,..YZГIstЃХЫЬ<~  Б Д Д .х-L’љю #!•%Ѕk'Ђ+‹:Џ @`QEŸK/kRhuRUpp†spъ(u/8ygoS €Б‹l%Œ)l“ЈF•™|•a-–Ћa›[ }Ћ\ЎI{Б”{ЕР ЙМ Л1РFаl бkzв§ г‰Nкйeкиdо ;тН_щяыџ@€Д0XВ P@џџUnknownџџџџџџџџџџџџG‡z €џTimes New Roman5€Symbol3& ‡z €џArial"qˆ№аhhг‘fhг‘f4|&Оє Оє !№ ДД24d­ ­ 2ƒQ№HX)№џ?фџџџџџџџџџџџџџџџџџџџџџ”{Е2џџ!MICROSOFT ACCESS 97 LAB SESSION 1 Jamalўџр…ŸђљOhЋ‘+'Гй0œ˜ Ьиф№ќ , L X d p|„Œ”ф$MICROSOFT ACCESS 97 LAB SESSION 1  Normal.dotJamal2Microsoft Office Word@^аВ@hhžзЗУ@шŒвоХ@шŒвоХОє ўџеЭеœ.“—+,љЎ00 hpЄЌДМ ФЬдм ф ф,Southern Illinois University - Edwardsville­ и "MICROSOFT ACCESS 97 LAB SESSION 1 Title ўџџџўџџџ !ўџџџ#$%&'()ўџџџ+,-./01ўџџџ§џџџ4ўџџџўџџџўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџRoot Entryџџџџџџџџ РFрёяоХ6€Data џџџџџџџџџџџџ1TableџџџџšWordDocumentџџџџ. SummaryInformation(џџџџџџџџџџџџ"DocumentSummaryInformation8џџџџџџџџ*CompObjџџџџџџџџџџџџqџџџџџџџџџџџџўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџўџ џџџџ РFMicrosoft Office Word Document MSWordDocWord.Document.8є9Вq