{"id":16137,"date":"2024-04-15T04:56:38","date_gmt":"2024-04-15T04:56:38","guid":{"rendered":"https:\/\/exam.pscnotes.com\/mcq\/?p=16137"},"modified":"2024-04-15T04:56:38","modified_gmt":"2024-04-15T04:56:38","slug":"how-can-you-link-a-table-with-another-so-that-a-field-in-current-table-will-display-values-in-drop-down-box-from-another-table-while-entering-data-a-query-wizard-b-look-up-wizard-c-form-wizard-d","status":"publish","type":"post","link":"https:\/\/exam.pscnotes.com\/mcq\/how-can-you-link-a-table-with-another-so-that-a-field-in-current-table-will-display-values-in-drop-down-box-from-another-table-while-entering-data-a-query-wizard-b-look-up-wizard-c-form-wizard-d\/","title":{"rendered":"How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data: A. Query Wizard B. Look up Wizard C. Form Wizard D. Report Wizard"},"content":{"rendered":"<p>[amp_mcq option1=&#8221;Query Wizard&#8221; option2=&#8221;Look up Wizard&#8221; option3=&#8221;Form Wizard&#8221; option4=&#8221;Report Wizard&#8221; correct=&#8221;option2&#8243;]<!--more--><\/p>\n<p>The correct answer is: <strong>B. Look up Wizard<\/strong><\/p>\n<p>A lookup wizard is a tool that helps you create a lookup field in a table. A lookup field is a field that displays a list of values from another table. When you enter data into a lookup field, you can select a value from the list.<\/p>\n<p>To create a lookup field, follow these steps:<\/p>\n<ol>\n<li>In the table that you want to add the lookup field to, right-click the field where you want to add the lookup field, and then click <strong>Lookup Wizard<\/strong>.<\/li>\n<li>In the <strong>Lookup Wizard &#8211; Step 1 of 3<\/strong> dialog box, select the <strong>I want the lookup field to look up values in a table or list<\/strong> option, and then click <strong>Next<\/strong>.<\/li>\n<li>In the <strong>Lookup Wizard &#8211; Step 2 of 3<\/strong> dialog box, select the table that contains the values that you want to display in the lookup field, and then click <strong>Next<\/strong>.<\/li>\n<li>In the <strong>Lookup Wizard &#8211; Step 3 of 3<\/strong> dialog box, select the fields that you want to display in the lookup field, and then click <strong>Next<\/strong>.<\/li>\n<li>In the <strong>Lookup Wizard &#8211; Step 4 of 3<\/strong> dialog box, type a name for the lookup field, and then click <strong>Finish<\/strong>.<\/li>\n<\/ol>\n<p>The lookup field will be added to the table. When you enter data into the lookup field, you can select a value from the list of values that is displayed.<\/p>\n<p>The other options are incorrect because they are not tools that help you create a lookup field in a table.<\/p>\n<ul>\n<li><strong>A. Query Wizard<\/strong> is a tool that helps you create a query. A query is a way to select data from one or more tables.<\/li>\n<li><strong>C. Form Wizard<\/strong> is a tool that helps you create a form. A form is a way to enter and view data in a table.<\/li>\n<li><strong>D. Report Wizard<\/strong> is a tool that helps you create a report. A report is a way to summarize data from one or more tables.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>[amp_mcq option1=&#8221;Query Wizard&#8221; option2=&#8221;Look up Wizard&#8221; option3=&#8221;Form Wizard&#8221; option4=&#8221;Report Wizard&#8221; correct=&#8221;option2&#8243;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[672],"tags":[],"class_list":["post-16137","post","type-post","status-publish","format-standard","hentry","category-ms-access","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.2 (Yoast SEO v23.3) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data: A. Query Wizard B. Look up Wizard C. Form Wizard D. Report Wizard<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exam.pscnotes.com\/mcq\/how-can-you-link-a-table-with-another-so-that-a-field-in-current-table-will-display-values-in-drop-down-box-from-another-table-while-entering-data-a-query-wizard-b-look-up-wizard-c-form-wizard-d\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data: A. Query Wizard B. Look up Wizard C. Form Wizard D. Report Wizard\" \/>\n<meta property=\"og:description\" content=\"[amp_mcq option1=&#8221;Query Wizard&#8221; option2=&#8221;Look up Wizard&#8221; option3=&#8221;Form Wizard&#8221; option4=&#8221;Report Wizard&#8221; correct=&#8221;option2&#8243;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exam.pscnotes.com\/mcq\/how-can-you-link-a-table-with-another-so-that-a-field-in-current-table-will-display-values-in-drop-down-box-from-another-table-while-entering-data-a-query-wizard-b-look-up-wizard-c-form-wizard-d\/\" \/>\n<meta property=\"og:site_name\" content=\"MCQ and Quiz for Exams\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-15T04:56:38+00:00\" \/>\n<meta name=\"author\" content=\"rawan239\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"rawan239\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data: A. Query Wizard B. Look up Wizard C. Form Wizard D. Report Wizard","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exam.pscnotes.com\/mcq\/how-can-you-link-a-table-with-another-so-that-a-field-in-current-table-will-display-values-in-drop-down-box-from-another-table-while-entering-data-a-query-wizard-b-look-up-wizard-c-form-wizard-d\/","og_locale":"en_US","og_type":"article","og_title":"How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data: A. Query Wizard B. Look up Wizard C. Form Wizard D. Report Wizard","og_description":"[amp_mcq option1=&#8221;Query Wizard&#8221; option2=&#8221;Look up Wizard&#8221; option3=&#8221;Form Wizard&#8221; option4=&#8221;Report Wizard&#8221; correct=&#8221;option2&#8243;]","og_url":"https:\/\/exam.pscnotes.com\/mcq\/how-can-you-link-a-table-with-another-so-that-a-field-in-current-table-will-display-values-in-drop-down-box-from-another-table-while-entering-data-a-query-wizard-b-look-up-wizard-c-form-wizard-d\/","og_site_name":"MCQ and Quiz for Exams","article_published_time":"2024-04-15T04:56:38+00:00","author":"rawan239","twitter_card":"summary_large_image","twitter_misc":{"Written by":"rawan239","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exam.pscnotes.com\/mcq\/how-can-you-link-a-table-with-another-so-that-a-field-in-current-table-will-display-values-in-drop-down-box-from-another-table-while-entering-data-a-query-wizard-b-look-up-wizard-c-form-wizard-d\/","url":"https:\/\/exam.pscnotes.com\/mcq\/how-can-you-link-a-table-with-another-so-that-a-field-in-current-table-will-display-values-in-drop-down-box-from-another-table-while-entering-data-a-query-wizard-b-look-up-wizard-c-form-wizard-d\/","name":"How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data: A. Query Wizard B. Look up Wizard C. Form Wizard D. Report Wizard","isPartOf":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/#website"},"datePublished":"2024-04-15T04:56:38+00:00","dateModified":"2024-04-15T04:56:38+00:00","author":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/5807dafeb27d2ec82344d6cbd6c3d209"},"breadcrumb":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/how-can-you-link-a-table-with-another-so-that-a-field-in-current-table-will-display-values-in-drop-down-box-from-another-table-while-entering-data-a-query-wizard-b-look-up-wizard-c-form-wizard-d\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exam.pscnotes.com\/mcq\/how-can-you-link-a-table-with-another-so-that-a-field-in-current-table-will-display-values-in-drop-down-box-from-another-table-while-entering-data-a-query-wizard-b-look-up-wizard-c-form-wizard-d\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exam.pscnotes.com\/mcq\/how-can-you-link-a-table-with-another-so-that-a-field-in-current-table-will-display-values-in-drop-down-box-from-another-table-while-entering-data-a-query-wizard-b-look-up-wizard-c-form-wizard-d\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exam.pscnotes.com\/mcq\/"},{"@type":"ListItem","position":2,"name":"mcq","item":"https:\/\/exam.pscnotes.com\/mcq\/category\/mcq\/"},{"@type":"ListItem","position":3,"name":"Computer fundamentals","item":"https:\/\/exam.pscnotes.com\/mcq\/category\/mcq\/computer-fundamentals\/"},{"@type":"ListItem","position":4,"name":"Ms access","item":"https:\/\/exam.pscnotes.com\/mcq\/category\/mcq\/computer-fundamentals\/ms-access\/"},{"@type":"ListItem","position":5,"name":"How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data: A. Query Wizard B. Look up Wizard C. Form Wizard D. Report Wizard"}]},{"@type":"WebSite","@id":"https:\/\/exam.pscnotes.com\/mcq\/#website","url":"https:\/\/exam.pscnotes.com\/mcq\/","name":"MCQ and Quiz for Exams","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exam.pscnotes.com\/mcq\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/5807dafeb27d2ec82344d6cbd6c3d209","name":"rawan239","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/761a7274f9cce048fa5b921221e7934820d74514df93ef195a9d22af0c1c9001?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/761a7274f9cce048fa5b921221e7934820d74514df93ef195a9d22af0c1c9001?s=96&d=mm&r=g","caption":"rawan239"},"sameAs":["https:\/\/exam.pscnotes.com"],"url":"https:\/\/exam.pscnotes.com\/mcq\/author\/rawan239\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts\/16137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/comments?post=16137"}],"version-history":[{"count":0,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts\/16137\/revisions"}],"wp:attachment":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/media?parent=16137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/categories?post=16137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/tags?post=16137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}