Technoloy Management

profiledebaa4
mgmt447_u3_ip_1.zip
Home>Information Systems homework help>Technoloy Management

le2/Payments.mdb

Firm# FirmName FirmContact PLUSAcctRep Extension
1100 Korman, Rosen & Zek Panza, Ronald Martinez, Nancy 1275
1102 Chicago DA Office Posada, Liddy Tyler, Olivia 1234
1103 Milwaukee City Courts Carson, Helen Tyler, Olivia 1234
1104 Ling, Bingham, & Boyer Higgins, Gary Jain, Sunil 1249
1105 Atlanta DA Office Juarez, Victor Abelson, David 1280
1106 DuPont Investments Glover, Susan Jain, Sunil 1249
1108 GRN Industries Alexander, Paul Martinez, Nancy 1275
1109 Gardner MA Court System Gibbs, Daniel Abelson, David 1280
1110 Toledo City Manager's Office May, Janelle Tyler, Olivia 1234
1111 Toronto Trial Courts Serito, Jeff Tyler, Olivia 1234
1113 HAL Aeronautics Musil, James Abelson, David 1280
1115 7 Flags Inc. DesMarais, Denise Jain, Sunil 1249
1117 Outel Ltd Ward, Celia Jain, Sunil 1249
1118 Boston City Court Finnegan, Sarah Abelson, David 1280
1119 Martinez, Jones & Schwartz Peters, Myrna Martinez, Nancy 1275
1120 Chicken To Go Barges, Joseph Abelson, David 1280
1121 Truckers Inc Stryker, Jeffrey Abelson, David 1280
1122 San Jose DA Office Nez, Janet Tyler, Olivia 1234
1123 Reynolds, Marks, Li, & Vrei Bennett, Colin Martinez, Nancy 1275
1125 Cheshire Cats Ltd Anand, Rau Tyler, Olivia 1234
1126 World Wrestling Federation Reed, Dennis Abelson, David 1280
1127 Sports World Stein, James Jain, Sunil 1249
1128 Yale University Keil, Su Martinez, Nancy 1275
1130 Ken & Harry's Sundburg, Paul Martinez, Nancy 1275
1131 Yonkers City Court Guarnieri, Frank Jain, Sunil 1249
1133 Freemont Readywear Green, Carol Tyler, Olivia 1234
1134 Tanks Unlimited Durham, William Jain, Sunil 1249
1135 Copper Industries United Troy, Amy Abelson, David 1280
1136 Boise City Manager's Office Usoff, Douglas Abelson, David 1280
1140 Bond Street Enterprises Liu, Ya-Shih Abelson, David 1280
1141 Lexington Sportswear Drimusz, Eva Tyler, Olivia 1234
1142 Primitive Outfitters Fitzgerald, Michael Tyler, Olivia 1234
1144 Denver DA Office Beaudoin, William Jain, Sunil 1249
1145 El Paso Gas Pedicini, John Martinez, Nancy 1275
1147 HVL Telecommunications Barton, Marilyn Abelson, David 1280
1150 Sullivan, Krall, & Arnez Semken, Patti Martinez, Nancy 1275
1151 The Empire Mall Cox, Timothy Jain, Sunil 1249
1152 Embers Tool & Die Lazaro, Russell Tyler, Olivia 1234

le2/PLUS.bmp

le2/PlusPays.mdb

