MS access help

profilegen_1
database.accdb
Home>Computer Science homework help>MS access help
PartnershipID Country Partner Institution Faculty AgreementType Terms_Of_Review Effective_Date Expiry_Date: Date_To_Review ContactName Email Comments Status
125 Italy University of Brescia Review 1/1/11 1/1/16 5/3/15 true
126 Japan Chiba Institute of Technology Review 7/12/10 7/12/15 11/11/14 true
127 Japan Gunma University Review 9/28/12 9/28/17 1/28/17 true
128 Japan Kyoto University Review 5/15/13 5/15/18 9/14/17 Ms. Yukari Mikami [email protected] true
129 Japan Urawa University Automatic 3/13/11 3/13/14 7/13/13 false
130 Mexico Tec de Monterrey (ITESM) Automatic 8/1/09 8/1/15 12/1/14 Beatriz Medrano [email protected] false
131 Mexico Universidad Iberoamericana Review 8/1/09 8/1/14 12/1/13 Mtra. Catherine Fanning Woodruff [email protected] false
132 Netherlands Hanzehogeschool van Groningen Automatic 8/1/09 8/1/15 12/1/14 Andries Rodenboog [email protected] false
133 Netherlands Hogeschool van Amsterdam (AMFI) Automatic 8/1/10 8/1/16 12/2/15 false
134 Netherlands Hogeschool van Utrecht Automatic 8/1/11 8/1/14 12/1/13 Ms. Carmela Criseo [email protected] false
135 Netherlands InHolland University Amsterdam Automatic 8/1/09 8/1/15 12/1/14 false
136 Netherlands Tilburg University Review 9/1/12 9/1/17 1/1/17 Ms. Nadia Ptashchenko [email protected] false
137 Netherlands Tio University of Applied Sciences Review 9/1/12 9/1/17 1/1/17 Amsterdam and Utrecht Campuses false
138 New Zealand Auckland University of Technology Automatic 1/1/11 1/1/14 5/3/13 Kenneth Holt [email protected] false
139 Poland Wroclaw University of Technology Automatic 12/5/07 12/5/12 4/6/12 false
140 Portugal ISCTE-University Institute of Lisbon Review 7/1/12 7/1/17 10/31/16 false
141 Scotland Glasgow Caledonian University Automatic 8/1/10 8/1/16 12/2/16 Debbie Goodwill [email protected] false
142 Scotland Napier University Review 9/1/12 9/1/17 1/1/17 Claire Hope [email protected] false
143 Scotland University of Stirling Automatic 8/1/09 8/1/15 12/1/14 Stephanie Niven / Jo Hagerty [email protected] false
144 Singapore Nanyang Technological University Automatic 10/1/09 10/1/14 1/31/14 Ms. Pauline Ho [email protected] false
145 South Korea Chung-Ang University Review 5/1/11 5/1/16 9/1/15 false
146 Spain Universidad Carlos III de Madrid Review 10/1/11 10/1/16 2/1/15 David Gil Pérez [email protected] false
147 Spain Universidad de Zaragoza Review 8/1/08 8/1/13 12/1/12 Ms. Lucia Garcia Cebrian [email protected] false
148 Spain University of Mondragón Review 3/10/10 3/10/15 7/10/14 false
149 Sweden Jonkoping International Business School Automatic 6/15/11 6/15/14 10/15/13 false
150 Sweden Karlstad University Automatic 7/1/11 7/1/14 10/31/13 false
151 Sweden Linköping University Review 1/1/11 1/1/16 5/3/15 Anna Andersson [email protected] false
152 Sweden Umeå University Review 11/1/08 11/1/13 3/3/13 Ms. Ulla Blomqvist [email protected] false
153 Tunisia University of Sfax Review 7/1/12 7/1/17 10/31/16 false
154 Turkey Koc University Review 6/1/13 6/1/18 10/1/17 Ms. Sedef Ercetin [email protected] false
155 United States University of California, LA (UCLA) Review 5/23/12 false
156 Wales Royal Welsh College of Music and Drama Automatic 3/1/10 7/2/15 false
157 Wales University of Wales, Newport Automatic 4/1/11 4/1/14 8/1/13 Claire Birney [email protected] false
158 Germany University of Applied Sciences at Wuerzburg-Schweinfurt Inactive false
159 India National Institute of Fashion Technology (NIFT) Automatic 1/1/10 1/1/13 5/3/12 Mrs. Anupreet Bhalla Dugal [email protected] Terminated false
160 India Indian Retail School Review 1/15/07 1/15/07 Expired false
161 India Pearl Academy of Fashion Review 1/15/07 1/15/07 Expired false
117 India The Angel Investors Consortium Review 1/1/12 1/1/15 5/3/14 true
118 India University of Mumbai, College of Social Work, Mumbai Review 2/3/10 2/3/15 6/5/14 Gracie Joseph [email protected] true
119 Ireland Dublin Institute of Technology Automatic 3/1/10 3/1/16 7/2/15 Roger Sherlock [email protected] true
120 Ireland University of Haifa Review 7/23/13 7/23/18 11/22/17 Ms. Ilanit Palace [email protected] true
121 Ireland Tel Aviv University Automatic 11/28/12 11/28/17 3/30/17 true
122 Italy Libera Università di Lingue e Comunicazione (IULM) Review 5/30/10 5/30/15 9/29/14 true
123 Italy Universita degli Studi di Firenze (University of Florence) Review 8/29/12 8/29/17 12/29/16 true
162 Scotland University of Abertay Dundee Automatic 1/1/11 1/1/14 5/3/13 Frank Pullen false
163 Italy Milan Polytechnic University Review 5/2/05 5/2/10 9/1/09 Maria Perego [email protected] Expired, no interest was expressed in renewal. Research performed on programs, do not appear to have equivalent programs in english. false
164 Mexico Universidad Iberoamericana Automatic 7/20/09 7/20/12 false
165 Brazil Municipality of Belo Horizonte Review 8/1/08 8/1/10 12/1/09 false
166 Columbia Universidad de Catagena Review 9/28/09 9/28/09 1/28/09 false
167 Canada Canadian Manufacturers and Exporters Review 1/17/09 1/17/10 5/19/09 false
168 India The Confederation of Indian Industry Review 1/17/07 1/17/10 5/19/09 false
169 France Institut National de l'Audiovisuel Review 4/27/07 4/27/10 4/27/09 false
170 Taiwain National Taipai University of Technology Review 10/2/07 10/2/12 2/2/12 false
171 United States Pennsylvania State University Automatic 7/18/08 7/18/11 11/17/10 false
172 China North China University of Technology Automatic 10/23/10 10/23/11 2/22/11 false
173 Canada University of Prince Edward Island Automatic 8/1/10 8/1/13 12/1/12 Dr. Vianne Timmons [email protected] false
174 India The Hatch Review 1/1/12 1/1/12 5/3/14 false
175 true
30 Australia Curtin University of Technology Automatic 12/1/12 12/1/17 4/2/17 Julie-Anne Beasley [email protected] true
31 Australia RMIT University Review 8/18/10 8/18/15 12/18/14 Judi Cowie [email protected] true
32 Australia RMIT University (Study Tour) Review 6/8/12 8/18/15 12/18/14 Emilia Tabrizi [email protected] true
33 Australia University of New England None 10/25/10 true
34 Australia University of South Australia (UniSA) Automatic 1/1/10 1/1/16 5/3/15 Karen English [email protected] true
35 Australia University of Technology, Sydney Review 3/19/13 3/19/18 7/19/17 Ms. Tze Ay Chuah [email protected] true
36 Austria Johannes Kepler University Automatic 9/1/11 9/1/14 1/1/14 true
37 Barbados, Jamaica, Trinidad and Tobago University of the West Indies Review 1/1/09 1/1/14 5/3/13 true
38 Barbados, Jamaica, Trinidad and Tobago University of the West Indies Review 1/1/09 1/1/14 1/13/13 [email protected] true
39 Belgium Université Libre de Bruxelles Review 2/17/10 2/17/15 6/19/14 true
40 Brazil Sao Paulo Research Foundation Review true
41 Brazil SESI / SENAI / IEL Review 2/2/12 2/2/17 6/4/16 true
42 Canada Université du Québec à Montréal (UQAM) Review 9/29/09 9/29/14 1/29/14 Vice-doyen aux etudes true
43 Canada Université Laval Review 9/1/08 9/1/13 1/1/13 Patrick Hurley [email protected] true
44 Chile Universidad de Artes, Ciencias y Communicacion (UNIACC) Review 1/1/10 1/1/15 5/3/14 Ms. Grace Agosin [email protected] true
45 Chile Universidad del Pacifico Automatic 5/25/07 5/25/13 9/24/12 John Cowell [email protected] true
46 Chile Universidad Técnica Federico Santa María Review 10/7/10 10/7/15 2/6/15 true
47 China Beijing Jiaotong University Review 6/8/12 6/8/17 10/8/16 true
48 China China Three Gorges University Review 3/15/10 3/15/15 7/15/14 true
49 China City University Hong Kong Review 9/1/10 9/1/15 1/1/15 Dr. Mike Yao [email protected] true
50 China Communication University of China Review 12/1/11 12/1/16 4/2/16 true
51 China Tsinghua U. Insitute of Economics, Arts and Sciences Review 3/1/13 3/1/18 7/1/17 true
52 China The Institute of Ethnology and Anthropology Review 3/1/13 3/1/18 7/1/17 true
53 China Beijing Film Academy Review 4/8/13 4/8/18 8/8/17 true
54 China Dalian Maritime University Review 6/1/11 6/1/16 10/2/15 true
55 China Beijing University of Technology Review 5/1/13 5/1/18 8/31/17 [email protected] true
56 China COMAC Shanghai Aircraft Customer Service Co., Ltd. Review 1/16/12 1/1/17 5/3/16 Trial true
57 China Harbin Institute Review 6/1/11 6/1/16 10/2/15 true
58 China Hong Kong Baptist University Automatic 1/1/11 1/1/14 5/3/13 true
59 China Hong Kong Polytechnic University Review 8/28/12 8/28/17 12/28/16 Ms. Cathy Wong [email protected] true
60 China Nanjing Univeristy of Aeronautics and Astronautics Review 3/1/12 3/1/17 7/1/16 true
61 China Northwestern Polytechnical University Review 3/10/12 3/10/17 7/10/16 true
62 China Shanghai Finance University Review 6/10/13 6/10/18 10/10/17 Ms. Amelia Shen [email protected] true
63 China University of Hong Kong Review 6/15/09 6/15/14 10/15/13 true
64 China Zhengzhou University Review 9/6/12 9/6/17 1/6/17 true
65 Colombia Universidad de Cartagena Review 9/28/09 9/28/14 1/28/14 true
66 Colombia Universidad Nacional de Colombia Review 11/20/09 11/20/14 3/22/14 true
67 Croatia Zagreb School of Economics and Management Review 1/1/09 1/1/14 5/3/13 Javier Aguayo [email protected] true
68 Denmark Copenhagen Business School Review 1/9/11 1/9/14 5/11/13 Mette Kloch [email protected] true
69 Denmark Copenhagen School of Design and Technology (KEA) Review 7/1/11 7/1/16 11/1/15 true
70 Denmark Danish School of Journalism, Aarhus Automatic 6/1/12 6/1/17 10/1/16 Inger Muk [email protected] true
71 Denmark Roskilde University Automatic 8/1/09 8/1/15 12/1/14 Chanda Hansen [email protected] true
72 Denmark VIA University College Review 9/1/17 9/1/17 1/1/17 Tina Lisberg Bundgaard [email protected] true
73 England Birmingham City University Automatic 8/1/09 8/1/15 12/1/14 Sarah Hopkins [email protected] true
74 England Bournemouth University Automatic 1/1/11 1/1/14 5/3/13 true
75 England City University London Automatic 8/1/09 8/1/14 12/1/14 Ivan Hutchins [email protected] true
76 England Coventry University Review 12/1/09 12/1/14 4/2/14 Ian Dunn [email protected] true
77 England Manchester Metropolitan University Automatic 1/1/11 1/1/14 5/3/13 true
78 England Nottingham Trent University Review 11/18/11 7/1/16 11/1/15 true
79 England Sheffield Hallam University Automatic 8/1/09 8/1/15 12/1/14 true
80 England University of Portsmouth Automatic 6/30/11 6/30/16 10/31/15 true
81 England University of Surrey Review 5/1/11 5/1/11 5/1/16 1-sep-15 true
82 England University of Westminster Review 6/8/12 8/1/15 12/1/14 true
83 Finland AALTO University Review 11/1/12 11/1/17 3/3/17 true
84 Finland HAAGA-HELIA University of Applied Sciences Review 1/1/11 1/1/16 5/3/15 true
85 France AgroSup Dijon Review 4/8/11 4/8/16 8/9/15 true
86 France BBA ESSEC Business Schoo Review 1/1/13 1/1/18 5/3/17 true
87 France ESIDAI Review 12/7/09 12/7/14 4/8/14 Ecole Supérieure d’Ingénieurs en Développement Agroalimentaire Intégré true
88 France ESTACA École D'Ingénieurs Automatic 11/15/10 11/15/13 3/17/13 true
89 France Group ICAM Review 10/5/10 10/5/15 2/4/15 true
90 France Institut d'Économie Scientifique et de Gestion Review 1/1/09 1/1/14 5/3/13 true
91 France Institut Français de Mecanique Avancee (IFMA) Review 1/15/10 1/15/15 5/17/14 true
92 France SKEMA Business School (previously CERAM) Automatic 8/1/12 8/1/17 12/1/16 true
93 France Telecom INT SudParis Automatic 3/10/08 3/10/13 7/10/12 true
94 France Universite Paris-Dauphine Automatic 8/1/10 8/1/16 12/2/15 true
95 Germany Fachhochschule Frankfurt am Main Automatic 1/1/10 1/1/16 5/3/15 true
96 Germany Filmakademie Baden Württemburg Automatic 1/1/11 1/1/14 5/3/13 true
97 Germany Friedrich-Alexander-Universitaet Erlangen-Nuernberg (FAU) Review 7/13/11 7/13/16 11/13/15 true
98 Germany German Cancer Research Center (DKFZ) Review 2/6/09 2/6/14 6/8/13 true
99 Germany Heidelberg University Review 1/1/09 1/1/14 5/3/13 Dr. H. Joachim Gerke [email protected] true
100 Germany Hochschule der Medien Automatic 1/1/11 1/1/14 5/3/13 true
101 Germany Karlsruhe University of Applied Sciences Review 5/1/10 5/1/15 8/31/14 true
102 Germany Karlsruhe University of Applied Sciences Review 9/1/09 9/1/13 1/1/13 true
103 Germany Karlsruhe University of Applied Sciences Automatic 3/1/11 3/1/14 7/1/13 Dr. Joachim Lembach [email protected] true
104 Germany Karlsruhe University of Applied Sciences Review 1/1/10 1/1/15 5/3/14 true
105 Germany University of Applied Sciences Offenburg Review 5/1/10 5/1/15 8/31/14 true
106 Germany University of Augsburg and Technische Universität München Automatic 5/18/11 5/18/13 9/17/12 true
107 Germany University of Münster Review 9/1/09 9/1/14 1/1/14 Dr. Christoph Brox true
108 Germany University of Television and Film Munich Review 9/1/12 9/1/17 1/1/17 true
109 Germany Aristotle University of Thessaloniki Review 2/2/12 2/2/17 6/4/16 true
110 India Anna University Review 6/1/11 6/1/16 10/2/15 true
111 India Center for Development and Human Rights (CDHR) Review 2/1/12 2/1/17 6/3/16 true
112 India India Institute of Technology Bombay (IIT Bombay) Review 10/17/12 10/17/17 2/16/17 true
113 India Indian Institute of Technology Madras (IIT Madras) Review 11/24/09 11/24/14 3/26/14 true
114 India Indo-Canadian Business Chamber Review 2/1/12 2/1/15 6/3/14 true
115 India Jamia Millia Islamia University Review 9/27/12 9/27/17 1/27/17 true
116 India O.P Jindal Global University Review 1/24/12 1/24/17 5/26/16 true
SwitchboardID ItemNumber ItemText Command Argument
1 0 Main Switchboard Default
1 1 Add new Partnership 2 Partnership Form
1 2 View All Partnerships 4 rptAllPartnerships
1 3 Edit Partnerships 3 EditPartnership Form
1 4 View Renewable Partnerships 3 EditPartnership Form
1 5 View Cancelled/Expired Partnerships 4 CancelledExpiredContract
1 6 Country Wide Report 4 rptCountry
1 7 Search 3 EditPartnership Form
1 8 Exit 6
SELECT DISTINCTROW * FROM Partnership;
SELECT DISTINCTROW * FROM Partnership;
SELECT Partnership.Country, Partnership.[Partner Institution], AgreementType.AgreementType, PartnershipFaculty.Faculty, Partnership, Partnership.[Expiry_Date:], Partnership.ContactName FROM PartnershipFaculty INNER JOIN (AgreementType INNER JOIN Partnership ON AgreementType.AgreementTypeID=Partnership.AgreementTypeID) ON PartnershipFaculty.Faculty_ID=Partnership.Faculty_ID WHERE (((Partnership.Country)=[Enter the Country Name?]));
SELECT * FROM [Switchboard Items] WHERE [ItemNumber]>0 And [SwitchboardID]=TempVars!SwitchboardID ORDER BY [ItemNumber];
SELECT Partnership.Country, Partnership.[Partner Institution], Partnership.Faculty, Partnership.AgreementType, Partnership.[Expiry_Date:], Partnership.PartnershipID, Partnership.PartnershipID, Partnership.Country, Partnership.Faculty, Partnership.AgreementType, Partnership.Terms_Of_Review, Partnership.Status, Partnership.Effective_Date, Partnership.[Expiry_Date:], Partnership.Date_To_Review, Partnership.Date_To_Review, Partnership.ContactName, Partnership.Email, Partnership.Email, Partnership.Comments, Partnership.Status, Partnership.* FROM Partnership WHERE (((Partnership.Country)=[Enter the Country Name?]));
SELECT Partnership.PartnershipID, Partnership.Country, Partnership.[Partner Institution], Partnership.Faculty, Partnership.AgreementType, Partnership.Terms_Of_Review, Partnership.Effective_Date, Partnership.[Expiry_Date:], Partnership.Date_To_Review, Partnership.ContactName, Partnership.Email, Partnership.Comments, Partnership.Status FROM Partnership WHERE (((Partnership.Country)=[Search the Entire Database]));
UPDATE Partnership SET Partnership.[Expiry_Date:] = DateAdd('yyyy',1,[Expiry_Date:]) WHERE (((DateDiff("m",Now(),[Expiry_Date:]))<4));
SELECT Partnership.PartnershipID, Partnership.Country, Partnership.[Partner Institution], Partnership.Faculty, Partnership.Faculty.Value, Partnership.AgreementType, Partnership.AgreementType.Value, Partnership.Terms_Of_Review, Partnership.Effective_Date, Partnership.[Expiry_Date:], Partnership.Date_To_Review, Partnership.ContactName, Partnership.Email, Partnership.Comments, Partnership.Status FROM Partnership WHERE (((Partnership.[Expiry_Date:])<Date()));
SELECT DISTINCTROW [Partnership].[PartnershipID], [Partnership].[Country], [Partnership].[Partner Institution], [Partnership].[Faculty], [Faculty_D0C57CA7F316446C87D989741DFADC6F].[Value], [Partnership].[AgreementType], [AgreementType_0ABB9AAE9B034EE79A55C23240BD0AE8].[Value], [Partnership].[Terms_Of_Review], [Partnership].[Effective_Date], [Partnership].[Expiry_Date:], [Partnership].[Date_To_Review], [Partnership].[ContactName], [Partnership].[Email], [Partnership].[Comments], [Partnership].[Status], [Faculty_D0C57CA7F316446C87D989741DFADC6F].[_TempField*0], [AgreementType_0ABB9AAE9B034EE79A55C23240BD0AE8].[_TempField*0] FROM (Partnership LEFT JOIN [f_72D9198A83554980A99939BDD140CEBC_TempField*0] AS Faculty_D0C57CA7F316446C87D989741DFADC6F ON [Partnership].[Faculty]=[Faculty_D0C57CA7F316446C87D989741DFADC6F].[_TempField*0]) LEFT JOIN [f_40FA3815EFB94B97900F6D953FB4A719_TempField*0] AS AgreementType_0ABB9AAE9B034EE79A55C23240BD0AE8 ON [Partnership].[AgreementType]=[AgreementType_0ABB9AAE9B034EE79A55C23240BD0AE8].[_TempField*0] WHERE ((([Partnership].[Expiry_Date:])<Date()));
SELECT DISTINCTROW * FROM Partnership;
SELECT Partnership.Country, Partnership.[Partner Institution], Partnership.Faculty, Partnership.AgreementType, Partnership.[Expiry_Date:], Partnership.Terms_Of_Review, Partnership.Effective_Date, Partnership.Date_To_Review, Partnership.Status FROM Partnership WHERE (((DateDiff("m",Now(),[Expiry_Date:]))<[Select no of renewal partnership months ?]));