{"id":325,"date":"2022-12-01T20:32:30","date_gmt":"2022-12-01T20:32:30","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/field-names-and-data-types\/"},"modified":"2022-12-01T20:32:30","modified_gmt":"2022-12-01T20:32:30","slug":"field-names-and-data-types","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/field-names-and-data-types\/","title":{"raw":"Field Names and Data Types","rendered":"Field Names and Data Types"},"content":{"raw":"\n<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n \t<li>Discuss field name requirements<\/li>\n \t<li>Discuss types of data used in Microsoft Access<\/li>\n<\/ul>\n<\/div>\n<h2>Field Names<\/h2>\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:\n<ul>\n \t<li style=\"font-weight: 400;\">Cannot exceed 64 characters,<\/li>\n \t<li style=\"font-weight: 400;\">Cannot include periods (.), exclamation points (!), accent grave (`), or brackets ([]),<\/li>\n \t<li style=\"font-weight: 400;\">Cannot include spaces,<\/li>\n \t<li style=\"font-weight: 400;\">Cannot include low-order ASCII characters,<\/li>\n \t<li style=\"font-weight: 400;\">Cannot start with a blank space.<\/li>\n<\/ul>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/be3f092e-a9aa-4314-be55-ed6dda461d76\n\n<\/div>\n<h2>Data Types<\/h2>\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:\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>\nhttps:\/\/assess.lumenlearning.com\/practice\/0a8d6dc0-05cc-4c05-9921-35ee3dcf7b65\n\n<\/div>\n<h2>Contribute!<\/h2><div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div><a href=\"https:\/\/docs.google.com\/document\/d\/17LHtGGYgi5jdUO4aF1qD6jgN9bCk8qwqGm1rjw6sYvI\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a>\n","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><\/p>\n<\/div>\n<h2>Contribute!<\/h2>\n<div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div>\n<p><a href=\"https:\/\/docs.google.com\/document\/d\/17LHtGGYgi5jdUO4aF1qD6jgN9bCk8qwqGm1rjw6sYvI\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a><\/p>\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-325\">\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":503070,"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-325","chapter","type-chapter","status-publish","hentry"],"part":317,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/325","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/users\/503070"}],"version-history":[{"count":0,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/325\/revisions"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/parts\/317"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/325\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=325"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=325"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=325"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}