{"id":113091,"date":"2023-01-19T02:03:08","date_gmt":"2023-01-19T02:03:08","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/go19_ac_ch02_grader_2a_hw-instructors-and-courses-1-1\/"},"modified":"2023-01-19T02:03:08","modified_gmt":"2023-01-19T02:03:08","slug":"go19_ac_ch02_grader_2a_hw-instructors-and-courses-1-1","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/go19_ac_ch02_grader_2a_hw-instructors-and-courses-1-1\/","title":{"rendered":"Go19_ac_ch02_grader_2a_hw &#8211; instructors and courses 1.1"},"content":{"rendered":"<div>\n<p><strong>GO19_AC_CH02_GRADER_2A_HW &#8211; Instructors and Courses 1.1<\/strong><\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n<p>Start \u00a0\u00a0Access. Open the file <em>Student_Access_2A_Instructors_Courses.accdb<\/em> \u00a0\u00a0downloaded with this project. Then, in your textbook, turn to Project 2A and \u00a0\u00a0complete all of the steps in Activities 2.01-2.16.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.01 Opening an Existing Database and Viewing Tables.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.02 Selecting the Tables and Common Field to Establish the Table \u00a0\u00a0Relationship.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.03 Setting Relationship Options.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.04 Saving a Relationship Report. Save the report as <strong>Relationships for 2A_Instructors_Courses<\/strong>.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.05 Displaying Subdatasheet Records.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.06 Testing Cascade Options.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.07 Sorting Records in a Table in Ascending or Descending Order.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.08 Sorting Records in a Table on Multiple Fields.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.09 Creating a New Select Query in Design View.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.10 Running, Saving, Printing, and Closing a Query.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.11 Copying an Existing Query.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.12 Modifying the Design of a Query.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.13 Sorting Query Results.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.14 Specifying Text Criteria in a Query.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.15 Specifying Criteria and Hiding the Field in the Query Results.<\/p>\n<p>\u00a0<\/p>\n<p>Complete \u00a0\u00a0Activity 2.16 Using Is Null Criteria to Find Empty Fields.<\/p>\n<p>\u00a0<\/p>\n<p>Save \u00a0\u00a0and close the database, and then submit for grading.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>GO19_AC_CH02_GRADER_2A_HW &#8211; Instructors and Courses 1.1 \u00a0\u00a0\u00a0\u00a0\u00a0 Start \u00a0\u00a0Access. Open the file Student_Access_2A_Instructors_Courses.accdb \u00a0\u00a0downloaded with this project. Then, in your textbook, turn to Project 2A and \u00a0\u00a0complete all of the steps in Activities 2.01-2.16. \u00a0 Complete \u00a0\u00a0Activity 2.01 Opening an Existing Database and Viewing Tables. \u00a0 Complete \u00a0\u00a0Activity 2.02 Selecting the Tables and Common Field [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-113091","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/113091","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=113091"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/113091\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=113091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=113091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=113091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}