Computer Based Training: Office 97, Windows 95 & NT Basics

home *** CD-ROM | disk | FTP | other *** search

/ Computer Based Training: …, Windows 95 & NT Basics / a1454501.iso / mo97a03 / AA02.CTL < prev next >

Wrap

Text File | 1997-05-14 | 36.0 KB | 1,282 lines

* SimScrn 2 1 11 ********************************* * Course: Advanced Access 97 * Unit: Working with queries Unit No.:02 * Topic: Total and summary queries Topic No.: 1 **** eff.exe a02_101.gif 0 459 0 1 0 15 15 15 * When defining queries you some isave 196 390 535 339 text1 textbox 196 390 535 339 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_102a.gif 222 180 0 1 0 15 15 15 eff.exe a02_102b.gif 344 227 0 1 0 15 15 15 * Instead you might wish to see, isave 196 344 535 288 text2 growbox 196 344 535 288 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_103a.gif 413 152 0 1 0 15 15 15 eff.exe a02_103b.gif 413 96 0 1 0 15 15 15 * A total query is a type of sel isave 196 293 535 237 text3 growbox 196 293 535 237 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 196 293 image memory text2 0 196 344 image memory text1 0 196 390 * eff.exe a02_104a.gif 403 226 0 1 0 15 15 15 eff.exe a02_104b.gif 499 226 0 1 0 15 15 15 eff.exe a02_104c.gif 499 93 0 1 0 15 15 15 * Suppose you are interested in isave 293 405 526 337 text1 textbox 293 405 526 337 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_105a.gif 2 458 0 1 0 15 15 15 * You decide to define a new que isave 293 342 526 269 text2 growbox 293 342 526 269 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 293 342 image memory text1 0 293 405 * eff.exe a02_106a.gif 64 276 0 1 0 15 15 15 * At this stage you have include isave 350 457 629 372 text1 textbox 350 457 629 372 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_107a.gif 64 316 0 1 0 15 15 15 eff.exe a02_107b.gif 64 276 0 1 0 15 15 15 * ≥ Unit Price (from the Product isave 350 377 629 338 text2 growbox 350 377 629 338 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_108a.gif 186 316 0 1 0 15 15 15 eff.exe a02_108b.gif 186 274 0 1 0 15 15 15 * ≥ Units sold (from the Sales t isave 350 343 629 304 text3 growbox 350 343 629 304 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_109a.gif 270 273 0 1 0 15 15 15 eff.exe a02_109b.gif 633 273 0 1 0 15 15 15 * ≥ an expression multiplying Un isave 350 309 629 253 text4 growbox 350 309 629 253 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 350 309 image memory text3 0 350 343 image memory text2 0 350 377 image memory text1 0 350 457 * eff.exe a02_110a.gif 60 256 0 1 0 15 15 15 eff.exe a02_110b.gif 192 272 0 1 0 15 15 15 eff.exe a02_110c.gif 192 72 0 1 0 15 15 15 * Notice that you can change a f isave 369 454 623 335 text1 textbox 369 454 623 335 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_111a.gif 76 274 0 1 0 15 15 15 eff.exe a02_111b.gif 354 273 0 1 0 15 15 15 eff.exe a02_111c.gif 354 70 0 1 0 15 15 15 * This is useful for making reco isave 369 340 623 267 text2 growbox 369 340 623 267 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 369 340 image memory text1 0 369 454 * eff.exe a02_112a.gif 0 458 0 1 0 15 15 15 eff.exe a02_112b.gif 342 273 0 1 0 15 15 15 * You can see the recordset resu isave 25 240 314 172 text1 textbox 25 240 314 172 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_113a.gif 0 458 0 1 0 15 15 15 * The recordset shows individual isave 25 177 314 104 text2 growbox 25 177 314 104 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** qcall AA02q 020101 eff.exe a02_114a.gif 450 323 0 1 0 15 15 15 eff.exe a02_114b.gif 630 147 0 1 0 15 15 15 * You can now group all the occu isave 25 109 314 19 text3 growbox 25 109 314 19 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 25 109 image memory text2 0 25 177 image memory text1 0 25 240 * eff.exe a02_115a.gif 2 452 0 1 0 15 15 15 * To do this you click the Total isave 18 177 315 126 text1 textbox 18 177 315 126 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_116a.gif 17 446 0 1 0 15 15 15 eff.exe a02_116b.gif 70 63 0 1 0 15 15 15 * A new row - the Total row - is isave 18 131 315 75 text2 growbox 18 131 315 75 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_117a.gif 17 263 0 1 0 15 15 15 * By default, the Total row cont isave 18 80 315 24 text3 growbox 18 80 315 24 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 18 80 image memory text2 0 18 131 image memory text1 0 18 177 * eff.exe a02_118a.gif 316 440 0 1 0 15 15 15 eff.exe a02_118b.gif 20 263 0 1 0 15 15 15 * The records will be grouped ac isave 73 163 313 95 text1 textbox 73 163 313 95 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_119a.gif 2 452 0 1 0 15 15 15 * Now the recordset shows one ro isave 73 100 313 27 text2 growbox 73 100 313 27 showtext 0 0 4 footnote 1 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 73 100 image memory text1 0 73 163 * eff.exe a02_120a.gif 2 452 0 1 0 15 15 15 * You can replace Group By in an isave 308 450 625 382 text1 textbox 308 450 625 382 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_121a.gif 20 427 0 1 0 15 15 15 eff.exe a02_121b.gif 20 265 0 1 0 15 15 15 eff.exe a02_121c.gif 615 265 0 1 0 15 15 15 * Alternatively, you can choose isave 308 387 625 314 text2 growbox 308 387 625 314 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_122a.gif 242 208 0 1 0 15 15 15 * Here, you require the Sum func isave 308 319 625 280 text3 growbox 308 319 625 280 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 308 319 image memory text2 0 308 387 image memory text1 0 308 450 * eff.exe a02_123a.gif 2 452 0 1 0 15 15 15 * Each Product Name entry in the isave 83 244 329 159 text1 textbox 83 244 329 159 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_124a.gif 7 418 0 1 0 15 15 15 eff.exe a02_124b.gif 295 392 0 1 0 15 15 15 eff.exe a02_124c.gif 295 41 0 1 0 15 15 15 * Also shown are the total numbe isave 83 164 329 74 text2 growbox 83 164 329 74 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 83 164 image memory text1 0 83 244 * eff.exe a02_125a.gif 2 452 0 1 0 15 15 15 * In addition to Group By and th isave 327 436 617 334 text1 textbox 327 436 617 334 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_126a.gif 57 130 0 1 0 15 15 15 * ≥ Wher isave 327 339 617 300 text2 growbox 327 339 617 300 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_127a.gif 56 170 0 1 0 15 15 15 * Expression allows you to creat isave 327 305 617 232 text3 growbox 327 305 617 232 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 327 305 image memory text2 0 327 339 image memory text1 0 327 436 * qcall AA02q 020102 eff.exe a02_128a.gif 56 170 0 1 0 15 15 15 eff.exe a02_128b.gif 237 197 0 1 0 15 15 15 * You can use Where, together wi isave 275 455 634 387 text1 textbox 275 455 634 387 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_129a.gif 56 431 0 1 0 15 15 15 eff.exe a02_129b.gif 495 431 0 1 0 15 15 15 eff.exe a02_129c.gif 56 256 0 1 0 15 15 15 * For example, you might be inte isave 275 392 634 319 text2 growbox 275 392 634 319 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_130a.gif 2 452 0 1 0 15 15 15 * Running the query now returns isave 275 324 634 268 text3 growbox 275 324 634 268 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** footnote 0 image memory text3 0 275 324 image memory text2 0 275 392 image memory text1 0 275 455 * eff.exe a02_131a.gif 2 452 0 1 0 15 15 15 * If you want the product names isave 324 405 603 320 text1 textbox 324 405 603 320 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_132a.gif 0 452 0 1 0 15 15 15 * Now the Product Name groups ar isave 324 325 603 269 text2 growbox 324 325 603 269 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 324 325 image memory text1 0 324 405 * SimScrn 2 2 11 ********************************* eff.exe a02_133.gif 0 459 0 1 0 15 15 15 * A summary query is a total que isave 4 200 268 132 text1 textbox 4 200 268 132 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * You click the New button on th notebox 275 183 507 ** eff.exe a02_135a.gif 20 427 0 1 0 15 15 15 eff.exe a02_135b.gif 547 434 0 1 0 15 15 15 eff.exe a02_135c.gif 11 18 0 1 0 15 15 15 eff.exe a02_135d.gif 547 18 0 1 0 15 15 15 * First you choose the fields yo isave 4 137 268 64 text2 growbox 4 137 268 64 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_136a.gif 35 376 0 1 0 15 15 15 eff.exe a02_136b.gif 35 77 0 1 0 15 15 15 * Now you can choose between a D isave 4 69 268 13 text3 growbox 4 69 268 13 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 4 69 image memory text2 0 4 137 image memory text1 0 4 200 * eff.exe a02_137a.gif 49 356 0 1 0 15 15 15 eff.exe a02_137b.gif 198 376 0 1 0 15 15 15 * The Summary Options button bec isave 38 187 316 119 text1 textbox 38 187 316 119 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02a138a.gif 26 398 0 1 0 15 15 15 eff.exe a02a138b.gif 25 371 0 1 0 15 15 15 eff.exe a02a138c.gif 514 53 0 1 0 15 15 15 *qcall AA02q 020103 eff.exe a02_138a.gif 157 315 0 1 0 15 15 15 * When you click the Summary Opt isave 38 124 316 34 text2 growbox 38 124 316 34 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 38 124 image memory text1 0 38 187 * eff.exe a02_139a.gif 507 426 0 1 0 15 15 15 eff.exe a02_139b.gif 25 315 0 1 0 15 15 15 eff.exe a02_139c.gif 507 102 0 1 0 15 15 15 * As well as selecting one or mo isave 277 458 584 373 text1 textbox 277 458 584 373 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_140a.gif 93 427 0 1 0 15 15 15 eff.exe a02_140b.gif 524 427 0 1 0 15 15 15 eff.exe a02_140c.gif 93 337 0 1 0 15 15 15 * You click OK to return to the isave 277 378 584 339 text2 growbox 277 378 584 339 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_141a.gif 26 398 0 1 0 15 15 15 eff.exe a02_141b.gif 35 371 0 1 0 15 15 15 * Then you click Next to continu isave 277 344 584 305 text3 growbox 277 344 584 305 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 277 344 image memory text2 0 277 378 image memory text1 0 277 458 * eff.exe a02_142a.gif 50 427 0 1 0 15 15 15 eff.exe a02_142b.gif 50 366 0 1 0 15 15 15 * Now you can give the query a t isave 273 436 544 368 text1 textbox 273 436 544 368 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_143a.gif 210 427 0 1 0 15 15 15 eff.exe a02_143b.gif 80 207 0 1 0 15 15 15 eff.exe a02_143c.gif 210 207 0 1 0 15 15 15 * When you click Finish, Access isave 273 373 544 300 text2 growbox 273 373 544 300 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 273 373 image memory text1 0 273 436 * eff.exe a02_144a.gif 2 452 0 1 0 15 15 15 eff.exe a02_144b.gif 2 18 0 1 0 15 15 15 * As you can see, your summary q isave 86 163 353 112 text1 textbox 86 163 353 112 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_145a.gif 2 452 0 1 0 15 15 15 * In the Datasheet View you can isave 86 117 353 27 text2 growbox 86 117 353 27 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 86 117 image memory text1 0 86 163 * * Topic: Crosstab queries Topic No.: 2 **** SimScrn 2 3 11 ********************************* eff.exe a02_201.gif 0 459 0 1 0 15 15 15 * A crosstab query is a special isave 289 456 627 388 text1 textbox 289 456 627 388 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_202a.gif 547 434 0 1 0 15 15 15 eff.exe a02_202b.gif 20 368 0 1 0 15 15 15 eff.exe a02_202c.gif 501 125 0 1 0 15 15 15 * For example, you could use a c isave 289 393 627 320 text2 growbox 289 393 627 320 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 289 393 image memory text1 0 289 456 * eff.exe a02_203a.gif 268 303 0 1 0 15 15 15 * You can easily create a crosst isave 389 441 623 356 text1 textbox 389 441 623 356 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 389 441 * eff.exe a02_204a.gif 20 453 0 1 0 15 15 15 eff.exe a02_204b.gif 11 18 0 1 0 15 15 15 * First you choose a table or qu isave 22 227 277 159 text1 textbox 22 227 277 159 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_205a.gif 53 430 0 1 0 15 15 15 eff.exe a02_205b.gif 53 149 0 1 0 15 15 15 * If you wish to use fields from isave 22 164 277 74 text2 growbox 22 164 277 74 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_206a.gif 53 393 0 1 0 15 15 15 eff.exe a02_206b.gif 371 372 0 1 0 15 15 15 * You double-click the required isave 22 79 277 6 text3 growbox 22 79 277 6 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 22 79 image memory text2 0 22 164 image memory text1 0 22 227 * eff.exe a02_207a.gif 68 421 0 1 0 15 15 15 eff.exe a02_207b.gif 68 87 0 1 0 15 15 15 * Now you choose the field(s) th isave 34 214 275 146 text1 textbox 34 214 275 146 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02a208a.gif 216 410 0 1 0 15 15 15 eff.exe a02a208b.gif 291 211 0 1 0 15 15 15 qcall AA02q 020201 eff.exe a02_208a.gif 258 386 0 1 0 15 15 15 eff.exe a02_208b.gif 291 211 0 1 0 15 15 15 * To select a field, you highlig isave 34 151 275 61 text2 growbox 34 151 275 61 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_209a.gif 258 401 0 1 0 15 15 15 eff.exe a02_209b.gif 244 211 0 1 0 15 15 15 * Then you click Next to continu isave 34 66 275 27 text3 growbox 34 66 275 27 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 34 66 image memory text2 0 34 151 image memory text1 0 34 214 * eff.exe a02_210a.gif 68 418 0 1 0 15 15 15 eff.exe a02_210b.gif 271 422 0 1 0 15 15 15 eff.exe a02_210c.gif 296 211 0 1 0 15 15 15 * Now you select the field that isave 7 326 318 258 text1 textbox 7 326 318 258 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Although you can select up to notebox 38 236 280 ** eff.exe a02_212a.gif 67 418 0 1 0 15 15 15 eff.exe a02_212b.gif 271 422 0 1 0 15 15 15 * Then you decide on a calculate isave 7 263 318 207 text2 growbox 7 263 318 207 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_213a.gif 305 336 0 1 0 15 15 15 * You select a field and a funct isave 7 212 318 156 text3 growbox 7 212 318 156 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_214a.gif 70 303 0 1 0 15 15 15 eff.exe a02_214b.gif 383 336 0 1 0 15 15 15 eff.exe a02_214c.gif 296 211 0 1 0 15 15 15 * If you don't need row sums you isave 7 161 318 105 text4 growbox 7 161 318 105 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * A row sum summarizes the calcu notebox 24 436 289 ** image memory text4 0 7 161 image memory text3 0 7 212 image memory text2 0 7 263 image memory text1 0 7 326 * eff.exe a02_216a.gif 65 431 0 1 0 15 15 15 * Finally you can name the query isave 28 207 256 139 text1 textbox 28 207 256 139 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_217a.gif 2 453 0 1 0 15 15 15 * In the Datasheet View you can isave 28 144 256 54 text2 growbox 28 144 256 54 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 28 144 image memory text1 0 28 207 * qcall AA02q 020202 eff.exe a02_218a.gif 2 452 0 1 0 15 15 15 * In Design View you can identif isave 3 331 265 229 text1 textbox 3 331 265 229 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_219a.gif 232 459 0 1 0 15 15 15 eff.exe a02_219b.gif 7 241 0 1 0 15 15 15 * Since the Crosstab Query Wizar isave 3 234 265 144 text2 growbox 3 234 265 144 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 3 234 image memory text1 0 3 331 * SimScrn 2 4 11 ********************************* eff.exe a02_220.gif 0 459 0 1 0 15 15 15 qcall AA02q 020203 * You can also create a crosstab isave 262 422 506 371 text1 textbox 262 422 506 371 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_221a.gif 9 409 0 1 0 15 15 15 eff.exe a02_221b.gif 297 211 0 1 0 15 15 15 * You can use the design grid to isave 262 376 506 286 text2 growbox 262 376 506 286 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_222a.gif 2 452 0 1 0 15 15 15 * City Sales is currently a sele isave 262 291 506 235 text3 growbox 262 291 506 235 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 262 291 image memory text2 0 262 376 image memory text1 0 262 422 * eff.exe a02_223a.gif 2 452 0 1 0 15 15 15 * To convert it to a crosstab qu isave 10 456 260 371 text1 textbox 10 456 260 371 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * Alternatively, you can choose notebox 44 348 226 ** eff.exe a02_225a.gif 282 434 0 1 0 15 15 15 eff.exe a02_225b.gif 8 228 0 1 0 15 15 15 * Now the Total and Crosstab row isave 10 376 260 320 text2 growbox 10 376 260 320 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_226a.gif 8 431 0 1 0 15 15 15 eff.exe a02_226b.gif 8 244 0 1 0 15 15 15 * You use the drop-down list in isave 10 325 260 235 text3 growbox 10 325 260 235 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 10 325 image memory text2 0 10 376 image memory text1 0 10 456 * eff.exe a02_227a.gif 26 427 0 1 0 15 15 15 eff.exe a02_227b.gif 26 227 0 1 0 15 15 15 * Each column heading must have isave 348 456 628 405 text1 textbox 348 456 628 405 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * Any field that provides row he notebox 380 381 596 ** qcall AA02q 020204 eff.exe a02_229a.gif 26 432 0 1 0 15 15 15 eff.exe a02_229b.gif 26 227 0 1 0 15 15 15 * For your crosstab query to wor isave 348 410 628 320 text2 growbox 348 410 628 320 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_230a.gif 161 432 0 1 0 15 15 15 eff.exe a02_230b.gif 161 216 0 1 0 15 15 15 eff.exe a02_230c.gif 418 216 0 1 0 15 15 15 * The field containing the Value isave 348 325 628 235 text3 growbox 348 325 628 235 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 348 325 image memory text2 0 348 410 image memory text1 0 348 456 * eff.exe a02_231a.gif 258 149 0 1 0 15 15 15 eff.exe a02_231b.gif 415 251 0 1 0 15 15 15 eff.exe a02_231c.gif 403 37 0 1 0 15 15 15 * Since you do not wish to use t isave 351 454 625 369 text1 textbox 351 454 625 369 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_232a.gif 0 444 0 1 0 15 15 15 eff.exe a02_232b.gif 424 431 0 1 0 15 15 15 * Now you can click the View but isave 351 374 625 318 text2 growbox 351 374 625 318 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_233a.gif 0 452 0 1 0 15 15 15 * Notice that entries in the Nam isave 351 323 625 233 text3 growbox 351 323 625 233 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 351 323 image memory text2 0 351 374 image memory text1 0 351 454 * eff.exe a02_234a.gif 26 459 0 1 0 15 15 15 eff.exe a02_234b.gif 159 459 0 1 0 15 15 15 * When you click the Close Windo isave 13 228 224 143 text1 textbox 13 228 224 143 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_235a.gif 2 459 0 1 0 15 15 15 * On the Queries tab, the icon n isave 13 148 224 58 text2 growbox 13 148 224 58 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 13 148 image memory text1 0 13 228 * * Topic: Hands-on: Customizing a crosstab query Topic No.: 3 **** SimScrn 2 5 11 MoveCtrl 1 493 426 0 0 ********************************* * Sometimes it is useful to base isave 29 395 369 344 text1 textbox 29 395 369 344 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 * For example, an existing query isave 29 349 369 276 text2 growbox 29 349 369 276 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 * image memory text2 0 29 349 image memory text1 0 29 395 * exercise 01 01 120 70 * * *task 1 0101 320 300 320 12 50 67 5 5 task 1 0101 0 300 320 12 50 67 5 5 pause 1 1 1 1 1 1 1 1 ** * SimScrn 2 6 11 ********************************* eff.exe a02_401.gif 0 459 0 1 0 15 15 15 * An action query is a query tha isave 8 228 306 177 text1 textbox 8 228 306 177 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_402a.gif 213 341 0 1 0 15 15 15 * There are four types of action isave 8 182 306 109 text2 growbox 8 182 306 109 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_404a.gif 213 341 0 1 0 15 15 15 eff.exe a02_404b.gif 335 341 0 1 0 15 15 15 * ≥ delete querie isave 8 114 306 75 text3 growbox 8 114 306 75 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_403a.gif 217 336 0 1 0 15 15 15 eff.exe a02_403b.gif 350 336 0 1 0 15 15 15 * ≥ append querie isave 8 80 306 41 text4 growbox 8 80 306 41 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_405a.gif 217 336 0 1 0 15 15 15 eff.exe a02_405b.gif 350 339 0 1 0 15 15 15 * ≥ update querie isave 8 46 306 7 text5 growbox 8 46 306 7 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text5 0 8 46 image memory text4 0 8 80 image memory text3 0 8 114 image memory text2 0 8 182 image memory text1 0 8 228 * eff.exe a02_406a.gif 23 353 0 1 0 15 15 15 eff.exe a02_406b.gif 204 360 0 1 0 15 15 15 * You might find that you often isave 11 449 298 381 text1 textbox 11 449 298 381 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_407a.gif 2 452 0 1 0 15 15 15 * In such a case, it could be us isave 11 386 298 313 text2 growbox 11 386 298 313 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_408a.gif 2 452 0 1 0 15 15 15 * You can create a new table by isave 11 318 298 245 text3 growbox 11 318 298 245 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 11 318 image memory text2 0 11 386 image memory text1 0 11 449 * eff.exe a02a409a.gif 154 457 0 1 0 15 15 15 qcall AA02q 020401 eff.exe a02_409a.gif 137 459 0 1 0 15 15 15 eff.exe a02_409b.gif 103 320 0 1 0 15 15 15 * To convert this select query t isave 144 200 477 132 text1 textbox 144 200 477 132 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Alternatively you can choose M notebox 189 110 438 ** eff.exe a02_411a.gif 72 459 0 1 0 15 15 15 * Then you type a name for the n isave 144 137 477 81 text2 growbox 144 137 477 81 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_412a.gif 143 319 0 1 0 15 15 15 eff.exe a02_412b.gif 474 336 0 1 0 15 15 15 * You can choose to add the new isave 144 86 477 13 text3 growbox 144 86 477 13 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 144 86 image memory text2 0 144 137 image memory text1 0 144 200 * eff.exe a02_413a.gif 72 430 0 1 0 15 15 15 eff.exe a02_413b.gif 140 430 0 1 0 15 15 15 * You can recognize this query a isave 323 273 603 205 text1 textbox 323 273 603 205 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_414a.gif 72 434 0 1 0 15 15 15 eff.exe a02_414b.gif 161 434 0 1 0 15 15 15 eff.exe a02_414c.gif 72 250 0 1 0 15 15 15 eff.exe a02_414d.gif 161 250 0 1 0 15 15 15 * Now you can make the new table isave 323 210 603 154 text2 growbox 323 210 603 154 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * You could also select Query - notebox 356 368 568 ** eff.exe a02_416a.gif 74 430 0 1 0 15 15 15 eff.exe a02_416b.gif 524 431 0 1 0 15 15 15 * Access asks you to confirm tha isave 323 159 603 86 text3 growbox 323 159 603 86 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 323 159 image memory text2 0 323 210 image memory text1 0 323 273 * eff.exe a02_417a.gif 2 452 0 1 0 15 15 15 * You can now see the new table isave 50 181 276 113 text1 textbox 50 181 276 113 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 50 181 * SimScrn 2 7 11 ********************************* eff.exe a02_418.gif 0 459 0 1 0 15 15 15 * An append query adds a group o isave 404 458 635 390 text1 textbox 404 458 635 390 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_419a.gif 2 452 0 1 0 15 15 15 * Suppose you have recently adde isave 404 395 635 322 text2 growbox 404 395 635 322 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_420a.gif 2 452 0 1 0 15 15 15 * You can use an append query to isave 404 327 635 254 text3 growbox 404 327 635 254 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 404 327 image memory text2 0 404 395 image memory text1 0 404 458 * eff.exe a02_421a.gif 7 403 0 1 0 15 15 15 eff.exe a02_421b.gif 20 367 0 1 0 15 15 15 * Again, it is convenient to con isave 11 181 310 130 text1 textbox 11 181 310 130 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_422a.gif 2 452 0 1 0 15 15 15 * You can use the Query Type but isave 11 135 310 79 text2 growbox 11 135 310 79 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_423a.gif 74 434 0 1 0 15 15 15 eff.exe a02_423b.gif 140 434 0 1 0 15 15 15 * Now you click OK in the Append isave 11 84 310 11 text3 growbox 11 84 310 11 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 11 84 image memory text2 0 11 135 image memory text1 0 11 181 * qcall AA02q 020402 eff.exe a02_424a.gif 140 431 0 1 0 15 15 15 eff.exe a02_424b.gif 8 206 0 1 0 15 15 15 eff.exe a02_424c.gif 582 206 0 1 0 15 15 15 * Before you run the query you m isave 375 278 632 193 text1 textbox 375 278 632 193 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_425a.gif 353 357 0 1 0 15 15 15 eff.exe a02_425b.gif 113 241 0 1 0 15 15 15 * You drag the field you want to isave 375 198 632 125 text2 growbox 375 198 632 125 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_426a.gif 258 431 0 1 0 15 15 15 eff.exe a02_426b.gif 24 242 0 1 0 15 15 15 eff.exe a02_426c.gif 542 242 0 1 0 15 15 15 * Then you type the condition(s) isave 375 130 632 57 text3 growbox 375 130 632 57 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 375 130 image memory text2 0 375 198 image memory text1 0 375 278 * eff.exe a02_427a.gif 2 452 0 1 0 15 15 15 * You can preview the records th isave 375 267 628 199 text1 textbox 375 267 628 199 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_428a.gif 2 459 0 1 0 15 15 15 * Then you return to Design View isave 375 204 628 131 text2 growbox 375 204 628 131 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_429a.gif 102 459 0 1 0 15 15 15 * You click Yes to confirm that isave 375 136 628 63 text3 growbox 375 136 628 63 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 375 136 image memory text2 0 375 204 image memory text1 0 375 267 * eff.exe a02_430a.gif 2 452 0 1 0 15 15 15 * Then you can return to the Dat isave 409 447 627 362 text1 textbox 409 447 627 362 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_431a.gif 2 452 0 1 0 15 15 15 * The new records have been adde isave 409 367 627 311 text2 growbox 409 367 627 311 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 409 367 image memory text1 0 409 447 * SimScrn 2 8 11 ********************************* eff.exe a02_432.gif 0 459 0 1 0 15 15 15 * Suppose you wish to discontinu isave 360 453 631 385 text1 textbox 360 453 631 385 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_433a.gif 250 330 0 1 0 15 15 15 * You can use a delete query to isave 360 390 631 317 text2 growbox 360 390 631 317 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 360 390 image memory text1 0 360 453 * eff.exe a02_434a.gif 2 459 0 1 0 15 15 15 * You begin by creating a select isave 321 285 624 217 text1 textbox 321 285 624 217 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_435a.gif 108 459 0 1 0 15 15 15 eff.exe a02_435b.gif 236 459 0 1 0 15 15 15 eff.exe a02_435c.gif 74 248 0 1 0 15 15 15 eff.exe a02_435d.gif 236 248 0 1 0 15 15 15 * Then you select Delete Query f isave 321 222 624 166 text2 growbox 321 222 624 166 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_436a.gif 258 446 0 1 0 15 15 15 eff.exe a02_436b.gif 30 245 0 1 0 15 15 15 * Now you insert all the fields isave 321 171 624 115 text3 growbox 321 171 624 115 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_437a.gif 55 430 0 1 0 15 15 15 eff.exe a02_437b.gif 55 244 0 1 0 15 15 15 * Access automatically inserts t isave 321 120 624 64 text4 growbox 321 120 624 64 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 321 120 image memory text3 0 321 171 image memory text2 0 321 222 image memory text1 0 321 285 * eff.exe a02_438a.gif 55 430 0 1 0 15 15 15 eff.exe a02_438b.gif 55 244 0 1 0 15 15 15 * In the design grid you also ne isave 347 282 625 214 text1 textbox 347 282 625 214 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_439a.gif 186 328 0 1 0 15 15 15 * Access inserts the word "Where isave 347 219 625 129 text2 growbox 347 219 625 129 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_440a.gif 2 452 0 1 0 15 15 15 * You can use the Datasheet View isave 347 134 625 61 text3 growbox 347 134 625 61 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 347 134 image memory text2 0 347 219 image memory text1 0 347 282 * eff.exe a02_441a.gif 2 452 0 1 0 15 15 15 * When you are satisfied that th isave 18 184 278 99 text1 textbox 18 184 278 99 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** qcall AA02q 020403 eff.exe a02_442a.gif 163 427 0 1 0 15 15 15 eff.exe a02_442b.gif 524 431 0 1 0 15 15 15 * You cannot undo a delete actio isave 18 104 278 31 text2 growbox 18 104 278 31 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 18 104 image memory text1 0 18 184 * eff.exe a02_443a.gif 163 459 0 1 0 15 15 15 eff.exe a02_443b.gif 524 459 0 1 0 15 15 15 * If the related table is open w isave 364 449 624 381 text1 textbox 364 449 624 381 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_444a.gif 2 459 0 1 0 15 15 15 * The table now shows where the isave 364 386 624 330 text2 growbox 364 386 624 330 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_445a.gif 2 389 0 1 0 15 15 15 eff.exe a02_445b.gif 2 41 0 1 0 15 15 15 * When you next open the table t isave 364 335 624 279 text3 growbox 364 335 624 279 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 364 335 image memory text2 0 364 386 image memory text1 0 364 449 * qcall AA02q 020404 eff.exe a02_446a.gif 2 408 0 1 0 15 15 15 eff.exe a02_446b.gif 2 39 0 1 0 15 15 15 * However, records meeting the c isave 93 186 463 135 text1 textbox 93 186 463 135 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_447a.gif 2 452 0 1 0 15 15 15 * Access cannot delete records f isave 93 140 463 67 text2 growbox 93 140 463 67 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_448a.gif 92 459 0 1 0 15 15 15 * You take away the selected tab isave 93 72 463 16 text3 growbox 93 72 463 16 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 93 72 image memory text2 0 93 140 image memory text1 0 93 186 * eff.exe a02_449a.gif 48 459 0 1 0 15 15 15 eff.exe a02_449b.gif 322 434 0 1 0 15 15 15 * Now you click the Run button a isave 329 320 626 269 text1 textbox 329 320 626 269 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * If you run a delete query on a notebox 336 247 614 ** eff.exe a02_451a.gif 48 417 0 1 0 15 15 15 eff.exe a02_451b.gif 524 431 0 1 0 15 15 15 * You click Yes to proceed when isave 329 274 626 218 text2 growbox 329 274 626 218 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a02_452a.gif 0 459 0 1 0 15 15 15 * The Products table (which was isave 329 223 626 150 text3 growbox 329 223 626 150 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 329 223 image memory text2 0 329 274 image memory text1 0 329 320 * * Topic: Hands-on: Creating and running an update query Topic No.: 5 **** SimScrn 2 9 11 ********************************* MoveCtrl 1 493 426 0 * Suppose you want to make chang isave 19 286 281 201 text1 textbox 19 286 281 201 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * For example, the current datab isave 19 206 281 116 text2 growbox 19 206 281 116 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** * image memory text2 0 19 206 image memory text1 0 19 286 ** exercise 02 3 120 70 task 2 0102 280 300 360 4 70 67 35 75 * pause 1 1 1 1 1 1 1 1 * ** ************************* SimScrn 2 10 11 ************************* task 03 0103 404 320 236 4 70 67 35 75 * pause 1 1 1 1 1 1 1 1 1 * ** SimScrn 2 11 11 task 04 0104 404 320 236 4 70 67 35 75 * pause 1 1 1 1 1 1 1 1 1 **