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 / mo97a02 / IA03.CTL < prev next >

Wrap

Text File | 1997-05-08 | 52.4 KB | 1,881 lines

* SimScrn 3 1 7 ********************************* * Course: Intermediate Access 97 * Unit: Reports Unit No.:03 * Topic: Using reports Topic No.: 1 **** eff.exe i03_101.gif 0 459 0 1 0 15 15 15 * Reports are an effective way o isave 249 315 463 230 text1 textbox 249 315 463 230 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 249 315 * eff.exe i03_102a.gif 2 452 0 1 0 15 15 15 * Although you can also print a isave 10 191 241 123 text1 textbox 10 191 241 123 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_103a.gif 0 455 0 1 0 15 15 15 * They can compare, summarize, a isave 10 128 241 72 text2 growbox 10 128 241 72 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_104a.gif 369 377 0 1 0 15 15 15 * Using a report also gives you isave 10 77 241 4 text3 growbox 10 77 241 4 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 10 77 image memory text2 0 10 128 image memory text1 0 10 191 * eff.exe i03_105a.gif 305 393 0 1 0 15 15 15 * Most of the information in a r isave 6 333 273 265 text1 textbox 6 333 273 265 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_106a.gif 2 425 0 1 0 15 15 15 eff.exe i03_106b.gif 2 405 0 1 0 15 15 15 eff.exe i03_106c.gif 622 310 0 1 0 15 15 15 * Other information, such as add isave 6 270 273 197 text2 growbox 6 270 273 197 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_107a.gif 378 313 0 1 0 15 15 15 * For example, you might design isave 6 202 273 129 text3 growbox 6 202 273 129 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 6 202 image memory text2 0 6 270 image memory text1 0 6 333 * eff.exe i03_108a.gif 0 455 0 1 0 15 15 15 * Reports have three views: Desi isave 356 310 612 208 text1 textbox 356 310 612 208 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_109a.gif 14 365 0 1 0 15 15 15 * Design view is used when you w isave 356 213 612 140 text2 growbox 356 213 612 140 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 356 213 image memory text1 0 356 310 * eff.exe i03_110a.gif 14 404 0 1 0 15 15 15 * You can use Print Preview to s isave 365 311 616 243 text1 textbox 365 311 616 243 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall IA03q 030101 eff.exe i03_111a.gif 14 404 0 1 0 15 15 15 * Layout Preview is a quick way isave 365 248 616 124 text2 growbox 365 248 616 124 showtext 0 0 7 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 365 248 image memory text1 0 365 311 * eff.exe i03_112a.gif 0 452 0 1 0 15 15 15 * Let's take a look at an existi isave 148 312 379 261 text1 textbox 148 312 379 261 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_113a.gif 291 431 0 1 0 15 15 15 eff.exe i03_113b.gif 7 403 0 1 0 15 15 15 eff.exe i03_113c.gif 298 403 0 1 0 15 15 15 * First you click the Reports ta isave 148 266 379 210 text2 growbox 148 266 379 210 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_114a.gif 7 367 0 1 0 15 15 15 eff.exe i03_114b.gif 385 386 0 1 0 15 15 15 * Then you click the Preview but isave 148 215 379 159 text3 growbox 148 215 379 159 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 148 215 image memory text2 0 148 266 image memory text1 0 148 312 * eff.exe i03_115a.gif 2 452 0 1 0 15 15 15 * As you can see, the report is isave 6 223 210 155 text1 textbox 6 223 210 155 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_116a.gif 73 434 0 1 0 15 15 15 eff.exe i03_116b.gif 332 209 0 1 0 15 15 15 * The magnifying glass pointer m isave 6 160 210 87 text2 growbox 6 160 210 87 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_117a.gif 2 434 0 1 0 15 15 15 * For example, you can zoom out isave 6 92 210 2 text3 growbox 6 92 210 2 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 6 92 image memory text2 0 6 160 image memory text1 0 6 223 * eff.exe i03_118a.gif 34 434 0 1 0 15 15 15 * In Access 97, you have the opt isave 35 327 239 259 text1 textbox 35 327 239 259 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03a119.gif 0 459 0 1 0 15 15 15 qcall IA03q 030102 eff.exe i03_119a.gif 39 434 0 1 0 15 15 15 eff.exe i03_119b.gif 431 434 0 1 0 15 15 15 eff.exe i03_119c.gif 431 272 0 1 0 15 15 15 * To display multiple pages you isave 35 264 239 191 text2 growbox 35 264 239 191 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 35 264 image memory text1 0 35 327 * eff.exe i03_120a.gif 39 427 0 1 0 15 15 15 eff.exe i03_120b.gif 431 427 0 1 0 15 15 15 eff.exe i03_120c.gif 431 272 0 1 0 15 15 15 * You choose the number of pages isave 6 295 204 244 text1 textbox 6 295 204 244 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_121a.gif 34 434 0 1 0 15 15 15 * Access displays the option you isave 6 249 204 193 text2 growbox 6 249 204 193 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 6 249 image memory text1 0 6 295 * eff.exe i03_122a.gif 11 434 0 1 0 15 15 15 eff.exe i03_122b.gif 407 169 0 1 0 15 15 15 * Let's see what the report look isave 435 324 632 273 text1 textbox 435 324 632 273 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_123a.gif 0 452 0 1 0 15 15 15 * Like forms, reports are divide isave 435 278 632 222 text2 growbox 435 278 632 222 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 435 278 image memory text1 0 435 324 * eff.exe i03_124a.gif 119 398 0 1 0 15 15 15 eff.exe i03_124b.gif 456 179 0 1 0 15 15 15 * The report header appears once isave 9 183 250 132 text1 textbox 9 183 250 132 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_125a.gif 119 398 0 1 0 15 15 15 eff.exe i03_125b.gif 346 402 0 1 0 15 15 15 * You can use it for items such isave 9 137 250 81 text2 growbox 9 137 250 81 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_126a.gif 346 402 0 1 0 15 15 15 * The report header is printed b isave 9 86 250 13 text3 growbox 9 86 250 13 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 9 86 image memory text2 0 9 137 image memory text1 0 9 183 * eff.exe i03_127a.gif 11 408 0 1 0 15 15 15 eff.exe i03_127b.gif 6 248 0 1 0 15 15 15 * The page header appears at the isave 11 115 242 64 text1 textbox 11 115 242 64 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_128a.gif 10 248 0 1 0 15 15 15 eff.exe i03_128b.gif 408 184 0 1 0 15 15 15 * You use it to display items su isave 11 69 242 13 text2 growbox 11 69 242 13 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 11 69 image memory text1 0 11 115 * eff.exe i03_129a.gif 6 340 0 1 0 15 15 15 * The detail section contains th isave 387 434 634 383 text1 textbox 387 434 634 383 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_130a.gif 314 225 0 1 0 15 15 15 eff.exe i03_130b.gif 408 197 0 1 0 15 15 15 * This section appears for each isave 387 388 634 332 text2 growbox 387 388 634 332 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 387 388 image memory text1 0 387 434 * eff.exe i03_131a.gif 124 163 0 1 0 15 15 15 eff.exe i03_131b.gif 408 197 0 1 0 15 15 15 * The page footer appears at the isave 416 328 617 260 text1 textbox 416 328 617 260 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_132a.gif 124 163 0 1 0 15 15 15 eff.exe i03_132b.gif 408 184 0 1 0 15 15 15 * You use it to display items su isave 416 265 617 209 text2 growbox 416 265 617 209 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 416 265 image memory text1 0 416 328 * eff.exe i03_133a.gif 6 379 0 1 0 15 15 15 eff.exe i03_133b.gif 6 335 0 1 0 15 15 15 * The report footer appears once isave 369 453 634 402 text1 textbox 369 453 634 402 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_134a.gif 250 215 0 1 0 15 15 15 eff.exe i03_134b.gif 408 184 0 1 0 15 15 15 * It can display items such as G isave 369 407 634 351 text2 growbox 369 407 634 351 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall IA03q 030103 eff.exe i03_135a.gif 426 206 0 1 0 15 15 15 * The report footer is the last isave 369 356 634 266 text3 growbox 369 356 634 266 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 * image memory text3 0 369 356 image memory text2 0 369 407 image memory text1 0 369 453 ** *eff.exe i03a136.gif 0 459 0 1 0 15 15 15 *qcall IA03q 030104 eff.exe i03_136a.gif 6 457 0 1 0 15 15 15 * You can hide or view the heade isave 409 318 613 216 text1 textbox 409 318 613 216 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 409 318 * eff.exe i03_137a.gif 11 457 0 1 0 15 15 15 eff.exe i03_137b.gif 11 52 0 1 0 15 15 15 * The Layout Preview shows the r isave 413 317 609 266 text1 textbox 413 317 609 266 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_138a.gif 0 452 0 1 0 15 15 15 * It includes just a sample of t isave 413 271 609 215 text2 growbox 413 271 609 215 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 413 271 image memory text1 0 413 317 * eff.exe i03_139a.gif 6 428 0 1 0 15 15 15 eff.exe i03_139b.gif 6 408 0 1 0 15 15 15 * Access 97 enables you to separ isave 365 456 634 405 text1 textbox 365 456 634 405 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_140a.gif 329 408 0 1 0 15 15 15 * By grouping records meaningful isave 365 410 634 354 text2 growbox 365 410 634 354 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_141a.gif 174 335 0 1 0 15 15 15 eff.exe i03_141b.gif 179 155 0 1 0 15 15 15 eff.exe i03_141c.gif 408 188 0 1 0 15 15 15 * For example, a report that gro isave 365 359 634 269 text3 growbox 365 359 634 269 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_142a.gif 170 335 0 1 0 15 15 15 eff.exe i03_142b.gif 179 155 0 1 0 15 15 15 * The advantage is that you can isave 365 274 634 201 text4 growbox 365 274 634 201 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 365 274 image memory text3 0 365 359 image memory text2 0 365 410 image memory text1 0 365 456 * *qcall IA03q 030105 eff.exe i03_143a.gif 0 452 0 1 0 15 15 15 * When you group records, you ca isave 4 437 224 369 text1 textbox 4 437 224 369 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_144a.gif 434 348 0 1 0 15 15 15 eff.exe i03_144b.gif 340 220 0 1 0 15 15 15 eff.exe i03_144c.gif 408 188 0 1 0 15 15 15 * For example, you could calcula isave 4 374 224 301 text2 growbox 4 374 224 301 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 4 374 image memory text1 0 4 437 * SimScrn 3 2 7 ********************************* eff.exe i03_145.gif 0 459 0 1 0 15 15 15 * Access provides a number of wa isave 24 193 275 142 text1 textbox 24 193 275 142 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * You cannot create a report if notebox 18 290 280 ** eff.exe i03_147a.gif 408 210 0 1 0 15 15 15 * Suppose you need a sales repor isave 24 147 275 91 text2 growbox 24 147 275 91 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_148a.gif 408 223 0 1 0 15 15 15 * You can create that report qui isave 24 96 275 40 text3 growbox 24 96 275 40 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 24 96 image memory text2 0 24 147 image memory text1 0 24 193 * eff.exe i03_149a.gif 448 434 0 1 0 15 15 15 eff.exe i03_149b.gif 306 295 0 1 0 15 15 15 * You click the New Object butto isave 204 321 446 287 text1 textbox 204 321 446 287 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_150a.gif 306 295 0 1 0 15 15 15 eff.exe i03_150b.gif 448 418 0 1 0 15 15 15 * You choose Report from the dro isave 204 292 446 236 text2 growbox 204 292 446 236 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 204 292 image memory text1 0 204 321 * eff.exe i03_151a.gif 0 409 0 1 0 15 15 15 eff.exe i03_151b.gif 514 434 0 1 0 15 15 15 * In the New Report dialog box, isave 424 342 625 274 text1 textbox 424 342 625 274 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** *qcall IA03q 030106 eff.exe i03_152a.gif 285 344 0 1 0 15 15 15 * The AutoReport: Tabular option isave 424 279 625 172 text2 growbox 424 279 625 172 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_153a.gif 20 358 0 1 0 15 15 15 eff.exe i03_153b.gif 181 374 0 1 0 15 15 15 * Here, you click the AutoReport isave 424 177 625 70 text3 growbox 424 177 625 70 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 424 177 image memory text2 0 424 279 image memory text1 0 424 342 * eff.exe i03_154a.gif 0 427 0 1 0 15 15 15 * You click the table or query t isave 394 261 605 176 text1 textbox 394 261 605 176 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_155a.gif 90 427 0 1 0 15 15 15 eff.exe i03_155b.gif 90 295 0 1 0 15 15 15 * Then you click OK isave 394 181 605 142 text2 growbox 394 181 605 142 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 394 181 image memory text1 0 394 261 * eff.exe i03_156a.gif 0 452 0 1 0 15 15 15 * Access applies the last autofo isave 381 456 630 405 text1 textbox 381 456 630 405 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_157a.gif 40 307 0 1 0 15 15 15 eff.exe i03_157b.gif 377 259 0 1 0 15 15 15 * If you haven't created a repor isave 381 410 630 320 text2 growbox 381 410 630 320 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 381 410 image memory text1 0 381 456 * eff.exe i03_158a.gif 2 452 0 1 0 15 15 15 * Suppose you have the Employees isave 5 456 328 422 text1 textbox 5 456 328 422 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_159a.gif 282 234 0 1 0 15 15 15 eff.exe i03_159b.gif 489 434 0 1 0 15 15 15 * You can create a single-column isave 5 427 328 354 text2 growbox 5 427 328 354 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_160a.gif 0 452 0 1 0 15 15 15 * Reports created with this meth isave 5 359 328 303 text3 growbox 5 359 328 303 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 5 359 image memory text2 0 5 427 image memory text1 0 5 456 * eff.exe i03_161a.gif 350 205 0 1 0 15 15 15 * Suppose that you need a detail isave 3 457 243 389 text1 textbox 3 457 243 389 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_162a.gif 500 171 0 1 0 15 15 15 * The easiest way to do this is isave 3 394 243 338 text2 growbox 3 394 243 338 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_163a.gif 418 458 0 1 0 15 15 15 * You click the New Object butto isave 3 343 243 270 text3 growbox 3 343 243 270 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 3 343 image memory text2 0 3 394 image memory text1 0 3 457 * eff.exe i03_164a.gif 4 408 0 1 0 15 15 15 eff.exe i03_164b.gif 465 458 0 1 0 15 15 15 * You click Report Wizard isave 392 259 590 225 text1 textbox 392 259 590 225 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_165a.gif 186 360 0 1 0 15 15 15 eff.exe i03_165b.gif 522 379 0 1 0 15 15 15 eff.exe i03_165c.gif 164 216 0 1 0 15 15 15 * You open the drop-down combo b isave 392 230 590 123 text2 growbox 392 230 590 123 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_166a.gif 93 216 0 1 0 15 15 15 * Then you click OK isave 392 128 590 89 text3 growbox 392 128 590 89 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 392 128 image memory text2 0 392 230 image memory text1 0 392 259 * eff.exe i03_167a.gif 0 436 0 1 0 15 15 15 eff.exe i03_167b.gif 0 18 0 1 0 15 15 15 * In the Table/Queries area you isave 396 357 629 272 text1 textbox 396 357 629 272 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_168a.gif 154 379 0 1 0 15 15 15 eff.exe i03_168b.gif 418 191 0 1 0 15 15 15 * You can also choose to base th isave 396 277 629 221 text2 growbox 396 277 629 221 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 396 277 image memory text1 0 396 357 * eff.exe i03_169a.gif 177 347 0 1 0 15 15 15 eff.exe i03_169b.gif 418 191 0 1 0 15 15 15 * In the Available Fields box, y isave 416 332 591 230 text1 textbox 416 332 591 230 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_170a.gif 16 347 0 1 0 15 15 15 eff.exe i03_170b.gif 196 237 0 1 0 15 15 15 * Here, you click the double rig isave 416 235 591 162 text2 growbox 416 235 591 162 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_171a.gif 196 379 0 1 0 15 15 15 eff.exe i03_171b.gif 16 269 0 1 0 15 15 15 eff.exe i03_171c.gif 196 267 0 1 0 15 15 15 * Then you click Next isave 416 167 591 128 text3 growbox 416 167 591 128 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 416 167 image memory text2 0 416 235 image memory text1 0 416 332 * eff.exe i03_172a.gif 13 404 0 1 0 15 15 15 eff.exe i03_172b.gif 14 113 0 1 0 15 15 15 * You can now decide how you wan isave 6 202 221 151 text1 textbox 6 202 221 151 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_173a.gif 16 367 0 1 0 15 15 15 eff.exe i03_173b.gif 221 387 0 1 0 15 15 15 eff.exe i03_173c.gif 16 112 0 1 0 15 15 15 eff.exe i03_173d.gif 221 112 0 1 0 15 15 15 * For example, you might want to isave 6 156 221 83 text2 growbox 6 156 221 83 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_174a.gif 237 330 0 1 0 15 15 15 eff.exe i03_174b.gif 380 375 0 1 0 15 15 15 * This means that the group head isave 6 88 221 15 text3 growbox 6 88 221 15 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * The Grouping Option button ena notebox 8 315 263 ** image memory text3 0 6 88 image memory text2 0 6 156 image memory text1 0 6 202 * eff.exe i03_176a.gif 16 379 0 1 0 15 15 15 eff.exe i03_176b.gif 237 379 0 1 0 15 15 15 eff.exe i03_176c.gif 315 187 0 1 0 15 15 15 * You click Next isave 263 248 397 214 text1 textbox 263 248 397 214 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 263 248 * eff.exe i03_177a.gif 12 404 0 1 0 15 15 15 * You can now specify sorting op isave 445 456 633 405 text1 textbox 445 456 633 405 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_178a.gif 167 294 0 1 0 15 15 15 eff.exe i03_178b.gif 415 320 0 1 0 15 15 15 * For example, you might want to isave 445 410 633 320 text2 growbox 445 410 633 320 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_179a.gif 189 339 0 1 0 15 15 15 eff.exe i03_179b.gif 415 320 0 1 0 15 15 15 * In the drop-down list box you isave 445 325 633 269 text3 growbox 445 325 633 269 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 445 325 image memory text2 0 445 410 image memory text1 0 445 456 * eff.exe i03_180a.gif 409 413 0 1 0 15 15 15 eff.exe i03_180b.gif 189 283 0 1 0 15 15 15 * The Sort button shows that the isave 382 318 637 250 text1 textbox 382 318 637 250 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_181a.gif 222 413 0 1 0 15 15 15 eff.exe i03_181b.gif 223 184 0 1 0 15 15 15 * You click the Summary Options isave 382 255 637 182 text2 growbox 382 255 637 182 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_182a.gif 2 434 0 1 0 15 15 15 * Here, only the Unit Price and isave 382 187 637 131 text3 growbox 382 187 637 131 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 382 187 image memory text2 0 382 255 image memory text1 0 382 318 * eff.exe i03_183a.gif 493 379 0 1 0 15 15 15 eff.exe i03_183b.gif 92 347 0 1 0 15 15 15 * Since there has been a change isave 6 174 181 72 text1 textbox 6 174 181 72 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_184a.gif 92 347 0 1 0 15 15 15 eff.exe i03_184b.gif 377 400 0 1 0 15 15 15 * Then you click OK isave 6 77 181 38 text2 growbox 6 77 181 38 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_185a.gif 3 434 0 1 0 15 15 15 * And you click Next isave 6 43 181 4 text3 growbox 6 43 181 4 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 6 43 image memory text2 0 6 77 image memory text1 0 6 174 * eff.exe i03_186a.gif 12 401 0 1 0 15 15 15 eff.exe i03_186b.gif 12 381 0 1 0 15 15 15 * Access makes it easy to lay ou isave 7 155 219 87 text1 textbox 7 155 219 87 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_187a.gif 202 428 0 1 0 15 15 15 eff.exe i03_187b.gif 437 248 0 1 0 15 15 15 * You can choose to print your r isave 7 92 219 19 text2 growbox 7 92 219 19 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 7 92 image memory text1 0 7 155 * eff.exe i03_188a.gif 202 428 0 1 0 15 15 15 eff.exe i03_188b.gif 435 345 0 1 0 15 15 15 * You can opt to print your page isave 423 242 630 174 text1 textbox 423 242 630 174 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_189a.gif 344 389 0 1 0 15 15 15 * Here, you choose Portrait isave 423 179 630 140 text2 growbox 423 179 630 140 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 423 179 image memory text1 0 423 242 * eff.exe i03_190a.gif 277 389 0 1 0 15 15 15 eff.exe i03_190b.gif 150 178 0 1 0 15 15 15 eff.exe i03_190c.gif 268 190 0 1 0 15 15 15 * If you'd like all your fields isave 411 274 634 206 text1 textbox 411 274 634 206 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_191a.gif 268 379 0 1 0 15 15 15 eff.exe i03_191b.gif 150 190 0 1 0 15 15 15 eff.exe i03_191c.gif 268 190 0 1 0 15 15 15 * Then you click Next isave 411 211 634 172 text2 growbox 411 211 634 172 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 411 211 image memory text1 0 411 274 * eff.exe i03_192a.gif 12 401 0 1 0 15 15 15 eff.exe i03_192b.gif 252 380 0 1 0 15 15 15 eff.exe i03_192c.gif 315 112 0 1 0 15 15 15 * You can scroll through differe isave 417 314 619 246 text1 textbox 417 314 619 246 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_193a.gif 29 277 0 1 0 15 15 15 eff.exe i03_193b.gif 238 365 0 1 0 15 15 15 eff.exe i03_193c.gif 29 203 0 1 0 15 15 15 eff.exe i03_193d.gif 238 203 0 1 0 15 15 15 * For example, you can select th isave 417 251 619 195 text2 growbox 417 251 619 195 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_194a.gif 238 379 0 1 0 15 15 15 eff.exe i03_194b.gif 315 112 0 1 0 15 15 15 * Then you click Next isave 417 200 619 161 text3 growbox 417 200 619 161 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 417 200 image memory text2 0 417 251 image memory text1 0 417 314 * eff.exe i03_195a.gif 12 410 0 1 0 15 15 15 eff.exe i03_195b.gif 314 113 0 1 0 15 15 15 * Although the Report wizard sug isave 435 379 635 277 text1 textbox 435 379 635 277 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_196a.gif 305 410 0 1 0 15 15 15 eff.exe i03_196b.gif 399 410 0 1 0 15 15 15 eff.exe i03_196c.gif 399 188 0 1 0 15 15 15 * Then you click Finish to close isave 435 282 635 226 text2 growbox 435 282 635 226 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 435 282 image memory text1 0 435 379 * eff.exe i03_197a.gif 0 452 0 1 0 15 15 15 * The Report Wizard creates your isave 241 437 416 386 text1 textbox 241 437 416 386 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 241 437 * * Topic: Customising reports Topic No.: 2 **** SimScrn 3 3 7 ********************************* eff.exe i03_201.gif 0 459 0 1 0 15 15 15 * Once your report has been crea isave 7 454 232 369 text1 textbox 7 454 232 369 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_202a.gif 420 343 0 1 0 15 15 15 eff.exe i03_202b.gif 491 169 0 1 0 15 15 15 * For example, you may want to u isave 7 374 232 284 text2 growbox 7 374 232 284 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 7 374 image memory text1 0 7 454 * eff.exe i03_203a.gif 334 382 0 1 0 15 15 15 * You click the Field List butto isave 4 456 230 388 text1 textbox 4 456 230 388 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_204a.gif 293 429 0 1 0 15 15 15 eff.exe i03_204b.gif 79 117 0 1 0 15 15 15 * Then you simply drag-and-drop isave 4 393 230 320 text2 growbox 4 393 230 320 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_205a.gif 15 429 0 1 0 15 15 15 eff.exe i03_205b.gif 6 193 0 1 0 15 15 15 * Access draws the new control isave 4 325 230 286 text3 growbox 4 325 230 286 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 4 325 image memory text2 0 4 393 image memory text1 0 4 456 * eff.exe i03_206a.gif 109 119 0 1 0 15 15 15 eff.exe i03_206b.gif 354 163 0 1 0 15 15 15 * When you created the Stock Rep isave 7 456 238 371 text1 textbox 7 456 238 371 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** qcall IA03q 030201 eff.exe i03_207a.gif 460 195 0 1 0 15 15 15 * Now, for instance, you could c isave 7 376 238 269 text2 growbox 7 376 238 269 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 7 376 image memory text1 0 7 456 * eff.exe i03a208a.gif 354 195 0 1 0 15 15 15 qcall IA03q 030202 eff.exe i03_208a.gif 11 405 0 1 0 15 15 15 eff.exe i03_208b.gif 6 267 0 1 0 15 15 15 * You click the Sorting and Grou isave 20 139 265 71 text1 textbox 20 139 265 71 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Choosing View - Sorting and Gr notebox 30 233 252 ** eff.exe i03_210a.gif 8 409 0 1 0 15 15 15 eff.exe i03_210b.gif 8 18 0 1 0 15 15 15 * You select the field you want isave 20 76 265 20 text2 growbox 20 76 265 20 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 20 76 image memory text1 0 20 139 * eff.exe i03_211a.gif 23 356 0 1 0 15 15 15 * In the Sort Order box, you cli isave 16 112 205 27 text1 textbox 16 112 205 27 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 16 112 * eff.exe i03_212a.gif 2 409 0 1 0 15 15 15 eff.exe i03_212b.gif 2 18 0 1 0 15 15 15 * After you close the dialog box isave 5 124 241 73 text1 textbox 5 124 241 73 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_213a.gif 0 452 0 1 0 15 15 15 * As you can see, Access has app isave 5 78 241 22 text2 growbox 5 78 241 22 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 5 78 image memory text1 0 5 124 * eff.exe i03_214a.gif 14 408 0 1 0 15 15 15 eff.exe i03_214b.gif 622 318 0 1 0 15 15 15 eff.exe i03_214c.gif 18 95 0 1 0 15 15 15 * The Report Wizard automaticall isave 280 405 544 337 text1 textbox 280 405 544 337 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 280 405 * eff.exe i03_215a.gif 0 452 0 1 0 15 15 15 * Suppose you want to change the isave 5 256 268 205 text1 textbox 5 256 268 205 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_216.gif 0 459 0 1 0 15 15 15 * The easiest way to do this is isave 5 210 268 137 text2 growbox 5 210 268 137 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_217a.gif 11 402 0 1 0 15 15 15 eff.exe i03_217b.gif 113 408 0 1 0 15 15 15 eff.exe i03_217c.gif 11 242 0 1 0 15 15 15 eff.exe i03_217d.gif 252 242 0 1 0 15 15 15 * For example, you can type ="Pa isave 5 142 268 69 text3 growbox 5 142 268 69 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_218a.gif 0 452 0 1 0 15 15 15 * In Print Preview, you can see isave 5 74 268 1 text4 growbox 5 74 268 1 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 5 74 image memory text3 0 5 142 image memory text2 0 5 210 image memory text1 0 5 256 * eff.exe i03_219a.gif 0 452 0 1 0 15 15 15 * You can also add controls such isave 6 143 206 75 text1 textbox 6 143 206 75 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_220a.gif 11 402 0 1 0 15 15 15 eff.exe i03_220b.gif 113 408 0 1 0 15 15 15 eff.exe i03_220c.gif 113 52 0 1 0 15 15 15 * Let's see how you create a lab isave 6 80 206 24 text2 growbox 6 80 206 24 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 6 80 image memory text1 0 6 143 * eff.exe i03_221a.gif 63 434 0 1 0 15 15 15 eff.exe i03_221b.gif 360 306 0 1 0 15 15 15 * You click the Label button to isave 9 141 212 90 text1 textbox 9 141 212 90 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_222a.gif 11 402 0 1 0 15 15 15 eff.exe i03_222b.gif 63 434 0 1 0 15 15 15 eff.exe i03_222c.gif 63 52 0 1 0 15 15 15 * Then you click where you want isave 9 95 212 39 text2 growbox 9 95 212 39 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 9 95 image memory text1 0 9 141 * eff.exe i03_223a.gif 6 379 0 1 0 15 15 15 eff.exe i03_223b.gif 6 304 0 1 0 15 15 15 * You type the text for the labe isave 23 86 252 52 text1 textbox 23 86 252 52 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_224a.gif 419 321 0 1 0 15 15 15 * And then you press Enter isave 23 57 252 18 text2 growbox 23 57 252 18 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 23 57 image memory text1 0 23 86 * eff.exe i03_225a.gif 11 405 0 1 0 15 15 15 eff.exe i03_225b.gif 25 321 0 1 0 15 15 15 * You can move, size, or align s isave 7 409 235 358 text1 textbox 7 409 235 358 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_226a.gif 15 408 0 1 0 15 15 15 eff.exe i03_226b.gif 25 203 0 1 0 15 15 15 * Let's see how you size a group isave 7 363 235 324 text2 growbox 7 363 235 324 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * To select several controls, yo notebox 14 298 222 ** image memory text2 0 7 363 image memory text1 0 7 409 * eff.exe i03_228a.gif 145 457 0 1 0 15 15 15 eff.exe i03_228b.gif 340 117 0 1 0 15 15 15 * You choose Format - Size which isave 349 456 634 405 text1 textbox 349 456 634 405 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_229a.gif 145 342 0 1 0 15 15 15 eff.exe i03_229b.gif 290 285 0 1 0 15 15 15 * For example, you can make the isave 349 410 634 337 text2 growbox 349 410 634 337 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_230a.gif 154 457 0 1 0 15 15 15 eff.exe i03_230b.gif 129 140 0 1 0 15 15 15 * Access resizes the selected co isave 349 342 634 303 text3 growbox 349 342 634 303 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 349 342 image memory text2 0 349 410 image memory text1 0 349 456 * eff.exe i03_231a.gif 284 127 0 1 0 15 15 15 eff.exe i03_231b.gif 383 317 0 1 0 15 15 15 * Access allows you to change th isave 367 457 636 389 text1 textbox 367 457 636 389 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_232a.gif 15 408 0 1 0 15 15 15 eff.exe i03_232b.gif 25 332 0 1 0 15 15 15 * Let's see how you change the f isave 367 394 636 321 text2 growbox 367 394 636 321 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * You select the entire form by notebox 397 294 609 ** image memory text2 0 367 394 image memory text1 0 367 457 * eff.exe i03a234a.gif 15 408 0 1 0 15 15 15 eff.exe i03a234b.gif 25 332 0 1 0 15 15 15 qcall IA03q 030203 eff.exe i03_234a.gif 11 402 0 1 0 15 15 15 eff.exe i03_234b.gif 113 408 0 1 0 15 15 15 eff.exe i03_234c.gif 27 144 0 1 0 15 15 15 eff.exe i03_234d.gif 86 144 0 1 0 15 15 15 * You click AutoFormat isave 203 351 383 317 text1 textbox 203 351 383 317 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** * Choosing Format - Autoformat h notebox 183 284 408 ** image memory text1 0 203 351 * eff.exe i03_236a.gif 4 410 0 1 0 15 15 15 eff.exe i03_236b.gif 4 18 0 1 0 15 15 15 * You select a new autoformat fo isave 153 457 390 406 text1 textbox 153 457 390 406 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_237a.gif 5 374 0 1 0 15 15 15 eff.exe i03_237b.gif 210 379 0 1 0 15 15 15 * You click OK isave 153 411 390 372 text2 growbox 153 411 390 372 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_238a.gif 4 410 0 1 0 15 15 15 eff.exe i03_238b.gif 11 109 0 1 0 15 15 15 * Access applies the new format isave 153 377 390 338 text3 growbox 153 377 390 338 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 153 377 image memory text2 0 153 411 image memory text1 0 153 457 * eff.exe i03_239a.gif 15 408 0 1 0 15 15 15 eff.exe i03_239b.gif 96 185 0 1 0 15 15 15 * To make more detailed changes isave 3 439 241 354 text1 textbox 3 439 241 354 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_240a.gif 416 421 0 1 0 15 15 15 eff.exe i03_240b.gif 389 109 0 1 0 15 15 15 * Then you can change the format isave 3 359 241 286 text2 growbox 3 359 241 286 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 3 359 image memory text1 0 3 439 ** eff.exe i03_241.gif 0 459 0 1 0 15 15 15 * Let's use the one of the Speci isave 90 385 337 317 text1 textbox 90 385 337 317 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 90 385 * eff.exe i03_242a.gif 416 421 0 1 0 15 15 15 * You click the Special Effects isave 5 436 270 385 text1 textbox 5 436 270 385 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_243a.gif 15 408 0 1 0 15 15 15 eff.exe i03_243b.gif 127 144 0 1 0 15 15 15 * Access applies the new format isave 5 390 270 351 text2 growbox 5 390 270 351 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 5 390 image memory text1 0 5 436 * * Topic: Hands-on: Customising an autoformat Topic No.: 3 **** SimScrn 3 4 7 ********************************* MoveCtrl 1 493 426 0 0 ********************************* exercise 01 01 130 100 task 01 0101 404 320 236 6 70 67 35 75 pause 1 1 1 1 1 1 1 1 ** * Topic: Sub-reports Topic No.: 4 **** SimScrn 3 5 7 ********************************* eff.exe i03_401.gif 0 459 0 1 0 15 15 15 * A subreport is a report that's isave 31 281 251 230 text1 textbox 31 281 251 230 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_402a.gif 289 245 0 1 0 15 15 15 * When you combine reports, one isave 31 235 251 162 text2 growbox 31 235 251 162 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 31 235 image memory text1 0 31 281 * eff.exe i03_403a.gif 289 249 0 1 0 15 15 15 * The main report is either boun isave 402 454 636 403 text1 textbox 402 454 636 403 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_404a.gif 295 257 0 1 0 15 15 15 * An unbound main report can sto isave 402 408 636 335 text2 growbox 402 408 636 335 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_405a.gif 107 395 0 1 0 15 15 15 eff.exe i03_405b.gif 107 257 0 1 0 15 15 15 eff.exe i03_405c.gif 295 257 0 1 0 15 15 15 * If a main report is bound, it isave 402 340 636 267 text3 growbox 402 340 636 267 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 402 340 image memory text2 0 402 408 image memory text1 0 402 454 * eff.exe i03_406a.gif 327 278 0 1 0 15 15 15 * In Access 97 you can nest subf isave 420 455 635 387 text1 textbox 420 455 635 387 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_407a.gif 279 238 0 1 0 15 15 15 * You can create an outer report isave 420 392 635 285 text2 growbox 420 392 635 285 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 420 392 image memory text1 0 420 455 * eff.exe i03_408a.gif 279 294 0 1 0 15 15 15 * A main report can contain up t isave 178 402 380 334 text1 textbox 178 402 380 334 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_409.gif 0 459 0 1 0 15 15 15 * For example, a report can cont isave 178 339 380 249 text2 growbox 178 339 380 249 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 178 339 image memory text1 0 178 402 * eff.exe i03_410a.gif 25 350 0 1 0 15 15 15 eff.exe i03_410b.gif 359 343 0 1 0 15 15 15 * Let's see how you create a Sal isave 178 405 393 320 text1 textbox 178 405 393 320 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_411a.gif 107 395 0 1 0 15 15 15 eff.exe i03_411b.gif 107 343 0 1 0 15 15 15 eff.exe i03_411c.gif 202 343 0 1 0 15 15 15 * You select the Stock Report isave 178 325 393 286 text2 growbox 178 325 393 286 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 178 325 image memory text1 0 178 405 * eff.exe i03_412a.gif 4 453 0 1 0 15 15 15 * You click the Design button to isave 193 323 402 255 text1 textbox 193 323 402 255 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_413a.gif 0 453 0 1 0 15 15 15 * Then you click the Subform/Sub isave 193 260 402 204 text2 growbox 193 260 402 204 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_414a.gif 6 453 0 1 0 15 15 15 eff.exe i03_414b.gif 4 196 0 1 0 15 15 15 * You click where you want to pl isave 193 209 402 136 text3 growbox 193 209 402 136 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 193 209 image memory text2 0 193 260 image memory text1 0 193 323 * eff.exe i03_415a.gif 3 459 0 1 0 15 15 15 * You have the option to use a t isave 8 174 219 89 text1 textbox 8 174 219 89 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_416a.gif 136 354 0 1 0 15 15 15 * Here you click Table/Query isave 8 94 219 55 text2 growbox 8 94 219 55 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_417a.gif 9 459 0 1 0 15 15 15 eff.exe i03_417b.gif 4 71 0 1 0 15 15 15 * And you click Next isave 8 60 219 21 text3 growbox 8 60 219 21 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 8 60 image memory text2 0 8 94 image memory text1 0 8 174 * eff.exe i03_418a.gif 6 406 0 1 0 15 15 15 * You select Sales isave 433 455 634 421 text1 textbox 433 455 634 421 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_419a.gif 5 364 0 1 0 15 15 15 * Then in the Available Fields b isave 433 426 634 336 text2 growbox 433 426 634 336 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_420a.gif 5 347 0 1 0 15 15 15 eff.exe i03_420b.gif 5 317 0 1 0 15 15 15 eff.exe i03_420c.gif 241 302 0 1 0 15 15 15 * Here you double-click Customer isave 433 341 634 268 text3 growbox 433 341 634 268 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 433 341 image memory text2 0 433 426 image memory text1 0 433 455 * qcall IA03q 030401 eff.exe i03_421a.gif 2 437 0 1 0 15 15 15 * In most cases, a subreport is isave 377 456 635 371 text1 textbox 377 456 635 371 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_422a.gif 5 397 0 1 0 15 15 15 * To set up a link, you click th isave 377 376 635 320 text2 growbox 377 376 635 320 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 377 376 image memory text1 0 377 456 * eff.exe i03_423a.gif 48 397 0 1 0 15 15 15 eff.exe i03_423b.gif 136 284 0 1 0 15 15 15 * You select the approriate link isave 17 205 227 120 text1 textbox 17 205 227 120 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_424a.gif 136 379 0 1 0 15 15 15 eff.exe i03_424b.gif 136 284 0 1 0 15 15 15 * And then you click Next isave 17 125 227 86 text2 growbox 17 125 227 86 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 17 125 image memory text1 0 17 205 * eff.exe i03_425a.gif 22 350 0 1 0 15 15 15 * You enter an appropriate name isave 7 124 229 56 text1 textbox 7 124 229 56 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_426a.gif 131 344 0 1 0 15 15 15 eff.exe i03_426b.gif 318 182 0 1 0 15 15 15 * Then you click Finish to close isave 7 61 229 5 text2 growbox 7 61 229 5 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 7 61 image memory text1 0 7 124 * eff.exe i03_427a.gif 2 408 0 1 0 15 15 15 eff.exe i03_427b.gif 2 18 0 1 0 15 15 15 * Access embed the subreport on isave 182 174 399 123 text1 textbox 182 174 399 123 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 182 174 * * Topic: Printing Topic No.: 5 **** SimScrn 3 6 7 ********************************* eff.exe i03_501.gif 0 459 0 1 0 15 15 15 * Access 97 makes it easy to pri isave 9 457 214 406 text1 textbox 9 457 214 406 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_502a.gif 0 452 0 1 0 15 15 15 * For example, you can prin isave 9 411 214 321 text2 growbox 9 411 214 321 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_503a.gif 2 431 0 1 0 15 15 15 eff.exe i03_503b.gif 151 176 0 1 0 15 15 15 * ≥ a selection of record isave 9 326 214 287 text3 growbox 9 326 214 287 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_504a.gif 0 452 0 1 0 15 15 15 * ≥ a grouped repor isave 9 292 214 253 text4 growbox 9 292 214 253 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 9 292 image memory text3 0 9 326 image memory text2 0 9 411 image memory text1 0 9 457 * eff.exe i03_505a.gif 92 181 0 1 0 15 15 15 eff.exe i03_505b.gif 150 181 0 1 0 15 15 15 * Unless your report or form is isave 167 458 442 390 text1 textbox 167 458 442 390 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_506a.gif 80 382 0 1 0 15 15 15 eff.exe i03_506b.gif 58 201 0 1 0 15 15 15 * The quickest way to print a re isave 167 395 442 339 text2 growbox 167 395 442 339 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 167 395 image memory text1 0 167 458 * eff.exe i03_507a.gif 58 201 0 1 0 15 15 15 * The Print button method is sui isave 193 451 466 383 text1 textbox 193 451 466 383 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_508a.gif 80 382 0 1 0 15 15 15 eff.exe i03_508b.gif 150 182 0 1 0 15 15 15 * It is also an easy way to prin isave 193 388 466 332 text2 growbox 193 388 466 332 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 193 388 image memory text1 0 193 451 * eff.exe i03_509a.gif 0 452 0 1 0 15 15 15 * When you click the Print butto isave 25 331 228 246 text1 textbox 25 331 228 246 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 25 331 * eff.exe i03_510a.gif 6 459 0 1 0 15 15 15 * Sometimes you might want to ch isave 371 456 634 405 text1 textbox 371 456 634 405 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_511a.gif 6 459 0 1 0 15 15 15 * For example, you could set dif isave 371 410 634 337 text2 growbox 371 410 634 337 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_512a.gif 33 457 0 1 0 15 15 15 * To do this, you click Tools - isave 371 342 634 303 text3 growbox 371 342 634 303 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 371 342 image memory text2 0 371 410 image memory text1 0 371 456 * *qcall IA03q 030501 eff.exe i03_513a.gif 6 459 0 1 0 15 15 15 * You click the General tab isave 135 170 337 136 text1 textbox 135 170 337 136 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_514a.gif 16 397 0 1 0 15 15 15 eff.exe i03_514b.gif 403 47 0 1 0 15 15 15 * In the Print Margin area, you isave 135 141 337 68 text2 growbox 135 141 337 68 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * Changing default margins doesn notebox 111 284 356 ** image memory text2 0 135 141 image memory text1 0 135 170 * eff.exe i03_516a.gif 16 388 0 1 0 15 15 15 eff.exe i03_516b.gif 217 125 0 1 0 15 15 15 * You click Apply isave 101 228 246 194 text1 textbox 101 228 246 194 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_517a.gif 121 125 0 1 0 15 15 15 * And then you click OK to close isave 101 199 246 126 text2 growbox 101 199 246 126 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 101 199 image memory text1 0 101 228 * eff.exe i03_518a.gif 0 459 0 1 0 15 15 15 * Since your report is grouped, isave 416 456 635 388 text1 textbox 416 456 635 388 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_519a.gif 0 459 0 1 0 15 15 15 * Setting this property prevents isave 416 393 635 320 text2 growbox 416 393 635 320 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_520a.gif 1 459 0 1 0 15 15 15 * You select Design View in the isave 416 325 635 269 text3 growbox 416 325 635 269 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 416 325 image memory text2 0 416 393 image memory text1 0 416 456 * eff.exe i03_521a.gif 0 452 0 1 0 15 15 15 * You click the Sorting and Grou isave 6 458 228 407 text1 textbox 6 458 228 407 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_522a.gif 8 409 0 1 0 15 15 15 * In the Keep Together field, yo isave 6 412 228 356 text2 growbox 6 412 228 356 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_523a.gif 416 403 0 1 0 15 15 15 eff.exe i03_523b.gif 101 205 0 1 0 15 15 15 * Then you close the dialog box isave 6 361 228 322 text3 growbox 6 361 228 322 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 6 361 image memory text2 0 6 412 image memory text1 0 6 458 * eff.exe i03_524a.gif 1 409 0 1 0 15 15 15 * You could preview your documen isave 406 456 634 405 text1 textbox 406 456 634 405 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_525a.gif 1 368 0 1 0 15 15 15 * You simply click Print Preview isave 406 410 634 354 text2 growbox 406 410 634 354 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_526a.gif 0 452 0 1 0 15 15 15 * You can use the navigation but isave 406 359 634 269 text3 growbox 406 359 634 269 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 406 359 image memory text2 0 406 410 image memory text1 0 406 456 * eff.exe i03_527a.gif 4 421 0 1 0 15 15 15 eff.exe i03_527b.gif 103 106 0 1 0 15 15 15 * Once you are satisfied with th isave 5 113 239 45 text1 textbox 5 113 239 45 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_528a.gif 4 457 0 1 0 15 15 15 * To do this you click File - Pr isave 5 50 239 11 text2 growbox 5 50 239 11 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 5 50 image memory text1 0 5 113 * eff.exe i03_529a.gif 1 457 0 1 0 15 15 15 eff.exe i03_529b.gif 453 457 0 1 0 15 15 15 * You enter the settings you wan isave 413 454 625 403 text1 textbox 413 454 625 403 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_530a.gif 70 371 0 1 0 15 15 15 eff.exe i03_530b.gif 374 296 0 1 0 15 15 15 * For example, in the Printer ar isave 413 408 625 352 text2 growbox 413 408 625 352 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 413 408 image memory text1 0 413 454 * eff.exe i03_531a.gif 70 371 0 1 0 15 15 15 eff.exe i03_531b.gif 11 253 0 1 0 15 15 15 * Similarly in the Print Range a isave 375 404 632 336 text1 textbox 375 404 632 336 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_532a.gif 97 434 0 1 0 15 15 15 eff.exe i03_532b.gif 11 253 0 1 0 15 15 15 * For example, if you only wante isave 375 341 632 268 text2 growbox 375 341 632 268 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i03_533a.gif 130 194 0 1 0 15 15 15 * Then you click OK isave 375 273 632 234 text3 growbox 375 273 632 234 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 375 273 image memory text2 0 375 341 image memory text1 0 375 404 * * Topic: Hands-on: Printing a report Topic No.: 6 **** SimScrn 3 7 7 ********************************* MoveCtrl 1 493 426 0 0 ********************************* exercise 02 01 130 100 task 02 0202 404 320 236 5 70 67 35 75 pause 1 1 1 1 1 1 1 1 **