Payment# Deposit# Firm# AmtPaid DatePaid
10001 100 1102 ¤ 900.00 6/1/01
10003 100 1103 ¤ 1,190.00 6/1/01
10004 100 1104 ¤ 1,055.00 6/1/01
10005 100 1105 ¤ 750.00 6/1/01
10006 100 1106 ¤ 1,400.00 6/1/01
10007 100 1108 ¤ 1,605.00 6/1/01
10008 100 1109 ¤ 1,800.00 6/1/01
10009 100 1111 ¤ 3,700.00 6/1/01
10010 100 1113 ¤ 1,250.00 6/1/01
10011 100 1117 ¤ 790.00 6/1/01
10012 100 1119 ¤ 3,000.00 6/1/01
10013 100 1121 ¤ 1,500.00 6/1/01
10014 101 1122 ¤ 1,000.00 6/1/01
10016 101 1125 ¤ 1,500.00 6/1/01
10017 101 1126 ¤ 2,050.00 6/1/01
10018 101 1131 ¤ 1,550.00 6/1/01
10019 101 1136 ¤ 1,750.00 6/1/01
10020 102 1118 ¤ 2,250.00 6/2/01
10021 102 1130 ¤ 2,575.00 6/2/01
10022 102 1128 ¤ 1,900.00 6/2/01
10023 102 1140 ¤ 1,100.00 6/2/01
10024 102 1120 ¤ 1,050.00 6/2/01
10025 102 1141 ¤ 3,470.00 6/2/01
10026 102 1133 ¤ 1,937.00 6/2/01
10027 102 1135 ¤ 1,505.00 6/2/01
10028 102 1144 ¤ 4,575.00 6/2/01
10029 102 1123 ¤ 1,305.00 6/2/01
10030 102 1134 ¤ 1,690.00 6/2/01
10032 103 1152 ¤ 1,150.00 6/3/01
10033 103 1150 ¤ 2,240.00 6/3/01
10034 103 1145 ¤ 1,200.00 6/3/01
10035 103 1115 ¤ 1,400.00 6/3/01
10036 104 1151 ¤ 2,600.00 6/3/01
10037 105 1117 ¤ 1,800.00 6/4/01
10038 105 1142 ¤ 3,780.00 6/4/01
10039 105 1126 ¤ 2,500.00 6/4/01
10040 105 1140 ¤ 1,400.00 6/4/01
10041 105 1131 ¤ 1,600.00 6/4/01
10042 105 1133 ¤ 3,200.00 6/4/01
10043 106 1108 ¤ 2,400.00 6/5/01
10044 106 1118 ¤ 1,300.00 6/5/01
10045 106 1123 ¤ 3,600.00 6/5/01
10046 106 1150 ¤ 5,700.00 6/5/01
10047 106 1144 ¤ 3,000.00 6/5/01
10048 107 1130 ¤ 2,400.00 6/8/01
10049 107 1103 ¤ 1,100.00 6/8/01
10050 107 1110 ¤ 2,975.00 6/8/01
10051 107 1122 ¤ 2,320.00 6/8/01
10052 107 1128 ¤ 3,242.00 6/8/01
10053 107 1115 ¤ 1,309.00 6/8/01
10054 107 1135 ¤ 1,015.00 6/8/01
10055 108 1147 ¤ 2,320.00 6/9/01
10056 108 1100 ¤ 3,450.00 6/9/01
10057 108 1102 ¤ 1,850.00 6/9/01
10058 108 1111 ¤ 2,300.00 6/9/01
10059 108 1113 ¤ 1,225.00 6/9/01
10060 108 1120 ¤ 2,390.00 6/9/01
10061 108 1152 ¤ 900.00 6/9/01
10062 108 1136 ¤ 1,497.00 6/9/01
10063 108 1145 ¤ 1,190.00 6/9/01
10064 109 1134 ¤ 1,074.00 6/10/01
10065 109 1119 ¤ 1,084.00 6/10/01
10066 109 1106 ¤ 1,269.00 6/10/01
10067 110 1105 ¤ 1,760.00 6/10/01
10068 110 1125 ¤ 1,248.00 6/10/01
10069 110 1130 ¤ 1,607.00 6/10/01
10070 110 1133 ¤ 1,939.00 6/10/01
10071 111 1152 ¤ 2,300.00 6/11/01
10072 111 1128 ¤ 2,030.00 6/11/01
10073 111 1131 ¤ 1,530.00 6/11/01
10074 111 1135 ¤ 1,505.00 6/11/01
10075 111 1103 ¤ 1,187.00 6/11/01
10076 111 1150 ¤ 1,800.00 6/11/01
10077 111 1142 ¤ 1,810.00 6/11/01
10078 111 1136 ¤ 1,263.00 6/11/01
10079 111 1102 ¤ 4,250.00 6/11/01
10080 111 1147 ¤ 1,178.00 6/11/01
10081 111 1151 ¤ 1,724.00 6/11/01
10082 111 1125 ¤ 1,307.00 6/11/01
10083 111 1108 ¤ 1,546.00 6/11/01
10084 112 1105 ¤ 3,000.00 6/12/01
10085 112 1134 ¤ 2,800.00 6/12/01
10086 112 1140 ¤ 1,129.00 6/12/01
10087 112 1119 ¤ 1,243.00 6/12/01
10088 112 1122 ¤ 1,129.00 6/12/01
10089 112 1100 ¤ 1,440.00 6/12/01
10090 113 1104 ¤ 1,401.00 6/15/01
10091 113 1106 ¤ 1,178.00 6/15/01
10092 113 1109 ¤ 1,840.00 6/15/01
10093 113 1141 ¤ 1,407.00 6/15/01
10094 113 1127 ¤ 2,568.00 6/15/01
10095 114 1123 ¤ 1,088.00 6/16/01
10096 114 1121 ¤ 1,724.00 6/16/01
10097 114 1144 ¤ 903.00 6/16/01
10098 115 1117 ¤ 868.00 6/17/01
10099 115 1120 ¤ 918.00 6/17/01
10100 116 1111 ¤ 1,227.00 6/18/01
10101 116 1145 ¤ 1,195.00 6/18/01
10102 116 1113 ¤ 1,348.00 6/18/01
10103 116 1115 ¤ 1,426.00 6/18/01
10104 116 1118 ¤ 1,246.00 6/18/01
ID DocType DocName ModuleText
Order LibraryID
2 *\G{00025E01-0000-0000-C000-000000000046}#3.0#0#C:\PROGRAM FILES\COMMON FILES\DAO\DAO3032.DLL#Microsoft DAO 3.0 Object Library

