Info Systems for Managers Spring

Info Systems for Managers Spring 2007

Access Project

**GPA**
First Name	Last Name	Major	GPA
Jose	Azcona	Finance	2.5
Reginald	Raphael	Art	2.6
Jamille	Rose	Accounting	2.9
Andre	Armor	Art	3.0
Edwin	Sanchez	Psychology	3.1
Korina	Cruz`	Biology	3.2
Brenda	Pedersen	Finance	3.3
Rebecca	Matthews	Finance	3.5

**School Record**
Last Name	First Name	Gender	Age	Major
Armor	Andre	Male	23	Art
Azcona	Jose	Male	21	Finance
Cruz	Korina	Female	21	Biology
Matthews	Rebecca	Female	21	Accounting
Pedersen	Brenda	Female	22	Finance
Raphael	Reginald	Male	22	Art
Rose	Jamille	Female	22	Accounting
Sanchez	Edwin	Male	22	Psychology

**Student info**
Social Security	Last Name	First Name	Age	Telephone Number
123-46-6566	Matthews	Rebecca`	21	(347) 697-0735
542-84-5624	Rose	Jamille	22	(547) 545-2536
542-87-5752	Raphael	Reginald	22	(347) 256-0353
574-18-8956	Sanchez	Edwin	22	(547) 833-2664
845-24-5652	Pedersen	Brenda	22	(917) 968-5008
874-42-1545	Armor	Andre	23	(718) 359-7466
875-41-2433	Cruz	Korina	21	(646) 641-0354
942-74-5642	Azcona	Jose	21	(973) 542-4125

**Years**
Year	First Name	Last Name
Freshman	Andre	Armor
Sophomore	Brenda	Pedersen
Sophomore	Edwin	Sanchez
Senior	Jamille	Rose
Sophomore	Jose	Azcona
Junior	Korina	Cruz
Senior	Rebecca	Matthews
Junior	Reginald	Raphael

Queries

**GPA & Age**
GPA	Major	Age	First Name	Last Name
3.5	Finance	21	Rebecca	Matthews
3.0	Art	23	Andre	Armor
2.5	Finance	21	Jose	Azcona
3.3	Finance	22	Brenda	Pedersen
2.6	Art	22	Reginald	Raphael
2.9	Accounting	22	Jamille	Rose
3.1	Psychology	22	Edwin	Sanchez

**GPA & Year of Study**
GPA	Year	First Name	Last Name
3.5	Senior	Rebecca	Matthews
3.0	Freshman	Andre	Armor
2.5	Sophomore	Jose	Azcona
3.2	Junior	Korina	Cruz
3.3	Sophomore	Brenda	Pedersen
2.6	Junior	Reginald	Raphael
2.9	Senior	Jamille	Rose
3.1	Sophomore	Edwin	Sanchez

**Majors & Year of Study**
Year	First Name	Last Name	Major
Senior	Rebecca	Matthews	Finance
Freshman	Andre	Armor	Art
Sophomore	Jose	Azcona	Finance
Junior	Korina	Cruz`	Biology
Sophomore	Brenda	Pedersen	Finance
Junior	Reginald	Raphael	Art
Senior	Jamille	Rose	Accounting
Sophomore	Edwin	Sanchez	Psychology

**Year of Study & Students**
Year	Last Name	First Name	Age
Junior	Raphael	Reginald	22
Sophomore	Pedersen	Brenda	22
Freshman	Armor	Andre	23
Sophomore	Azcona	Jose	21
Junior	Cruz	Korina	21
Senior	Rose	Jamille	22
Sophomore	Sanchez	Edwin	22

SELECT Years.Year, GPA.[Last Name], GPA.Major, GPA.GPA
FROM Years INNER JOIN GPA ON Years.[First Name] = GPA.[First Name]
WHERE (((Years.Year)="Sophomore") AND ((GPA.[First Name])>"2.0") AND ((GPA.Major)="Finance") AND ((GPA.GPA)>"2.0"));

**Majors & Year of Study**
Year	Last Name	Major	GPA
Sophomore	Azcona	Finance	2.5
Sophomore	Pedersen	Finance	3.3

SELECT Years.Year, [Student info].Age, [School Record].Major, [School Record].[First Name]
FROM (Years INNER JOIN [Student info] ON Years.[First Name] = [Student info].[First Name]) INNER JOIN [School Record] ON Years.[Last Name] = [School Record].[Last Name]
WHERE (((Years.Year)="senior") AND (([Student info].Age)>21));

**Query1**
Year	Age	Major	First Name
Senior	22	Accounting	Jamille

Forms

Report

Hosted by www.Geocities.ws