{"id":3157,"date":"2019-12-23T16:46:10","date_gmt":"2019-12-23T16:46:10","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3157"},"modified":"2024-05-17T00:27:46","modified_gmt":"2024-05-17T00:27:46","slug":"creating-basic-forms","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/creating-basic-forms\/","title":{"raw":"Creating Basic Forms","rendered":"Creating Basic Forms"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Create basic forms<\/li>\r\n<\/ul>\r\n<\/div>\r\nAccess makes it relatively easy to create a basic form.\r\n<ol>\r\n \t<li>Select the table or query containing the data you are interested in seeing on your form in the Navigation pane.<\/li>\r\n \t<li>Go to the <strong>Create<\/strong> tab, and the <strong>Forms<\/strong> group and select <strong>Form<\/strong>.<\/li>\r\n<\/ol>\r\nAccess will create a basic form and open it in Layout view. You should be able to see the data you selected. In Layout view, you have some limited capabilities to make design changes to the form.\r\n\r\nIn addition to creating a basic form, Access will check to see if there are one-to-many relationships existing between the table you selected to create the form and any other tables in the database. If so, it will add a datasheet based on the related table or query to your basic form. For example, if you create a basic form based on the Customers table, and there is a one-to-many relationship with the Orders table, Access will display all of the records in the Orders table that relate to the Customers table in Datasheet view.\r\n\r\n<img class=\"aligncenter wp-image-3639 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/15225142\/5-Creating-Basic-forms.jpg\" alt=\"\" width=\"1277\" height=\"710\" \/>\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/7baf8e32-803a-455f-8cd3-7a497fac008c\r\n\r\n<\/div>\r\n<div class=\"textbox key-takeaways\">\r\n<h3>Learn More<\/h3>\r\nFor detailed, step-by-step instructions Microsoft Access Help is an excellent resource and can be found by following this link:\u00a0<a href=\"https:\/\/support.office.com\/en-us\/article\/create-a-form-in-access-5d550a3d-92e1-4f38-9772-7e7e21e80c6b\">MS Access Help: Creating Forms<\/a>\r\n\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Create basic forms<\/li>\n<\/ul>\n<\/div>\n<p>Access makes it relatively easy to create a basic form.<\/p>\n<ol>\n<li>Select the table or query containing the data you are interested in seeing on your form in the Navigation pane.<\/li>\n<li>Go to the <strong>Create<\/strong> tab, and the <strong>Forms<\/strong> group and select <strong>Form<\/strong>.<\/li>\n<\/ol>\n<p>Access will create a basic form and open it in Layout view. You should be able to see the data you selected. In Layout view, you have some limited capabilities to make design changes to the form.<\/p>\n<p>In addition to creating a basic form, Access will check to see if there are one-to-many relationships existing between the table you selected to create the form and any other tables in the database. If so, it will add a datasheet based on the related table or query to your basic form. For example, if you create a basic form based on the Customers table, and there is a one-to-many relationship with the Orders table, Access will display all of the records in the Orders table that relate to the Customers table in Datasheet view.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3639 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/15225142\/5-Creating-Basic-forms.jpg\" alt=\"\" width=\"1277\" height=\"710\" \/><\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_7baf8e32-803a-455f-8cd3-7a497fac008c\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/7baf8e32-803a-455f-8cd3-7a497fac008c?iframe_resize_id=assessment_practice_id_7baf8e32-803a-455f-8cd3-7a497fac008c\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<div class=\"textbox key-takeaways\">\n<h3>Learn More<\/h3>\n<p>For detailed, step-by-step instructions Microsoft Access Help is an excellent resource and can be found by following this link:\u00a0<a href=\"https:\/\/support.office.com\/en-us\/article\/create-a-form-in-access-5d550a3d-92e1-4f38-9772-7e7e21e80c6b\">MS Access Help: Creating Forms<\/a><\/p>\n<\/div>\n","protected":false},"author":17,"menu_order":11,"template":"","meta":{"_candela_citation":"[]","CANDELA_OUTCOMES_GUID":"9303f6f2-6afa-405b-ae21-97c70d158afb, cd3ead65-624f-403b-ab2d-c099d6c2b6bd","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3157","chapter","type-chapter","status-publish","hentry"],"part":2775,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3157","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":15,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3157\/revisions"}],"predecessor-version":[{"id":5982,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3157\/revisions\/5982"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/parts\/2775"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3157\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=3157"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=3157"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=3157"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=3157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}