le3/Payments.mdb

Firm# FirmName FirmContact PLUSAcctRep Extension
1100 Korman, Rosen & Zek Panza, Ronald Martinez, Nancy 1275
1102 Chicago DA Office Posada, Liddy Tyler, Olivia 1234
1103 Milwaukee City Courts Carson, Helen Tyler, Olivia 1234
1104 Ling, Bingham, & Boyer Higgins, Gary Jain, Sunil 1249
1105 Atlanta DA Office Juarez, Victor Abelson, David 1280
1106 DuPont Investments Glover, Susan Jain, Sunil 1249
1108 GRN Industries Alexander, Paul Martinez, Nancy 1275
1109 Gardner MA Court System Gibbs, Daniel Abelson, David 1280
1110 Toledo City Manager's Office May, Janelle Tyler, Olivia 1234
1111 Toronto Trial Courts Serito, Jeff Tyler, Olivia 1234
1113 HAL Aeronautics Musil, James Abelson, David 1280
1115 7 Flags Inc. DesMarais, Denise Jain, Sunil 1249
1117 Outel Ltd Ward, Celia Jain, Sunil 1249
1118 Boston City Court Finnegan, Sarah Abelson, David 1280
1119 Martinez, Jones & Schwartz Peters, Myrna Martinez, Nancy 1275
1120 Chicken To Go Barges, Joseph Abelson, David 1280
1121 Truckers Inc Stryker, Jeffrey Abelson, David 1280
1122 San Jose DA Office Nez, Janet Tyler, Olivia 1234
1123 Reynolds, Marks, Li, & Vrei Bennett, Colin Martinez, Nancy 1275
1125 Cheshire Cats Ltd Anand, Rau Tyler, Olivia 1234
1126 World Wrestling Federation Reed, Dennis Abelson, David 1280
1127 Sports World Stein, James Jain, Sunil 1249
1128 Yale University Keil, Su Martinez, Nancy 1275
1130 Ken & Harry's Sundburg, Paul Martinez, Nancy 1275
1131 Yonkers City Court Guarnieri, Frank Jain, Sunil 1249
1133 Freemont Readywear Green, Carol Tyler, Olivia 1234
1134 Tanks Unlimited Durham, William Jain, Sunil 1249
1135 Copper Industries United Troy, Amy Abelson, David 1280
1136 Boise City Manager's Office Usoff, Douglas Abelson, David 1280
1140 Bond Street Enterprises Liu, Ya-Shih Abelson, David 1280
1141 Lexington Sportswear Drimusz, Eva Tyler, Olivia 1234
1142 Primitive Outfitters Fitzgerald, Michael Tyler, Olivia 1234
1144 Denver DA Office Beaudoin, William Jain, Sunil 1249
1145 El Paso Gas Pedicini, John Martinez, Nancy 1275
1147 HVL Telecommunications Barton, Marilyn Abelson, David 1280
1150 Sullivan, Krall, & Arnez Semken, Patti Martinez, Nancy 1275
1151 The Empire Mall Cox, Timothy Jain, Sunil 1249
1152 Embers Tool & Die Lazaro, Russell Tyler, Olivia 1234

le3/PLUS.bmp

le3/PlusPays.mdb

