Požadované znalosti Pro kurz je doporučená znalost prostředí MS Excel, MS Word a MS Access, a to na úrovni pokračovacích kurzů.Popis kurzu : Prostředí ladícího programu VBA Základy tvorby modulů Podprogramy a procedury Deklarace a naplnění proměnných Vlastní funkce Objekty MS Access (DAO) Dialogy a formuláře Ochrana dat – víceuživatelský přístup Podrobná osnova kurzu Osnova kurzu ...

• Srpen 2024 online   ... VBA MS Access...



• Červen 2024 online   ... VBA MS Access...



• Červenec 2024 online   ... VBA MS Access...

Požadované znalosti Předpokladem jsou rutinní znalosti programu Excel (v rozsahu určeném základním kurzem) a praxe s tvorbou tabulek a matematických výrazů.Popis kurzu : Prostředí editoru VBA Deklarace a naplnění proměnných Aritmetické, textové a logické operátory Vlastnosti a metody buněk a oblastí Objekty, kontejnery a kolekce Uživatelem definované funkce (UDF) Tvorba a pokročilé ladění a optimalizace kódu VBA Formuláře prvky a ovládací prvky ActiveX Tvorba a správa uživatelského formuláře (UserForm) Události listu a události sešitu Tvorba vlastního doplňku Podrobná osnova kurzu Osnova kurzu osnova kurzu Visual Basic for applications Microsoft Excel: 1. První den * 1.1. Nahrávání, spouštění a umístění maker* 1.2. Prostředí editoru VBA* 1.3. Projekt, modul, procedura* 1.4. Notace zápisu kódu VBA* 1.5. Optimalizace kódu nahraného makrem* 1.6. Deklarace a naplnění proměnných* 1.7. Aritmetické, textové a logické operátory* 1.8. Vlastnosti a metody buněk a oblastí * 2.1. Objektový model Excelu* 2.2. Objekty, kontejnery a kolekce 2. Druhý den * 2.3. Tvorba vlastního kódu VBA* 2.4. Uživatelem definované funkce (UDF)* 2.5. Cykly k opakovanému provádění kódu* 2.6. Cykly pro členy kolekce* 2.7. Pokročilé ladění a optimalizace kódu* 2.8. Dialogová okna * 3.1. Ovládací prvky formuláře a prvky ActiveX* 3.2. Vytvoření uživatelského formuláře (UserForm)* 3.3. Ovládací prvky uživatelského formuláře (Toolbox)* 3.4. Spuštění uživatelského formuláře z listu* 3.5. Uchování dat uživatelského formuláře* 3.6. Přenesení dat z formuláře na list* 3.7. Události listu a sešitu* 3.8. Tvorba doplňku ...

• Září 2024 online   ... VBA MS Excel...



• Červen 2024 online   ... VBA MS Excel...



• Srpen 2024 online   ... VBA MS Excel...



• Červenec 2024 online   ... VBA MS Excel...

This one-and-a-half-day course, application Setup in Microsoft Dynamics NAV 2009, provides students with the tools to implement and maintain cross-application setup data after the system components are installed. The focus is on the application-oriented work involved in setting up and maintaining company-wide rules, data, and users. * Module 1: Set Up a Company with the RIM Toolkit This module provides individuals in charge of application setup, such as implementation consultants or customer staff, with the tools to set up a new company using the RIM toolkit, in addition to creating new records based on RIM data templates. Lessons Manual Setup vs. RIM, RIM Toolkit Overview, Using the RIM Toolkit, Demonstration: Create a Setup Questionnaire, Demonstration: Initialize a New Company Based on the Setup Questionnaire, Use Data Templates, Migrate Data Module 2: Set Up Number Series This module explains the purpose of number series and how to manually set them up, including how to define number series relationships to use multiple number series on a single number series. Lessons Number Series Module 3: Set Up Journal Templates and Batches This module provides an overview of journal templates and journal batches to explain their purpose and composition. This module also explains how to set up a journal template and demonstrates how to create two journal batches based on one journal template. Lessons Journal Templates, Batches, and Lines, Create Journal Templates and Batches Module 4: Set Up Posting Groups In this module, the three types of posting groups are described and set up, and then the functions of a posting group structure are demonstrated using a posted sales invoice. Lessons Specific Posting Groups, General Posting Groups, General Posting Setup, VAT Posting Groups, VAT Posting Setup, Additional VAT Posting Setup, Procedure: Determine Posting Groups, Demonstration: Post and Review a Sales Transaction Module 5: Set Up Dimensions In this module, all aspects of dimensions are defined and set up, including Dimension Values, Dimension Combinations, Default Dimensions, and Default Dimension Priority. Lessons Dimensions and Dimensions Values, Dimension Types, Dimension Combinations, Default Dimensions, Default Dimension Priority, Demonstration: Work with Default Dimension Priorities Module 6: Manage User Rights and Profiles This module explains the concepts of logins, roles, and permissions, which are critical to managing user rights in Microsoft Dynamics NAV. The module demonstrates central administrator tasks and offers recommendations about how to most effectively secure data in the system with logins for both the RoleTailored client and Classic client. This module also explains how to set up and assign users to profiles for use in the RoleTailored client. Lessons Authentication, Security Setup Overview, Security Sectup for RoleTailored Client, User Profile Setup for the RoleTaloired Client, Demonstration: Create a New Role, Demonstration: Apply SQL server Security Filters, Security Setup for Classic Client, User-Specific Setup, Active Directory Security Module 7: Set Up and Manage Document Approvals This module is an introduction to process of setting up and managing the document approval system. It covers the general ...

