a13N_Faculty_Awards

a13N_Faculty_Awards - your answers in the space provided...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
GO! With Microsoft Office 2007 Brief Access Project 13N Faculty Awards Instructions: 1. From the Office menu, click Save As . Navigate to your Access Chapter 13 folder, and then save this Word document as 13N_Faculty_Awards_Firstname_Lastname Using the techniques you learned when studying the Word chapters in this textbook, add the file name to the footer of this Word document. 2. From the student files that accompany this textbook, make a copy of the database a13N_Faculty_Awards and save it in your Access Chapter 13 folder as 13N_Faculty_Awards_Firstname_Lastname 3. Use your database to determine the answers to the following questions, and then type
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: your answers in the space provided under each question below. Save the queries with appropriate names. Submit this Word document and your database to your instructor as directed. Questions: 1. What is the one-to-many relationship between the tables in this database? 2. In alphabetical order by Last Name, which faculty members received an award greater than or equal to $2,500? 3. In alphabetical order by Last Name, which faculty members received one of the Presidential awards? 4. In ascending order by Faculty#, which faculty members received an award in the amount of $1,000?...
View Full Document

This note was uploaded on 12/13/2009 for the course CZVZVZ vzvz taught by Professor Vzcvz during the Spring '09 term at Monmouth IL.

Ask a homework question - tutors are online