Payment# Deposit# Firm# AmtPaid DatePaid
10001 100 1102 ¤ 900.00 6/1/01
10003 100 1103 ¤ 1,190.00 6/1/01
10004 100 1104 ¤ 1,055.00 6/1/01
10005 100 1105 ¤ 750.00 6/1/01
10006 100 1106 ¤ 1,400.00 6/1/01
10007 100 1108 ¤ 1,605.00 6/1/01
10008 100 1109 ¤ 1,800.00 6/1/01
10009 100 1111 ¤ 3,700.00 6/1/01
10010 100 1113 ¤ 1,250.00 6/1/01
10011 100 1117 ¤ 790.00 6/1/01
10012 100 1119 ¤ 3,000.00 6/1/01
10013 100 1121 ¤ 1,500.00 6/1/01
10014 101 1122 ¤ 1,000.00 6/1/01
10016 101 1125 ¤ 1,500.00 6/1/01
10017 101 1126 ¤ 2,050.00 6/1/01
10018 101 1131 ¤ 1,550.00 6/1/01
10019 101 1136 ¤ 1,750.00 6/1/01
10020 102 1118 ¤ 2,250.00 6/2/01
10021 102 1130 ¤ 2,575.00 6/2/01
10022 102 1128 ¤ 1,900.00 6/2/01
10023 102 1140 ¤ 1,100.00 6/2/01
10024 102 1120 ¤ 1,050.00 6/2/01
10025 102 1141 ¤ 3,470.00 6/2/01
10026 102 1133 ¤ 1,937.00 6/2/01
10027 102 1135 ¤ 1,505.00 6/2/01
10028 102 1144 ¤ 4,575.00 6/2/01
10029 102 1123 ¤ 1,305.00 6/2/01
10030 102 1134 ¤ 1,690.00 6/2/01
10032 103 1152 ¤ 1,150.00 6/3/01
10033 103 1150 ¤ 2,240.00 6/3/01
10034 103 1145 ¤ 1,200.00 6/3/01
10035 103 1115 ¤ 1,400.00 6/3/01
10036 104 1151 ¤ 2,600.00 6/3/01
10037 105 1117 ¤ 1,800.00 6/4/01
10038 105 1142 ¤ 3,780.00 6/4/01
10039 105 1126 ¤ 2,500.00 6/4/01
10040 105 1140 ¤ 1,400.00 6/4/01
10041 105 1131 ¤ 1,600.00 6/4/01
10042 105 1133 ¤ 3,200.00 6/4/01
10043 106 1108 ¤ 2,400.00 6/5/01
10044 106 1118 ¤ 1,300.00 6/5/01
10045 106 1123 ¤ 3,600.00 6/5/01
10046 106 1150 ¤ 5,700.00 6/5/01
10047 106 1144 ¤ 3,000.00 6/5/01
10048 107 1130 ¤ 2,400.00 6/8/01
10049 107 1103 ¤ 1,100.00 6/8/01
10050 107 1110 ¤ 2,975.00 6/8/01
10051 107 1122 ¤ 2,320.00 6/8/01
10052 107 1128 ¤ 3,242.00 6/8/01
10053 107 1115 ¤ 1,309.00 6/8/01
10054 107 1135 ¤ 1,015.00 6/8/01
10055 108 1147 ¤ 2,320.00 6/9/01
10056 108 1100 ¤ 3,450.00 6/9/01
10057 108 1102 ¤ 1,850.00 6/9/01
10058 108 1111 ¤ 2,300.00 6/9/01
10059 108 1113 ¤ 1,225.00 6/9/01
10060 108 1120 ¤ 2,390.00 6/9/01
10061 108 1152 ¤ 900.00 6/9/01
10062 108 1136 ¤ 1,497.00 6/9/01
10063 108 1145 ¤ 1,190.00 6/9/01
10064 109 1134 ¤ 1,074.00 6/10/01
10065 109 1119 ¤ 1,084.00 6/10/01
10066 109 1106 ¤ 1,269.00 6/10/01
10067 110 1105 ¤ 1,760.00 6/10/01
10068 110 1125 ¤ 1,248.00 6/10/01
10069 110 1130 ¤ 1,607.00 6/10/01
10070 110 1133 ¤ 1,939.00 6/10/01
10071 111 1152 ¤ 2,300.00 6/11/01
10072 111 1128 ¤ 2,030.00 6/11/01
10073 111 1131 ¤ 1,530.00 6/11/01
10074 111 1135 ¤ 1,505.00 6/11/01
10075 111 1103 ¤ 1,187.00 6/11/01
10076 111 1150 ¤ 1,800.00 6/11/01
10077 111 1142 ¤ 1,810.00 6/11/01
10078 111 1136 ¤ 1,263.00 6/11/01
10079 111 1102 ¤ 4,250.00 6/11/01
10080 111 1147 ¤ 1,178.00 6/11/01
10081 111 1151 ¤ 1,724.00 6/11/01
10082 111 1125 ¤ 1,307.00 6/11/01
10083 111 1108 ¤ 1,546.00 6/11/01
10084 112 1105 ¤ 3,000.00 6/12/01
10085 112 1134 ¤ 2,800.00 6/12/01
10086 112 1140 ¤ 1,129.00 6/12/01
10087 112 1119 ¤ 1,243.00 6/12/01
10088 112 1122 ¤ 1,129.00 6/12/01
10089 112 1100 ¤ 1,440.00 6/12/01
10090 113 1104 ¤ 1,401.00 6/15/01
10091 113 1106 ¤ 1,178.00 6/15/01
10092 113 1109 ¤ 1,840.00 6/15/01
10093 113 1141 ¤ 1,407.00 6/15/01
10094 113 1127 ¤ 2,568.00 6/15/01
10095 114 1123 ¤ 1,088.00 6/16/01
10096 114 1121 ¤ 1,724.00 6/16/01
10097 114 1144 ¤ 903.00 6/16/01
10098 115 1117 ¤ 868.00 6/17/01
10099 115 1120 ¤ 918.00 6/17/01
10100 116 1111 ¤ 1,227.00 6/18/01
10101 116 1145 ¤ 1,195.00 6/18/01
10102 116 1113 ¤ 1,348.00 6/18/01
10103 116 1115 ¤ 1,426.00 6/18/01
10104 116 1118 ¤ 1,246.00 6/18/01
ID DocType DocName ModuleText
Order LibraryID
2 *\G{00025E01-0000-0000-C000-000000000046}#3.0#0#C:\PROGRAM FILES\COMMON FILES\DAO\DAO3032.DLL#Microsoft DAO 3.0 Object Library

