{"id":7806,"date":"2017-01-07T16:05:34","date_gmt":"2017-01-07T21:05:34","guid":{"rendered":"https:\/\/kaceli.com\/a\/?p=7806"},"modified":"2017-01-07T16:05:34","modified_gmt":"2017-01-07T21:05:34","slug":"microsoft-access-2016-modifying-tables-creating-forms-queries-and-reports","status":"publish","type":"post","link":"https:\/\/kaceli.com\/a\/microsoft-access-2016-modifying-tables-creating-forms-queries-and-reports\/","title":{"rendered":"Microsoft Access 2016: Modifying Tables, Creating Forms, Queries and Reports"},"content":{"rendered":"<p>This is part 4 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to modifying a table, creating forms, reports and queries. For more info. see also https:\/\/kaceli.com\/a<\/p>\n<p>In more detail, this session we will focus on:<br \/>\nLearn how to modify an existing table in Microsoft Access 2016<br \/>\nLearn how to create queries in Access 2016<br \/>\nLearn how to create yes\/no fields in a table<br \/>\nLearn how to insert design notes in the table design<br \/>\nLearn about primary keys in Access 2016<br \/>\nLearn how to create a form from a table in Access 2016<br \/>\nLearn how to use the Form Wizard in Acces 2016<br \/>\nLearn how to modify the Forms in Access Databases<br \/>\nLearn how to create queries in a database in Access 2016<br \/>\nLearn how to create reports in Access 2016<\/p>\n<p><iframe width=\"1140\" height=\"641\" src=\"https:\/\/www.youtube.com\/embed\/1r47z7YRYwM?feature=oembed\" frameborder=\"0\" allowfullscreen><\/iframe><\/p>\n<p>If you like the video, please &#8220;Like,&#8221; &#8220;Favorite,&#8221; and &#8220;Share&#8221; it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.<\/p>\n<p>Video URL: https:\/\/youtu.be\/1r47z7YRYwM<br \/>\nIt is suggested that you continue to part 5 after completing this module.<\/p>\n<p>Keep in touch and please spread the word by subscribing and using the share links below the video and commenting:<br \/>\nWebsite: https:\/\/kaceli.com\/a<br \/>\nYouTube Channel: http:\/\/youtube.com\/skaceli<\/p>\n<p>&nbsp;<\/p>\n[wysija_form id=&#8221;1&#8243;]\n","protected":false},"excerpt":{"rendered":"<p>This is part 4 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to modifying a table, creating forms, reports and queries. For more info. see also https:\/\/kaceli.com\/a In more detail, this session we will focus on: Learn how to modify an existing table in Microsoft Access 2016 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":7807,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[5,205,107],"tags":[206,208,209,212,211,210,207],"class_list":["post-7806","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-education-2","category-microsoft-access-2016","category-office-2016-tutorials","tag-access-databases","tag-access-queries","tag-access-reports","tag-creating-forms-in-access-2016","tag-creating-queries-in-access-2016","tag-creating-reports-in-access-2016","tag-tutorial-on-access-2016"],"spectra_custom_meta":{"_vc_post_settings":["a:1:{s:10:\"vc_grid_id\";a:0:{}}"],"_edit_lock":["1483823041:1"],"_edit_last":["1"],"_oembed_41509dc28b02d3caa018956e88415a87":["<iframe width=\"1140\" height=\"641\" src=\"https:\/\/www.youtube.com\/embed\/1r47z7YRYwM?feature=oembed\" frameborder=\"0\" allowfullscreen><\/iframe>"],"_oembed_time_41509dc28b02d3caa018956e88415a87":["1483822976"],"_thumbnail_id":["7807"],"textfalse":[""],"_layout":["right"],"_padding":["false"],"page_preloader":["false"],"_introduce_align":["left"],"_disable_breadcrumb":["true"],"_sidebar":["sidebar-21"],"_single_blog_style":["default"],"_single_post_type":["image"],"_classic_orientation":["landscape"],"_single_video_site":["youtube"],"_disable_featured_image":["true"],"_disable_meta":["true"],"_disable_tags":["true"],"_disable_related_posts":["true"],"_disable_about_author":["false"],"_show_author_email":["false"],"_disable_comments":["true"],"_enable_local_backgrounds":["false"],"theme_header_style":["1"],"theme_header_align":["left"],"theme_toolbar_toggle":["true"],"_transparent_header":["false"],"_trans_header_remove_bg":["true"],"_transparent_header_skin":["light"],"_sticky_header_offset":["header"],"background_selector_orientation":["full_width_layout"],"boxed_layout_shadow_size":["0"],"boxed_layout_shadow_intensity":["0"],"body_color_gradient":["single"],"body_color_gradient_style":["linear"],"body_color_gradient_angle":["vertical"],"body_size":["false"],"body_source":["no-image"],"body_parallax":["false"],"page_color_gradient":["single"],"page_color_gradient_style":["linear"],"page_color_gradient_angle":["vertical"],"page_size":["false"],"page_source":["no-image"],"page_parallax":["false"],"header_color_gradient":["single"],"header_color_gradient_style":["linear"],"header_color_gradient_angle":["vertical"],"header_size":["false"],"header_source":["no-image"],"header_parallax":["false"],"banner_color_gradient":["single"],"banner_color_gradient_style":["linear"],"banner_color_gradient_angle":["vertical"],"banner_size":["false"],"banner_source":["no-image"],"banner_parallax":["false"],"footer_color_gradient":["single"],"footer_color_gradient_style":["linear"],"footer_color_gradient_angle":["vertical"],"footer_size":["false"],"footer_source":["no-image"],"footer_parallax":["false"],"_mk_post_love":["0"],"_theme_options_build":["6a3af18ea5f53"],"views":["4718"],"_dynamic_styles":["Tjs="],"_yoast_wpseo_title":["Microsoft access tutorial"],"_eb_reusable_block_ids":["a:0:{}"],"_eael_post_view_count":["1093"],"rank_math_title":["Microsoft access tutorial"],"rank_math_news_sitemap_robots":["index"],"rank_math_robots":["a:1:{i:0;s:5:\"index\";}"],"rank_math_analytic_object_id":["178"],"rank_math_internal_links_processed":["1"],"_uag_page_assets":["a:9:{s:3:\"css\";s:0:\"\";s:2:\"js\";s:0:\"\";s:18:\"current_block_list\";a:0:{}s:8:\"uag_flag\";b:0;s:11:\"uag_version\";s:10:\"1782610208\";s:6:\"gfonts\";a:0:{}s:10:\"gfonts_url\";s:0:\"\";s:12:\"gfonts_files\";a:0:{}s:14:\"uag_faq_layout\";b:0;}"],"_elementor_page_assets":["a:0:{}"]},"uagb_featured_image_src":{"full":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016.png",1090,610,false],"thumbnail":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-150x150.png",150,150,true],"medium":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-300x168.png",300,168,true],"medium_large":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-768x430.png",768,430,true],"large":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-1024x573.png",1024,573,true],"1536x1536":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-1536x1536.png",1536,1536,true],"2048x2048":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-2048x2048.png",2048,2048,true],"image-size-150x150":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-150x150.png",150,150,true],"image-size-550x550":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-550x550.png",550,550,true],"image-size-550x550-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-1100x1100.png",1100,1100,true],"photo-album-thumbnail-small":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-150x100.png",150,100,true],"photo-album-thumbnail-square":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-500x500.png",500,500,true],"employees-large":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-500x500.png",500,500,true],"employees-small":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-225x225.png",225,225,true],"blog-magazine-thumbnail":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-200x200.png",200,200,true],"blog-magazine-thumbnail-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-400x400.png",400,400,true],"woocommerce-recent-carousel":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-330x260.png",330,260,true],"blog-carousel":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-245x180.png",245,180,true],"blog-carousel-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-490x360.png",490,360,true],"blog-showcase":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-260x180.png",260,180,true],"blog-showcase-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-520x360.png",520,360,true],"portfolio-x_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-300x300.png",300,300,true],"portfolio-two_x_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-600x300.png",600,300,true],"portfolio-four_x_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-1200x300.png",1200,300,true],"portfolio-x_two_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-300x620.png",300,620,true],"portfolio-two_x_two_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-600x600.png",600,600,true],"portfolio-three_x_two_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-900x600.png",900,600,true],"portfolio-three_x_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-900x300.png",900,300,true],"portfolio-four_x_two_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-1200x600.png",1200,600,true],"portfolio-x_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-600x600.png",600,600,true],"portfolio-two_x_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-1200x600.png",1200,600,true],"portfolio-four_x_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-2400x600.png",2400,600,true],"portfolio-x_two_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-600x1240.png",600,1240,true],"portfolio-two_x_two_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-1200x1200.png",1200,1200,true],"portfolio-three_x_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-1800x600.png",1800,600,true],"portfolio-three_x_two_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-1800x1200.png",1800,1200,true],"portfolio-four_x_two_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-2400x1200.png",2400,1200,true],"portfolio-four_x_x-@mobile":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-736x184.png",736,184,true],"portfolio-three_x_x-@mobile":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-736x245.png",736,245,true],"portfolio-three_x_two_x-@mobile":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-736x490.png",736,490,true],"portfolio-four_x_two_x-@mobile":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-736x368.png",736,368,true],"landscape-desktop":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-1920x1280.png",1920,1280,true],"landscape-tablet":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-1024x768.png",1024,768,true],"landscape-mobile":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-736x414.png",736,414,true],"portrait-desktop":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-1280x1920.png",1280,1920,true],"portrait-tablet":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-768x1024.png",768,1024,true],"portrait-mobile":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2017\/01\/1.3-modifying-tables-creating-basic-form-query-and-reports-from-a-table-in-access-2016-414x736.png",414,736,true]},"uagb_author_info":{"display_name":"Sali","author_link":"https:\/\/kaceli.com\/a\/author\/skaceligmail-com\/"},"uagb_comment_info":0,"uagb_excerpt":"This is part 4 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to modifying a table, creating forms, reports and queries. For more info. see also https:\/\/kaceli.com\/a In more detail, this session we will focus on: Learn how to modify an existing table in Microsoft Access 2016&hellip;","_links":{"self":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts\/7806","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/comments?post=7806"}],"version-history":[{"count":0,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts\/7806\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/media\/7807"}],"wp:attachment":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/media?parent=7806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/categories?post=7806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/tags?post=7806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}