Unformatted text preview: the chart title “Commission on Sales” followed by your name . Save the file as carsales.xls (make sure you know where you save the file to: Q5 ) then print a copy of it. 6) Access 6 a) Create a new database on your disk, named midterm.mdb, using MS Access. In the design view, specify the following fields for a table named Students: Field Name Field Type Field Size Name Text 12 Class Text 6 Grade Text 2 Year Number Integer b) Input the following data: Name Class Grade Year Alice CS110 B 2006 Alice CS401 A 2005 Alice CS131 B-2005 Bob CS401 C 2006 Carol CS110 A+ 2006 Carol CS131 B 2004 Dan CS110 B-2004 Dan CS1501 B 2005 c) Create a query to find all people who took CS110 in 2006. Have it return just their names and grades. Save the database inside the folder Q6. Print a copy of the query results....
View Full Document
- Fall '06
- Sales, English-language films, The Commission, 1925, Alice and Bob, CS110 CS131 CS110