Question

6. The following sample table shows 11 of the students enrolled in an MIS course. Organize the data in a relational format, and use Microsoft Access to list all ACC majors, all ACC majors with a GPA higher than 3.7, all students who are MIS or ACC majors, and all students who aren't ACC majors. Repeat this assignment, this time using Excel, and generate the same results. SAMPLE TABLE Fname Lname ID Major GPA Age Status Mary Jones 111-1 MIS 2.79 19 Freshman Tom Smith 222-7 ACC 3.60 22 Senior Alan Bidgoli 333-9 ACC 3.86 21 Junior Brian Stark 444-6 MKT 3.45 20 Sophomore Steve Kline 555-6 MGT 3.75 24 Junior Nooshin Bidgoli 666-1 MIS 3.90 21 Junior Moury Bidgoli 777-2 MIS 3.90 22 Junior Janet Jeffrey 888-0 MGT 4.00 20 Junior Andy Thomas 999-2 MKT 3.65 29 Senior Jack Tucker 234-1 ACC 3.92 23 Senior

          6. The following sample table shows 11 of the students enrolled in an MIS course. Organize the data in a relational format, and use
Microsoft Access to list all ACC majors, all ACC majors with a GPA higher than 3.7, all students who are MIS or ACC majors,
and all students who aren't ACC majors. Repeat this assignment, this time using Excel, and generate the same results.
SAMPLE TABLE
Fname Lname ID Major GPA Age Status
Mary Jones 111-1 MIS 2.79 19 Freshman
Tom Smith 222-7 ACC 3.60 22 Senior
Alan Bidgoli 333-9 ACC 3.86 21 Junior
Brian Stark 444-6 MKT 3.45 20 Sophomore
Steve Kline 555-6 MGT 3.75 24 Junior
Nooshin Bidgoli 666-1 MIS 3.90 21 Junior
Moury Bidgoli 777-2 MIS 3.90 22 Junior
Janet Jeffrey 888-0 MGT 4.00 20 Junior
Andy Thomas 999-2 MKT 3.65 29 Senior
Jack Tucker 234-1 ACC 3.92 23 Senior

6. The following sample table shows 11 of the students enrolled in an MIS course. Organize the data in a relational format, and use
Microsoft Access to list all ACC majors, all ACC majors with a GPA higher than 3.7, all students who are MIS or ACC majors,
and all students who aren't ACC majors. Repeat this assignment, this time using Excel, and generate the same results.
SAMPLE TABLE
Fname Lname ID Major GPA Age Status
Mary Jones 111-1 MIS 2.79 19 Freshman
Tom Smith 222-7 ACC 3.60 22 Senior
Alan Bidgoli 333-9 ACC 3.86 21 Junior
Brian Stark 444-6 MKT 3.45 20 Sophomore
Steve Kline 555-6 MGT 3.75 24 Junior
Nooshin Bidgoli 666-1 MIS 3.90 21 Junior
Moury Bidgoli 777-2 MIS 3.90 22 Junior
Janet Jeffrey 888-0 MGT 4.00 20 Junior
Andy Thomas 999-2 MKT 3.65 29 Senior
Jack Tucker 234-1 ACC 3.92 23 Senior

Added by Darrell J.

Question

Please give Ace some feedback