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

Wrap

Text File | 1997-05-12 | 58.2 KB | 2,170 lines

* Screen 3 1 14 ********************************* * Course: Access 97 for Power Users * Unit: Importing and exporting data Unit No.:03 * Topic: Importing from Access databases Topic No.: 1 **** eff.exe p03_101.gif 86 443 0 1 0 15 15 15 * Sometimes when you are working isave 89 439 356 371 text1 textbox 89 439 356 371 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_102a.gif 236 279 0 1 0 15 15 15 * Access 97 allows you to import isave 89 376 356 286 text2 growbox 89 376 356 286 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 89 376 image memory text1 0 89 439 * qcall PA03q 030101 eff.exe p03_103a.gif 404 350 0 1 0 15 15 15 eff.exe p03_103b.gif 210 258 0 1 0 15 15 15 * When you import data, you crea isave 92 437 342 386 text1 textbox 92 437 342 386 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_103.gif 86 443 0 1 0 15 15 15 * The external source of the dat isave 92 391 342 335 text2 growbox 92 391 342 335 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 92 391 image memory text1 0 92 437 * eff.exe p03_105a.gif 210 258 0 1 0 15 15 15 eff.exe p03_105b.gif 383 369 0 1 0 15 15 15 * When you import data from an A isave 18 452 269 384 text1 textbox 18 452 269 384 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall PA03q 030102 eff.exe p03_106a.gif 243 284 0 1 0 15 15 15 eff.exe p03_106b.gif 409 339 0 1 0 15 15 15 * When you import data from anot isave 18 389 269 299 text2 growbox 18 389 269 299 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_107.gif 86 443 0 1 0 15 15 15 * Imported objects are displayed isave 18 304 269 231 text3 growbox 18 304 269 231 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 18 304 image memory text2 0 18 389 image memory text1 0 18 452 * eff.exe p03_108a.gif 243 284 0 1 0 15 15 15 eff.exe p03_108b.gif 318 369 0 1 0 15 15 15 * Sometimes you may want to use isave 4 456 297 388 text1 textbox 4 456 297 388 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_109a.gif 406 351 0 1 0 15 15 15 eff.exe p03_109b.gif 293 265 0 1 0 15 15 15 * Access allows you to link data isave 4 393 297 303 text2 growbox 4 393 297 303 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_110a.gif 339 319 0 1 0 15 15 15 * The data remains in its extern isave 4 308 297 269 text3 growbox 4 308 297 269 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 4 308 image memory text2 0 4 393 image memory text1 0 4 456 * eff.exe p03_111a.gif 339 374 0 1 0 15 15 15 eff.exe p03_111b.gif 221 162 0 1 0 15 15 15 * When you link data from an Acc isave 5 456 268 405 text1 textbox 5 456 268 405 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_112a.gif 328 374 0 1 0 15 15 15 eff.exe p03_112b.gif 221 162 0 1 0 15 15 15 * When you link data from anothe isave 5 410 268 337 text2 growbox 5 410 268 337 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_113a.gif 328 374 0 1 0 15 15 15 eff.exe p03_113b.gif 211 164 0 1 0 15 15 15 * Icons for linked tables are ma isave 5 342 268 286 text3 growbox 5 342 268 286 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Icons for imported tables that notebox 14 257 256 * image memory text3 0 5 342 image memory text2 0 5 410 image memory text1 0 5 456 * eff.exe p03_114a.gif 211 374 0 1 0 15 15 15 * When choosing between importin isave 89 439 343 354 text1 textbox 89 439 343 354 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 89 439 * eff.exe p03_115a.gif 210 350 0 1 0 15 15 15 * You should consider importing isave 3 457 244 321 text1 textbox 3 457 244 321 showtext 0 0 7 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_116.gif 86 443 0 1 0 15 15 15 * ≥ you don't need to share the isave 3 326 244 253 text2 growbox 3 326 244 253 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_117a.gif 404 342 0 1 0 15 15 15 eff.exe p03_117b.gif 236 148 0 1 0 15 15 15 eff.exe p03_117c.gif 352 227 0 1 0 15 15 15 * ≥ you no longer need the data isave 3 258 244 202 text3 growbox 3 258 244 202 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_118a.gif 404 342 0 1 0 15 15 15 eff.exe p03_118b.gif 236 238 0 1 0 15 15 15 * ≥ you need the best possible p isave 3 207 244 100 text4 growbox 3 207 244 100 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 3 207 image memory text3 0 3 258 image memory text2 0 3 326 image memory text1 0 3 457 * eff.exe p03_119a.gif 352 370 0 1 0 15 15 15 eff.exe p03_119b.gif 210 265 0 1 0 15 15 15 * You should consider linking da isave 4 455 305 353 text1 textbox 4 455 305 353 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_120a.gif 352 370 0 1 0 15 15 15 * ≥ the data is changed frequent isave 4 358 305 302 text2 growbox 4 358 305 302 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_121.gif 86 443 0 1 0 15 15 15 * ≥ you must share the file with isave 4 307 305 251 text3 growbox 4 307 305 251 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 4 307 image memory text2 0 4 358 image memory text1 0 4 455 * eff.exe p03_122a.gif 233 351 0 1 0 15 15 15 * If you attempt to import a tab isave 89 440 369 372 text1 textbox 89 440 369 372 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_123a.gif 242 281 0 1 0 15 15 15 eff.exe p03_123b.gif 233 151 0 1 0 15 15 15 * Instead a table is created tha isave 89 377 369 321 text2 growbox 89 377 369 321 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 89 377 image memory text1 0 89 440 * SimScrn 3 2 14 ********************************* eff.exe p03_124.gif 0 459 0 1 0 15 15 15 * Suppose you are working with y isave 413 455 634 370 text1 textbox 413 455 634 370 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_125a.gif 29 457 0 1 0 15 15 15 * You first select File isave 413 375 634 336 text2 growbox 413 375 634 336 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03a126a.gif 32 439 0 1 0 15 15 15 *qcall PA03q 030103 eff.exe p03_126a.gif 17 414 0 1 0 15 15 15 * And then you select Get Extern isave 413 341 634 285 text3 growbox 413 341 634 285 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 413 341 image memory text2 0 413 375 image memory text1 0 413 455 * eff.exe p03_127a.gif 14 457 0 1 0 15 15 15 * You find the database from whi isave 225 373 400 305 text1 textbox 225 373 400 305 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * You need to make sure that Mic notebox 188 263 434 ** eff.exe p03_129a.gif 14 409 0 1 0 15 15 15 eff.exe p03_129b.gif 440 392 0 1 0 15 15 15 * And you click Import isave 225 310 400 271 text2 growbox 225 310 400 271 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 225 310 image memory text1 0 225 373 * eff.exe p03_130a.gif 6 449 0 1 0 15 15 15 * The Import Objects dialog box isave 144 292 354 190 text1 textbox 144 292 354 190 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_131a.gif 6 448 0 1 0 15 15 15 * Suppose you want to import the isave 144 195 354 139 text2 growbox 144 195 354 139 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_132a.gif 27 368 0 1 0 15 15 15 eff.exe p03_132b.gif 27 342 0 1 0 15 15 15 * You select Sales from the Tabl isave 144 144 354 88 text3 growbox 144 144 354 88 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * To select all the objects on a notebox 143 389 354 ** image memory text3 0 144 144 image memory text2 0 144 195 image memory text1 0 144 292 * eff.exe p03_134a.gif 27 342 0 1 0 15 15 15 * You click the Options button t isave 375 314 629 263 text1 textbox 375 314 629 263 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_135a.gif 42 366 0 1 0 15 15 15 eff.exe p03_135b.gif 16 247 0 1 0 15 15 15 * Access allows you to include t isave 375 268 629 161 text2 growbox 375 268 629 161 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_136a.gif 383 366 0 1 0 15 15 15 eff.exe p03_136b.gif 23 200 0 1 0 15 15 15 * ≥ custom menus and Toolbar isave 375 166 629 127 text3 growbox 375 166 629 127 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_137a.gif 23 178 0 1 0 15 15 15 * ≥ all import and export specif isave 375 132 629 59 text4 growbox 375 132 629 59 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 375 132 image memory text3 0 375 166 image memory text2 0 375 268 image memory text1 0 375 314 * eff.exe p03_138a.gif 23 181 0 1 0 15 15 15 * To import only a table's defin isave 339 343 548 275 text1 textbox 339 343 548 275 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Definitions are a table's stru notebox 341 251 539 ** eff.exe p03_140a.gif 186 199 0 1 0 15 15 15 * But to import both a table's d isave 339 280 548 207 text2 growbox 339 280 548 207 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 339 280 image memory text1 0 339 343 * eff.exe p03_141a.gif 155 383 0 1 0 15 15 15 eff.exe p03_141b.gif 186 199 0 1 0 15 15 15 * To import objects other than t isave 124 276 352 208 text1 textbox 124 276 352 208 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_142a.gif 27 403 0 1 0 15 15 15 eff.exe p03_142b.gif 27 187 0 1 0 15 15 15 * And then you select the report isave 124 213 352 157 text2 growbox 124 213 352 157 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 124 213 image memory text1 0 124 276 * eff.exe p03_143a.gif 27 382 0 1 0 15 15 15 eff.exe p03_143b.gif 345 181 0 1 0 15 15 15 * If you are importing queries, isave 63 341 313 273 text1 textbox 63 341 313 273 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_144a.gif 345 196 0 1 0 15 15 15 * Or you can save them as querie isave 63 278 313 239 text2 growbox 63 278 313 239 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 63 278 image memory text1 0 63 341 * eff.exe p03_145a.gif 279 369 0 1 0 15 15 15 eff.exe p03_145b.gif 345 196 0 1 0 15 15 15 * Once you have finished selecti isave 53 341 259 273 text1 textbox 53 341 259 273 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 53 341 * eff.exe p03_146a.gif 6 436 0 1 0 15 15 15 eff.exe p03_146b.gif 550 430 0 1 0 15 15 15 * As you can see, the 1997 Sales isave 248 364 541 313 text1 textbox 248 364 541 313 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_147a.gif 291 431 0 1 0 15 15 15 eff.exe p03_147b.gif 6 403 0 1 0 15 15 15 eff.exe p03_147c.gif 298 403 0 1 0 15 15 15 * The Sales table from the Auckl isave 248 318 541 262 text2 growbox 248 318 541 262 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * The table has been given the n notebox 271 236 516 ** image memory text2 0 248 318 image memory text1 0 248 364 * eff.exe p03_149a.gif 11 367 0 1 0 15 15 15 * It's just as easy to link tabl isave 20 267 280 216 text1 textbox 20 267 280 216 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** qcall PA03q 030104 eff.exe p03_150a.gif 18 457 0 1 0 15 15 15 * You select File - Get External isave 20 221 280 182 text2 growbox 20 221 280 182 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_151a.gif 18 410 0 1 0 15 15 15 * And then you choose Link Table isave 20 187 280 148 text3 growbox 20 187 280 148 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 20 187 image memory text2 0 20 221 image memory text1 0 20 267 * * Topic: Hands-on: Linking tables Topic No.: 2 **** SimScrn 3 3 14 ********************************* MoveCtrl 1 493 426 0 0 * Suppose you want to be able to isave 123 334 369 249 text1 textbox 123 334 369 249 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * You want to link the data so t isave 123 254 369 164 text2 growbox 123 254 369 164 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 * * image memory text2 0 123 254 image memory text1 0 123 334 * * You decide to link all the tab isave 120 343 389 275 text1 textbox 120 343 389 275 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Both the Sales and Expenses da isave 120 280 389 224 text2 growbox 120 280 389 224 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 * * image memory text2 0 120 280 image memory text1 0 120 343 * * exercise 01 1 120 80 task 1 0301 376 380 266 5 50 67 0 5 ** pause 1 1 1 1 1 1 1 1 * * Topic: Importing from non-Access sources Topic No.: 3 **** SimScrn 3 4 14 ********************************* eff.exe p03_301.gif 0 459 0 1 0 15 15 15 * One of the advantages of Acces isave 3 457 277 389 text1 textbox 3 457 277 389 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** footnote 1 qcall PA03q 030301 eff.exe p03_302a.gif 383 219 0 1 0 15 15 15 * Access allows you to import or isave 3 394 277 304 text2 growbox 3 394 277 304 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_303a.gif 383 219 0 1 0 15 15 15 * ≥ Microsoft FoxPr isave 3 309 277 270 text3 growbox 3 309 277 270 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_304a.gif 405 198 0 1 0 15 15 15 * ≥ dBAS isave 3 275 277 236 text4 growbox 3 275 277 236 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_305a.gif 410 199 0 1 0 15 15 15 * ≥ Parado isave 3 241 277 202 text5 growbox 3 241 277 202 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_306a.gif 404 201 0 1 0 15 15 15 * ≥ Lotus 1-2- isave 3 207 277 168 text6 growbox 3 207 277 168 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_307a.gif 283 275 0 1 0 15 15 15 * ≥ delimited text file isave 3 173 277 134 text7 growbox 3 173 277 134 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_308a.gif 365 266 0 1 0 15 15 15 eff.exe p03_308b.gif 283 197 0 1 0 15 15 15 * ≥ fixed-width text file isave 3 139 277 100 text8 growbox 3 139 277 100 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_309a.gif 325 293 0 1 0 15 15 15 * ≥ HTML file isave 3 105 277 66 text9 growbox 3 105 277 66 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_310a.gif 322 273 0 1 0 15 15 15 * ≥ other DBMSs and applications growbox 3 71 277 15 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** footnote 0 image memory text0 0 3 71 image memory text9 0 3 105 image memory text8 0 3 139 image memory text7 0 3 173 image memory text6 0 3 207 image memory text5 0 3 241 image memory text4 0 3 275 image memory text3 0 3 309 image memory text2 0 3 394 image memory text1 0 3 457 * eff.exe p03_311a.gif 322 293 0 1 0 15 15 15 * Suppose you want to import an isave 424 406 636 338 text1 textbox 424 406 636 338 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03a312a.gif 29 457 0 1 0 15 15 15 qcall PA03q 030302 eff.exe p03_312a.gif 17 414 0 1 0 15 15 15 eff.exe p03_312b.gif 63 143 0 1 0 15 15 15 * With the database open, you se isave 424 343 636 270 text2 growbox 424 343 636 270 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 424 343 image memory text1 0 424 406 * eff.exe p03_313a.gif 17 457 0 1 0 15 15 15 * You select Microsoft Excel fro isave 181 357 399 289 text1 textbox 181 357 399 289 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_314a.gif 14 396 0 1 0 15 15 15 eff.exe p03_314b.gif 31 136 0 1 0 15 15 15 * Now you find and select the fi isave 181 294 399 238 text2 growbox 181 294 399 238 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_315a.gif 14 387 0 1 0 15 15 15 eff.exe p03_315b.gif 442 374 0 1 0 15 15 15 * You then click Import isave 181 243 399 204 text3 growbox 181 243 399 204 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 181 243 image memory text2 0 181 294 image memory text1 0 181 357 * eff.exe p03_316a.gif 16 437 0 1 0 15 15 15 eff.exe p03_316b.gif 11 18 0 1 0 15 15 15 * You select the worksheet that isave 5 454 207 403 text1 textbox 5 454 207 403 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * To import a named range you se notebox 8 374 237 ** eff.exe p03_318a.gif 17 384 0 1 0 15 15 15 * The data on the sheet is displ isave 5 408 207 318 text2 growbox 5 408 207 318 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** * You can use the scroll bars to notebox 220 429 421 ** eff.exe p03_320a.gif 17 271 0 1 0 15 15 15 * Now you click Next isave 5 323 207 284 text3 growbox 5 323 207 284 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 5 323 image memory text2 0 5 408 image memory text1 0 5 454 * eff.exe p03_321a.gif 11 402 0 1 0 15 15 15 * If you check First Row Contain isave 334 356 537 237 text1 textbox 334 356 537 237 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_322a.gif 11 386 0 1 0 15 15 15 eff.exe p03_322b.gif 330 169 0 1 0 15 15 15 * You click Next isave 334 242 537 203 text2 growbox 334 242 537 203 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** footnote 2 image memory text2 0 334 242 image memory text1 0 334 356 * eff.exe p03_323a.gif 17 402 0 1 0 15 15 15 eff.exe p03_323b.gif 330 169 0 1 0 15 15 15 * To add the data to a table, yo isave 403 364 618 279 text1 textbox 403 364 618 279 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_324a.gif 15 373 0 1 0 15 15 15 * But to create a new table to c isave 403 284 618 211 text2 growbox 403 284 618 211 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_325a.gif 15 373 0 1 0 15 15 15 eff.exe p03_325b.gif 330 169 0 1 0 15 15 15 * Then you click Next isave 403 216 618 177 text3 growbox 403 216 618 177 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** footnote 0 image memory text3 0 403 216 image memory text2 0 403 284 image memory text1 0 403 364 * SimScrn 3 5 14 ********************************* eff.exe p03_326.gif 0 459 0 1 0 15 15 15 * Access highlights the first fi isave 374 405 628 337 text1 textbox 374 405 628 337 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_327a.gif 19 361 0 1 0 15 15 15 eff.exe p03_327b.gif 460 361 0 1 0 15 15 15 * You can change the field's nam isave 374 342 628 286 text2 growbox 374 342 628 286 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_328a.gif 25 361 0 1 0 15 15 15 * You can specify whether or not isave 374 291 628 201 text3 growbox 374 291 628 201 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** * For information on indexing fi notebox 375 177 620 ** image memory text3 0 374 291 image memory text2 0 374 342 image memory text1 0 374 405 * qcall PA03q 030303 eff.exe p03_330a.gif 25 361 0 1 0 15 15 15 * Access automatically assigns t isave 228 259 443 208 text1 textbox 228 259 443 208 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * You can only change the data t notebox 194 182 472 ** footnote 3 eff.exe p03_332a.gif 19 361 0 1 0 15 15 15 * A data type is chosen on the b isave 228 213 443 157 text2 growbox 228 213 443 157 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_333a.gif 19 361 0 1 0 15 15 15 * In this example, the data type isave 228 162 443 89 text3 growbox 228 162 443 89 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 228 162 image memory text2 0 228 213 image memory text1 0 228 259 * eff.exe p03_334a.gif 42 345 0 1 0 15 15 15 eff.exe p03_334b.gif 248 361 0 1 0 15 15 15 * To select another field, you c isave 22 224 265 173 text1 textbox 22 224 265 173 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_335a.gif 111 334 0 1 0 15 15 15 eff.exe p03_335b.gif 248 334 0 1 0 15 15 15 * If you do not want the field t isave 22 178 265 105 text2 growbox 22 178 265 105 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** footnote 0 image memory text2 0 22 178 image memory text1 0 22 224 * eff.exe p03_336a.gif 251 334 0 1 0 15 15 15 eff.exe p03_336b.gif 330 169 0 1 0 15 15 15 * Once you have finished modifyi isave 22 189 273 138 text1 textbox 22 189 273 138 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 22 189 * qcall PA03q 030304 eff.exe p03_337a.gif 28 406 0 1 0 15 15 15 eff.exe p03_337b.gif 17 273 0 1 0 15 15 15 * By default, Access defines a P isave 104 242 321 191 text1 textbox 104 242 321 191 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 104 242 * eff.exe p03_338a.gif 17 357 0 1 0 15 15 15 * To use a different field as th isave 33 456 272 388 text1 textbox 33 456 272 388 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_339a.gif 150 349 0 1 0 15 15 15 * You then select a field from t isave 33 393 272 320 text2 growbox 33 393 272 320 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_340a.gif 42 348 0 1 0 15 15 15 * In this example, the Staff Cod isave 33 325 272 269 text3 growbox 33 325 272 269 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_341a.gif 173 272 0 1 0 15 15 15 * Now you click Next isave 33 274 272 235 text4 growbox 33 274 272 235 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 33 274 image memory text3 0 33 325 image memory text2 0 33 393 image memory text1 0 33 456 * eff.exe p03_342a.gif 28 402 0 1 0 15 15 15 * You can type a name for the ne isave 448 296 634 228 text1 textbox 448 296 634 228 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_343a.gif 147 327 0 1 0 15 15 15 eff.exe p03_343b.gif 415 170 0 1 0 15 15 15 * Then you click Finish isave 448 233 634 194 text2 growbox 448 233 634 194 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_344a.gif 16 437 0 1 0 15 15 15 eff.exe p03_344b.gif 11 18 0 1 0 15 15 15 * And you click OK isave 448 199 634 160 text3 growbox 448 199 634 160 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 448 199 image memory text2 0 448 233 image memory text1 0 448 296 * eff.exe p03_345a.gif 10 367 0 1 0 15 15 15 * As you can see, a new table ha isave 412 292 626 207 text1 textbox 412 292 626 207 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_346a.gif 2 452 0 1 0 15 15 15 * You can open the table and wor isave 412 212 626 139 text2 growbox 412 212 626 139 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 412 212 image memory text1 0 412 292 * eff.exe p03_347a.gif 2 452 0 1 0 15 15 15 * Linking worksheets from Excel isave 5 209 249 158 text1 textbox 5 209 249 158 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_348a.gif 26 457 0 1 0 15 15 15 * You begin by selecting File - isave 5 163 249 107 text2 growbox 5 163 249 107 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 5 163 image memory text1 0 5 209 * eff.exe p03_349a.gif 17 457 0 1 0 15 15 15 * With Microsoft Excel selected isave 10 325 250 240 text1 textbox 10 325 250 240 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_350a.gif 94 435 0 1 0 15 15 15 eff.exe p03_350b.gif 443 374 0 1 0 15 15 15 * You click Link isave 10 245 250 206 text2 growbox 10 245 250 206 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_351a.gif 15 439 0 1 0 15 15 15 eff.exe p03_351b.gif 12 18 0 1 0 15 15 15 * And you follow the instruction isave 10 211 250 155 text3 growbox 10 211 250 155 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * When you link a spreadsheet, A notebox 10 125 270 ** image memory text3 0 10 211 image memory text2 0 10 245 image memory text1 0 10 325 * eff.exe p03_353a.gif 6 439 0 1 0 15 15 15 eff.exe p03_353b.gif 6 18 0 1 0 15 15 15 * Tables linked to Excel sheets isave 21 210 273 159 text1 textbox 21 210 273 159 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_354a.gif 2 452 0 1 0 15 15 15 * You can use tables linked to E isave 21 164 273 108 text2 growbox 21 164 273 108 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_355a.gif 68 396 0 1 0 15 15 15 eff.exe p03_355b.gif 482 312 0 1 0 15 15 15 eff.exe p03_355c.gif 295 141 0 1 0 15 15 15 * But any changes you make to th isave 21 113 273 40 text3 growbox 21 113 273 40 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 21 113 image memory text2 0 21 164 image memory text1 0 21 210 * SimScrn 3 6 14 ********************************* eff.exe p03_356.gif 0 459 0 1 0 15 15 15 * Importing and linking text fil isave 21 368 329 317 text1 textbox 21 368 329 317 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_357.gif 0 459 0 1 0 15 15 15 * This is because the data in te isave 21 322 329 249 text2 growbox 21 322 329 249 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 21 322 image memory text1 0 21 368 * eff.exe p03_358a.gif 416 297 0 1 0 15 15 15 * Access can import two types of isave 20 368 195 283 text1 textbox 20 368 195 283 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_359a.gif 381 303 0 1 0 15 15 15 * ≥ fixed-widt isave 20 288 195 249 text2 growbox 20 288 195 249 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 20 288 image memory text1 0 20 368 * eff.exe p03_360a.gif 0 456 0 1 0 15 15 15 * Delimited text files use delim isave 6 318 255 250 text1 textbox 6 318 255 250 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_361a.gif 67 272 0 1 0 15 15 15 eff.exe p03_361b.gif 332 251 0 1 0 15 15 15 * Most characters can be used as isave 6 255 255 148 text2 growbox 6 255 255 148 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_362a.gif 481 83 0 1 0 15 15 15 * ≥ tab isave 6 153 255 114 text3 growbox 6 153 255 114 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_363a.gif 481 88 0 1 0 15 15 15 * ≥ semicolon isave 6 119 255 80 text4 growbox 6 119 255 80 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_364a.gif 495 88 0 1 0 15 15 15 * ≥ space isave 6 85 255 46 text5 growbox 6 85 255 46 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text5 0 6 85 image memory text4 0 6 119 image memory text3 0 6 153 image memory text2 0 6 255 image memory text1 0 6 318 * eff.exe p03_365a.gif 11 328 0 1 0 15 15 15 * In this example, commas are us isave 143 192 483 158 text1 textbox 143 192 483 158 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_366a.gif 169 303 0 1 0 15 15 15 * Each comma indicates the end o isave 143 163 483 107 text2 growbox 143 163 483 107 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Carriage returns indicate the notebox 189 307 434 ** image memory text2 0 143 163 image memory text1 0 143 192 * qcall PA03q 030305 eff.exe p03_368a.gif 529 434 0 1 0 15 15 15 eff.exe p03_368b.gif 11 363 0 1 0 15 15 15 * Fixed-width text files contain isave 172 265 418 197 text1 textbox 172 265 418 197 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_369a.gif 222 359 0 1 0 15 15 15 * For example, in this text file isave 172 202 418 146 text2 growbox 172 202 418 146 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 172 202 image memory text1 0 172 265 * SimScrn 3 7 14 ********************************* eff.exe p03_370.gif 0 459 0 1 0 15 15 15 * Suppose you want to import the isave 5 454 226 369 text1 textbox 5 454 226 369 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_371a.gif 421 289 0 1 0 15 15 15 * You first need to make sure th isave 5 374 226 267 text2 growbox 5 374 226 267 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 5 374 image memory text1 0 5 454 * eff.exe p03_372a.gif 0 456 0 1 0 15 15 15 * You open the Sales database isave 21 343 243 309 text1 textbox 21 343 243 309 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_373a.gif 17 457 0 1 0 15 15 15 * And then you select File - Get isave 21 314 243 258 text2 growbox 21 314 243 258 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 21 314 image memory text1 0 21 343 * eff.exe p03_374a.gif 17 457 0 1 0 15 15 15 * You select Text Files from the isave 139 456 375 405 text1 textbox 139 456 375 405 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_375a.gif 29 373 0 1 0 15 15 15 eff.exe p03_375b.gif 31 136 0 1 0 15 15 15 * And then you double-click the isave 139 410 375 354 text2 growbox 139 410 375 354 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 139 410 image memory text1 0 139 456 * qcall PA03q 030306 eff.exe p03_376a.gif 16 437 0 1 0 15 15 15 eff.exe p03_376b.gif 11 18 0 1 0 15 15 15 * Access tries to determine whet isave 25 281 289 230 text1 textbox 25 281 289 230 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_377a.gif 19 380 0 1 0 15 15 15 * In this example, Access determ isave 25 235 289 179 text2 growbox 25 235 289 179 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * If Access has not made the cor notebox 32 395 277 ** eff.exe p03_379a.gif 20 362 0 1 0 15 15 15 eff.exe p03_379b.gif 330 175 0 1 0 15 15 15 * Now you click Next isave 25 184 289 145 text3 growbox 25 184 289 145 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 25 184 image memory text2 0 25 235 image memory text1 0 25 281 * eff.exe p03_380a.gif 31 402 0 1 0 15 15 15 eff.exe p03_380b.gif 28 367 0 1 0 15 15 15 * Access tries to determine whic isave 23 454 267 403 text1 textbox 23 454 267 403 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * If Access does not make the co notebox 43 376 239 ** qcall PA03q 030307 eff.exe p03_382a.gif 18 362 0 1 0 15 15 15 * Access uses the delimiter to d isave 23 408 267 352 text2 growbox 23 408 267 352 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_383a.gif 18 258 0 1 0 15 15 15 * Now you click Next isave 23 357 267 318 text3 growbox 23 357 267 318 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 23 357 image memory text2 0 23 408 image memory text1 0 23 454 * eff.exe p03_384a.gif 28 402 0 1 0 15 15 15 * In this example, we'll add the isave 153 453 372 402 text1 textbox 153 453 372 402 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_385a.gif 143 350 0 1 0 15 15 15 * Now you click Next isave 153 407 372 368 text2 growbox 153 407 372 368 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 153 407 image memory text1 0 153 453 * eff.exe p03_386a.gif 28 406 0 1 0 15 15 15 * You click Finish to import the isave 160 455 335 404 text1 textbox 160 455 335 404 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_387a.gif 16 437 0 1 0 15 15 15 * Then you click OK isave 160 409 335 370 text2 growbox 160 409 335 370 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 160 409 image memory text1 0 160 455 * eff.exe p03_388a.gif 14 367 0 1 0 15 15 15 eff.exe p03_388b.gif 11 18 0 1 0 15 15 15 * The data has been imported int isave 129 456 382 405 text1 textbox 129 456 382 405 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_389a.gif 2 452 0 1 0 15 15 15 * If you open the table, you can isave 129 410 382 337 text2 growbox 129 410 382 337 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 129 410 image memory text1 0 129 456 * SimScrn 3 8 14 ********************************* eff.exe p03_390.gif 0 459 0 1 0 15 15 15 * An important feature of Access isave 5 445 257 360 text1 textbox 5 445 257 360 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_391a.gif 477 256 0 1 0 15 15 15 eff.exe p03_391b.gif 363 194 0 1 0 15 15 15 eff.exe p03_391c.gif 477 194 0 1 0 15 15 15 * You can import data directly f isave 5 365 257 292 text2 growbox 5 365 257 292 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** qcall PA03q 030308 eff.exe p03_392a.gif 207 203 0 1 0 15 15 15 * You can also import from any o isave 5 297 257 207 text3 growbox 5 297 257 207 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** * ODBC is now a widely accepted notebox 6 179 251 ** image memory text3 0 5 297 image memory text2 0 5 365 image memory text1 0 5 445 * eff.exe p03_394a.gif 378 295 0 1 0 15 15 15 * Suppose you want to link a tab isave 19 288 247 220 text1 textbox 19 288 247 220 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_395a.gif 29 457 0 1 0 15 15 15 * You select File - Get External isave 19 225 247 169 text2 growbox 19 225 247 169 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 19 225 image memory text1 0 19 288 * eff.exe p03_396a.gif 7 457 0 1 0 15 15 15 * You select dBase 5 from the Fi isave 201 371 407 303 text1 textbox 201 371 407 303 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_397a.gif 21 396 0 1 0 15 15 15 eff.exe p03_397b.gif 532 398 0 1 0 15 15 15 eff.exe p03_397c.gif 21 157 0 1 0 15 15 15 * Then you find and click the fi isave 201 308 407 252 text2 growbox 201 308 407 252 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_398a.gif 90 383 0 1 0 15 15 15 eff.exe p03_398b.gif 433 397 0 1 0 15 15 15 * And you click Link isave 201 257 407 218 text3 growbox 201 257 407 218 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 201 257 image memory text2 0 201 308 image memory text1 0 201 371 * eff.exe p03_399a.gif 3 451 0 1 0 15 15 15 * You click any index files asso isave 213 353 402 285 text1 textbox 213 353 402 285 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Index files for dBase use .ndx notebox 208 258 402 ** eff.exe p03a302a.gif 91 366 0 1 0 15 15 15 eff.exe p03a302b.gif 428 380 0 1 0 15 15 15 * Then you click Select isave 213 290 402 251 text2 growbox 213 290 402 251 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 213 290 image memory text1 0 213 353 * eff.exe p03a303a.gif 6 434 0 1 0 15 15 15 eff.exe p03a303b.gif 17 380 0 1 0 15 15 15 * You click OK isave 298 202 436 168 text1 textbox 298 202 436 168 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe p03a304a.gif 6 434 0 1 0 15 15 15 eff.exe p03a304b.gif 158 378 0 1 0 15 15 15 * And then you click Close isave 298 173 436 117 text2 growbox 298 173 436 117 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 298 173 image memory text1 0 298 202 * eff.exe p03a305a.gif 3 437 0 1 0 15 15 15 * You select an index that uniqu isave 5 445 242 394 text1 textbox 5 445 242 394 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03a306a.gif 132 350 0 1 0 15 15 15 * Then you click OK isave 5 399 242 360 text2 growbox 5 399 242 360 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03a307a.gif 134 384 0 1 0 15 15 15 * And you click OK again isave 5 365 242 326 text3 growbox 5 365 242 326 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03a308a.gif 10 451 0 1 0 15 15 15 eff.exe p03a308b.gif 182 398 0 1 0 15 15 15 * Then you click Close isave 5 331 242 292 text4 growbox 5 331 242 292 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 5 331 image memory text3 0 5 365 image memory text2 0 5 399 image memory text1 0 5 445 * eff.exe p03a309a.gif 4 454 0 1 0 15 15 15 * As you can see, a table is cre isave 214 346 406 278 text1 textbox 214 346 406 278 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 214 346 * * Topic: Hands-on: Linking a spreadsheet Topic No.: 4 **** SimScrn 3 9 14 ********************************* * Suppose you want to be able to isave 132 329 404 244 text1 textbox 132 329 404 244 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 * image memory text1 0 132 329 * * exercise 02 1 120 80 task 2 0302 372 85 266 8 50 67 5 5 * pause 1 1 1 1 1 1 1 1 ** * Topic: Exporting data Topic No.: 5 **** SimScrn 3 10 14 ********************************* eff.exe p03_501.gif 0 459 0 1 0 15 15 15 * Sometimes you need to export d isave 5 407 298 322 text1 textbox 5 407 298 322 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_502a.gif 288 290 0 1 0 15 15 15 * When you export data you creat isave 5 327 298 271 text2 growbox 5 327 298 271 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall PA03q 030501 eff.exe p03_503a.gif 153 325 0 1 0 15 15 15 eff.exe p03_503b.gif 170 238 0 1 0 15 15 15 * As with importing, the source isave 5 276 298 220 text3 growbox 5 276 298 220 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** footnote 4 image memory text3 0 5 276 image memory text2 0 5 327 image memory text1 0 5 407 * eff.exe p03_504a.gif 140 325 0 1 0 15 15 15 eff.exe p03_504b.gif 288 290 0 1 0 15 15 15 * Access 97 can export to most o isave 5 456 306 354 text1 textbox 5 456 306 354 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_505a.gif 342 220 0 1 0 15 15 15 * ≥ Microsoft Exce isave 5 359 306 320 text2 growbox 5 359 306 320 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_506a.gif 252 351 0 1 0 15 15 15 * ≥ delimited and fixed-width te isave 5 325 306 286 text3 growbox 5 325 306 286 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_507.gif 0 459 0 1 0 15 15 15 * ≥ DBMSs that support the ODBC isave 5 291 306 252 text4 growbox 5 291 306 252 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** footnote 0 image memory text4 0 5 291 image memory text3 0 5 325 image memory text2 0 5 359 image memory text1 0 5 456 * eff.exe p03_508a.gif 9 361 0 1 0 15 15 15 * Suppose you want to export the isave 23 236 247 151 text1 textbox 23 236 247 151 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * You can export any database ob notebox 22 123 268 ** qcall PA03q 030502 eff.exe p03_510a.gif 9 429 0 1 0 15 15 15 * You first click the table isave 23 156 247 117 text2 growbox 23 156 247 117 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_511a.gif 20 457 0 1 0 15 15 15 * Then you select File - Save As isave 23 122 247 66 text3 growbox 23 122 247 66 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 23 122 image memory text2 0 23 156 image memory text1 0 23 236 * eff.exe p03_512a.gif 20 457 0 1 0 15 15 15 * If you want to create a copy o isave 23 227 227 125 text1 textbox 23 227 227 125 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_513a.gif 29 363 0 1 0 15 15 15 * But to export the table you se isave 23 130 227 57 text2 growbox 23 130 227 57 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_514a.gif 29 450 0 1 0 15 15 15 * Then you click OK isave 23 62 227 23 text3 growbox 23 62 227 23 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 23 62 image memory text2 0 23 130 image memory text1 0 23 227 * eff.exe p03_515a.gif 14 450 0 1 0 15 15 15 * You find and select the databa isave 214 352 389 284 text1 textbox 214 352 389 284 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_516a.gif 14 369 0 1 0 15 15 15 eff.exe p03_516b.gif 404 374 0 1 0 15 15 15 * And you click Export isave 214 289 389 250 text2 growbox 214 289 389 250 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 214 289 image memory text1 0 214 352 * eff.exe p03_517a.gif 17 431 0 1 0 15 15 15 * You can change the name of the isave 172 213 380 145 text1 textbox 172 213 380 145 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_518a.gif 38 443 0 1 0 15 15 15 * Then you click OK isave 172 150 380 111 text2 growbox 172 150 380 111 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 172 150 image memory text1 0 172 213 * eff.exe p03_519a.gif 26 443 0 1 0 15 15 15 * A copy of the Customers table isave 22 291 235 223 text1 textbox 22 291 235 223 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 22 291 * eff.exe p03_520a.gif 69 270 0 1 0 15 15 15 eff.exe p03_520b.gif 311 343 0 1 0 15 15 15 eff.exe p03_520c.gif 457 150 0 1 0 15 15 15 * Exporting data to DBMSs other isave 5 454 249 386 text1 textbox 5 454 249 386 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 5 454 * eff.exe p03_521a.gif 13 452 0 1 0 15 15 15 * You can export t isave 5 391 244 323 text1 textbox 5 391 244 323 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_522a.gif 84 147 0 1 0 15 15 15 * ≥ FoxPro file isave 5 328 244 289 text2 growbox 5 328 244 289 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_523a.gif 85 147 0 1 0 15 15 15 * ≥ other ODBC-compliant DBMS isave 5 294 244 255 text3 growbox 5 294 244 255 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 5 294 image memory text2 0 5 328 image memory text1 0 5 391 * SimScrn 3 11 14 ********************************* eff.exe p03_524.gif 0 459 0 1 0 15 15 15 * Access allows you to export ta isave 196 456 543 405 text1 textbox 196 456 543 405 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_525a.gif 6 321 0 1 0 15 15 15 eff.exe p03_525b.gif 186 317 0 1 0 15 15 15 * Suppose you want to export the isave 196 410 543 354 text2 growbox 196 410 543 354 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 196 410 image memory text1 0 196 456 * eff.exe p03_526a.gif 6 389 0 1 0 15 15 15 * You click the Sales table icon isave 319 335 542 301 text1 textbox 319 335 542 301 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_527a.gif 20 457 0 1 0 15 15 15 * Then you select File - Save As isave 319 306 542 250 text2 growbox 319 306 542 250 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_528a.gif 20 457 0 1 0 15 15 15 * And you click OK isave 319 255 542 216 text3 growbox 319 255 542 216 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 319 255 image memory text2 0 319 306 image memory text1 0 319 335 * eff.exe p03_529a.gif 11 450 0 1 0 15 15 15 * You select the version of Exce isave 15 348 211 229 text1 textbox 15 348 211 229 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** footnote 5 eff.exe p03_530a.gif 23 393 0 1 0 15 15 15 eff.exe p03_530b.gif 83 172 0 1 0 15 15 15 * Then you click Export isave 15 234 211 195 text2 growbox 15 234 211 195 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** footnote 0 image memory text2 0 15 234 image memory text1 0 15 348 * eff.exe p03_531a.gif 11 450 0 1 0 15 15 15 * An Excel sheet that contains t isave 20 367 205 299 text1 textbox 20 367 205 299 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_532a.gif 0 458 0 1 0 15 15 15 * You can view the sheet by open isave 20 304 205 231 text2 growbox 20 304 205 231 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * For an introduction to Excel s notebox 17 203 233 ** image memory text2 0 20 304 image memory text1 0 20 367 * eff.exe p03_534a.gif 310 294 0 1 0 15 15 15 * A much quicker way to export d isave 3 406 223 321 text1 textbox 3 406 223 321 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** qcall PA03q 030503 eff.exe p03_535.gif 0 459 0 1 0 15 15 15 * Loading the output of a databa isave 3 326 223 236 text2 growbox 3 326 223 236 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 3 326 image memory text1 0 3 406 * eff.exe p03_536a.gif 0 458 0 1 0 15 15 15 * Suppose you want to export the isave 205 285 442 234 text1 textbox 205 285 442 234 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_537a.gif 6 385 0 1 0 15 15 15 eff.exe p03_537b.gif 288 434 0 1 0 15 15 15 * With the report selected, you isave 205 239 442 166 text2 growbox 205 239 442 166 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_538a.gif 276 417 0 1 0 15 15 15 * Then you select Analyze It wit isave 205 171 442 115 text3 growbox 205 171 442 115 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 205 171 image memory text2 0 205 239 image memory text1 0 205 285 * eff.exe p03_539a.gif 0 458 0 1 0 15 15 15 * A sheet is created that contai isave 215 140 460 89 text1 textbox 215 140 460 89 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * Excel opens automatically and notebox 234 233 438 ** qcall PA03q 030504 eff.exe p03_541a.gif 2 326 0 1 0 15 15 15 * The report's group levels are isave 215 94 460 38 text2 growbox 215 94 460 38 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * For more information on using notebox 205 253 472 ** image memory text2 0 215 94 image memory text1 0 215 140 * SimScrn 3 12 14 ********************************* eff.exe p03_543.gif 0 459 0 1 0 15 15 15 * Access allows you to export ta isave 292 411 547 343 text1 textbox 292 411 547 343 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_544a.gif 9 345 0 1 0 15 15 15 * Suppose you want to export the isave 292 348 547 292 text2 growbox 292 348 547 292 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_545a.gif 9 457 0 1 0 15 15 15 * You select File - Save As/Expo isave 292 297 547 258 text3 growbox 292 297 547 258 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 292 297 image memory text2 0 292 348 image memory text1 0 292 411 * eff.exe p03_546a.gif 20 457 0 1 0 15 15 15 * You click OK isave 394 279 593 245 text1 textbox 394 279 593 245 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_547a.gif 15 446 0 1 0 15 15 15 * Then you select Text Files fro isave 394 250 593 177 text2 growbox 394 250 593 177 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_548a.gif 27 439 0 1 0 15 15 15 eff.exe p03_548b.gif 87 140 0 1 0 15 15 15 * And you click Export isave 394 182 593 143 text3 growbox 394 182 593 143 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 394 182 image memory text2 0 394 250 image memory text1 0 394 279 * qcall PA03q 030505 eff.exe p03_549a.gif 15 456 0 1 0 15 15 15 eff.exe p03_549b.gif 12 18 0 1 0 15 15 15 * Access formats the data as del isave 416 455 634 404 text1 textbox 416 455 634 404 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_550a.gif 23 380 0 1 0 15 15 15 eff.exe p03_550b.gif 35 162 0 1 0 15 15 15 * You select Fixed Width to crea isave 416 409 634 353 text2 growbox 416 409 634 353 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_551a.gif 23 358 0 1 0 15 15 15 eff.exe p03_551b.gif 330 188 0 1 0 15 15 15 * Then you click Next isave 416 358 634 319 text3 growbox 416 358 634 319 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 416 358 image memory text2 0 416 409 image memory text1 0 416 455 * eff.exe p03_552a.gif 30 421 0 1 0 15 15 15 eff.exe p03_552b.gif 30 289 0 1 0 15 15 15 * Access displays the breaks bet isave 379 453 635 402 text1 textbox 379 453 635 402 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_553a.gif 30 289 0 1 0 15 15 15 eff.exe p03_553b.gif 335 290 0 1 0 15 15 15 * To move a field break, you fir isave 379 407 635 334 text2 growbox 379 407 635 334 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_554a.gif 127 290 0 1 0 15 15 15 eff.exe p03_554b.gif 335 290 0 1 0 15 15 15 * Then you drag the break to the isave 379 339 635 283 text3 growbox 379 339 635 283 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_555a.gif 127 290 0 1 0 15 15 15 eff.exe p03_555b.gif 435 271 0 1 0 15 15 15 * As you can see, the field brea isave 379 288 635 232 text4 growbox 379 288 635 232 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 379 288 image memory text3 0 379 339 image memory text2 0 379 407 image memory text1 0 379 453 * eff.exe p03_556a.gif 210 285 0 1 0 15 15 15 eff.exe p03_556b.gif 330 188 0 1 0 15 15 15 * Now you click Next isave 443 227 602 193 text1 textbox 443 227 602 193 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 443 227 * eff.exe p03_557a.gif 28 425 0 1 0 15 15 15 * You type the name and path of isave 454 457 634 372 text1 textbox 454 457 634 372 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_558a.gif 146 386 0 1 0 15 15 15 eff.exe p03_558b.gif 415 189 0 1 0 15 15 15 * Then you click Finish isave 454 377 634 338 text2 growbox 454 377 634 338 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_559a.gif 16 456 0 1 0 15 15 15 * And you click OK isave 454 343 634 304 text3 growbox 454 343 634 304 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 454 343 image memory text2 0 454 377 image memory text1 0 454 457 * eff.exe p03_560a.gif 26 364 0 1 0 15 15 15 eff.exe p03_560b.gif 12 18 0 1 0 15 15 15 * The Products table has been ex isave 417 455 633 387 text1 textbox 417 455 633 387 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall PA03q 030506 eff.exe p03_561a.gif 0 456 0 1 0 15 15 15 * If you view the file, you can isave 417 392 633 302 text2 growbox 417 392 633 302 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 417 392 image memory text1 0 417 455 * SimScrn 3 13 14 ********************************* eff.exe p03_562.gif 0 459 0 1 0 15 15 15 * The quickest way to export dat isave 7 287 260 219 text1 textbox 7 287 260 219 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall PA03q 030507 eff.exe p03_563a.gif 133 449 0 1 0 15 15 15 * As with Excel, you can load th isave 7 224 260 151 text2 growbox 7 224 260 151 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 7 224 image memory text1 0 7 287 * eff.exe p03_564a.gif 13 325 0 1 0 15 15 15 eff.exe p03_564b.gif 240 370 0 1 0 15 15 15 * Suppose you want to export the isave 99 356 348 305 text1 textbox 99 356 348 305 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** qcall PA03q 030508 eff.exe p03_565a.gif 13 325 0 1 0 15 15 15 eff.exe p03_565b.gif 276 434 0 1 0 15 15 15 * You click the down arrow besid isave 99 310 348 237 text2 growbox 99 310 348 237 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 99 310 image memory text1 0 99 356 * eff.exe p03_566a.gif 0 456 0 1 0 15 15 15 * Access saves the data as a Ric isave 5 445 341 394 text1 textbox 5 445 341 394 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_567.gif 0 459 0 1 0 15 15 15 * As you can see, a Rich Text Fo isave 5 399 341 343 text2 growbox 5 399 341 343 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_568a.gif 0 456 0 1 0 15 15 15 * You can also create a Rich Tex isave 5 348 341 275 text3 growbox 5 348 341 275 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 5 348 image memory text2 0 5 399 image memory text1 0 5 445 * eff.exe p03_569a.gif 17 431 0 1 0 15 15 15 * A useful feature of Access 97 isave 186 365 361 246 text1 textbox 186 365 361 246 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_570a.gif 13 365 0 1 0 15 15 15 eff.exe p03_570b.gif 308 250 0 1 0 15 15 15 * Suppose you want to merge the isave 186 251 361 178 text2 growbox 186 251 361 178 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 186 251 image memory text1 0 186 365 * eff.exe p03_571a.gif 13 365 0 1 0 15 15 15 eff.exe p03_571b.gif 272 434 0 1 0 15 15 15 * You click the down arrow besid isave 162 255 438 187 text1 textbox 162 255 438 187 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p03_572a.gif 26 434 0 1 0 15 15 15 eff.exe p03_572b.gif 12 18 0 1 0 15 15 15 * You then follow the instructio isave 162 192 438 136 text2 growbox 162 192 438 136 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 162 192 image memory text1 0 162 255 * * Topic: Hands-on: Exporting to a FoxPro file Topic No.: 6 **** SimScrn 3 14 14 MoveCtrl 1 493 426 0 0 ********************************* * Suppose you want to be able to isave 115 346 418 295 text1 textbox 115 346 418 295 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 * * You want to link the data so t isave 115 300 418 227 text2 growbox 115 300 418 227 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 * * image memory text2 0 115 300 image memory text1 0 115 346 * * You decide to link all the tab isave 112 343 380 275 text1 textbox 112 343 380 275 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 * * Both the Sales and Expenses da isave 112 280 380 207 text2 growbox 112 280 380 207 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 * image memory text2 0 112 280 image memory text1 0 112 343 * exercise 03 1 120 80 task 3 0303 417 252 220 5 50 67 5 5 * pause 1 1 1 1 1 1 1 1 *