le4/FirmPays.mdb

Firm# FirmName FirmContact PLUSAcctRep Extension
1100 Korman, Rosen & Zek Panza, Ronald Martinez, Nancy 1275
1102 Chicago DA Office Posada, Liddy Tyler, Olivia 1234
1103 Milwaukee City Courts Carson, Helen Tyler, Olivia 1234
1104 Ling, Bingham, & Boyer Higgins, Gary Jain, Sunil 1249
1105 Atlanta DA Office Juarez, Victor Abelson, David 1280
1106 DuPont Investments Glover, Susan Jain, Sunil 1249
1108 GRN Industries Alexander, Paul Martinez, Nancy 1275
1109 Gardner MA Court System Gibbs, Daniel Abelson, David 1280
1110 Toledo City Manager's Office May, Janelle Tyler, Olivia 1234
1111 Toronto Trial Courts Serito, Jeff Tyler, Olivia 1234
1113 HAL Aeronautics Musil, James Abelson, David 1280
1115 7 Flags Inc. DesMarais, Denise Jain, Sunil 1249
1117 Outel Ltd Ward, Celia Jain, Sunil 1249
1118 Boston City Court Finnegan, Sarah Abelson, David 1280
1119 Martinez, Jones & Schwartz Peters, Myrna Martinez, Nancy 1275
1120 Chicken To Go Barges, Joseph Abelson, David 1280
1121 Truckers Inc Stryker, Jeffrey Abelson, David 1280
1122 San Jose DA Office Nez, Janet Tyler, Olivia 1234
1123 Reynolds, Marks, Li, & Vrei Bennett, Colin Martinez, Nancy 1275
1125 Cheshire Cats Ltd Anand, Rau Tyler, Olivia 1234
1126 World Wrestling Federation Reed, Dennis Abelson, David 1280
1127 Sports World Stein, James Jain, Sunil 1249
1128 Yale University Keil, Su Martinez, Nancy 1275
1130 Ken & Harry's Sundburg, Paul Martinez, Nancy 1275
1131 Yonkers City Court Guarnieri, Frank Jain, Sunil 1249
1133 Freemont Readywear Green, Carol Tyler, Olivia 1234
1134 Tanks Unlimited Durham, William Jain, Sunil 1249
1135 Copper Industries United Troy, Amy Abelson, David 1280
1136 Boise City Manager's Office Usoff, Douglas Abelson, David 1280
1140 Bond Street Enterprises Liu, Ya-Shih Abelson, David 1280
1141 Lexington Sportswear Drimusz, Eva Tyler, Olivia 1234
1142 Primitive Outfitters Fitzgerald, Michael Tyler, Olivia 1234
1144 Denver DA Office Beaudoin, William Jain, Sunil 1249
1145 El Paso Gas Pedicini, John Martinez, Nancy 1275
1147 HVL Telecommunications Barton, Marilyn Abelson, David 1280
1150 Sullivan, Krall, & Arnez Semken, Patti Martinez, Nancy 1275
1151 The Empire Mall Cox, Timothy Jain, Sunil 1249
1152 Embers Tool & Die Lazaro, Russell Tyler, Olivia 1234
Payment# Deposit# Firm# AmtPaid DatePaid
10001 100 1102 ¤ 900.00 6/1/01
10002 101 1147 ¤ 1,300.00 6/1/01
10003 100 1103 ¤ 1,190.00 6/1/01
10004 100 1104 ¤ 1,055.00 6/1/01
10005 100 1105 ¤ 750.00 6/1/01
10006 100 1106 ¤ 1,400.00 6/1/01
10007 100 1108 ¤ 1,605.00 6/1/01
10008 100 1109 ¤ 1,800.00 6/1/01
10009 100 1111 ¤ 3,700.00 6/1/01
10010 100 1113 ¤ 1,250.00 6/1/01
10011 100 1117 ¤ 790.00 6/1/01
10012 100 1119 ¤ 3,000.00 6/1/01
10013 100 1121 ¤ 1,500.00 6/1/01
10014 101 1122 ¤ 1,000.00 6/1/01
10015 102 1151 ¤ 2,000.00 6/2/01
10016 101 1125 ¤ 1,500.00 6/1/01
10017 101 1126 ¤ 2,050.00 6/1/01
10018 101 1131 ¤ 1,550.00 6/1/01
10019 101 1136 ¤ 1,750.00 6/1/01
10020 102 1118 ¤ 2,250.00 6/2/01
10021 102 1130 ¤ 2,575.00 6/2/01
10022 102 1128 ¤ 1,900.00 6/2/01
10023 102 1140 ¤ 1,100.00 6/2/01
10024 102 1120 ¤ 1,050.00 6/2/01
10025 102 1141 ¤ 3,470.00 6/2/01
10026 102 1133 ¤ 1,937.00 6/2/01
10027 102 1135 ¤ 1,505.00 6/2/01
10028 102 1144 ¤ 4,575.00 6/2/01
10029 102 1123 ¤ 1,305.00 6/2/01
10030 102 1134 ¤ 1,690.00 6/2/01
10031 103 1111 ¤ 2,500.00 6/3/01
10032 103 1152 ¤ 1,150.00 6/3/01
10033 103 1150 ¤ 2,240.00 6/3/01
10034 103 1145 ¤ 1,200.00 6/3/01
10035 103 1115 ¤ 1,400.00 6/3/01
10036 104 1151 ¤ 2,600.00 6/3/01
10037 105 1117 ¤ 1,800.00 6/4/01
10038 105 1142 ¤ 3,780.00 6/4/01
10039 105 1126 ¤ 2,500.00 6/4/01
10040 105 1140 ¤ 1,400.00 6/4/01
10041 105 1131 ¤ 1,600.00 6/4/01
10042 105 1133 ¤ 3,200.00 6/4/01
10043 106 1108 ¤ 2,400.00 6/5/01
10044 106 1118 ¤ 1,300.00 6/5/01
10045 106 1123 ¤ 3,600.00 6/5/01
10046 106 1150 ¤ 5,700.00 6/5/01
10047 106 1144 ¤ 3,000.00 6/5/01
10048 107 1130 ¤ 2,400.00 6/8/01
10049 107 1103 ¤ 1,100.00 6/8/01
10050 107 1110 ¤ 2,975.00 6/8/01
10051 107 1122 ¤ 2,320.00 6/8/01
10052 107 1128 ¤ 3,242.00 6/8/01
10053 107 1115 ¤ 1,309.00 6/8/01
10054 107 1135 ¤ 1,015.00 6/8/01
10055 108 1147 ¤ 2,320.00 6/9/01
10056 108 1100 ¤ 3,450.00 6/9/01
10057 108 1102 ¤ 1,850.00 6/9/01
10058 108 1111 ¤ 2,300.00 6/9/01
10059 108 1113 ¤ 1,225.00 6/9/01
10060 108 1120 ¤ 2,390.00 6/9/01
10061 108 1152 ¤ 900.00 6/9/01
10062 108 1136 ¤ 1,497.00 6/9/01
10063 108 1145 ¤ 1,190.00 6/9/01
10064 109 1134 ¤ 1,074.00 6/10/01
10065 109 1119 ¤ 1,084.00 6/10/01
10066 109 1106 ¤ 1,269.00 6/10/01
10067 110 1105 ¤ 1,760.00 6/10/01
10068 110 1125 ¤ 1,248.00 6/10/01
10069 110 1130 ¤ 1,607.00 6/10/01
10070 110 1133 ¤ 1,939.00 6/10/01
10071 111 1152 ¤ 2,300.00 6/11/01
10072 111 1128 ¤ 2,030.00 6/11/01
10073 111 1131 ¤ 1,530.00 6/11/01
10074 111 1135 ¤ 1,505.00 6/11/01
10075 111 1103 ¤ 1,187.00 6/11/01
10076 111 1150 ¤ 1,800.00 6/11/01
10077 111 1142 ¤ 1,810.00 6/11/01
10078 111 1136 ¤ 1,263.00 6/11/01
10079 111 1102 ¤ 4,250.00 6/11/01
10080 111 1147 ¤ 1,178.00 6/11/01
10081 111 1151 ¤ 1,724.00 6/11/01
10082 111 1125 ¤ 1,307.00 6/11/01
10083 111 1108 ¤ 1,546.00 6/11/01
10084 112 1105 ¤ 3,000.00 6/12/01
10085 112 1134 ¤ 2,800.00 6/12/01
10086 112 1140 ¤ 1,129.00 6/12/01
10087 112 1119 ¤ 1,243.00 6/12/01
10088 112 1122 ¤ 1,129.00 6/12/01
10089 112 1100 ¤ 1,440.00 6/12/01
10090 113 1104 ¤ 1,401.00 6/15/01
10091 113 1106 ¤ 1,178.00 6/15/01
10092 113 1109 ¤ 1,840.00 6/15/01
10093 113 1141 ¤ 1,407.00 6/15/01
10094 113 1127 ¤ 2,568.00 6/15/01
10095 114 1123 ¤ 1,088.00 6/16/01
10097 114 1144 ¤ 903.00 6/16/01
10098 115 1117 ¤ 868.00 6/17/01
10099 115 1120 ¤ 918.00 6/17/01
10100 116 1111 ¤ 1,227.00 6/18/01
10101 116 1145 ¤ 1,195.00 6/18/01
10102 116 1113 ¤ 1,348.00 6/18/01
10103 116 1115 ¤ 1,426.00 6/18/01
10104 116 1118 ¤ 1,246.00 6/18/01
10105 117 1103 ¤ 1,750.00 6/20/01
PARAMETERS __Firm# Value; SELECT DISTINCTROW * FROM Payment AS [Firm Payments] WHERE ([__Firm#] = [Firm#]);
SELECT DISTINCTROW * FROM Firm;
SELECT DISTINCTROW * FROM Payment;
SELECT Firm.[Firm#], Firm.FirmName, Firm.FirmContact, Firm.PLUSAcctRep, Payment.[Payment#], Payment.[Deposit#], Payment.AmtPaid, Payment.DatePaid FROM Firm INNER JOIN Payment ON [Firm].[Firm#]=[Payment].[Firm#];
SELECT Payment.[Payment#], Payment.AmtPaid, Firm.FirmName FROM Firm INNER JOIN Payment ON Firm.[Firm#] = Payment.[Firm#] WHERE (((Payment.DatePaid)=#6/2/2001#));
SELECT Firm.[Firm#], Firm.FirmName, Payment.AmtPaid, Payment.DatePaid FROM Firm INNER JOIN Payment ON Firm.[Firm#] = Payment.[Firm#] WHERE (((Payment.AmtPaid)>2400)) ORDER BY Payment.AmtPaid DESC;
SELECT Firm.FirmName, Firm.FirmContact, Payment.AmtPaid, Payment.DatePaid FROM Firm INNER JOIN Payment ON [Firm].[Firm#]=[Payment].[Firm#] WHERE ((([Firm].[PLUSAcctRep])="Martinez, Nancy"));
SELECT Max([Payment].[AmtPaid]) AS HighestPayment, Min([Payment].[AmtPaid]) AS LowestPayment, Sum([Payment].[AmtPaid]) AS TotalPayments, Avg([Payment].[AmtPaid]) AS AveragePayment, Count([Payment].[AmtPaid]) AS [#Payments] FROM Payment;
SELECT Max([Payment].[AmtPaid]) AS HighestPayment, Min([Payment].[AmtPaid]) AS LowestPayment, Sum([Payment].[AmtPaid]) AS TotalPayments, Avg([Payment].[AmtPaid]) AS AveragePayment, Count([Payment].[AmtPaid]) AS [#Payments], Payment.DatePaid FROM Payment GROUP BY [Payment].[DatePaid];
SELECT Max([Payment].[AmtPaid]) AS HighestPayment, Min([Payment].[AmtPaid]) AS LowestPayment, Sum([Payment].[AmtPaid]) AS TotalPayments, Avg([Payment].[AmtPaid]) AS AveragePayment, Count([Payment].[AmtPaid]) AS [#Payments], Payment.DatePaid, Payment.[Deposit#] FROM Payment GROUP BY [Payment].[DatePaid], [Payment].[Deposit#];
SELECT Firm.FirmName, Firm.PLUSAcctRep, Firm.Extension FROM Firm;
SELECT Payment.DatePaid, Payment.AmtPaid, Firm.FirmName, Firm.[Firm#] FROM Firm INNER JOIN Payment ON Firm.[Firm#] = Payment.[Firm#] WHERE (((Payment.DatePaid)=#6/11/2001# Or (Payment.DatePaid)=#6/12/2001#)) ORDER BY Payment.DatePaid DESC;

le5/3N4TA.bmp

le5/79XBF.bmp

le5/AAEAF.bmp

le5/BuySell.mdb

Category# Category
1 Antiques
2 Books, Movies, Music
3 Coins & Stamps
4 Collectibles
5 Computers
6 Dolls, Figures
7 Jewelry, Gemstones
8 Photo & Electronics
9 Pottery & Glass
10 Sports Memorabilia
11 Toys
12 Miscellaneous
Item# Seller Subcategory# Title Description Qty MinimumBid Duration ReservePrice Opened Visual
1 7 15 Wayne Gretsky 1981 Authentic autograph on his picture during the Stanley Cup playoffs 1 50 7 80 4/20/01
2 7 36 Ted Williams 1939 All-Star Game signing 1 200 7 300 4/20/01 #Baseball.doc#
3 2 3 18th Century Violin All parts original, needs some work 1 300 15 4/20/01 #Music.doc#
4 9 12 Pine Tree Shilling VF small planchet 1 2200 10 2600 4/21/01
5 9 12 Oak Tree Sixpence VG 1 500 10 650 4/21/01
6 9 12 Virginia Halfpenny Unc 1773 Halfpenny, no period 1 650 10 850 4/21/01
7 9 22 Cut ruby 1.5 carats 1 1500 9 1750 4/21/01
8 9 12 MA 1788 Half Cent EF original luster 1 750 10 800 4/21/01
9 9 12 Brasher Doubloon copy circa 1850 1 10 10 20 4/21/01
10 10 12 Virginia Halfpenny VF 1773 Halfpenny, no period 1 450 5 500 4/19/01
11 13 19 Bugs Bunny 1945 movie cell 1 45 10 4/18/01
12 13 19 Daffy Duck 1948 movie cell 1 40 10 4/18/01
13 13 29 1941 Ted Williams mint 1 250 7 300 4/23/01
14 13 29 1956 Mickey Mantle near mint 1 140 7 150 4/23/01
15 13 29 1958 Ted Williams rare year for Williams 1 100 7 110 4/23/01
16 13 29 1991 Barry Bonds mint 1 20 7 4/23/01
17 13 29 1962 Harmon Killebrew mint 1 45 7 45 4/23/01
18 13 29 1955 Willie Mays mint 1 90 7 100 4/23/01
19 13 29 1946 Joe DiMaggio near mint 1 175 7 200 4/23/01
20 13 36 1930 Hack Wilson 1 60 9 75 4/18/01
21 13 36 1927 Babe Ruth World Series signing 1 300 10 450 4/17/01
22 13 12 CT cent Fine sharp strike 1 120 7 150 4/27/01
23 13 30 1990 John Elway mint 1 40 8 50 5/27/01 #Football.doc#
Registrant# LastName FirstName MI Phone Email UserId Password
1 Zainea Amy M 9994530976 [email protected] Tiger regit
2 Petrosyan Edward K 9999544643 [email protected] Leopard drapoel
3 Do Khue M 9999750104 [email protected] Cobra arboc
4 Sanchez Valencia L 9992417599 [email protected] Firebrand dnarberi
5 Jukic Hava S 9998975916 [email protected] Panda adnap
6 Uzarski Mayra G 9996775349 [email protected] Tree Frog gorfeert
7 Ayala Francisco B 9998375919 [email protected] Polar Bear raebralo
8 Styne David R 9997352982 [email protected] Lizard drazil
9 Suarez Jorge R 9997840883 [email protected] Jaguar raugaj
10 Jiang Xinyan J 9996810191 [email protected] Lion noil
11 Bousu Michelle L 9998966978 [email protected] Crater retarc
12 Ramirez Rosalinda H 9994565815 [email protected] Llama amall
13 Koppelmann Jacob A 9994752955 [email protected] Lynx xnyl
14 Cook Kristine T 9996628878 [email protected] Opal lapo
15 Walker William J 9995311886 [email protected] Rhino onihr
16 Cook Marcia P 9992431241 [email protected] Cygnet tengyc
17 Visser Brad S 9995598652 [email protected] Eagle elgae
18 Cox Kelly W 9998910348 [email protected] Trout tuort
Subcategory# Subcategory Category#
1 General 1
2 Ancient World 1
3 Musical Instruments 1
4 Folk Art 1
5 Books: General 2
6 Books: Rare 2
7 Magazines: General 2
8 Magazines: Children 2
9 Music: General 2
10 Music: Tapes 2
11 Coins: US: General 3
12 Coins: US: Colonial 3
13 Stamps: World: Asia 3
14 Memorabilia: Baseball 10
15 Autographs: Sports: Hockey 10
16 Coins: Ancient 3
17 Coins: Medieval 3
18 Advertising 4
19 Animation Characters 4
20 Comic Books 4
21 Bears 4
22 Gemstones: General 7
23 Gemstones: Faceted 7
24 Gold: Antique 7
25 Gold: Comtemporary 7
26 Glass 9
27 Pottery 9
28 Porcelain 9
29 Trading Cards: Baseball 10
30 Trading Cards: Football 10
31 Trading Cards: Hockey 10
32 Trading Cards: Basketball 10
33 Vintage Barbie 6
34 Raggedy Ann, Andy 6
35 Beanie Babies 11
36 Autographs: Sports: Baseball 10
SELECT DISTINCTROW * FROM Category;
SELECT DISTINCTROW * FROM Category;
SELECT DISTINCTROW * FROM Item;
SELECT DISTINCTROW * FROM Item;
SELECT DISTINCTROW * FROM Item;
SELECT DISTINCTROW * FROM Registrant;
SELECT DISTINCTROW * FROM Registrant;
SELECT DISTINCTROW * FROM Subcategory;
SELECT DISTINCTROW * FROM Subcategory;
SELECT DISTINCTROW * FROM Subcategory;
SELECT [Subcategory].[Subcategory], [Category].[Category], [Item].[Title], [Item].[MinimumBid], [Registrant].[LastName], [Registrant].[FirstName], 2+(0.03*[MinimumBid]) AS ProjectedIncome FROM (Category INNER JOIN Subcategory ON [Category].[Category#]=[Subcategory].[Category#]) INNER JOIN (Registrant INNER JOIN Item ON [Registrant].[Registrant#]=[Item].[Seller]) ON [Subcategory].[Subcategory#]=[Item].[Subcategory#] ORDER BY [Item].[Title];
SELECT Item.[Item#], Item.Seller, Item.[Subcategory#], Item.Title, Item.Description, Item.Qty, Item.MinimumBid, Item.Duration, Item.ReservePrice, Item.Opened FROM Item WHERE (((Item.[Subcategory#])=[Enter Subcategory#:]));