Pastebin launched a little side project called HostCabi.net, check it out ;-)Pastebin is 300% more awesome when you are logged in. Sign Up, it's FREE!
Guest

Untitled

By: a guest on Sep 22nd, 2011  |  syntax: None  |  size: 3.66 KB  |  hits: 2,340  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1.  
  2.  
  3. New Perspectives Access 2010
  4. Tutorial 3 - Case Problem 1
  5. Pine Hill Music School
  6. Skills  
  7. Save a database with a new filename
  8. Edit data in a table datasheet
  9. Find data
  10. Delete a record from a subdatasheet
  11. Delete a record from a datasheet
  12. Create a query using the Simple Query Wizard
  13. Run a query
  14. Edit data in a query datasheet
  15. Create a query in Design view
  16. Sort a query on multiple fields in Design view
  17. Save a copy of a query as a new query
  18. Use a comparison operator in a query
  19. Use text criteria in a query
  20. Add a Total row to a datasheet
  21. Format a query datasheet
  22. Project overview
  23. After reviewing the Pine Hill Music School database, Yuka Koyama wants to modify some records and then view specific information about the students, teachers, and contracts for her music school. She asks you to update and then query the database to perform these tasks.
  24. STUDENT start FILE
  25. NP_Access2010_T3_CP1a_FirstLastName_1.accdb (Note: Download your personalized start file from www.cengage.com/sam2010)
  26.  
  27. Instructions
  28. 1. Open the file NP_Access2010_T3_CP1a_FirstLastName_1.accdb and save the file as NP_Access2010_T3_CP1a_FirstLastName_2.accdb by clicking the "Save Database As" command in Backstage view. (Note: Verify that your name appears in the first record in the _SAMProjects table before you begin. If it does not, then please download a new copy of the start file from the SAM Web site.)
  29.  
  30. 2. In the Teacher table, change the following information for the record with TeacherID 55-5310: Degree is BM and Hire Date is 3/12/2012. Close the table.
  31.  
  32. 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.
  33.  
  34. 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.
  35.  
  36. 5. In the results of the StudentPhoneList query, change the phone number for Andrea Barreau to 503-579-2277. Close the query.
  37.  
  38. 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.
  39.  
  40. 7. Display Backstage view, 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.
  41.  
  42. 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. Run the query to confirm it works, and then save the query.
  43.  
  44. 9. Modify the CurrentGuitarLessons query so that it does not show the lesson type.
  45.        
  46. 10. In the CurrentGuitarLessons query datasheet, display the Total row and show the total amount for the lesson monthly cost.
  47.  
  48. 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.
  49.  
  50. Compact and repair the database, and exit Access. Follow the directions on the SAM Web site to submit your completed project.