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

Wrap

Text File | 1997-05-08 | 49.1 KB | 1,758 lines

* SimScrn 1 1 8 ********************************* * Course: Intermediate Access 97 * Unit: Starting forms Unit No.:01 * Topic: Working with forms Topic No.: 1 **** eff.exe i01_101.gif 0 459 0 1 0 15 15 15 * A form, printed or online, is isave 9 431 281 363 text1 textbox 9 431 281 363 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_102a.gif 233 412 0 1 0 15 15 15 eff.exe i01_102b.gif 312 412 0 1 0 15 15 15 * Access recognizes this, by mak isave 9 368 281 295 text2 growbox 9 368 281 295 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 9 368 image memory text1 0 9 431 * eff.exe i01_103a.gif 63 412 0 1 0 15 15 15 * Using a form you can gather re isave 415 456 628 388 text1 textbox 415 456 628 388 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_104a.gif 63 300 0 1 0 15 15 15 eff.exe i01_104b.gif 507 179 0 1 0 15 15 15 * Instead of searching various t isave 415 393 628 303 text2 growbox 415 393 628 303 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 415 393 image memory text1 0 415 456 * eff.exe i01_105a.gif 64 328 0 1 0 15 15 15 eff.exe i01_105b.gif 101 179 0 1 0 15 15 15 * You can control and enhance th isave 372 455 635 387 text1 textbox 372 455 635 387 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_106a.gif 83 161 0 1 0 15 15 15 eff.exe i01_106b.gif 424 163 0 1 0 15 15 15 * For example, you can add shadi isave 372 392 635 336 text2 growbox 372 392 635 336 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 372 392 image memory text1 0 372 455 * eff.exe i01_107a.gif 0 456 0 1 0 15 15 15 * You can display pictures and g isave 8 169 250 118 text1 textbox 8 169 250 118 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_108a.gif 416 366 0 1 0 15 15 15 eff.exe i01_108b.gif 545 130 0 1 0 15 15 15 * This is useful when you want t isave 8 123 250 16 text2 growbox 8 123 250 16 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 8 123 image memory text1 0 8 169 * eff.exe i01_109a.gif 0 452 0 1 0 15 15 15 * You click the Forms tab in the isave 250 284 471 216 text1 textbox 250 284 471 216 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_110a.gif 48 431 0 1 0 15 15 15 eff.exe i01_110b.gif 469 431 0 1 0 15 15 15 eff.exe i01_110c.gif 469 19 0 1 0 15 15 15 * Let's look at the Products for isave 250 221 471 165 text2 growbox 250 221 471 165 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 250 221 image memory text1 0 250 284 * eff.exe i01_111a.gif 46 314 0 1 0 15 15 15 eff.exe i01_111b.gif 459 331 0 1 0 15 15 15 * If you click Design, the selec isave 356 212 594 161 text1 textbox 356 212 594 161 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_112a.gif 0 452 0 1 0 15 15 15 * You can alter or modify a form isave 356 166 594 110 text2 growbox 356 166 594 110 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 356 166 image memory text1 0 356 212 * eff.exe i01_113a.gif 0 452 0 1 0 15 15 15 * Clicking the New button lets y isave 371 214 620 163 text1 textbox 371 214 620 163 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_114a.gif 18 399 0 1 0 15 15 15 eff.exe i01_114b.gif 459 318 0 1 0 15 15 15 * Access opens a dialog box in w isave 371 168 620 61 text2 growbox 371 168 620 61 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 371 168 image memory text1 0 371 214 * eff.exe i01_115a.gif 18 399 0 1 0 15 15 15 eff.exe i01_115b.gif 554 345 0 1 0 15 15 15 * Let's say you want to enter da isave 210 359 401 291 text1 textbox 210 359 401 291 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_116a.gif 8 381 0 1 0 15 15 15 eff.exe i01_116b.gif 455 361 0 1 0 15 15 15 * You select the form, and then isave 210 296 401 240 text2 growbox 210 296 401 240 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Right-clicking Products, and s notebox 173 213 428 ** image memory text2 0 210 296 image memory text1 0 210 359 * qcall IA01q 010101 eff.exe i01_118a.gif 2 452 0 1 0 15 15 15 * The initial default Form Windo isave 373 261 611 210 text1 textbox 373 261 611 210 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_119a.gif 8 430 0 1 0 15 15 15 eff.exe i01_119b.gif 74 81 0 1 0 15 15 15 * You can use it to view, change isave 373 215 611 159 text2 growbox 373 215 611 159 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 373 215 image memory text1 0 373 261 * eff.exe i01a119a.gif 8 321 0 1 0 15 15 15 qcall IA01q 010102 ** eff.exe i01_120a.gif 3 442 0 1 0 15 15 15 eff.exe i01_120b.gif 3 39 0 1 0 15 15 15 * You click the Form View button isave 6 244 252 176 text1 textbox 6 244 252 176 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_121a.gif 3 442 0 1 0 15 15 15 * Then you select Datasheet View isave 6 181 252 125 text2 growbox 6 181 252 125 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_122a.gif 2 434 0 1 0 15 15 15 eff.exe i01_122b.gif 2 20 0 1 0 15 15 15 * Access displays all the fields isave 6 130 252 74 text3 growbox 6 130 252 74 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_123a.gif 424 347 0 1 0 15 15 15 * Depending on the number of rec isave 6 79 252 6 text4 growbox 6 79 252 6 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 6 79 image memory text3 0 6 130 image memory text2 0 6 181 image memory text1 0 6 244 * qcall IA01q 010103 eff.exe i01_124a.gif 0 452 0 1 0 15 15 15 * When you have a lot of informa isave 36 436 317 368 text1 textbox 36 436 317 368 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_125a.gif 0 459 0 1 0 15 15 15 * You use the record number box isave 36 373 317 283 text2 growbox 36 373 317 283 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 36 373 image memory text1 0 36 436 * eff.exe i01_126a.gif 0 459 0 1 0 15 15 15 * Continuous forms are useful fo isave 360 458 637 390 text1 textbox 360 458 637 390 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_127a.gif 29 457 0 1 0 15 15 15 eff.exe i01_127b.gif 2 408 0 1 0 15 15 15 * Rather than showing you only a isave 360 395 637 305 text2 growbox 360 395 637 305 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 360 395 image memory text1 0 360 458 * eff.exe i01_128a.gif 29 457 0 1 0 15 15 15 eff.exe i01_128b.gif 2 430 0 1 0 15 15 15 * Access provides a special type isave 243 189 488 104 text1 textbox 243 189 488 104 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_129a.gif 282 430 0 1 0 15 15 15 eff.exe i01_129b.gif 282 329 0 1 0 15 15 15 eff.exe i01_129c.gif 496 329 0 1 0 15 15 15 * An example of a modal form is isave 243 109 488 19 text2 growbox 243 109 488 19 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** * A modal form is the same as a notebox 9 160 231 ** *footnote 1 image memory text2 0 243 109 image memory text1 0 243 189 * eff.exe i01_131a.gif 2 452 0 1 0 15 15 15 * Generally forms are designed s isave 52 258 315 173 text1 textbox 52 258 315 173 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_132a.gif 344 361 0 1 0 15 15 15 eff.exe i01_132b.gif 452 141 0 1 0 15 15 15 * Let's suppose that you want to isave 52 178 315 122 text2 growbox 52 178 315 122 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_133.gif 0 459 0 1 0 15 15 15 * The way you enter a new record isave 52 127 315 54 text3 growbox 52 127 315 54 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** *footnote 0 image memory text3 0 52 127 image memory text2 0 52 178 image memory text1 0 52 258 * eff.exe i01_134a.gif 47 347 0 1 0 15 15 15 eff.exe i01_134b.gif 344 345 0 1 0 15 15 15 * You double-click the Products isave 169 205 362 154 text1 textbox 169 205 362 154 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 169 205 * eff.exe i01a134a.gif 0 459 0 1 0 15 15 15 qcall IA01q 010104 eff.exe i01_135a.gif 244 434 0 1 0 15 15 15 eff.exe i01_135b.gif 490 434 0 1 0 15 15 15 * You click the Blank record but isave 190 267 408 216 text1 textbox 190 267 408 216 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * Pressing Ctrl+, or choosing Ed notebox 175 188 423 ** image memory text1 0 190 267 * qcall IA01q 010105 eff.exe i01_137a.gif 0 459 0 1 0 15 15 15 * As soon as you enter new data isave 140 289 436 204 text1 textbox 140 289 436 204 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_138a.gif 248 406 0 1 0 15 15 15 eff.exe i01_138b.gif 447 131 0 1 0 15 15 15 * You enter the new product's na isave 140 209 436 136 text2 growbox 140 209 436 136 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 140 209 image memory text1 0 140 289 * *qcall IA01q 010106 eff.exe i01_139a.gif 0 430 0 1 0 15 15 15 eff.exe i01_139b.gif 447 131 0 1 0 15 15 15 * Access changes the indicator t isave 160 239 423 171 text1 textbox 160 239 423 171 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 160 239 * eff.exe i01_140a.gif 0 419 0 1 0 15 15 15 * You enter the relevant data at isave 21 193 270 142 text1 textbox 21 193 270 142 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_141a.gif 3 442 0 1 0 15 15 15 * Then you click the View b isave 21 147 270 91 text2 growbox 21 147 270 91 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_142a.gif 2 442 0 1 0 15 15 15 eff.exe i01_142b.gif 2 20 0 1 0 15 15 15 * Access displays the new record isave 21 96 270 57 text3 growbox 21 96 270 57 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 21 96 image memory text2 0 21 147 image memory text1 0 21 193 * eff.exe i01_143a.gif 9 430 0 1 0 15 15 15 eff.exe i01_143b.gif 150 430 0 1 0 15 15 15 eff.exe i01_143c.gif 9 317 0 1 0 15 15 15 eff.exe i01_143d.gif 150 289 0 1 0 15 15 15 * Access allows you to change or isave 8 212 230 161 text1 textbox 8 212 230 161 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_144a.gif 10 335 0 1 0 15 15 15 eff.exe i01_144b.gif 395 218 0 1 0 15 15 15 * To do this you select the reco isave 8 166 230 93 text2 growbox 8 166 230 93 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_145a.gif 10 458 0 1 0 15 15 15 * You can choose Edit - Delete t isave 8 98 230 42 text3 growbox 8 98 230 42 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 8 98 image memory text2 0 8 166 image memory text1 0 8 212 * eff.exe i01_146a.gif 4 458 0 1 0 15 15 15 * Access warns you of the implic isave 437 404 629 302 text1 textbox 437 404 629 302 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_147a.gif 42 152 0 1 0 15 15 15 eff.exe i01_147b.gif 287 114 0 1 0 15 15 15 * You click Yes isave 437 307 629 268 text2 growbox 437 307 629 268 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_148a.gif 0 431 0 1 0 15 15 15 eff.exe i01_148b.gif 0 314 0 1 0 15 15 15 * Access removes the record isave 437 273 629 217 text3 growbox 437 273 629 217 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 437 273 image memory text2 0 437 307 image memory text1 0 437 404 * eff.exe i01_149a.gif 0 459 0 1 0 15 15 15 * When you use forms to display isave 371 252 630 184 text1 textbox 371 252 630 184 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_150a.gif 2 452 0 1 0 15 15 15 * When you specify a sort order isave 371 189 630 99 text2 growbox 371 189 630 99 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 371 189 image memory text1 0 371 252 * eff.exe i01_151a.gif 325 411 0 1 0 15 15 15 eff.exe i01_151b.gif 110 183 0 1 0 15 15 15 * Suppose you want to familiariz isave 36 184 348 133 text1 textbox 36 184 348 133 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_152a.gif 325 415 0 1 0 15 15 15 * Let's see how you sort the Cus isave 36 138 348 82 text2 growbox 36 138 348 82 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_154a.gif 99 408 0 1 0 15 15 15 eff.exe i01_154b.gif 380 415 0 1 0 15 15 15 *eff.exe i01_153.gif 0 459 0 1 0 15 15 15 * To make it easier for him to f isave 36 87 348 48 text3 growbox 36 87 348 48 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * You click the Company Name hea *isave 5 43 431 4 text4 *growbox 5 43 431 4 *showtext 0 0 2 *pause 1 1 1 1 1 1 1 1 ** *image memory text4 0 5 43 image memory text3 0 36 87 image memory text2 0 36 138 image memory text1 0 36 184 * eff.exe i01a154a.gif 0 459 0 1 0 15 15 15 qcall IA01q 010107 ** eff.exe i01_155a.gif 0 459 0 1 0 15 15 15 * You click the Sort Ascending b isave 190 178 443 127 text1 textbox 190 178 443 127 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_156a.gif 0 459 0 1 0 15 15 15 * Access automatically sorts the isave 190 132 443 76 text2 growbox 190 132 443 76 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 190 132 image memory text1 0 190 178 * qcall IA01q 010108 eff.exe i01_157a.gif 215 342 0 1 0 15 15 15 eff.exe i01_157b.gif 407 212 0 1 0 15 15 15 * Regardless of where you specif isave 7 191 247 106 text1 textbox 7 191 247 106 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_158a.gif 215 342 0 1 0 15 15 15 eff.exe i01_158b.gif 407 212 0 1 0 15 15 15 * When you open the form again, isave 7 111 247 38 text2 growbox 7 111 247 38 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 7 111 image memory text1 0 7 191 * SimScrn 1 2 8 ********************************* eff.exe i01_170.gif 0 459 0 1 0 15 15 15 * Let's say, for example, that y isave 5 209 313 124 text1 textbox 5 209 313 124 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** qcall IA01q 010109 eff.exe i01_171a.gif 173 328 0 1 0 15 15 15 eff.exe i01_171b.gif 409 434 0 1 0 15 15 15 eff.exe i01_171c.gif 324 36 0 1 0 15 15 15 * You click the Filter by Form b isave 5 129 313 73 text2 growbox 5 129 313 73 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Choosing Records - Filter - Fi notebox 27 340 289 ** eff.exe i01_173a.gif 0 459 0 1 0 15 15 15 * Then you select Department Nam isave 5 78 313 22 text3 growbox 5 78 313 22 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 5 78 image memory text2 0 5 129 image memory text1 0 5 209 * eff.exe i01_174a.gif 2 430 0 1 0 15 15 15 eff.exe i01_174b.gif 481 424 0 1 0 15 15 15 eff.exe i01_174c.gif 2 117 0 1 0 15 15 15 * You can enter one criterion, a isave 13 369 236 284 text1 textbox 13 369 236 284 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_175a.gif 121 430 0 1 0 15 15 15 eff.exe i01_175b.gif 592 430 0 1 0 15 15 15 eff.exe i01_175c.gif 107 117 0 1 0 15 15 15 * For example, you may want to s isave 13 289 236 216 text2 growbox 13 289 236 216 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 13 289 image memory text1 0 13 369 * eff.exe i01a175a.gif 312 392 0 1 0 15 15 15 eff.exe i01a175b.gif 392 384 0 1 0 15 15 15 qcall IA01q 010110 ** eff.exe i01_176a.gif 281 434 0 1 0 15 15 15 * If you don't like any of the c isave 10 253 283 185 text1 textbox 10 253 283 185 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_177a.gif 0 459 0 1 0 15 15 15 * When you are satisfied with th isave 10 190 283 134 text2 growbox 10 190 283 134 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_178a.gif 0 459 0 1 0 15 15 15 * Excel returns only those emplo isave 10 139 283 49 text3 growbox 10 139 283 49 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 10 139 image memory text2 0 10 190 image memory text1 0 10 253 * qcall IA01q 010111 eff.exe i01_179a.gif 0 459 0 1 0 15 15 15 * To remove the filter you simpl isave 7 164 194 96 text1 textbox 7 164 194 96 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Choosing Remove Filter/Sort co notebox 208 176 435 ** eff.exe i01_181a.gif 2 434 0 1 0 15 15 15 eff.exe i01_181b.gif 245 31 0 1 0 15 15 15 * Excel removes the filter that isave 7 101 194 45 text2 growbox 7 101 194 45 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 7 101 image memory text1 0 7 164 * * Topic: Creating forms Topic No.: 2 **** SimScrn 1 3 8 ********************************* eff.exe i01_202.gif 0 459 0 1 0 15 15 15 * Microsoft Access 97 has many f isave 26 214 266 129 text1 textbox 26 214 266 129 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** *eff.exe i01_202.gif 0 459 0 1 0 15 15 15 * For example, the AutoForm faci isave 26 134 266 44 text2 growbox 26 134 266 44 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 26 134 image memory text1 0 26 214 * eff.exe i01_203a.gif 197 458 0 1 0 15 15 15 * Suppose you want to create a s isave 11 458 272 390 text1 textbox 11 458 272 390 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_204a.gif 377 413 0 1 0 15 15 15 * The quickest way to do this is isave 11 395 272 322 text2 growbox 11 395 272 322 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** notebox 55 298 228 * image memory text2 0 11 395 image memory text1 0 11 458 * eff.exe i01_205a.gif 74 386 0 1 0 15 15 15 eff.exe i01_205b.gif 197 413 0 1 0 15 15 15 * In the Database window, you cl isave 185 341 388 290 text1 textbox 185 341 388 290 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * You can also create a form bas ** eff.exe i01_207a.gif 26 396 0 1 0 15 15 15 eff.exe i01_207b.gif 394 446 0 1 0 15 15 15 * Then you click the arrow next isave 185 295 388 205 text2 growbox 185 295 388 205 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 185 295 image memory text1 0 185 341 * qcall IA01q 010201 eff.exe i01_208a.gif 0 459 0 1 0 15 15 15 * Access automatically builds th isave 86 180 342 112 text1 textbox 86 180 342 112 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_209a.gif 92 429 0 1 0 15 15 15 eff.exe i01_209b.gif 350 338 0 1 0 15 15 15 * All the fields from the select isave 86 117 342 61 text2 growbox 86 117 342 61 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * You cannot include fields from notebox 108 293 316 ** image memory text2 0 86 117 image memory text1 0 86 180 * eff.exe i01_211a.gif 165 458 0 1 0 15 15 15 eff.exe i01_211b.gif 203 458 0 1 0 15 15 15 * The AutoForm facility is usefu isave 8 206 337 138 text1 textbox 8 206 337 138 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_212a.gif 381 361 0 1 0 15 15 15 eff.exe i01_212b.gif 469 407 0 1 0 15 15 15 * An AutoForm also serves as goo isave 8 143 337 70 text2 growbox 8 143 337 70 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_213a.gif 237 458 0 1 0 15 15 15 * Much like any form in Access, isave 8 75 337 19 text3 growbox 8 75 337 19 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 8 75 image memory text2 0 8 143 image memory text1 0 8 206 * eff.exe i01_214a.gif 235 458 0 1 0 15 15 15 * Suppose you want to build an o isave 35 179 299 128 text1 textbox 35 179 299 128 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_215a.gif 165 452 0 1 0 15 15 15 eff.exe i01_215b.gif 165 190 0 1 0 15 15 15 eff.exe i01_215c.gif 476 190 0 1 0 15 15 15 * The Form Wizard gives you more isave 35 133 299 60 text2 growbox 35 133 299 60 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 35 133 image memory text1 0 35 179 * eff.exe i01_216a.gif 0 459 0 1 0 15 15 15 * You click the New Object butto isave 155 322 464 288 text1 textbox 155 322 464 288 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_217a.gif 12 456 0 1 0 15 15 15 eff.exe i01_217b.gif 469 434 0 1 0 15 15 15 * Then you select Form in the dr isave 155 293 464 254 text2 growbox 155 293 464 254 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 155 293 image memory text1 0 155 322 * eff.exe i01_218a.gif 6 410 0 1 0 15 15 15 eff.exe i01_218b.gif 516 434 0 1 0 15 15 15 * The choices in the New Form di isave 397 384 628 299 text1 textbox 397 384 628 299 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_219a.gif 0 459 0 1 0 15 15 15 * For example, the Chart Wizard isave 397 304 628 231 text2 growbox 397 304 628 231 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_220a.gif 0 459 0 1 0 15 15 15 * In the New Form dialog box, yo isave 397 236 628 146 text3 growbox 397 236 628 146 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 397 236 image memory text2 0 397 304 image memory text1 0 397 384 * eff.exe i01_221a.gif 252 244 0 1 0 15 15 15 * You select Form Wizard, and th isave 392 404 630 353 text1 textbox 392 404 630 353 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_222a.gif 6 427 0 1 0 15 15 15 eff.exe i01_222b.gif 6 18 0 1 0 15 15 15 * In the Form Wizard dialog box, isave 392 358 630 268 text2 growbox 392 358 630 268 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_223a.gif 102 230 0 1 0 15 15 15 eff.exe i01_223b.gif 234 218 0 1 0 15 15 15 * To choose a highlighted field, isave 392 273 630 217 text3 growbox 392 273 630 217 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * You can also include fields fr notebox 406 191 611 ** eff.exe i01_225a.gif 31 236 0 1 0 15 15 15 eff.exe i01_225b.gif 211 236 0 1 0 15 15 15 * If you copy the wrong field, y isave 392 222 630 132 text4 growbox 392 222 630 132 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_226a.gif 31 236 0 1 0 15 15 15 eff.exe i01_226b.gif 211 236 0 1 0 15 15 15 * You can remove all fields and isave 392 137 630 64 text5 growbox 392 137 630 64 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text5 0 392 137 image memory text4 0 392 222 image memory text3 0 392 273 image memory text2 0 392 358 image memory text1 0 392 404 * eff.exe i01_227a.gif 31 236 0 1 0 15 15 15 * Here you click the double righ isave 441 284 618 199 text1 textbox 441 284 618 199 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_228a.gif 112 193 0 1 0 15 15 15 eff.exe i01_228b.gif 329 156 0 1 0 15 15 15 * You click Next isave 441 204 618 165 text2 growbox 441 204 618 165 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 441 204 image memory text1 0 441 284 * eff.exe i01_229a.gif 28 427 0 1 0 15 15 15 eff.exe i01_229b.gif 28 371 0 1 0 15 15 15 * Access gives you a number of c isave 330 212 551 161 text1 textbox 330 212 551 161 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_230a.gif 223 266 0 1 0 15 15 15 eff.exe i01_230b.gif 395 305 0 1 0 15 15 15 * You can choose to display the isave 330 166 551 93 text2 growbox 330 166 551 93 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 330 166 image memory text1 0 330 212 * eff.exe i01_231a.gif 53 427 0 1 0 15 15 15 eff.exe i01_231b.gif 53 354 0 1 0 15 15 15 eff.exe i01_231c.gif 317 354 0 1 0 15 15 15 * You can also choose to arrange isave 7 166 320 98 text1 textbox 7 166 320 98 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_232a.gif 53 427 0 1 0 15 15 15 eff.exe i01_232b.gif 53 354 0 1 0 15 15 15 eff.exe i01_232c.gif 305 354 0 1 0 15 15 15 * Alternatively you could choose isave 7 103 320 47 text2 growbox 7 103 320 47 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_233a.gif 54 311 0 1 0 15 15 15 eff.exe i01_233b.gif 305 268 0 1 0 15 15 15 * Another option is the Justifie isave 7 52 320 13 text3 growbox 7 52 320 13 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 7 52 image memory text2 0 7 103 image memory text1 0 7 166 * eff.exe i01_234a.gif 53 427 0 1 0 15 15 15 eff.exe i01_234b.gif 53 325 0 1 0 15 15 15 * Here, you select the Columnar isave 417 437 635 369 text1 textbox 417 437 635 369 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_235a.gif 29 368 0 1 0 15 15 15 eff.exe i01_235b.gif 29 349 0 1 0 15 15 15 * You can now choose the style y isave 417 374 635 267 text2 growbox 417 374 635 267 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_236a.gif 264 428 0 1 0 15 15 15 eff.exe i01_236b.gif 44 244 0 1 0 15 15 15 eff.exe i01_236c.gif 196 330 0 1 0 15 15 15 * Let's, for example, select Sto isave 417 272 635 233 text3 growbox 417 272 635 233 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_237a.gif 253 428 0 1 0 15 15 15 eff.exe i01_237b.gif 253 205 0 1 0 15 15 15 * Now you can click Next isave 417 238 635 199 text4 growbox 417 238 635 199 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 417 238 image memory text3 0 417 272 image memory text2 0 417 374 image memory text1 0 417 437 * eff.exe i01_238a.gif 27 372 0 1 0 15 15 15 * You type an appropriate title, isave 387 454 634 403 text1 textbox 387 454 634 403 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** *qcall IA01q 010202 eff.exe i01_239a.gif 272 340 0 1 0 15 15 15 eff.exe i01_239b.gif 85 174 0 1 0 15 15 15 * If you click the Modify the fo isave 387 408 634 335 text2 growbox 387 408 634 335 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_240a.gif 85 204 0 1 0 15 15 15 * Here, you choose Open the form isave 387 340 634 284 text3 growbox 387 340 634 284 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 387 340 image memory text2 0 387 408 image memory text1 0 387 454 * eff.exe i01_241a.gif 88 204 0 1 0 15 15 15 * Now you click Finish to go dir isave 417 214 613 163 text1 textbox 417 214 613 163 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 417 214 * eff.exe i01_242a.gif 0 459 0 1 0 15 15 15 * The new Orders Form is display isave 292 305 438 254 text1 textbox 292 305 438 254 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 292 305 * * Topic: Hands-on: Creating a form using Autoform Topic No.: 3 **** SimScrn 1 4 8 ********************************* *simscrn 1 4 8 MoveCtrl 1 493 500 0 * exercise 01 1 120 70 task 01 0101 402 300 235 3 120 67 35 75 * pause 1 1 1 1 1 1 1 1 *Exercise 1 1 200 80 *task 01 0101 404 320 236 *step 1 50 70 220 *step 2 50 70 220 *step 3 50 70 220 ** * Topic: Subforms Topic No.: 4 **** SimScrn 1 5 8 ********************************* eff.exe i01_401.gif 0 459 0 1 0 15 15 15 * You may sometimes need to disp isave 17 254 272 169 text1 textbox 17 254 272 169 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_402a.gif 479 258 0 1 0 15 15 15 eff.exe i01_402b.gif 571 258 0 1 0 15 15 15 * You may, for example, want to isave 17 174 272 101 text2 growbox 17 174 272 101 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_403a.gif 479 258 0 1 0 15 15 15 * Using subforms, you can combin isave 17 106 272 16 text3 growbox 17 106 272 16 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 17 106 image memory text2 0 17 174 image memory text1 0 17 254 * eff.exe i01_404a.gif 6 431 0 1 0 15 15 15 eff.exe i01_404b.gif 6 392 0 1 0 15 15 15 * You can create an outer form o isave 386 157 611 72 text1 textbox 386 157 611 72 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 386 157 * eff.exe i01_405a.gif 205 180 0 1 0 15 15 15 * In most cases, the subform is isave 398 228 612 126 text1 textbox 398 228 612 126 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_406a.gif 64 102 0 1 0 15 15 15 eff.exe i01_406b.gif 205 110 0 1 0 15 15 15 * For example, this subform show isave 398 131 612 58 text2 growbox 398 131 612 58 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 398 131 image memory text1 0 398 228 * eff.exe i01_407a.gif 64 102 0 1 0 15 15 15 eff.exe i01_407b.gif 430 184 0 1 0 15 15 15 * A link between a main form and isave 17 254 233 186 text1 textbox 17 254 233 186 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_408a.gif 431 184 0 1 0 15 15 15 eff.exe i01_408b.gif 586 184 0 1 0 15 15 15 * The main form should be based isave 17 191 233 118 text2 growbox 17 191 233 118 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_409a.gif 446 185 0 1 0 15 15 15 * The subform should be based on isave 17 123 233 16 text3 growbox 17 123 233 16 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 17 123 image memory text2 0 17 191 image memory text1 0 17 254 * qcall IA01q 010401 eff.exe i01_410a.gif 416 236 0 1 0 15 15 15 * The main form is based on the isave 179 173 408 105 text1 textbox 179 173 408 105 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_411a.gif 567 395 0 1 0 15 15 15 eff.exe i01_411b.gif 535 187 0 1 0 15 15 15 * The subform meets the second c isave 179 110 408 20 text2 growbox 179 110 408 20 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 179 110 image memory text1 0 179 173 * qcall IA01q 010402 eff.exe i01_412a.gif 573 395 0 1 0 15 15 15 eff.exe i01_412b.gif 416 263 0 1 0 15 15 15 * If the two conditions for link isave 179 211 418 126 text1 textbox 179 211 418 126 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_413a.gif 443 114 0 1 0 15 15 15 * But there must be a field in t isave 179 131 418 24 text2 growbox 179 131 418 24 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 179 131 image memory text1 0 179 211 * eff.exe i01_414a.gif 418 221 0 1 0 15 15 15 * This is called a "one to many" isave 11 456 321 422 text1 textbox 11 456 321 422 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_415a.gif 409 319 0 1 0 15 15 15 * The data in the Customers tabl isave 11 427 321 371 text2 growbox 11 427 321 371 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_416a.gif 440 327 0 1 0 15 15 15 eff.exe i01_416b.gif 429 254 0 1 0 15 15 15 * The data in the Orders table i isave 11 376 321 303 text3 growbox 11 376 321 303 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 11 376 image memory text2 0 11 427 image memory text1 0 11 456 * eff.exe i01_417a.gif 0 452 0 1 0 15 15 15 * The main form and subform are isave 12 456 239 371 text1 textbox 12 456 239 371 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_418a.gif 6 430 0 1 0 15 15 15 * For example, where the main fo isave 12 376 239 286 text2 growbox 12 376 239 286 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_419a.gif 350 289 0 1 0 15 15 15 eff.exe i01_419b.gif 219 153 0 1 0 15 15 15 eff.exe i01_419c.gif 424 103 0 1 0 15 15 15 * You can use the navigation but isave 12 291 239 218 text3 growbox 12 291 239 218 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 12 291 image memory text2 0 12 376 image memory text1 0 12 456 * qcall IA01q 010403 eff.exe i01_420a.gif 92 223 0 1 0 15 15 15 eff.exe i01_420b.gif 219 153 0 1 0 15 15 15 * If you need to make a change t isave 19 409 350 341 text1 textbox 19 409 350 341 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_421a.gif 6 430 0 1 0 15 15 15 eff.exe i01_421b.gif 92 430 0 1 0 15 15 15 eff.exe i01_421c.gif 6 223 0 1 0 15 15 15 eff.exe i01_421d.gif 92 223 0 1 0 15 15 15 * Let's suppose a vendor changes isave 19 346 350 290 text2 growbox 19 346 350 290 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_422a.gif 27 140 0 1 0 15 15 15 eff.exe i01_422b.gif 295 145 0 1 0 15 15 15 * To update the entire database isave 19 295 350 222 text3 growbox 19 295 350 222 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 19 295 image memory text2 0 19 346 image memory text1 0 19 409 * eff.exe i01_423a.gif 0 459 0 1 0 15 15 15 * You save the change, then swit isave 112 154 313 86 text1 textbox 112 154 313 86 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_424a.gif 17 395 0 1 0 15 15 15 eff.exe i01_424b.gif 320 220 0 1 0 15 15 15 * Access reflects the change you isave 112 91 313 35 text2 growbox 112 91 313 35 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 112 91 image memory text1 0 112 154 * eff.exe i01_425a.gif 17 344 0 1 0 15 15 15 eff.exe i01_425b.gif 452 336 0 1 0 15 15 15 * A subform can be displayed as isave 172 191 411 123 text1 textbox 172 191 411 123 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_426a.gif 504 316 0 1 0 15 15 15 * A main form can only be displa isave 172 128 411 72 text2 growbox 172 128 411 72 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_427a.gif 488 306 0 1 0 15 15 15 * It can have any number of subf isave 172 77 411 4 text3 growbox 172 77 411 4 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 172 77 image memory text2 0 172 128 image memory text1 0 172 191 * eff.exe i01_428a.gif 0 459 0 1 0 15 15 15 * You can also nest up to two le isave 20 173 273 122 text1 textbox 20 173 273 122 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_429a.gif 498 318 0 1 0 15 15 15 eff.exe i01_429b.gif 466 193 0 1 0 15 15 15 * For example, you could have a isave 20 127 273 20 text2 growbox 20 127 273 20 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 20 127 image memory text1 0 20 173 * SimScrn 1 6 8 ********************************* eff.exe i01_430.gif 0 459 0 1 0 15 15 15 * The easiest way to create a fo isave 19 149 223 81 text1 textbox 19 149 223 81 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_431a.gif 512 163 0 1 0 15 15 15 * The Form Wizard builds both fo isave 19 86 223 13 text2 growbox 19 86 223 13 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 19 86 image memory text1 0 19 149 * eff.exe i01_432a.gif 0 459 0 1 0 15 15 15 * Lets say that you want to buil isave 184 327 374 259 text1 textbox 184 327 374 259 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_433a.gif 112 414 0 1 0 15 15 15 eff.exe i01_433b.gif 428 295 0 1 0 15 15 15 * On the main form you want also isave 184 264 374 174 text2 growbox 184 264 374 174 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 184 264 image memory text1 0 184 327 * eff.exe i01_434a.gif 431 322 0 1 0 15 15 15 eff.exe i01_434b.gif 443 322 0 1 0 15 15 15 * The main form is based on a Cu isave 18 232 285 181 text1 textbox 18 232 285 181 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_435a.gif 307 322 0 1 0 15 15 15 * You also want to create a subf isave 18 186 285 96 text2 growbox 18 186 285 96 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_436a.gif 307 322 0 1 0 15 15 15 * Both forms have a Customer ID isave 18 101 285 28 text3 growbox 18 101 285 28 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 18 101 image memory text2 0 18 186 image memory text1 0 18 232 * eff.exe i01_437a.gif 7 431 0 1 0 15 15 15 eff.exe i01_437b.gif 425 431 0 1 0 15 15 15 eff.exe i01_437c.gif 7 403 0 1 0 15 15 15 eff.exe i01_437d.gif 425 366 0 1 0 15 15 15 * In the database window, you cl isave 335 205 620 154 text1 textbox 335 205 620 154 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_438a.gif 24 370 0 1 0 15 15 15 eff.exe i01_438b.gif 289 386 0 1 0 15 15 15 eff.exe i01_438c.gif 24 41 0 1 0 15 15 15 eff.exe i01_438d.gif 289 41 0 1 0 15 15 15 * You click the New button isave 335 159 620 120 text2 growbox 335 159 620 120 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_439a.gif 8 379 0 1 0 15 15 15 eff.exe i01_439b.gif 458 318 0 1 0 15 15 15 * Then you double-click the Form isave 335 125 620 69 text3 growbox 335 125 620 69 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 335 125 image memory text2 0 335 159 image memory text1 0 335 205 * eff.exe i01_440a.gif 4 436 0 1 0 15 15 15 eff.exe i01_440b.gif 4 18 0 1 0 15 15 15 * In the Tables/Queries box, you isave 11 182 249 114 text1 textbox 11 182 249 114 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_441a.gif 12 312 0 1 0 15 15 15 * Then you double-click Company isave 11 119 249 29 text2 growbox 11 119 249 29 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 11 119 image memory text1 0 11 182 * eff.exe i01_442a.gif 4 312 0 1 0 15 15 15 eff.exe i01_442b.gif 373 252 0 1 0 15 15 15 * In the Tables/Queries list box isave 337 316 625 265 text1 textbox 337 316 625 265 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_443a.gif 0 456 0 1 0 15 15 15 * Then you double-click Order ID isave 337 270 625 231 text2 growbox 337 270 625 231 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_444a.gif 14 318 0 1 0 15 15 15 eff.exe i01_444b.gif 313 160 0 1 0 15 15 15 * You click Next isave 337 236 625 197 text3 growbox 337 236 625 197 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 337 236 image memory text2 0 337 270 image memory text1 0 337 316 * eff.exe i01_445a.gif 10 376 0 1 0 15 15 15 * You select the Form with Subfo isave 413 299 627 231 text1 textbox 413 299 627 231 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_446a.gif 10 376 0 1 0 15 15 15 * You select Datasheet as the la isave 413 236 627 163 text2 growbox 413 236 627 163 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 413 236 image memory text1 0 413 299 * eff.exe i01_447a.gif 12 373 0 1 0 15 15 15 eff.exe i01_447b.gif 12 354 0 1 0 15 15 15 * Access allows you to select a isave 338 337 543 269 text1 textbox 338 337 543 269 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_448a.gif 27 249 0 1 0 15 15 15 eff.exe i01_448b.gif 237 210 0 1 0 15 15 15 * You click Next isave 338 274 543 235 text2 growbox 338 274 543 235 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 338 274 image memory text1 0 338 337 * eff.exe i01_449a.gif 10 424 0 1 0 15 15 15 eff.exe i01_449b.gif 10 382 0 1 0 15 15 15 * You give the form an appropria isave 6 195 214 144 text1 textbox 6 195 214 144 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_450a.gif 368 382 0 1 0 15 15 15 eff.exe i01_450b.gif 397 157 0 1 0 15 15 15 * Then you click the Finish butt isave 6 149 214 76 text2 growbox 6 149 214 76 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_451a.gif 0 459 0 1 0 15 15 15 * Access saves both the main for isave 6 81 214 25 text3 growbox 6 81 214 25 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 6 81 image memory text2 0 6 149 image memory text1 0 6 195 * eff.exe i01_452a.gif 12 372 0 1 0 15 15 15 eff.exe i01_452b.gif 428 214 0 1 0 15 15 15 * As your business needs change, isave 44 208 403 157 text1 textbox 44 208 403 157 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_453a.gif 12 372 0 1 0 15 15 15 * For example, you may have a Pr isave 44 162 403 106 text2 growbox 44 162 403 106 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_454a.gif 135 353 0 1 0 15 15 15 * To avoid having to switch betw isave 44 111 403 38 text3 growbox 44 111 403 38 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 44 111 image memory text2 0 44 162 image memory text1 0 44 208 * eff.exe i01_455a.gif 50 431 0 1 0 15 15 15 eff.exe i01_455b.gif 50 366 0 1 0 15 15 15 * You click the Products form, a isave 246 230 511 179 text1 textbox 246 230 511 179 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_456a.gif 1 452 0 1 0 15 15 15 * If the Toolbox is not visible, isave 246 184 511 128 text2 growbox 246 184 511 128 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 246 184 image memory text1 0 246 230 * eff.exe i01_457a.gif 0 436 0 1 0 15 15 15 eff.exe i01_457b.gif 0 224 0 1 0 15 15 15 * You click the Subform/Subrepor isave 343 249 633 215 text1 textbox 343 249 633 215 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_458a.gif 11 434 0 1 0 15 15 15 eff.exe i01_458b.gif 470 434 0 1 0 15 15 15 eff.exe i01_458c.gif 4 237 0 1 0 15 15 15 * Then you drag the crosshair to isave 343 220 633 164 text2 growbox 343 220 633 164 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 343 220 image memory text1 0 343 249 * eff.exe i01_459a.gif 4 434 0 1 0 15 15 15 eff.exe i01_459b.gif 4 18 0 1 0 15 15 15 * In the Subform/Subreport dialo isave 380 436 633 351 text1 textbox 380 436 633 351 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_460a.gif 0 459 0 1 0 15 15 15 * You click the Table/Query radi isave 380 356 633 283 text2 growbox 380 356 633 283 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_461a.gif 70 259 0 1 0 15 15 15 * Then you click Next isave 380 288 633 249 text3 growbox 380 288 633 249 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 380 288 image memory text2 0 380 356 image memory text1 0 380 436 * eff.exe i01_462a.gif 0 459 0 1 0 15 15 15 * In the Tables and Queries list isave 8 434 236 383 text1 textbox 8 434 236 383 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_463a.gif 37 401 0 1 0 15 15 15 eff.exe i01_463b.gif 37 270 0 1 0 15 15 15 * In the Available fields list y isave 8 388 236 315 text2 growbox 8 388 236 315 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_464a.gif 0 459 0 1 0 15 15 15 * Then you click Next isave 8 320 236 281 text3 growbox 8 320 236 281 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 8 320 image memory text2 0 8 388 image memory text1 0 8 434 * eff.exe i01_465a.gif 36 405 0 1 0 15 15 15 eff.exe i01_465b.gif 36 331 0 1 0 15 15 15 * Access allows you to define th isave 4 456 249 388 text1 textbox 4 456 249 388 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_466a.gif 70 295 0 1 0 15 15 15 eff.exe i01_466b.gif 378 283 0 1 0 15 15 15 * You click the Choose from a li isave 4 393 249 337 text2 growbox 4 393 249 337 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_467a.gif 70 288 0 1 0 15 15 15 * Here, you select the link Show isave 4 342 249 269 text3 growbox 4 342 249 269 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_468a.gif 0 459 0 1 0 15 15 15 * Then you click Next isave 4 274 249 235 text4 growbox 4 274 249 235 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 4 274 image memory text3 0 4 342 image memory text2 0 4 393 image memory text1 0 4 456 * eff.exe i01_469a.gif 0 459 0 1 0 15 15 15 * You name the new subform you'v isave 238 244 426 193 text1 textbox 238 244 426 193 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_470a.gif 360 335 0 1 0 15 15 15 eff.exe i01_470b.gif 495 162 0 1 0 15 15 15 * Then you click Finish to close isave 238 198 426 142 text2 growbox 238 198 426 142 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 238 198 image memory text1 0 238 244 * eff.exe i01_471a.gif 0 452 0 1 0 15 15 15 * Access creates the form you've isave 324 366 540 298 text1 textbox 324 366 540 298 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_472a.gif 206 276 0 1 0 15 15 15 * You can open it by double-clic isave 324 303 540 247 text2 growbox 324 303 540 247 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_473a.gif 2 452 0 1 0 15 15 15 * It opens in the default view isave 324 252 540 213 text3 growbox 324 252 540 213 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 324 252 image memory text2 0 324 303 image memory text1 0 324 366 * eff.exe i01_474a.gif 2 452 0 1 0 15 15 15 * Let's see what the subform loo isave 7 456 221 388 text1 textbox 7 456 221 388 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_475a.gif 117 295 0 1 0 15 15 15 * You double-click the main form isave 7 393 221 337 text2 growbox 7 393 221 337 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_476a.gif 0 455 0 1 0 15 15 15 * Access nests the Products/Manu isave 7 342 221 269 text3 growbox 7 342 221 269 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 7 342 image memory text2 0 7 393 image memory text1 0 7 456 * * Topic: Hands-on: Creating a subform Topic No.: 5 **** simscrn 1 7 8 * MoveCtrl 1 493 500 0 exercise 02 2 120 70 task 02 0102 402 300 235 3 120 67 35 75 * pause 1 1 1 1 1 1 1 1 * * simscrn 1 8 8 * MoveCtrl 1 493 500 0 0 * isave 16 204 242 119 text1 textbox 16 204 242 119 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 16 204 * task 3 0103 402 1 235 9 120 67 35 75 * pause 1 1 1 1 1 1 1 1