Data Entry and Project Implentiation
sdotholla
week_3__infrequentfliers.accdb
| Destination_ID | Destination | Distance | Price | Member_ID |
| 1 | Rome | 2000 | 349 | 1 |
| 2 | Rome | 2500 | 549 | 2 |
| 3 | Rome | 2000 | 739 | 3 |
| 4 | Rome | 1500 | 899 | 4 |
| 5 | Rome | 1000 | 799 | 5 |
| 6 | Rome | 1500 | 699 | 6 |
| 7 | Rome | 2500 | 499 | 7 |
| 8 | Rome | 3000 | 459 | 8 |
| 9 | Rome | 2500 | 659 | 9 |
| 10 | Rome | 1500 | 359 | 10 |
| 11 | Rome | 1000 | 459 | 11 |
| 12 | Rome | 1500 | 659 | 12 |
| 13 | Rome | 1500 | 759 | 13 |
| 14 | Rome | 1000 | 899 | 14 |
| 15 | Rome | 2500 | 799 | 15 |
| 16 | Rome | 2500 | 999 | 16 |
| 17 | Rome | 3000 | 699 | 17 |
| 18 | Frankfurt | 2500 | 799 | 18 |
| 19 | Frankfurt | 1000 | 499 | 19 |
| 20 | Frankfurt | 500 | 459 | 20 |
| 21 | Frankfurt | 500 | 469 | 21 |
| 22 | Frankfurt | 1500 | 459 | 22 |
| 23 | Frankfurt | 1500 | 299 | 23 |
| 24 | Frankfurt | 2500 | 599 | 24 |
| 25 | Frankfurt | 2500 | 899 | 25 |
| 26 | Frankfurt | 2000 | 599 | 26 |
| 27 | Frankfurt | 1500 | 459 | 27 |
| 28 | Frankfurt | 1500 | 659 | 28 |
| 29 | Frankfurt | 1000 | 759 | 29 |
| 30 | Paris | 500 | 859 | 30 |
| 31 | Paris | 500 | 359 | 31 |
| 32 | Paris | 1500 | 399 | 32 |
| 33 | Paris | 1500 | 499 | 33 |
| 34 | Paris | 2500 | 409 | 34 |
| 35 | Paris | 1500 | 429 | 35 |
| 36 | Paris | 2500 | 429 | 36 |
| 37 | Paris | 3000 | 529 | 37 |
| 38 | Paris | 2500 | 599 | 38 |
| 39 | Paris | 1500 | 699 | 39 |
| 40 | Paris | 1000 | 369 | 40 |
| 41 | Paris | 1500 | 569 | 41 |
| 42 | Paris | 1500 | 599 | 42 |
| 43 | Paris | 1000 | 899 | 43 |
| 44 | Barcelona | 2500 | 799 | 6 |
| 45 | Barcelona | 2500 | 499 | 7 |
| 46 | Barcelona | 1000 | 399 | 8 |
| 47 | Barcelona | 500 | 569 | 9 |
| 48 | Barcelona | 500 | 489 | 10 |
| 49 | Barcelona | 1500 | 599 | 11 |
| 50 | Barcelona | 1500 | 569 | 12 |
| 51 | Barcelona | 2500 | 399 | 13 |
| 52 | Barcelona | 1500 | 569 | 14 |
| 53 | Barcelona | 2500 | 299 | 15 |
| 54 | Barcelona | 3000 | 399 | 30 |
| 55 | Barcelona | 1500 | 889 | 31 |
| 56 | Barcelona | 2500 | 789 | 32 |
| 57 | Athens | 1500 | 889 | 33 |
| 58 | Athens | 2500 | 599 | 34 |
| 59 | Athens | 3000 | 899 | 35 |
| 60 | Athens | 1000 | 699 | 36 |
| 61 | Athens | 1500 | 599 | 37 |
| 62 | Athens | 1500 | 569 | 38 |
| 63 | Athens | 1000 | 459 | 39 |
| 64 | Athens | 2500 | 569 | 40 |
| 65 | Athens | 2500 | 859 | 41 |
| 66 | Oslo | 1000 | 259 | 42 |
| 67 | Oslo | 500 | 699 | 43 |
| 68 | Oslo | 500 | 899 | 6 |
| 69 | Oslo | 1500 | 799 | 7 |
| 70 | Oslo | 1500 | 599 | 12 |
| 71 | Oslo | 1000 | 699 | 13 |
| 72 | Oslo | 500 | 588 | 14 |
| 73 | Oslo | 500 | 498 | 15 |
| 74 | Oslo | 1500 | 589 | 16 |
| 75 | Oslo | 1500 | 569 | 17 |
| 76 | Oslo | 2500 | 299 | 18 |
| 77 | Oslo | 1500 | 399 | 19 |
| 78 | Oslo | 2500 | 359 | 20 |
| 79 | Oslo | 3000 | 659 | 4 |
| 80 | Oslo | 2500 | 759 | 5 |
| 81 | Oslo | 1500 | 859 | 6 |
| 82 | Oslo | 1000 | 499 | 7 |
| 83 | Copenhagen | 1500 | 899 | 8 |
| 84 | Copenhagen | 1500 | 599 | 9 |
| 85 | Copenhagen | 1500 | 699 | 10 |
| 86 | Copenhagen | 1000 | 588 | 11 |
| 87 | Copenhagen | 2500 | 598 | 12 |
| 88 | Copenhagen | 2500 | 478 | 15 |
| 89 | Copenhagen | 1000 | 489 | 16 |
| 90 | Porto | 500 | 589 | 17 |
| 91 | Porto | 500 | 658 | 18 |
| 92 | Porto | 1500 | 657 | 19 |
| 93 | Porto | 1500 | 859 | 20 |
| 94 | Porto | 1000 | 586 | 4 |
| 95 | Porto | 500 | 458 | 30 |
| 96 | Porto | 500 | 596 | 31 |
| 97 | Porto | 1500 | 599 | 32 |
| 98 | Porto | 1500 | 799 | 33 |
| 99 | Porto | 2500 | 568 | 34 |
| 100 | Lisboa | 1500 | 658 | 35 |
| 101 | Lisboa | 2500 | 569 | 36 |
| 102 | Lisboa | 1500 | 549 | 37 |
| 103 | Lisboa | 1000 | 549 | 38 |
| 104 | Lisboa | 1500 | 564 | 39 |
| 105 | Lisboa | 1500 | 599 | 40 |
| 106 | Milano | 1500 | 588 | 19 |
| 107 | Milano | 1000 | 599 | 20 |
| 108 | Milano | 2500 | 577 | 4 |
| 109 | Toulouse | 2500 | 899 | 30 |
| 110 | Toulouse | 1000 | 999 | 31 |
| 111 | Toulouse | 500 | 699 | 32 |
| 112 | Toulouse | 500 | 299 | 33 |
| 113 | Toulouse | 1500 | 399 | 34 |
| 114 | Toulouse | 500 | 299 | 35 |
| 115 | Toulouse | 500 | 299 | 40 |
| 116 | Toulouse | 1500 | 599 | 41 |
| 117 | Toulouse | 1500 | 688 | 42 |
| 118 | Toulouse | 1000 | 569 | 43 |
| 119 | Marseille | 500 | 459 | 6 |
| 120 | Marseille | 500 | 489 | 7 |
| 121 | Marseille | 1500 | 789 | 8 |
| 122 | Marseille | 1500 | 599 | 9 |
| 123 | Marseille | 2500 | 489 | 10 |
| 124 | Marseille | 1500 | 659 | 11 |
| 125 | Marseille | 2500 | 565 | 12 |
| 126 | Marseille | 1500 | 544 | 5 |
| 127 | Marseille | 1500 | 399 | 6 |
| 128 | Marseille | 1000 | 522 | 7 |
| 129 | Marseille | 500 | 568 | 8 |
| 130 | Marseille | 500 | 568 | 9 |
| 131 | Marseille | 1500 | 459 | 10 |
| 132 | Hamburg | 1500 | 456 | 11 |
| 133 | Hamburg | 2500 | 485 | 6 |
| 134 | Hamburg | 1500 | 597 | 7 |
| 135 | Hamburg | 1000 | 597 | 8 |
| 136 | Hamburg | 500 | 655 | 9 |
| 137 | Hamburg | 500 | 688 | 10 |
| 138 | Hamburg | 1500 | 698 | 11 |
| 139 | Munich | 1500 | 687 | 12 |
| 140 | Munich | 2500 | 599 | 13 |
| 141 | Munich | 1500 | 499 | 35 |
| 142 | Munich | 1500 | 799 | 36 |
| 143 | Munich | 1000 | 699 | 37 |
| 144 | Munich | 500 | 399 | 38 |
| 145 | Munich | 500 | 569 | 39 |
| 146 | Munich | 1500 | 459 | 40 |
| 147 | Munich | 1500 | 589 | 19 |
| 148 | Munich | 2500 | 698 | 20 |
| 149 | Munich | 1000 | 577 | 43 |
| Destination_ID | Destination | Distance | Price | Member_ID |
| 1 | Rome | 2000 | 349 | 1 |
| 2 | Rome | 2500 | 549 | 2 |
| 3 | Rome | 2000 | 739 | 3 |
| 4 | Rome | 1500 | 899 | 4 |
| 5 | Rome | 1000 | 799 | 5 |
| 6 | Rome | 1500 | 699 | 6 |
| 7 | Rome | 2500 | 499 | 7 |
| 8 | Rome | 3000 | 459 | 8 |
| 9 | Rome | 2500 | 659 | 9 |
| 10 | Rome | 1500 | 359 | 10 |
| 11 | Rome | 1000 | 459 | 11 |
| 12 | Rome | 1500 | 659 | 12 |
| 13 | Rome | 1500 | 759 | 13 |
| 14 | Rome | 1000 | 899 | 14 |
| 15 | Rome | 2500 | 799 | 15 |
| 16 | Rome | 2500 | 999 | 16 |
| 17 | Rome | 3000 | 699 | 17 |
| 18 | Frankfurt | 2500 | 799 | 18 |
| 19 | Frankfurt | 1000 | 499 | 19 |
| 20 | Frankfurt | 500 | 459 | 20 |
| 21 | Frankfurt | 500 | 469 | 21 |
| 22 | Frankfurt | 1500 | 459 | 22 |
| 23 | Frankfurt | 1500 | 299 | 23 |
| 24 | Frankfurt | 2500 | 599 | 24 |
| 25 | Frankfurt | 2500 | 899 | 25 |
| 26 | Frankfurt | 2000 | 599 | 26 |
| 27 | Frankfurt | 1500 | 459 | 27 |
| 28 | Frankfurt | 1500 | 659 | 28 |
| 29 | Frankfurt | 1000 | 759 | 29 |
| 30 | Paris | 500 | 859 | 30 |
| 31 | Paris | 500 | 359 | 31 |
| 32 | Paris | 1500 | 399 | 32 |
| 33 | Paris | 1500 | 499 | 33 |
| 34 | Paris | 2500 | 409 | 34 |
| 35 | Paris | 1500 | 429 | 35 |
| 36 | Paris | 2500 | 429 | 36 |
| 37 | Paris | 3000 | 529 | 37 |
| 38 | Paris | 2500 | 599 | 38 |
| 39 | Paris | 1500 | 699 | 39 |
| 40 | Paris | 1000 | 369 | 40 |
| 41 | Paris | 1500 | 569 | 41 |
| 42 | Paris | 1500 | 599 | 42 |
| 43 | Paris | 1000 | 899 | 43 |
| 44 | Barcelona | 2500 | 799 | 6 |
| 45 | Barcelona | 2500 | 499 | 7 |
| 46 | Barcelona | 1000 | 399 | 8 |
| 47 | Barcelona | 500 | 569 | 9 |
| 48 | Barcelona | 500 | 489 | 10 |
| 49 | Barcelona | 1500 | 599 | 11 |
| 50 | Barcelona | 1500 | 569 | 12 |
| 51 | Barcelona | 2500 | 399 | 13 |
| 52 | Barcelona | 1500 | 569 | 14 |
| 53 | Barcelona | 2500 | 299 | 15 |
| 54 | Barcelona | 3000 | 399 | 30 |
| 55 | Barcelona | 1500 | 889 | 31 |
| 56 | Barcelona | 2500 | 789 | 32 |
| 57 | Athens | 1500 | 889 | 33 |
| 58 | Athens | 2500 | 599 | 34 |
| 59 | Athens | 3000 | 899 | 35 |
| 60 | Athens | 1000 | 699 | 36 |
| 61 | Athens | 1500 | 599 | 37 |
| 62 | Athens | 1500 | 569 | 38 |
| 63 | Athens | 1000 | 459 | 39 |
| 64 | Athens | 2500 | 569 | 40 |
| 65 | Athens | 2500 | 859 | 41 |
| 66 | Oslo | 1000 | 259 | 42 |
| 67 | Oslo | 500 | 699 | 43 |
| 68 | Oslo | 500 | 899 | 6 |
| 69 | Oslo | 1500 | 799 | 7 |
| 70 | Oslo | 1500 | 599 | 12 |
| 71 | Oslo | 1000 | 699 | 13 |
| 72 | Oslo | 500 | 588 | 14 |
| 73 | Oslo | 500 | 498 | 15 |
| 74 | Oslo | 1500 | 589 | 16 |
| 75 | Oslo | 1500 | 569 | 17 |
| 76 | Oslo | 2500 | 299 | 18 |
| 77 | Oslo | 1500 | 399 | 19 |
| 78 | Oslo | 2500 | 359 | 20 |
| 79 | Oslo | 3000 | 659 | 4 |
| 80 | Oslo | 2500 | 759 | 5 |
| 81 | Oslo | 1500 | 859 | 6 |
| 82 | Oslo | 1000 | 499 | 7 |
| 83 | Copenhagen | 1500 | 899 | 8 |
| 84 | Copenhagen | 1500 | 599 | 9 |
| 85 | Copenhagen | 1500 | 699 | 10 |
| 86 | Copenhagen | 1000 | 588 | 11 |
| 87 | Copenhagen | 2500 | 598 | 12 |
| 88 | Copenhagen | 2500 | 478 | 15 |
| 89 | Copenhagen | 1000 | 489 | 16 |
| 90 | Porto | 500 | 589 | 17 |
| 91 | Porto | 500 | 658 | 18 |
| 92 | Porto | 1500 | 657 | 19 |
| 93 | Porto | 1500 | 859 | 20 |
| 94 | Porto | 1000 | 586 | 4 |
| 95 | Porto | 500 | 458 | 30 |
| 96 | Porto | 500 | 596 | 31 |
| 97 | Porto | 1500 | 599 | 32 |
| 98 | Porto | 1500 | 799 | 33 |
| 99 | Porto | 2500 | 568 | 34 |
| 100 | Lisboa | 1500 | 658 | 35 |
| 101 | Lisboa | 2500 | 569 | 36 |
| 102 | Lisboa | 1500 | 549 | 37 |
| 103 | Lisboa | 1000 | 549 | 38 |
| 104 | Lisboa | 1500 | 564 | 39 |
| 105 | Lisboa | 1500 | 599 | 40 |
| 106 | Milano | 1500 | 588 | 19 |
| 107 | Milano | 1000 | 599 | 20 |
| 108 | Milano | 2500 | 577 | 4 |
| 109 | Toulouse | 2500 | 899 | 30 |
| 110 | Toulouse | 1000 | 999 | 31 |
| 111 | Toulouse | 500 | 699 | 32 |
| 112 | Toulouse | 500 | 299 | 33 |
| 113 | Toulouse | 1500 | 399 | 34 |
| 114 | Toulouse | 500 | 299 | 35 |
| 115 | Toulouse | 500 | 299 | 40 |
| 116 | Toulouse | 1500 | 599 | 41 |
| 117 | Toulouse | 1500 | 688 | 42 |
| 118 | Toulouse | 1000 | 569 | 43 |
| 119 | Marseille | 500 | 459 | 6 |
| 120 | Marseille | 500 | 489 | 7 |
| 121 | Marseille | 1500 | 789 | 8 |
| 122 | Marseille | 1500 | 599 | 9 |
| 123 | Marseille | 2500 | 489 | 10 |
| 124 | Marseille | 1500 | 659 | 11 |
| 125 | Marseille | 2500 | 565 | 12 |
| 126 | Marseille | 1500 | 544 | 5 |
| 127 | Marseille | 1500 | 399 | 6 |
| 128 | Marseille | 1000 | 522 | 7 |
| 129 | Marseille | 500 | 568 | 8 |
| 130 | Marseille | 500 | 568 | 9 |
| 131 | Marseille | 1500 | 459 | 10 |
| 132 | Hamburg | 1500 | 456 | 11 |
| 133 | Hamburg | 2500 | 485 | 6 |
| 134 | Hamburg | 1500 | 597 | 7 |
| 135 | Hamburg | 1000 | 597 | 8 |
| 136 | Hamburg | 500 | 655 | 9 |
| 137 | Hamburg | 500 | 688 | 10 |
| 138 | Hamburg | 1500 | 698 | 11 |
| 139 | Munich | 1500 | 687 | 12 |
| 140 | Munich | 2500 | 599 | 13 |
| 141 | Munich | 1500 | 499 | 35 |
| 142 | Munich | 1500 | 799 | 36 |
| 143 | Munich | 1000 | 699 | 37 |
| 144 | Munich | 500 | 399 | 38 |
| 145 | Munich | 500 | 569 | 39 |
| 146 | Munich | 1500 | 459 | 40 |
| 147 | Munich | 1500 | 589 | 19 |
| 148 | Munich | 2500 | 698 | 20 |
| 149 | Munich | 1000 | 577 | 43 |
| Member_ID | Last_Name | First_Name |
| 1 | Lawrence | Earl |
| 2 | Looney | Carl |
| 3 | Nauman | Michael |
| 4 | Austin | Joseph |
| 5 | Baker | Beth |
| 6 | Baldwin | MaryAnn |
| 7 | Becker | Hubert |
| 8 | Beasley | Steve |
| 9 | Boyd | Gloria |
| 10 | Choi | Diane |
| 11 | Clark | Heather |
| 12 | Clausen | Gina |
| 13 | Cox | Linda |
| 14 | Dumont | Mark |
| 15 | Easton | Dennis |
| 16 | Fuhrmann | Leslie |
| 17 | Fujimoto | Carla |
| 18 | Frazier | Nancy |
| 19 | Gillespie | Patricia |
| 20 | Gibson | Fernanda |
| 21 | Hall | Marion |
| 22 | Herman | Frank |
| 23 | Henderson | Angela |
| 24 | Hunt | Jack |
| 25 | Hunter | Anna |
| 26 | Hutchinson | Eric |
| 27 | Lee | SooJin |
| 28 | Li | Chun |
| 29 | Lin | Yu-Lin |
| 30 | Marshal | Debbie |
| 31 | Norton | Cynthia |
| 32 | Proctor | Ginny |
| 33 | Sanderson | Sonja |
| 34 | Sanchez | Ramon |
| 35 | Stewart | Kathy |
| 36 | Thompson | Caitlin |
| 37 | Thornton | Janet |
| 38 | Walker | Ken |
| 39 | Wallace | Alex |
| 40 | Weber | Cliff |
| 41 | West | Helen |
| 42 | Yang | Jung |
| 43 | Zhan | Man |