Lea> how to create, test, and maintain Java EE-compliant applications from start to finish using the Eclipse-based Red Hat® JBoss Developer Studio. Comprehensive lectures and extensive use-case, hands-on labs introduce you to enterprise application development using Red Hat JBoss Enterprise application Platform 6, Contexts and Dependency I, Arquillian, JBoss Hibernate, RESTEasy, HornetQ, and other related technologies to create a fully functional enterprise Java applicat ...

This hands-on, lab-based course challenges students by providing a deep dive into Java EE APIs and emerging JBoss development technologies. Students will use JBoss EAP, Red Hat JBoss Developer Studio, and Maven to build and deploy scalable applications that perform well and use advanced features with advanced development techniques. Newer technologies such as Arquillian for testing, Errai for Google Web Toolkit (GWT) web development, and RESTeasy for web services are cove ...

Developing Rules applications with Red Hat JBoss BRMS (JB463) teaches rule developers and Java™ enterprise application developers how to create, test, debug, and control business rules, how to generate rules packages, and how the Red Hat JBoss BRMS [business rules management system] runtime environment executes rules. Students will use Red Hat JBoss Developer Studio 7 and Red Hat JBoss BRMS 6 to perform detailed, hands-on exercises that enable them to create and manage bu ...

An introduction to containerization concepts Deploying Containerized applications Technical Overview (DO080) is a series of on-demand, online videos that introduces you to Linux® containers and container orchestration technology using Docker, Kubernetes, and Red Hat® OpenShift Container Platform. This course is based on Red Hat OpenShift Container Platform 4.1. In this series of short lectures and in-depth demonstrations, you will lea> about the concepts of containerization—and see it in actio ...

Kurz APEX Oracle application Express seznámí studenty se základy APEX Oracle application Express, jeho komponentami a průvodci pro vytváření aplikací a databázových objektů. Studenti se naučí vytvářet formuláře a sestavy a používat různé prvky a sdílené komponenty APEX stejně jako Session Management nebo ladění APEX aplikací. Rovněž se naučí vytvářet instalační balíčky a naučí se nastavit zabezpečení pro přístup a ochranu Session. ...

Containerizing Software applications (DO276) introduces you to deploying applications in containers using Docker and Kubernetes. Lea> how to design containers for the deployment of an existing application across multiple containers, build and test those containers using Docker, and deploy the application in a Kubernetes cluster to achieve high availability and load balancing. Through hands-on labs students will take a monolithic application and break it down into its di ...

The Red Hat JBoss Enterprise application Development I with exam (JB226) bundle is a combination of the following: Red Hat JBoss Enterprise application Development I (JB225) course Red Hat JBoss Certified Developer exam (EX225) Below you will find a description of each component of the bundle. ...

Red Hat OpenShift Development I: Containerizing applications (DO288) enhances understanding of containers as a key technology for configuring and deploying applications and microservices. As the second course in the OpenShift development track, this offering will teach you how to design, build, and deploy containerized software applications to an OpenShift cluster. Whether you’re writing container-native applications or migrating existing brownfield applications, you’ll ...