{"id":3112,"date":"2019-12-23T16:40:53","date_gmt":"2019-12-23T16:40:53","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3112"},"modified":"2024-05-17T00:25:03","modified_gmt":"2024-05-17T00:25:03","slug":"adding-values-and-records-in-datasheets","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/adding-values-and-records-in-datasheets\/","title":{"raw":"Adding Values and Records in Datasheets","rendered":"Adding Values and Records in Datasheets"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Add values in datasheets<\/li>\r\n \t<li>Add records in datasheets<\/li>\r\n<\/ul>\r\n<\/div>\r\n<h2>Adding Values in Datasheets<\/h2>\r\nAdding and replacing values in Access is very straightforward.\r\n\r\n<img class=\"alignnone wp-image-3438 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07211246\/Figure13_6.png\" alt=\"The pencil icon on the far left of record 12 indicates that record 12 is being edited. The record directly below record 12 has an asterisk where the pencil icon is in record 12 and the word &quot;(New)&quot; in the first column.\" width=\"974\" height=\"135\" \/>\r\n\r\nIn this example, a new record is being added to the Supplier table. The asterisk and \u201cNew\u201d designation are automatically moved down one row as soon as a value has begun to be entered. The \u201cpencil\u201d icon appears in the far left field to indicate that data is being entered in to that record.\r\n\r\n<img class=\"alignnone wp-image-3439 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07211301\/Figure13_7.png\" alt=\"The job title column of the sheet is being edited in record 12 and the pencil icon is on the far left of record 12.\" width=\"974\" height=\"179\" \/>\r\n\r\nIn this example, the value entered of job title in the Supplier table is being modified. Clicking on the field causes the \u201cpencil\u201d icon to appear and the prior entry can be deleted and the new data entered and saved.\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/da830275-e5bd-49b5-bf6e-4e0989b6560e\r\n\r\n<\/div>\r\n<h2>Adding Records in Datasheets<\/h2>\r\nAs we see in the above example, adding new data into an empty field is as simple as positioning your cursor in the field and beginning typing. Adding data into a field already containing data is not much more difficult. If using the keyboard, tabbing to the field will highlight the entire field and the prior data will be replaced upon entering the first character of new data. If using the mouse, clicking on the field will place the cursor where the prior data can be deleted one character at a time or left-click and hold down the mouse to highlight the original data so it can be replaced.\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/58cfd349-d03f-476d-9853-bfca52d8d64a\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Add values in datasheets<\/li>\n<li>Add records in datasheets<\/li>\n<\/ul>\n<\/div>\n<h2>Adding Values in Datasheets<\/h2>\n<p>Adding and replacing values in Access is very straightforward.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3438 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07211246\/Figure13_6.png\" alt=\"The pencil icon on the far left of record 12 indicates that record 12 is being edited. The record directly below record 12 has an asterisk where the pencil icon is in record 12 and the word &quot;(New)&quot; in the first column.\" width=\"974\" height=\"135\" \/><\/p>\n<p>In this example, a new record is being added to the Supplier table. The asterisk and \u201cNew\u201d designation are automatically moved down one row as soon as a value has begun to be entered. The \u201cpencil\u201d icon appears in the far left field to indicate that data is being entered in to that record.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3439 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07211301\/Figure13_7.png\" alt=\"The job title column of the sheet is being edited in record 12 and the pencil icon is on the far left of record 12.\" width=\"974\" height=\"179\" \/><\/p>\n<p>In this example, the value entered of job title in the Supplier table is being modified. Clicking on the field causes the \u201cpencil\u201d icon to appear and the prior entry can be deleted and the new data entered and saved.<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_da830275-e5bd-49b5-bf6e-4e0989b6560e\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/da830275-e5bd-49b5-bf6e-4e0989b6560e?iframe_resize_id=assessment_practice_id_da830275-e5bd-49b5-bf6e-4e0989b6560e\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<h2>Adding Records in Datasheets<\/h2>\n<p>As we see in the above example, adding new data into an empty field is as simple as positioning your cursor in the field and beginning typing. Adding data into a field already containing data is not much more difficult. If using the keyboard, tabbing to the field will highlight the entire field and the prior data will be replaced upon entering the first character of new data. If using the mouse, clicking on the field will place the cursor where the prior data can be deleted one character at a time or left-click and hold down the mouse to highlight the original data so it can be replaced.<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_58cfd349-d03f-476d-9853-bfca52d8d64a\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/58cfd349-d03f-476d-9853-bfca52d8d64a?iframe_resize_id=assessment_practice_id_58cfd349-d03f-476d-9853-bfca52d8d64a\" 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-3112\">\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>Adding Values and Records in 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":11,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Adding Values and Records in Datasheets\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"2628afe6-9204-4d17-950a-2293857c8a44, 69be1c23-d1cd-47ce-8cf0-0a5644acff5b, 0df67048-ca29-44c3-97f5-fbb9d8d17b43","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3112","chapter","type-chapter","status-publish","hentry"],"part":2774,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3112","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\/3112\/revisions"}],"predecessor-version":[{"id":5960,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3112\/revisions\/5960"}],"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\/3112\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=3112"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=3112"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=3112"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=3112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}