This preview shows page 1. Sign up to view the full content.
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
This note was uploaded on 02/22/2010 for the course CMSY 103 taught by Professor N/a during the Fall '06 term at Howard County Community College.
- Fall '06