This preview has intentionally blurred parts. Sign up to view the full document

View Full Document

Unformatted Document Excerpt

Projects SAM 2010 Andrew Yeo, NP Access Case T3_CP1A Submission #1 Score is 100 out of 100 1. Verify that your name appears in the first record in the _SAMProjects table. 2. In the Teacher table, change the following information for the record with TeacherID 555310: Degree is BM and Hire Date is 3/12/2012. Close the table. 3. In the Student table, find the record with the Student ID HAV7535, and then delete the related record in the subdatasheet for this student. Delete the record for Student ID HAV7535, and then close the Student table. 4. Create a query based on the Student table that includes the LastName, FirstName, and MobilePhone fields, in that order. Save the query as StudentPhoneList, and run the query to confirm it works. 5. In the results of the StudentPhoneList query, change the phone number for Andrea Barreau to 503-579-2277. Close the query. 6. Use Design view to create a query based on the Teacher and Contract tables. Display the LastName field from the Teacher table, and the StudentID, EndDate, LessonType, LessonLength, and LessonCost fields, in that order, from the Contract table. Sort in ascending order first on the teacher's last name, and then in ascending order by the StudentID. Save the query as LessonsByTeacher, and run the query to confirm it works. 7. Display view, Backstage and then save the LessonsByTeacher query as CurrentLessons. Modify the CurrentLessons query to only display contracts that end on or after 7/1/2013. This should be done by adding a single criteria using the >= operator. Save your changes to the CurrentLessons query, and then run the query to confirm it works. 8. Display Backstage view, and then save the CurrentLessons query as CurrentGuitarLessons. Modify the CurrentGuitarLessons query criteria to display only those records for Guitar lesson contracts that end on or after 7/1/2013. (Note: Since it is based on the CurrentLessons query, the CurrentGuitarLessons query should already display contracts that end on or after 7/1/2013.) Run the query to confirm it works, and then save the query. 9. Modify the CurrentGuitarLessons query so that it does not show the lesson type. 10. In the CurrentGuitarLessons query datasheet, display the Total row and show the total amount for the lesson monthly cost. 11. Change the alternate row color in the CurrentGuitarLessons query datasheet to the Theme Color named Purple, Accent 4, Lighter 60% (third row, eighth column), and change the font size to 12. Save and close the query. SAM Projects COPYRIGHT 2010 PGS Systems Ref: 0E074BCB0B20056A -- Inference Engine version: IE1.1.80, KB version KB1.1.80 ... View Full Document

End of Preview

Sign up now to access the rest of the document