{"id":3070,"date":"2019-12-23T16:35:48","date_gmt":"2019-12-23T16:35:48","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3070"},"modified":"2024-05-17T00:17:56","modified_gmt":"2024-05-17T00:17:56","slug":"field-properties","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/field-properties\/","title":{"raw":"Field Properties","rendered":"Field Properties"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Differentiate among field properties<\/li>\r\n<\/ul>\r\n<\/div>\r\nRegardless of how you created your table, it is a good idea to examine and set field properties. While some properties are available in Datasheet view, some properties can only be set in <strong>Design view<\/strong>. To switch to Design view, right-click the table in the Navigation Pane and then click\u00a0Design View. To see a field's properties, click the field in the design grid. The properties are displayed below the design grid, under\u00a0<strong>Field Properties<\/strong>.\r\n\r\nTo see a description of each field property, click the property and read the description in the box next to the property list under\u00a0<strong>Field Properties<\/strong>. You can get more detailed information by clicking the Help button.\r\n\r\nField Properties sets boundaries on what\/how data is entered into table fields. There are five types of field properties:\r\n<ul>\r\n \t<li><strong>Field Size:<\/strong>\u00a0sets the maximum number of characters that can be entered into a text field.<\/li>\r\n \t<li><strong>Format:<\/strong> sets how the data is to be displayed in the table field.<\/li>\r\n \t<li><strong>Input Mask:<\/strong> sets the rules as to how data can be entered so that data is entered correctly.<\/li>\r\n \t<li><strong>Default Value:<\/strong> sets the default value that will appear in the table field each time a new record is entered.<\/li>\r\n \t<li><strong>Required:<\/strong> sets whether a value is required to be entered into this table field.<\/li>\r\n<\/ul>\r\n<div class=\"textbox key-takeaways\">\r\n<h3>Learn More<\/h3>\r\nFor more detailed information, 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-new-database-32a1ea1c-a155-43d6-aa00-f08cd1a8f01e#__toc269904807\">Field Properties Access Help<\/a>\r\n\r\n<\/div>\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Questions<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/229397ab-892f-4b1a-817e-903325aee34e\r\n\r\nhttps:\/\/assess.lumenlearning.com\/practice\/a7b17e8a-93ea-4091-8253-310fca3b4b16\r\n\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Differentiate among field properties<\/li>\n<\/ul>\n<\/div>\n<p>Regardless of how you created your table, it is a good idea to examine and set field properties. While some properties are available in Datasheet view, some properties can only be set in <strong>Design view<\/strong>. To switch to Design view, right-click the table in the Navigation Pane and then click\u00a0Design View. To see a field&#8217;s properties, click the field in the design grid. The properties are displayed below the design grid, under\u00a0<strong>Field Properties<\/strong>.<\/p>\n<p>To see a description of each field property, click the property and read the description in the box next to the property list under\u00a0<strong>Field Properties<\/strong>. You can get more detailed information by clicking the Help button.<\/p>\n<p>Field Properties sets boundaries on what\/how data is entered into table fields. There are five types of field properties:<\/p>\n<ul>\n<li><strong>Field Size:<\/strong>\u00a0sets the maximum number of characters that can be entered into a text field.<\/li>\n<li><strong>Format:<\/strong> sets how the data is to be displayed in the table field.<\/li>\n<li><strong>Input Mask:<\/strong> sets the rules as to how data can be entered so that data is entered correctly.<\/li>\n<li><strong>Default Value:<\/strong> sets the default value that will appear in the table field each time a new record is entered.<\/li>\n<li><strong>Required:<\/strong> sets whether a value is required to be entered into this table field.<\/li>\n<\/ul>\n<div class=\"textbox key-takeaways\">\n<h3>Learn More<\/h3>\n<p>For more detailed information, 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-new-database-32a1ea1c-a155-43d6-aa00-f08cd1a8f01e#__toc269904807\">Field Properties Access Help<\/a><\/p>\n<\/div>\n<div class=\"textbox tryit\">\n<h3>Practice Questions<\/h3>\n<p>\t<iframe id=\"assessment_practice_229397ab-892f-4b1a-817e-903325aee34e\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/229397ab-892f-4b1a-817e-903325aee34e?iframe_resize_id=assessment_practice_id_229397ab-892f-4b1a-817e-903325aee34e\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<p>\t<iframe id=\"assessment_practice_a7b17e8a-93ea-4091-8253-310fca3b4b16\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/a7b17e8a-93ea-4091-8253-310fca3b4b16?iframe_resize_id=assessment_practice_id_a7b17e8a-93ea-4091-8253-310fca3b4b16\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\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-3070\">\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 Properties. <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\":\"Field Properties\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"9fbc45d5-f87b-4a7c-958d-32bad6c539d5, f4de9e64-8898-43c7-ae15-8b0d30299528","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3070","chapter","type-chapter","status-publish","hentry"],"part":2773,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3070","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":13,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3070\/revisions"}],"predecessor-version":[{"id":5936,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3070\/revisions\/5936"}],"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\/3070\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=3070"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=3070"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=3070"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=3070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}