{"id":3071,"date":"2019-12-23T16:35:49","date_gmt":"2019-12-23T16:35:49","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3071"},"modified":"2024-05-17T00:18:07","modified_gmt":"2024-05-17T00:18:07","slug":"field-names-and-data-types","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/field-names-and-data-types\/","title":{"raw":"Field Names and Data Types","rendered":"Field Names and Data Types"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Discuss field name requirements<\/li>\r\n \t<li>Discuss types of data used in Microsoft Access<\/li>\r\n<\/ul>\r\n<\/div>\r\n<h2>Field Names<\/h2>\r\nA field name should be descriptive enough to identify the purpose of the field, without being overly long to prevent excessive typing. Enter the field name by placing the pointer in the first row of the Table Design window under the Field Name column. In order to ensure a valid field name, a field name:\r\n<ul>\r\n \t<li style=\"font-weight: 400;\">Cannot exceed 64 characters,<\/li>\r\n \t<li style=\"font-weight: 400;\">Cannot include periods (.), exclamation points (!), accent grave (`), or brackets ([]),<\/li>\r\n \t<li style=\"font-weight: 400;\">Cannot include spaces,<\/li>\r\n \t<li style=\"font-weight: 400;\">Cannot include low-order ASCII characters,<\/li>\r\n \t<li style=\"font-weight: 400;\">Cannot start with a blank space.<\/li>\r\n<\/ul>\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/be3f092e-a9aa-4314-be55-ed6dda461d76\r\n\r\n<\/div>\r\n<h2>Data Types<\/h2>\r\nThe data type must be consistent with the data to be stored in the field. The \u201ctext\u201d type is the most commonly used data type, including numbers that will not be added like social security or street address numbers. Here is a partial list of Access data types:\r\n<table>\r\n<thead>\r\n<tr>\r\n<th style=\"width: 50%;\">Data Type<\/th>\r\n<th style=\"width: 50%;\">Description<\/th>\r\n<\/tr>\r\n<\/thead>\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 50%;\">Short text<\/td>\r\n<td style=\"width: 50%;\">Alphanumeric characters<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 50%;\">Long text<\/td>\r\n<td style=\"width: 50%;\">Alphanumeric characters<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 50%;\">Number<\/td>\r\n<td style=\"width: 50%;\">Numeric values<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 50%;\">Large Number<\/td>\r\n<td style=\"width: 50%;\">Numeric values<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 50%;\">Date\/Time<\/td>\r\n<td style=\"width: 50%;\">Date and time data<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 50%;\">Currency<\/td>\r\n<td style=\"width: 50%;\">Monetary data<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 50%;\">AutoNumber<\/td>\r\n<td style=\"width: 50%;\">Automatic number increments<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 50%;\">Yes\/No<\/td>\r\n<td style=\"width: 50%;\">Logical values: Yes\/No, True\/False, etc.<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 50%;\">OLE Objects<\/td>\r\n<td style=\"width: 50%;\">Pictures, graphs, sound, video<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 50%;\">Hyperlink<\/td>\r\n<td style=\"width: 50%;\">Line to an Internet resource<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 50%;\">Attachment<\/td>\r\n<td style=\"width: 50%;\">External files<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 50%;\">Calculated<\/td>\r\n<td style=\"width: 50%;\">Stores calculations based on other fields<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 50%;\">Lookup Wizard<\/td>\r\n<td style=\"width: 50%;\">Displays data from another table<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/0a8d6dc0-05cc-4c05-9921-35ee3dcf7b65\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Discuss field name requirements<\/li>\n<li>Discuss types of data used in Microsoft Access<\/li>\n<\/ul>\n<\/div>\n<h2>Field Names<\/h2>\n<p>A field name should be descriptive enough to identify the purpose of the field, without being overly long to prevent excessive typing. Enter the field name by placing the pointer in the first row of the Table Design window under the Field Name column. In order to ensure a valid field name, a field name:<\/p>\n<ul>\n<li style=\"font-weight: 400;\">Cannot exceed 64 characters,<\/li>\n<li style=\"font-weight: 400;\">Cannot include periods (.), exclamation points (!), accent grave (`), or brackets ([]),<\/li>\n<li style=\"font-weight: 400;\">Cannot include spaces,<\/li>\n<li style=\"font-weight: 400;\">Cannot include low-order ASCII characters,<\/li>\n<li style=\"font-weight: 400;\">Cannot start with a blank space.<\/li>\n<\/ul>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_be3f092e-a9aa-4314-be55-ed6dda461d76\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/be3f092e-a9aa-4314-be55-ed6dda461d76?iframe_resize_id=assessment_practice_id_be3f092e-a9aa-4314-be55-ed6dda461d76\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<h2>Data Types<\/h2>\n<p>The data type must be consistent with the data to be stored in the field. The \u201ctext\u201d type is the most commonly used data type, including numbers that will not be added like social security or street address numbers. Here is a partial list of Access data types:<\/p>\n<table>\n<thead>\n<tr>\n<th style=\"width: 50%;\">Data Type<\/th>\n<th style=\"width: 50%;\">Description<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"width: 50%;\">Short text<\/td>\n<td style=\"width: 50%;\">Alphanumeric characters<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\">Long text<\/td>\n<td style=\"width: 50%;\">Alphanumeric characters<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\">Number<\/td>\n<td style=\"width: 50%;\">Numeric values<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\">Large Number<\/td>\n<td style=\"width: 50%;\">Numeric values<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\">Date\/Time<\/td>\n<td style=\"width: 50%;\">Date and time data<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\">Currency<\/td>\n<td style=\"width: 50%;\">Monetary data<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\">AutoNumber<\/td>\n<td style=\"width: 50%;\">Automatic number increments<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\">Yes\/No<\/td>\n<td style=\"width: 50%;\">Logical values: Yes\/No, True\/False, etc.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\">OLE Objects<\/td>\n<td style=\"width: 50%;\">Pictures, graphs, sound, video<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\">Hyperlink<\/td>\n<td style=\"width: 50%;\">Line to an Internet resource<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\">Attachment<\/td>\n<td style=\"width: 50%;\">External files<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\">Calculated<\/td>\n<td style=\"width: 50%;\">Stores calculations based on other fields<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 50%;\">Lookup Wizard<\/td>\n<td style=\"width: 50%;\">Displays data from another table<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_0a8d6dc0-05cc-4c05-9921-35ee3dcf7b65\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/0a8d6dc0-05cc-4c05-9921-35ee3dcf7b65?iframe_resize_id=assessment_practice_id_0a8d6dc0-05cc-4c05-9921-35ee3dcf7b65\" 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-3071\">\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>Field Names. <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":8,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Field Names\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"9fbc45d5-f87b-4a7c-958d-32bad6c539d5, af3962d1-194d-43b5-9b75-9264269c3aab, b6b82eda-f4ec-4b99-824d-6102ee721e1d","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3071","chapter","type-chapter","status-publish","hentry"],"part":2773,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3071","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":9,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3071\/revisions"}],"predecessor-version":[{"id":5937,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3071\/revisions\/5937"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/parts\/2773"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3071\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=3071"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=3071"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=3071"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=3071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}