{"id":3107,"date":"2019-12-23T16:40:30","date_gmt":"2019-12-23T16:40:30","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3107"},"modified":"2024-05-17T00:24:34","modified_gmt":"2024-05-17T00:24:34","slug":"datasheets","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/datasheets\/","title":{"raw":"Datasheets","rendered":"Datasheets"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Define datasheets<\/li>\r\n \t<li>Discuss datasheet windows within Microsoft Access<\/li>\r\n<\/ul>\r\n<\/div>\r\nA datasheet is a useful way of viewing data in Access. Most importantly, datasheet view allows a user to view many table records at the same time. In datasheet view, information is displayed in rows and columns\u2014similar to a spreadsheet. Records are displayed as rows, so each row is an individual record. Within each row, columns represent fields within the record.\r\n\r\n<img class=\"alignnone wp-image-4344 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/30232833\/Figure13_1_new.jpg\" alt=\"Microsoft access datasheet view.\" width=\"1287\" height=\"657\" \/>\r\n<div class=\"textbox tryit\">\r\n<h3>PRactice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/1f7edc7c-7f27-4c09-b7ae-b0d1a7c26fe7\r\n\r\n<\/div>\r\n<h2>Datasheet Windows<\/h2>\r\nAt the top of the datasheet window are the title bar, the Quick Access toolbar, and the Ribbon. The bottom of the window has a status bar and on the right side of the window a scroll bar as you would expect.\r\n\r\nMany of the features that are common to spreadsheets are present in Access datasheet windows. A user can modify row height, column width, font size to change the amount of data that fits without scrolling. A user can also change the order of the rows or columns displayed in the window.\r\n\r\nDatasheet views are a common display tool for tables, queries, and forms in Access. There are some irregularities in the functionality of the datasheet windows for these depending on the underlying data sources.\r\n\r\n<img class=\"alignnone wp-image-3429 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07210511\/Figure13_3.png\" alt=\"Microsoft access datasheet view.\" width=\"974\" height=\"668\" \/>\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/284b64a4-ddea-4180-a03a-c6053f686127\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Define datasheets<\/li>\n<li>Discuss datasheet windows within Microsoft Access<\/li>\n<\/ul>\n<\/div>\n<p>A datasheet is a useful way of viewing data in Access. Most importantly, datasheet view allows a user to view many table records at the same time. In datasheet view, information is displayed in rows and columns\u2014similar to a spreadsheet. Records are displayed as rows, so each row is an individual record. Within each row, columns represent fields within the record.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4344 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/30232833\/Figure13_1_new.jpg\" alt=\"Microsoft access datasheet view.\" width=\"1287\" height=\"657\" \/><\/p>\n<div class=\"textbox tryit\">\n<h3>PRactice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_1f7edc7c-7f27-4c09-b7ae-b0d1a7c26fe7\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/1f7edc7c-7f27-4c09-b7ae-b0d1a7c26fe7?iframe_resize_id=assessment_practice_id_1f7edc7c-7f27-4c09-b7ae-b0d1a7c26fe7\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<h2>Datasheet Windows<\/h2>\n<p>At the top of the datasheet window are the title bar, the Quick Access toolbar, and the Ribbon. The bottom of the window has a status bar and on the right side of the window a scroll bar as you would expect.<\/p>\n<p>Many of the features that are common to spreadsheets are present in Access datasheet windows. A user can modify row height, column width, font size to change the amount of data that fits without scrolling. A user can also change the order of the rows or columns displayed in the window.<\/p>\n<p>Datasheet views are a common display tool for tables, queries, and forms in Access. There are some irregularities in the functionality of the datasheet windows for these depending on the underlying data sources.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3429 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07210511\/Figure13_3.png\" alt=\"Microsoft access datasheet view.\" width=\"974\" height=\"668\" \/><\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_284b64a4-ddea-4180-a03a-c6053f686127\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/284b64a4-ddea-4180-a03a-c6053f686127?iframe_resize_id=assessment_practice_id_284b64a4-ddea-4180-a03a-c6053f686127\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe>\n<\/div>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-3107\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Datasheets. <strong>Authored by<\/strong>: Robert Danielson. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":17,"menu_order":7,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Datasheets\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"7cba1446-6d2f-4f0c-a52e-32201ff5ece0, da1cc80b-04c8-49fe-8dca-98217798b08b, 776e0cd9-05c3-42ab-8a48-62e90d8119e0","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3107","chapter","type-chapter","status-publish","hentry"],"part":2774,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3107","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":11,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3107\/revisions"}],"predecessor-version":[{"id":5956,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3107\/revisions\/5956"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/parts\/2774"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3107\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=3107"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=3107"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=3107"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=3107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}