MS access help

hello, i need you to make edits to an existing access 2007 database. the database tables and forms are all made. all i need u to do is make the changes to the database. the changes are mentioned in the document. pls take a look. The database is attached too. It is a very easy job.

Add New Partnership Form AND Edit Partnership Form:

1) When user clicks “save record”, a confirmation box comes up which says something like “user has been saved successfully” HOWEVER it does not work in Access 2007. It only works in Access 2010. Please make it work in
Access 2007!!!

2) Delete ‘Status” Field in ALL forms/tables/reports etc…

View Renewable Partnership:

1) When invoked, it should ask me how many number of months from expiry date (1 to infinity) (you did this before but it is not working now … not sure why)

· Once user enters number of months in step 1 (above), data should be generated in a REPORT

Switchboard:

1) When the “Search” function on the switchboard is invoked, it is going directly to “edit partnership”. The search function should allow me to search the entire database.

Make sure results appear as a
REPORT

2) View Renewable Partnerships Function: When this button is invoked by user, it should give me the option to view the
renewable partnership BY

· “AGREEMENT TYPE” (User should be able to click Which agreement type they want to view (MOU, Student Exchange, Mobility Project, Conference etc…), make sure you list all of the agreement types

· AND by how many number of months from Expiry Date (1 month to infinity)

· Results should show up as REPORT

Review

/15

Review

/12/1

true

Japan

Review

/12

true

Japan

Review

true

Japan

Automatic

false

Mexico

Review 8/1/09

false

Automatic 8/1/09 8/1/15 12/1/14

false

Netherlands

Automatic

false

Netherlands

Automatic

8/1/14 12/1/13

false

Netherlands

Automatic 8/1/09 8/1/15 12/1/14 false

Netherlands

Review

false

Netherlands

Review 9/1/12 9/1/17 1/1/17

false

Automatic 1/1/11

false

Automatic

false

Review

false

Automatic 8/1/10 8/1/16

false

Scotland

Review 9/1/12 9/1/17 1/1/17

false

Scotland

Automatic 8/1/09 8/1/15 12/1/14

false

Automatic

false

Review

false

Review

false

Spain

Review

false

Spain

Review

false

Automatic

false

Sweden

Automatic

false

Sweden

Review 1/1/11 1/1/16 5/3/15

false

Sweden

Review

false

Review 7/1/12 7/1/17 10/31/16 false

Review

false

Review

false

Automatic

false

Wales

Automatic

8/1/13

false

Automatic

1/1/13

false

India

Review

1/15/07

false

India

Review 1/15/07 1/15/07 Expired false

India

Review

true

India

Review

true

Automatic 3/1/10

7/2/15

true

Ireland

Review

true

Ireland

Automatic

true

Italy

Review

true

Italy

Review

true

Scotland

Automatic 1/1/11 1/1/14 5/3/13

false

Italy

Review

false

Mexico Universidad Iberoamericana Automatic

false

Review 8/1/08 8/1/10

false

Review

9/28/09

false

Review

false

India

Review

1/17/10 5/19/09 false

Review

false

Review

false

United States

Automatic

false

Automatic

false

Canada

Automatic 8/1/10 8/1/13 12/1/12

false

India

Review 1/1/12 1/1/12 5/3/14 false

true

Automatic 12/1/12

true

31 Australia

Review

true

32 Australia

Review

8/18/15 12/18/14

true

33 Australia

true

34 Australia

Automatic 1/1/10 1/1/16 5/3/15

true

35 Australia

Review

true

Automatic

1/1/14 true

Review

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

true

Review

true

40 Brazil

Review true

41 Brazil

Review 2/2/12

true

42 Canada

Review

9/29/14

true

43 Canada

Review

1/1/13

true

Review 1/1/10 1/1/15 5/3/14

true

45 Chile

Automatic

true

46 Chile

Review

true

47 China

Review 6/8/12

true

48 China

Review

true

49 China

Review

9/1/15 1/1/15

true

50 China

Review

true

51 China

Review

7/1/17 true

52 China

Review 3/1/13 3/1/18 7/1/17 true

53 China

Review

true

54 China

Review

true

55 China

Review

true

56 China

Review

1/1/17

true

57 China

Review 6/1/11 6/1/16 10/2/15 true

58 China

Automatic 1/1/11 1/1/14 5/3/13 true

59 China

Review

true

60 China

Review

true

61 China

Review

true

62 China

Review

true

63 China

Review

6/15/14 10/15/13 true

64 China

Review

true

Review 9/28/09

true

66 Colombia

Review

true

Review 1/1/09 1/1/14 5/3/13

true

Review

true

69 Denmark

Review 7/1/11 7/1/16

true

70 Denmark

Automatic

10/1/16

true

71 Denmark

Automatic 8/1/09 8/1/15 12/1/14

true

72 Denmark

Review 9/1/17 9/1/17 1/1/17

true

73 England

Automatic 8/1/09 8/1/15 12/1/14

true

74 England

Automatic 1/1/11 1/1/14 5/3/13 true

75 England

Automatic 8/1/09 8/1/14 12/1/14

true

England

Review 12/1/09 12/1/14

true

England

Automatic 1/1/11 1/1/14 5/3/13 true

England

Review

7/1/16 11/1/15 true

England

Automatic 8/1/09 8/1/15 12/1/14 true

England

Automatic

true

England

Review 5/1/11 5/1/11 5/1/16

true

England

Review 6/8/12 8/1/15 12/1/14 true

Review

true

Finland

Review 1/1/11 1/1/16 5/3/15 true

France

Review

true

France

Review 1/1/13

true

France

Review

true

France

Automatic

true

France

Review

true

France

Review 1/1/09 1/1/14 5/3/13 true

France

Review 1/15/10

true

France

Automatic

12/1/16 true

France

Automatic

true

France

Automatic 8/1/10 8/1/16 12/2/15 true

Germany

Automatic 1/1/10 1/1/16 5/3/15 true

Germany

Automatic 1/1/11 1/1/14 5/3/13 true

Germany

Review

true

Germany

Review

true

Germany

Review 1/1/09 1/1/14 5/3/13

true

Germany

Automatic 1/1/11 1/1/14 5/3/13 true

Germany

Review

true

Germany Karlsruhe University of Applied Sciences Review 9/1/09 9/1/13 1/1/13 true

Germany Karlsruhe University of Applied Sciences Automatic

true

Germany Karlsruhe University of Applied Sciences Review 1/1/10 1/1/15 5/3/14 true

Germany

Review 5/1/10 5/1/15 8/31/14 true

Germany

Automatic

true

Germany

Review 9/1/09 9/1/14 1/1/14

true

Germany

Review 9/1/12 9/1/17 1/1/17 true

Germany

Review 2/2/12 2/2/17 6/4/16 true

India

Review 6/1/11 6/1/16 10/2/15 true

India

Review 2/1/12 2/1/17

true

India

Review

true

India

Review

true

India

Review 2/1/12 2/1/15

true

India

Review

true

India

Review

true

																																									PartnershipID	Country	Partner Institution	Faculty	AgreementType	Terms_Of_	Review	Effective_Date	Expiry_Date:	Date_To_Review	ContactName	Email	Comments	Status
										1		2	5				Italy	University of Brescia								1/1/11				1/1/1		6	5/	3						true
126				Japan	Chiba Institute of Technology		7	0	7/12/15	11/11/1				4
127	Gunma University	9/2	8	9/28/17	1/28/17
128	Kyoto University	5/15/13	5/15/18	9/14/17	Ms. Yukari Mikami	y.mikami@gsm.kyoto-u.ac.jp
129	Urawa University																																		Automatic	3/13/11	3/13/14	7/13/13	false
1	30			Mexico	Tec de Monterrey (ITESM)									8/1/09								8/1/15							12/1/14	Beatriz Medrano	bmedrano@campus.maz.itesm.mx
1	31		Universidad Iberoamericana			8/1/14		12/1/13	Mtra. Catherine Fanning Woodruff	catherine.fanning@uia.mx
1	32						Netherlands	Hanzehogeschool van Groningen	Andries Rodenboog	a.j.rodenboog@pl.hanze.nl
1	33	Hogeschool van Amsterdam (AMFI)					8/1/10			8/1/16		12/2/15
1	34	Hogeschool van Utrecht	8/1/11	Ms. Carmela Criseo	carmela.criseo@hvu.nl
1	35	InHolland University Amsterdam
1	36	Tilburg University				9/1/12						9/1/17						1/1/17	Ms. Nadia Ptashchenko	n.ptashchenko@tilburguniversity.edu
1	37	Tio University of Applied Sciences	Amsterdam and Utrecht Campuses
1	38	New Zealand	Auckland University of Technology														1/1/14									5/3/13	Kenneth Holt	kenneth.holt@aut.ac.nz
1	39	Poland	Wroclaw University of Technology	12/5/07	12/5/12	4/6/12
1	40	Portugal	ISCTE-University Institute of Lisbon		7/1/12				7/1/17		10/31/16
1	41				Scotland	Glasgow Caledonian University	12/2/16	Debbie Goodwill	d.goodwill@gcal.ac.uk
1	42	Napier University	Claire Hope	c.hope@napier.ac.uk
1	43	University of Stirling	Stephanie Niven / Jo Hagerty	study-abroad@stir.ac.uk
1	44	Singapore	Nanyang Technological University	10/1/09	10/1/14	1/31/14	Ms. Pauline Ho	ixchange@ntu.edu.sg
1	45	South Korea	Chung-Ang University			5/1/11		5/1/16		9/1/15
1	46			Spain	Universidad Carlos III de Madrid	10/1/11		10/1/16		2/1/15	David Gil Pérez	david.gil@uc3m.es
1	47	Universidad de Zaragoza		8/1/08			8/1/13			1		2/1/12	Ms. Lucia Garcia Cebrian	lgarcia@unizar.es
1	48	University of Mondragón	3/10/10	3/10/15	7/10/14
1	49				Sweden	Jonkoping International Business School	6/15/11		6/15/14		10/15/13
1	50	Karlstad University		7/1/11	7/1/14	10/31/13
1	51	Linköping University	Anna Andersson	anna.andersson@liu.se
1	52	Umeå University	11/1/08	1				1/1/13	3/3/13	Ms. Ulla Blomqvist	ulla.blomqvist@adm.umu.se
1	53	Tunisia	University of Sfax
1	54	Turkey	Koc University	6/1/13	6/1/18	10/1/17	Ms. Sedef Ercetin	sercetom@ku.edu.tr
1	55		United States	University of California, LA (UCLA)	5/23/12
1	56		Wales	Royal Welsh College of Music and Drama		3/1/10		7/2/15
1	57	University of Wales, Newport	4/1/11	4/1/14	Claire Birney	international@newport.ac.uk
1	58																Germany	University of Applied Sciences at Wuerzburg-Schweinfurt	Inactive
1	59														India	National Institute of Fashion Technology (NIFT)					1/1/10	5/3/12	Mrs. Anupreet Bhalla Dugal	anupreet.dugal@gmail.com	Terminated
1	60	Indian Retail School				1/15/07		Expired
1	61	Pearl Academy of Fashion
117	The Angel Investors Consortium			1/1/12				1/1/15				5/3/14
118	University of Mumbai, College of Social Work, Mumbai	2/3/10	2/3/15	6/5/14	Gracie Joseph	graciejoseph@gmail.com
119			Ireland	Dublin Institute of Technology	3/1/16	Roger Sherlock	roger.sherlock@dit.ie
120	University of Haifa	7/23/13	7/23/18	11/22/17	Ms. Ilanit Palace	ipalace@univ.haifa.ac.il
121	Tel Aviv University	11/28/12	11/28/17	3/30/17
122	Libera Università di Lingue e Comunicazione (IULM)	5/30/10	5/30/15		9/29/14
123	Universita degli Studi di Firenze (University of Florence)	8/29/12	8/29/17	12/29/16
1	62	University of Abertay Dundee	Frank Pullen
1	63	Milan Polytechnic University	5/2/05	5/2/10			9/1/09	Maria Perego	cri.agreement@polimi.it	Expired, no interest was expressed in renewal. Research performed on programs, do not appear to have equivalent programs in english.
1	64	7/20/09	7/20/12
1	65			Brazil	Municipality of Belo Horizonte		12/1/09
1	66	Columbia	Universidad de Catagena			9/28/09	1/28/09
1	67				Canada	Canadian Manufacturers and Exporters	1/17/09		1/17/10		5/19/09
1	68	The Confederation of Indian Industry	1/17/07
1	69											France	Institut National de l’Audiovisuel	4/27/07	4/27/10	4/27/09
1	70	Taiwain	National Taipai University of Technology	10/2/07	10/2/12			2/2/12
1	71	Pennsylvania State University	7/18/08	7/18/11	11/17/10
1	72																			China	North China University of Technology	10/23/10	10/23/11	2/22/11
1	73	University of Prince Edward Island	Dr. Vianne Timmons	vtimmons@upei.ca
1	74	The Hatch
1	75
					Australia	Curtin University of Technology	1	2/1/17	4/2/17	Julie-Anne Beasley	J.Beasley@curtin.edu.au
RMIT University	8/18/10		8/18/15		12/18/14	Judi Cowie	judi.cowie@rmit.edu.au
RMIT University (Study Tour)			6/8/12	Emilia Tabrizi	emilia.tabrizi@rmit.edu.au
University of New										England	None	10/25/10
University of South Australia (UniSA)	Karen English	karen.english@unisa.edu.au
University of Technology, Sydney	3/19/13	3/19/18	7/19/17	Ms. Tze Ay Chuah	debbie.johnson@uts.edu.au
Austria	Johannes Kepler University	9/1/11		9/1/14
	Barbados, Jamaica, Trinidad and Tobago		University of the West Indies					1/1/09
1/13/13	lilieth.nelson@uwimona.edu.jm
Belgium	Université Libre de Bruxelles	2/17/10	2/17/15	6/19/14
Sao Paulo Research Foundation
SESI / SENAI / IEL		2/2/17		6/4/16
Université du Québec à Montréal (UQAM)	9/29/09	1/29/14	Vice-doyen aux etudes
Université Laval	9/1/08		9/1/13	Patrick Hurley	patrick.hurley@fsa.ulaval.ca
		Chile	Universidad de Artes, Ciencias y Communicacion (UNIACC)	Ms. Grace Agosin	grace.agosin@uniacc.cl
Universidad del Pacifico	5/25/07	5/25/13	9/24/12	John Cowell	jcowell@upacifico.cl
Universidad Técnica Federico Santa María	10/7/10	10/7/15	2/6/15
Beijing Jiaotong University	6/8/17	10/8/16
China Three Gorges University	3/15/10	3/15/15	7/15/14
City University Hong Kong	9/1/10	Dr. Mike Yao	mike.yao@cityu.edu.hk
Communication University of China	12/1/11		12/1/16	4/2/16
Tsinghua U. Insitute of Economics, Arts and Sciences		3/1/13		3/1/18
The Institute of Ethnology and Anthropology
Beijing Film Academy	4/8/13	4/8/18	8/8/17
Dalian Maritime University			6/1/11			6/1/16			10/2/15
Beijing University of Technology	5/1/13	5/1/18	8/31/17	abc@xyz.com
COMAC Shanghai Aircraft Customer Service Co., Ltd.	1/16/12	5/3/16	Trial
Harbin Institute
Hong Kong Baptist University
Hong Kong Polytechnic University	8/28/12	8/28/17	12/28/16	Ms. Cathy Wong	cathy.wong@polyu.edu.hk
Nanjing Univeristy of Aeronautics and Astronautics	3/1/12	3/1/17			7/1/16
Northwestern Polytechnical University	3/10/12	3/10/17	7/10/16
Shanghai Finance University	6/10/13	6/10/18	10/10/17	Ms. Amelia Shen	amelia_sheng@163.com
University of Hong Kong	6/15/09
Zhengzhou University	9/6/12	9/6/17	1/6/17
	Colombia	Universidad de Cartagena	9/28/14	1/28/14
Universidad Nacional de Colombia	11/20/09	11/20/14	3/22/14
Croatia	Zagreb School of Economics and Management	Javier Aguayo	jaguayo@zsem.hr
				Denmark	Copenhagen Business School	1/9/11	1/9/14	5/11/13	Mette Kloch	mk.io@cbs.dk
Copenhagen School of Design and Technology (KEA)		11/1/15
Danish School of Journalism, Aarhus	6/1/12	6/1/17	Inger Muk	imu@djh.dk
Roskilde University	Chanda Hansen	chanda@ruc.dk
VIA University College	Tina Lisberg Bundgaard	tlb@viauc.dk
Birmingham City University	Sarah Hopkins	sarah.hopkins@bcu.ac.uk
Bournemouth University
City University London	Ivan Hutchins	Ivan.Hutchins.1@city.ac.uk
76	Coventry University	4/2/14	Ian Dunn	i.dunn@coventry.ac.uk
77	Manchester Metropolitan University
78	Nottingham Trent University	11/18/11
79	Sheffield Hallam University
80	University of Portsmouth	6/30/11	6/30/16	10/31/15
81	University of Surrey	1-sep-15
82	University of Westminster
83		Finland	AALTO University	11/1/12	11/1/17	3/3/17
84	HAAGA-HELIA University of Applied Sciences
85	AgroSup Dijon	4/8/11	4/8/16	8/9/15
86	BBA ESSEC Business Schoo	1/1/18	5/3/17
87	ESIDAI	12/7/09	12/7/14	4/8/14	Ecole Supérieure d’Ingénieurs en Développement Agroalimentaire Intégré
88	ESTACA École D’Ingénieurs	1	1/15/10	11/15/13	3/17/13
89	Group ICAM	10/5/10	10/5/15	2/4/15
90	Institut d’Économie Scientifique et de Gestion
91	Institut Français de Mecanique Avancee (IFMA)	1/15/15	5/17/14
92	SKEMA Business School (previously CERAM)	8/1/12	8/1/17
93	Telecom INT SudParis	3/10/08	3/10/13	7/10/12
94	Universite Paris-Dauphine
95	Fachhochschule Frankfurt am Main
96	Filmakademie Baden Württemburg
97	Friedrich-Alexander-Universitaet Erlangen-Nuernberg (FAU)	7/13/11	7/13/16	11/13/15
98	German Cancer Research Center (DKFZ)	2/6/09	2/6/14	6/8/13
99	Heidelberg University	Dr. H. Joachim Gerke	gerke@zuv.uni-heidelberg.de
100	Hochschule der Medien
101				Karlsruhe University of Applied Sciences		5/1/10		5/1/15		8/31/14
102
103	3/1/11	3/1/14	7/1/13	Dr. Joachim Lembach	joachim.lembach@hs-karlsruhe.de
104
105	University of Applied Sciences Offenburg
106	University of Augsburg and Technische Universität München	5/18/11	5/18/13	9/17/12
107	University of Münster	Dr. Christoph Brox
108	University of Television and Film Munich
109	Aristotle University of Thessaloniki
110	Anna University
111	Center for Development and Human Rights (CDHR)	6/3/16
112	India Institute of Technology Bombay (IIT Bombay)	10/17/12	10/17/17	2/16/17
113	Indian Institute of Technology Madras (IIT Madras)	11/24/09	11/24/14	3/26/14
114	Indo-Canadian Business Chamber	6/3/14
115	Jamia Millia Islamia University	9/27/12	9/27/17	1/27/17
116	O.P Jindal Global University	1/24/12	1/24/17	5/26/16

1 0

1 1

1 2

1 3

1 4

3 EditPartnership Form

1 5

1 6

1 7

3 EditPartnership Form

1 8

SwitchboardID	ItemNumber	Command
Main Switchboard	Default
Add new Partnership	Partnership Form
View All Partnerships	rptAllPartnerships
Edit Partnerships		EditPartnership Form
View Renewable Partnerships
View Cancelled/Expired Partnerships	CancelledExpiredContract
Country Wide Report	rptCountry
Search
Exit

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:])

Turn in your highest-quality paper
Get a qualified writer to help you with

“ MS access help ”

Get high-quality paper

Guarantee! All work is written by expert writers!

Still stressed from student homework?

Get quality assistance from academic writers!

Order now