{"id":3077,"date":"2014-06-22T10:42:30","date_gmt":"2014-06-22T08:42:30","guid":{"rendered":"https:\/\/www.itlektor.cz\/?page_id=3077"},"modified":"2020-09-21T17:20:12","modified_gmt":"2020-09-21T15:20:12","slug":"access","status":"publish","type":"page","link":"https:\/\/www.itlektor.cz\/en\/access\/","title":{"rendered":"Microsoft Access"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"3077\" class=\"elementor elementor-3077\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-717d9ca elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"717d9ca\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-narrow\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2328ed4\" data-id=\"2328ed4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-616dbe6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"616dbe6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-1227c8a\" data-id=\"1227c8a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a03573a elementor-widget elementor-widget-text-editor\" data-id=\"a03573a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p>Microsoft Access provides the creation and management of databases at a much higher level than what enables eg. Excel. One of the advantages is the unlimited amount of records\u00a0in the tables. Use the queries obtained from the tables the information we need, and allow them aggregate results. Thanks to the forms you can create your own user interface so users have easier access to data. To print the data we use\u00a0reports. Why buy expensive programs, when you can have all the records in Access? Let ITLektor\u00a0show you the mysteries of this powerful application.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-4ea703f\" data-id=\"4ea703f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7b807b2 elementor-widget elementor-widget-image\" data-id=\"7b807b2\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"250\" height=\"251\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/06\/access_welcome_small-1.png\" class=\"attachment-large size-large wp-image-5764\" alt=\"\" srcset=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/06\/access_welcome_small-1.png 250w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/06\/access_welcome_small-1-130x130.png 130w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/06\/access_welcome_small-1-24x24.png 24w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/06\/access_welcome_small-1-36x36.png 36w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/06\/access_welcome_small-1-48x48.png 48w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/06\/access_welcome_small-1-150x150.png 150w\" sizes=\"(max-width: 250px) 100vw, 250px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-93d0a74 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"93d0a74\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-narrow\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-inner-column elementor-element elementor-element-5a235f6\" data-id=\"5a235f6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9b7e34a elementor-align-center elementor-widget elementor-widget-button\" data-id=\"9b7e34a\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a href=\"https:\/\/www.itlektor.cz\/microsoft-access\/skoleni-access-pro-zacatecniky-a-pokrocile\/\" class=\"elementor-button-link elementor-button elementor-size-sm\" role=\"button\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t<span class=\"elementor-button-icon elementor-align-icon-left\">\n\t\t\t\t\t\t\t\t\t<i class=\"fa fa-graduation-cap\" aria-hidden=\"true\"><\/i>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Browse courses<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-inner-column elementor-element elementor-element-ad6180d\" data-id=\"ad6180d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-539aaac elementor-align-center elementor-widget elementor-widget-button\" data-id=\"539aaac\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a href=\"https:\/\/www.itlektor.cz\/kategorie\/microsoft-access\/\" class=\"elementor-button-link elementor-button elementor-size-sm\" role=\"button\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t<span class=\"elementor-button-icon elementor-align-icon-left\">\n\t\t\t\t\t\t\t\t\t<i class=\"fa fa-list-ul\" aria-hidden=\"true\"><\/i>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"elementor-button-text\">All posts<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-inner-column elementor-element elementor-element-a92910a\" data-id=\"a92910a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b89de08 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"b89de08\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a href=\"https:\/\/www.itlektor.cz\/kategorie\/videonavody\/\" class=\"elementor-button-link elementor-button elementor-size-sm\" role=\"button\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t<span class=\"elementor-button-icon elementor-align-icon-left\">\n\t\t\t\t\t\t\t\t\t<i class=\"fa fa-youtube-play\" aria-hidden=\"true\"><\/i>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Videos<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-2464382 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"2464382\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-06beee7 elementor-tabs-view-horizontal elementor-widget elementor-widget-tabs\" data-id=\"06beee7\" data-element_type=\"widget\" data-widget_type=\"tabs.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-tabs\">\n\t\t\t<div class=\"elementor-tabs-wrapper\" role=\"tablist\" >\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-7071\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-7071\" aria-expanded=\"false\">Training<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-7072\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-7072\" aria-expanded=\"false\">Online kurzy Accessu<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-7073\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-7073\" aria-expanded=\"false\">Need help?<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t<div class=\"elementor-tabs-content-wrapper\" role=\"tablist\" aria-orientation=\"vertical\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-7071\" aria-expanded=\"false\">Training<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-7071\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-7071\" tabindex=\"0\" hidden=\"false\"><p>Many tips and tricks, which I met in practice, giving to readers free of charge in my\u00a0useful videos. See with your own eyes how to deal with situations that are perhaps your\u00a0daily basis. To view a list of all video tutorials just go to the\u00a0<a href=\"https:\/\/www.itlektor.cz\/en\/videotutorials\/\">video category<\/a>.<\/p><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-7072\" aria-expanded=\"false\">Online kurzy Accessu<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-7072\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"2\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-7072\" tabindex=\"0\" hidden=\"hidden\"><p>Nem\u00e1te \u010das chodit na drah\u00e1 \u0161kolen\u00ed? Stejnou osnovu jako b\u011b\u017en\u00e1 \u0161kolen\u00ed maj\u00ed i&nbsp;<strong>online kurzy<\/strong>&nbsp;(E-learning) v podob\u011b video lekc\u00ed s podrobn\u00fdm n\u00e1vodem, cvi\u010dn\u00fdmi soubory ke sta\u017een\u00ed, certifik\u00e1tem a do\u017eivotn\u00edm p\u0159\u00edstupem. Pod\u00edvejte se na&nbsp;<a href=\"https:\/\/www.umimexcel.cz\/kurzy-kategorie\/access\/\" target=\"_blank\" rel=\"noopener\"><b><u>Online kurzy Accessu<\/u><\/b><\/a>.<\/p><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-7073\" aria-expanded=\"false\">Need help?<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-7073\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"3\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-7073\" tabindex=\"0\" hidden=\"hidden\"><p>If you find that you are missing some knowledge, there is no easier way than to be trained. If you choose the path of \u201cself-learning\u201d, some procedures you will learn can take more time\u00a0or perhaps not quite correct. You can always use the articles on this site for inspiration or consult the\u00a0<a href=\"https:\/\/www.itlektor.cz\/en\/contact\/\">ITLektor<\/a>.<\/p><\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a2d273c elementor-widget elementor-widget-heading\" data-id=\"a2d273c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Newest Access posts<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4adc0cd elementor-widget elementor-widget-shortcode\" data-id=\"4adc0cd\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\"><ul class=\"lcp_catlist\" id=\"lcp_instance_0\"><li ><a href=\"https:\/\/www.itlektor.cz\/en\/online-kurz-access-tvorime-databazi\/\" title=\"(\u010ce\u0161tina) Online kurz Access &#8211; Tvo\u0159\u00edme datab\u00e1zi\">(\u010ce\u0161tina) Online kurz Access &#8211; Tvo\u0159\u00edme datab\u00e1zi<\/a>  <a href=\"https:\/\/www.itlektor.cz\/en\/online-kurz-access-tvorime-databazi\/\" title=\"(\u010ce\u0161tina) Online kurz Access - Tvo\u0159\u00edme datab\u00e1zi\"><img decoding=\"async\" width=\"130\" height=\"130\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2019\/02\/kurz_megakurz_acess-130x130.jpg\" class=\"lcp_thumbnail wp-post-image\" alt=\"(\u010ce\u0161tina) Online kurz Access - Tvo\u0159\u00edme datab\u00e1zi\" srcset=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2019\/02\/kurz_megakurz_acess-130x130.jpg 130w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2019\/02\/kurz_megakurz_acess-150x150.jpg 150w\" sizes=\"(max-width: 130px) 100vw, 130px\" title=\"\"><\/a>Sorry, this entry is only available in Czech.\n<\/li><li ><a href=\"https:\/\/www.itlektor.cz\/en\/vytvoreni-sestavy\/\" title=\"Setting new report\">Setting new report<\/a>  <a href=\"https:\/\/www.itlektor.cz\/en\/vytvoreni-sestavy\/\" title=\"Setting new report\"><img decoding=\"async\" width=\"130\" height=\"130\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/06\/sestava07-130x130.jpg\" class=\"lcp_thumbnail wp-post-image\" alt=\"Setting new report\" srcset=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/06\/sestava07-130x130.jpg 130w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/06\/sestava07-150x150.jpg 150w\" sizes=\"(max-width: 130px) 100vw, 130px\" title=\"\"><\/a>Access Reports\u00a0are designed for printouts. The proposed structure of the graphical elements is filled with data from tables or queries, and printed on paper like Word documents. The difference between the reports and forms is mainly in the fact that ...<\/li><li ><a href=\"https:\/\/www.itlektor.cz\/en\/vytvoreni-formulare\/\" title=\"Setting new form\">Setting new form<\/a>  <a href=\"https:\/\/www.itlektor.cz\/en\/vytvoreni-formulare\/\" title=\"Setting new form\"><img decoding=\"async\" width=\"130\" height=\"130\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/05\/form04-130x130.jpg\" class=\"lcp_thumbnail wp-post-image\" alt=\"Setting new form\" srcset=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/05\/form04-130x130.jpg 130w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/05\/form04-150x150.jpg 150w\" sizes=\"(max-width: 130px) 100vw, 130px\" title=\"\"><\/a>Forms of Access serve as a user interface, which allows us to easily inspect the data, modify it, add entries etc. Additionally, it can include\u00a0graphic objects &#8211; pictures, charts, controls, and even conditional formatting. When properly adjusted, related\u00a0forms in Access ...<\/li><li ><a href=\"https:\/\/www.itlektor.cz\/en\/vytvoreni-dotazu\/\" title=\"Setting new query\">Setting new query<\/a>  <a href=\"https:\/\/www.itlektor.cz\/en\/vytvoreni-dotazu\/\" title=\"Setting new query\"><img decoding=\"async\" width=\"130\" height=\"130\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/05\/qry1-130x130.png\" class=\"lcp_thumbnail wp-post-image\" alt=\"Setting new query\" srcset=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/05\/qry1-130x130.png 130w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/05\/qry1-150x150.png 150w\" sizes=\"(max-width: 130px) 100vw, 130px\" title=\"\"><\/a>To get information from tables are designed Queries. This object in Access gets the data from tables or other queries like filters in Excel, but at a much more advanced level. Queries can not only filter but also to count, ...<\/li><li ><a href=\"https:\/\/www.itlektor.cz\/en\/vytvoreni-nove-tabulky\/\" title=\"Setting new table\">Setting new table<\/a>  <a href=\"https:\/\/www.itlektor.cz\/en\/vytvoreni-nove-tabulky\/\" title=\"Setting new table\"><img decoding=\"async\" width=\"130\" height=\"130\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/05\/0-130x130.png\" class=\"lcp_thumbnail wp-post-image\" alt=\"Setting new table\" srcset=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/05\/0-130x130.png 130w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/05\/0-150x150.png 150w\" sizes=\"(max-width: 130px) 100vw, 130px\" title=\"\"><\/a>In the created database it is good to start with tables because without them the database does not make sense. In previous article\u00a0you could read how to set up a new database. Now we look at the creation of tables, ...<\/li><li ><a href=\"https:\/\/www.itlektor.cz\/en\/zalozeni-nove-databaze\/\" title=\"Setting new database\">Setting new database<\/a>  <a href=\"https:\/\/www.itlektor.cz\/en\/zalozeni-nove-databaze\/\" title=\"Setting new database\"><img decoding=\"async\" width=\"130\" height=\"130\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/05\/db1-130x130.png\" class=\"lcp_thumbnail wp-post-image\" alt=\"Setting new database\" srcset=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/05\/db1-130x130.png 130w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/05\/db1-150x150.png 150w\" sizes=\"(max-width: 130px) 100vw, 130px\" title=\"\"><\/a>Microsoft Access is used to create and manage databases. Generally, it is a higher level of Excel because Access does not have limitations on the number of records in tables, and links between the tables is created more efficiently than ...<\/li><li ><a href=\"https:\/\/www.itlektor.cz\/en\/skoleni-access-pro-zacatecniky-a-pokrocile\/\" title=\"Training Access\">Training Access<\/a>  <a href=\"https:\/\/www.itlektor.cz\/en\/skoleni-access-pro-zacatecniky-a-pokrocile\/\" title=\"Training Access\"><img decoding=\"async\" width=\"86\" height=\"95\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2012\/04\/access.jpg\" class=\"lcp_thumbnail wp-post-image\" alt=\"Training Access\" title=\"\"><\/a>\nTraining description\nOn this training, students will learn techniques for practical use of Microsoft Access and control of database objects, including theoretical introduction to the world of databases. A list of topics is provided below. Topics are presented by the trainer, ...<\/li><\/ul><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Microsoft Access provides the creation and management of databases at a much higher level than what enables eg. Excel. One of the advantages is the unlimited amount of records\u00a0in the tables. Use the queries obtained from the tables the information we need, and allow them aggregate results. Thanks to the forms you can create your [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"sidebar-page.php","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/pages\/3077"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=3077"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/pages\/3077\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=3077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}