{"id":8059,"date":"2017-08-18T21:06:02","date_gmt":"2017-08-19T02:06:02","guid":{"rendered":"https:\/\/kaceli.com\/a\/?p=8059"},"modified":"2017-08-18T21:06:02","modified_gmt":"2017-08-19T02:06:02","slug":"access-2016-tutorial-using-queries-in-an-access-database-comprehensive","status":"publish","type":"post","link":"https:\/\/kaceli.com\/a\/access-2016-tutorial-using-queries-in-an-access-database-comprehensive\/","title":{"rendered":"Access 2016 Tutorial: Using Queries in an Access Database (Comprehensive)"},"content":{"rendered":"<p>This is part 11 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to creating and customizing queries in Access. Learn more at http:\/\/learn.kaceli.com<\/p>\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=iG_HzKK8VoE\">https:\/\/www.youtube.com\/watch?v=iG_HzKK8VoE<\/a><\/p>\n<p>In more detail, this session we will focus on:<br \/>\n&#8211; Queries are a key concept for anyone whether in business or as a student when using any type of database. So learn:<br \/>\n-How to create a query from multiple tables in Access Database using both the Query Wizard and the Query Design tools in Access 2016.<br \/>\n&#8211; Learn how to customize a query by adding new fields, adding criteria, sorting options etc.<\/p>\n<p>&nbsp;<\/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\/iG_HzKK8VoE. The full tutorial is coming soon. Stay tuned. Access 2016 Part I is here if you want to start from the beginning: https:\/\/youtu.be\/1IA4SeajZRw<\/p>\n<p>Link to the working files for the tutorial: https:\/\/kaceli.com\/a\/access2016\/<\/p>\n<p>It is suggested that you continue to part 7 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<br \/>\nIf you want to take get a deeper understanding of Microsoft Access, take a look at http:\/\/learn.kaceli.com<\/p>\n<p>Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is part 11 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to creating and customizing queries in Access. Learn more at http:\/\/learn.kaceli.com https:\/\/www.youtube.com\/watch?v=iG_HzKK8VoE In more detail, this session we will focus on: &#8211; Queries are a key concept for anyone whether in business or as a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[6,205,107],"tags":[],"class_list":["post-8059","post","type-post","status-publish","format-standard","hentry","category-malesuada","category-microsoft-access-2016","category-office-2016-tutorials"],"spectra_custom_meta":{"_vc_post_settings":["a:1:{s:10:\"vc_grid_id\";a:0:{}}"],"_edit_lock":["1503108242:1"],"_edit_last":["1"],"_oembed_458d07b0ed6e2e45a091669f7522eae3":["{{unknown}}"],"views":["2651"],"hefo_before":["0"],"hefo_after":["0"],"episode_type":["audio"],"audio_file":[""],"duration":[""],"filesize":[""],"date_recorded":[""],"explicit":[""],"block":[""],"textfalse":[""],"_layout":["right"],"_padding":["false"],"page_preloader":["false"],"_introduce_align":["left"],"_disable_breadcrumb":["true"],"_sidebar":["sidebar-18"],"_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":["true"],"_show_author_email":["true"],"_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"],"_dynamic_styles":["Tjs="],"_yoast_wpseo_title":["Tutorial"],"_eb_reusable_block_ids":["a:0:{}"],"_eael_post_view_count":["618"],"rank_math_title":["Tutorial"],"rank_math_news_sitemap_robots":["index"],"rank_math_robots":["a:1:{i:0;s:5:\"index\";}"],"rank_math_analytic_object_id":["134"],"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":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"image-size-150x150":false,"image-size-550x550":false,"image-size-550x550-@2x":false,"photo-album-thumbnail-small":false,"photo-album-thumbnail-square":false,"employees-large":false,"employees-small":false,"blog-magazine-thumbnail":false,"blog-magazine-thumbnail-@2x":false,"woocommerce-recent-carousel":false,"blog-carousel":false,"blog-carousel-@2x":false,"blog-showcase":false,"blog-showcase-@2x":false,"portfolio-x_x":false,"portfolio-two_x_x":false,"portfolio-four_x_x":false,"portfolio-x_two_x":false,"portfolio-two_x_two_x":false,"portfolio-three_x_two_x":false,"portfolio-three_x_x":false,"portfolio-four_x_two_x":false,"portfolio-x_x-@2x":false,"portfolio-two_x_x-@2x":false,"portfolio-four_x_x-@2x":false,"portfolio-x_two_x-@2x":false,"portfolio-two_x_two_x-@2x":false,"portfolio-three_x_x-@2x":false,"portfolio-three_x_two_x-@2x":false,"portfolio-four_x_two_x-@2x":false,"portfolio-four_x_x-@mobile":false,"portfolio-three_x_x-@mobile":false,"portfolio-three_x_two_x-@mobile":false,"portfolio-four_x_two_x-@mobile":false,"landscape-desktop":false,"landscape-tablet":false,"landscape-mobile":false,"portrait-desktop":false,"portrait-tablet":false,"portrait-mobile":false},"uagb_author_info":{"display_name":"Sali","author_link":"https:\/\/kaceli.com\/a\/author\/skaceligmail-com\/"},"uagb_comment_info":0,"uagb_excerpt":"This is part 11 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to creating and customizing queries in Access. Learn more at http:\/\/learn.kaceli.com https:\/\/www.youtube.com\/watch?v=iG_HzKK8VoE In more detail, this session we will focus on: &#8211; Queries are a key concept for anyone whether in business or as a&hellip;","_links":{"self":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts\/8059","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=8059"}],"version-history":[{"count":0,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts\/8059\/revisions"}],"wp:attachment":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/media?parent=8059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/categories?post=8059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/tags?post=8059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}