Office Information Technology

{"desktop":{"unique_in":[],"is_horizontal_lv1":1,"is_horizontal_lv2":0,"is_horizontal_lv3":0,"is_horizontal_lv4":0,"column_lv1":1,"column_lv2":1,"column_lv3":1,"column_lv4":1,"position_lv2":"bottom","position_lv3":"right","position_lv4":"right","turn_on_arrow_1":0,"open_hover":1,"icon_open_horizontal":"fal fa-angle-right","icon_close_horizontal":"fal fa-angle-left","icon_open":"fal fa-angle-down","icon_close":"fal fa-angle-up","device_off_open_hover":"1024px","device_allow_event_toggle":"1024px","open_to_level":0,"style_lv2_box":{"width":"250px"},"style_lv3_box":{"width":"250px"},"style_lv4_box":{"width":"250px"},"style_custom":[]},"1024px":{"style_lv2_box":{"width":"100%"},"style_lv3_box":{"width":"100%"},"style_lv4_box":{"width":"100%"},"style_custom":[null,null,null,{"enable":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"enable":0}],"is_horizontal_lv1":0,"position_lv2":"","position_lv3":"","position_lv4":""},"768px":{"style_lv2_box":{"width":"100%"},"style_lv3_box":{"width":"100%"},"style_lv4_box":{"width":"100%"},"style_custom":[null,null,null,{"enable":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"enable":0}]},"480px":{"style_lv2_box":{"width":"100%"},"style_lv3_box":{"width":"100%"},"style_lv4_box":{"width":"100%"},"style_custom":[null,null,null,{"enable":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"enable":0}]},"375px":{"style_lv2_box":{"width":"100%"},"style_lv3_box":{"width":"100%"},"style_lv4_box":{"width":"100%"},"style_custom":[null,null,null,{"enable":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"enable":0}]},"320px":{"style_lv2_box":{"width":"100%"},"style_lv3_box":{"width":"100%"},"style_lv4_box":{"width":"100%"},"style_custom":[null,null,null,{"enable":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"enable":0}]}}

{"company_logo":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/files\/images%20%287%29.jpeg","company_name":"PHAN TUẤN YÊN","company_email":"yenp19122004@gmail.com","company_phone":"0374637685","company_address":"","company_fax":"","date_now":1782456210,"company_tags":[],"search_keyword":null,"facebook_comment":"https:\/\/www.ptyen.id.vn\/tin-hoc-van-phong","breadscrumb":[{"url":"https:\/\/www.ptyen.id.vn","name":"Trang chủ","icon":"","active":false},{"url":"https:\/\/www.ptyen.id.vn\/san-pham","name":"Các khóa học","icon":"","active":false},{"url":"javascript:void(0)","name":"Office Information Technology","icon":"","active":true}],"list_products_tmp":[],"list_section":[{"id":685770,"name":"Header","seo_name":"#w30s-section-685770","url":"#w30s-section-685770"},{"id":685772,"name":"Menu","seo_name":"#w30s-section-685772","url":"#w30s-section-685772"},{"id":685775,"name":"Menu fixed","seo_name":"#w30s-section-685775","url":"#w30s-section-685775"},{"id":685774,"name":"Banner detail","seo_name":"#w30s-section-685774","url":"#w30s-section-685774"},{"id":685793,"name":"Content","seo_name":"#w30s-section-685793","url":"#w30s-section-685793"},{"id":685773,"name":"Footer","seo_name":"#w30s-section-685773","url":"#w30s-section-685773"}],"category_desc":"Tin học văn ph&ograve;ng<\/strong> l&agrave; một tập hợp c&aacute;c kỹ năng v&agrave; kiến thức li&ecirc;n quan đến việc sử dụng c&aacute;c phần mềm m&aacute;y t&iacute;nh để thực hiện c&aacute;c t&aacute;c vụ h&agrave;ng ng&agrave;y trong m&ocirc;i trường văn ph&ograve;ng, gi&aacute;o dục, hoặc c&ocirc;ng việc c&aacute; nh&acirc;n<\/p>\n","category_image_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/files\/ky-nang-tin-hoc-van-phong.jpg?t=1747975685","category_icon_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/files\/images%20%2810%29.jpeg","slider_range_min":0,"slider_range_max":0,"type_page":3,"id_page":482131,"widget_15723431":{"content_data":{"content":"Hotline"}},"widget_15723454":{"content_data":{"content":"Tìm kiếm"}},"widget_15723445":{"content_data":[{"id":112389,"title":"American","code":"us","is_expires":false,"is_active":0},{"id":112388,"title":"Tiếng Việt","code":"vn","is_expires":false,"is_active":1}]},"widget_15723440":{"content_data":{"content":"Search"}},"widget_15723441":{"content_data":[]},"widget_15723443":{"content_data":{"content":"Tìm kiếm"}},"widget_15723450":{"content_data":[{"id":112389,"title":"American","code":"us","is_expires":false,"is_active":0},{"id":112388,"title":"Tiếng Việt","code":"vn","is_expires":false,"is_active":1}]},"widget_15723449":{"content_data":{"content":"Search"}},"widget_15723452":{"content_data":[]},"widget_15723444":{"content_data":{"content":"Search"}},"widget_15723487":{"content_data":{"content":"Tìm kiếm"}},"widget_15723494":{"content_data":[{"id":112389,"title":"American","code":"us","is_expires":false,"is_active":0},{"id":112388,"title":"Tiếng Việt","code":"vn","is_expires":false,"is_active":1}]},"widget_15723490":{"content_data":{"content":"Search"}},"widget_15723491":{"content_data":[]},"widget_15723493":{"content_data":{"content":"Tìm kiếm"}},"widget_15723482":{"content_data":[{"id":112389,"title":"American","code":"us","is_expires":false,"is_active":0},{"id":112388,"title":"Tiếng Việt","code":"vn","is_expires":false,"is_active":1}]},"widget_15723483":{"content_data":{"content":"Search"}},"widget_15723485":{"content_data":[]},"widget_15723495":{"content_data":{"content":"Search"}},"widget_15723640":{"content_data":{"content":"Đây là dữ liệu mặc định của Widget đoạn văn. Bạn có thể tự sửa nội dung này trong phần tác vụ khác của Widget hoặc thiết lập dữ liệu động tùy theo nhu cầu.","price_final":"Giá: Liên Hệ"}},"widget_15723634":{"content_data":[{"id":3640427,"name":"Advanced Power Query","desc":"Power Query in Microsoft Excel and Power BI have become indispensable tools, helping users transform data from many different sources quickly and flexibly.<\/p>\n","content":"<h3>Why learn Advanced Power Query?<\/font><\/font><\/strong><\/h3>\n\nWhile basic Power Query is powerful, to really turn raw data into valuable information, you need to overcome the following challenges:<\/font><\/font><\/p>\n\n<ul>\n\t<li>\n\tComplex and heterogeneous data:<\/font><\/font><\/b> Handle CSV, Excel files with messy structures, fragmented data, or need to combine from different sources with mismatched formats.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tOptimize performance:<\/font><\/font><\/b> When working with large amounts of data, it is important to know how to write efficient queries to avoid slowdowns and crashes.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tDeeper automation:<\/font><\/font><\/b> Desire to create custom functions, parameterize queries for reuse and reduce manual effort.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tDeep understanding of the M language:<\/font><\/font><\/b> This is the &quot;heart&quot; of Power Query, allowing you to refine, debug, and write more complex commands that the user interface cannot accommodate.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tConnect to diverse data sources:<\/font><\/font><\/b> Master how to connect and convert data from database systems (SQL Server, Access), web API, directories...<\/font><\/font><\/p>\n\t<\/li>\n<\/ul>\n\n<hr \/>\nMain content of the Advanced Power Query course<\/font><\/font><\/p>\n\nThis course will delve into more complex topics, making you an expert in data preprocessing:<\/font><\/font><\/p>\n\n<ol start=\"1\">\n\t<li>\n\tReview and improve basic transformations:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tOptimize common transformation steps: Split Columns, Merge Columns, Unpivot Columns, Pivot Columns.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tUse advanced conditions (Conditional Columns) and complex Text, Number, Date\/Time functions.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n\t<li>\n\tWorking with M Language:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tUnderstand the structure and syntax of the M language.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tWrite M queries directly in the Advanced Editor.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tDebugging and error handling in M code.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tUse advanced and custom M functions.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n\t<li>\n\tConnect and transform data from multiple complex sources:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tFolder:<\/font><\/font><\/b> Combine hundreds of Excel\/CSV files in one folder automatically.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tWeb Data:<\/font><\/font><\/b> Extract data from websites (Web Scraping) using HTML tables or API.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tDatabase:<\/font><\/font><\/b> Optimize connection and query data from SQL Server, Access.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tData Flows (in Power BI Service):<\/font><\/font><\/b> Introduction to preparing data in the cloud.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n\t<li>\n\tParameters &amp; Custom Functions:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tCreate and use parameters to make queries more flexible (e.g. change file path, report year).<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tBuild custom M functions to reuse complex transformation logic, saving time and ensuring consistency.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n\t<li>\n\tAdvanced techniques in data transformation:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tAdvanced Group By:<\/font><\/font><\/b> Group data with multiple aggregation operations.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tAdvanced Merge &amp; Append:<\/font><\/font><\/b> Merge types (Full Outer, Left Anti, Right Anti) and complex Append cases.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tBuffer Tables\/Lists:<\/font><\/font><\/b> Optimize performance when working with large amounts of data.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tHandling Errors and Exceptions:<\/font><\/font><\/b> Error Handling Techniques in Power Query.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n\t<li>\n\tPerformance optimization and query management:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tPractice tips and tricks to speed up Power Query processing.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tManage queries and query groups in an organized manner.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tIntroduction to <\/font><\/font>Query Folding<\/font><\/font><\/b> and its impact on performance.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n<\/ol>\n\n<hr \/>\nWho should take this course?<\/font><\/font><\/p>\n\nThe Advanced Power Query course is suitable for:<\/font><\/font><\/p>\n\n<ul>\n\t<li>\n\tData Analyst:<\/font><\/font><\/b> Want to prepare data more effectively for reports and Dashboards.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tAccounting, Finance Specialist:<\/font><\/font><\/b> Need to automate data aggregation from multiple tables and files.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tHR, Marketing Specialist:<\/font><\/font><\/b> Want to clean and prepare customer data, survey data.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tAnyone who already knows basic Power Query:<\/font><\/font><\/b> And wants to deepen their knowledge, master this tool to improve work productivity.<\/font><\/font><\/p>\n\t<\/li>\n<\/ul>\n","image_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/images\/san-pham\/khoahoc-19.jpg?t=1753113029","image_thumb_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/thumb_images\/san-pham\/khoahoc-19.jpg?t=1753113008","tags":["Computer Science","Advanced Power Query"],"count_view":161,"seo_name":"advanced-power-query","date_update":"1761167767","date_created_format":"","meta_title":"","meta_desc":"","meta_keyword":"","sku":"","code":"","rate":5,"image_2_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/images\/san-pham\/khoahoc-5.jpg","image_2_thumb_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/\/thumb_images\/san-pham\/khoahoc-5.jpg","image_list":[{"image_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/images\/san-pham\/khoahoc-19.jpg","image_thumb_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/\/thumb_images\/san-pham\/khoahoc-19.jpg"},{"image_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/images\/san-pham\/khoahoc-5.jpg","image_thumb_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/\/thumb_images\/san-pham\/khoahoc-5.jpg"}],"product_articles":[],"total_point_review":0,"link_youtube":"https:\/\/www.youtube.com\/embed\/","video_url":"","booking_url":"javascript:void(0)","brand_name":"","qr_code":"https:\/\/www.ptyen.id.vn\/advanced-power-query","promotion_name":"","status_inventory_value":1,"status_inventory":"Còn hàng","price":false,"price_final":"9.900.000 đ","percent_discount":false,"price_discount":false},{"id":3640426,"name":"VBA application in warehouse management","desc":"In an increasingly competitive business environment, effective warehouse management is a key factor determining the success of a business.<\/p>\n","content":"<h3>What is VBA and why is it necessary for inventory management?<\/font><\/font><\/strong><\/h3>\n\nVBA <\/font><\/font><\/b>is a programming language built into Microsoft Office applications like Excel, <\/font><\/font>Word, <\/font><\/font>Access, <\/font><\/font>etc. <\/font><\/font>With VBA, <\/font>you can create macros and small programs to automate repetitive tasks, customize the user interface <\/font><\/font>, <\/font><\/font>and develop specialized applications right in Excel.<\/font><\/font><\/p>\n\nIn warehouse management, <\/font><\/font>VBA brings many outstanding benefits:<\/font><\/font><\/p>\n\n<ul>\n\t<li>\n\tAutomate tasks: <\/font><\/font><\/b>Automatically import\/export inventory, <\/font><\/font>update inventory, <\/font><\/font>generate reports, <\/font><\/font>check data.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tMinimize errors: <\/font><\/font><\/b>Limit errors due to manual data entry, <\/font><\/font>apply strict testing rules.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tImprove productivity: <\/font><\/font><\/b>Save time on repetitive tasks, <\/font><\/font>allowing you to focus on more strategic tasks.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tFlexible customization: <\/font><\/font><\/b>Build a warehouse management system that fits your business&#39;s unique characteristics without expensive software.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tEasy integration: <\/font><\/font><\/b>Combine with Excel&#39;s built-in functions to analyze data and <\/font><\/font>create visual charts.<\/font><\/font><\/p>\n\t<\/li>\n<\/ul>\n\n<hr \/>\nMain content of the course<\/font><\/font><\/p>\n\nThis course will take you from the most basic concepts of VBA to building a complete warehouse management application, <\/font><\/font>including:<\/font><\/font><\/p>\n\n<ol start=\"1\">\n\t<li>\n\tOverview of VBA and development environment (VBE):<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tIntroduction to VBA and its role in warehouse management.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tGet familiar with the Visual Basic Editor window, <\/font><\/font>basic components (Project Explorer, <\/font><\/font>Properties Window, <\/font><\/font>Code Window).<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tRecord and edit basic Macros.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n\t<li>\n\tBasic programming concepts in VBA:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tVariables, <\/font><\/font>constants and data types.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tOperators and expressions.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tControl structure: <\/font><\/font>If... <\/font><\/font>Then... <\/font><\/font>Else, <\/font><\/font>Select Case.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tV&ograve;ng lặp: For...Next, Do While\/Until, For Each...Next.<\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tUse functions and procedures (Sub\/Function).<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n\t<li>\n\tWorking with objects in Excel (Excel Object Model):<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tWorkbook, Worksheet, <\/font><\/font>Range, Cell <\/font><\/font>objects <\/font><\/font>.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tData manipulation: <\/font><\/font>Read, <\/font><\/font>write, <\/font><\/font>search, <\/font><\/font>sort, <\/font><\/font>filter data.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tWork with tables, <\/font><\/font>charts, and <\/font><\/font>PivotTables.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n\t<li>\n\tDesign user interface with UserForm:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tCreate and customize UserForm.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tUsing controls: <\/font><\/font>TextBox, <\/font><\/font>ComboBox, <\/font><\/font>CommandButton, <\/font><\/font>ListBox, <\/font><\/font>OptionButton, <\/font><\/font>CheckBox.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tWrite code to handle events on UserForm.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n\t<li>\n\tVBA application in warehouse management operations:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tWarehouse: <\/font><\/font><\/b>Create automatic data entry form, <\/font><\/font>check input data.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tWarehouse export: <\/font><\/font><\/b>Build warehouse export process, <\/font><\/font>automatic inventory deduction.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tInventory: <\/font><\/font><\/b>Develop tools to support inventory and <\/font><\/font>data reconciliation.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tInventory Management: <\/font><\/font><\/b>Track actual inventory, <\/font><\/font>min\/max inventory, <\/font><\/font>alerts for outdated or low inventory.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tLookup and report: Create import\/export, <\/font><\/font><\/b>inventory, and transaction history <\/font><\/font>reports <\/font><\/font>quickly and accurately.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tSearch for information: <\/font><\/font><\/b>Build a function to search for products and <\/font><\/font>import\/export vouchers according to multiple criteria.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n\t<li>\n\tVBA Application Security and Optimization:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tProtect Macros, <\/font><\/font>spreadsheets and workbooks.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tOptimize code performance.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tError Handling.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n<\/ol>\n\n<hr \/>\nWho should take this course?<\/font><\/font><\/p>\n\nThis course is especially suitable for:<\/font><\/font><\/p>\n\n<ul>\n\t<li>\n\tWarehouse managers, storekeepers: <\/font><\/font><\/b>Want to automate work, <\/font><\/font>reduce data entry burden and improve accuracy.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tAccounting and purchasing staff: <\/font><\/font><\/b>Need to manage and track materials and <\/font><\/font>goods more effectively.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tSmall and medium business owners: Want to build a simple, <\/font><\/font><\/b>effective <\/font><\/font>warehouse management system at low cost.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tAnyone: <\/font><\/font><\/b>Has basic knowledge of Excel and wants to improve VBA application skills to automate office work.<\/font><\/font><\/p>\n\t<\/li>\n<\/ul>\n","image_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/images\/san-pham\/khoahoc-18.jpg?t=1753113029","image_thumb_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/thumb_images\/san-pham\/khoahoc-18.jpg?t=1753113008","tags":["Tin Học","Ứng dụng VBA"],"count_view":174,"seo_name":"vba-application-in-warehouse-management","date_update":"1761167767","date_created_format":"","meta_title":"","meta_desc":"","meta_keyword":"","sku":"","code":"","rate":5,"image_2_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/images\/san-pham\/khoahoc-17.jpg","image_2_thumb_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/\/thumb_images\/san-pham\/khoahoc-17.jpg","image_list":[{"image_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/images\/san-pham\/khoahoc-18.jpg","image_thumb_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/\/thumb_images\/san-pham\/khoahoc-18.jpg"},{"image_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/images\/san-pham\/khoahoc-17.jpg","image_thumb_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/\/thumb_images\/san-pham\/khoahoc-17.jpg"}],"product_articles":[],"total_point_review":0,"link_youtube":"https:\/\/www.youtube.com\/embed\/","video_url":"","booking_url":"javascript:void(0)","brand_name":"","qr_code":"https:\/\/www.ptyen.id.vn\/vba-application-in-warehouse-management","promotion_name":"","status_inventory_value":1,"status_inventory":"Còn hàng","price":false,"price_final":"9.900.000 đ","percent_discount":false,"price_discount":false},{"id":3640422,"name":"Tin Học Chứng Chỉ B","desc":"C&ocirc;ng việc văn ph&ograve;ng của bạn ng&agrave;y c&agrave;ng nhiều, l&agrave;m bạn cảm thấy căng thẳng. Những phần mềm văn ph&ograve;ng cơ bản như Word, Excel bắt đầu kh&ocirc;ng thể đảm đương hết y&ecirc;u cầu ng&agrave;y c&agrave;ng cao của bạn.&nbsp;<\/p>\n","content":"<h2>Giới Thiệu Kh&oacute;a Học Tin Học Chứng Chỉ B<\/strong><\/h2>\n\nC&ocirc;ng việc văn ph&ograve;ng của bạn ng&agrave;y c&agrave;ng nhiều, l&agrave;m bạn cảm thấy căng thẳng. Những phần mềm văn ph&ograve;ng cơ bản như Word, Excel bắt đầu kh&ocirc;ng thể đảm đương hết y&ecirc;u cầu ng&agrave;y c&agrave;ng cao của bạn. V&agrave; nhất l&agrave; khi bạn đ&atilde; bắt đầu tham gia v&agrave;o c&ocirc;ng việc quản l&yacute;. Bạn cần phải viết c&aacute;c phần mềm để hỗ trợ cho việc quản l&yacute; cửa h&agrave;ng, quản l&yacute; h&agrave;ng tồn kho, quản l&yacute; c&ocirc;ng nợ, quản l&yacute; lương, thưởng v&agrave; hoa hồng cho nh&acirc;n vi&ecirc;n, .. v&agrave; l&uacute;c n&agrave;y đ&acirc;y bạn cần một trợ thủ đắt lực hơn, thuận tiện hơn để đảm nhận c&ocirc;ng việc n&agrave;y, đấy ch&iacute;nh l&agrave; Access, th&agrave;nh phần ch&iacute;nh trong chương tr&igrave;nh đ&agrave;o tạo Tin Học Chứng Chỉ B của Trung t&acirc;m ngoại ngữ - Tin học ECO. Qua kh&oacute;a học n&agrave;y gi&uacute;p c&aacute;c học vi&ecirc;n: \n- Tổ chức, lưu trữ CSDL với Microsoft Access \n- X&acirc;y dựng c&aacute;c truy vấn, m&agrave;n h&igrave;nh nhập liệu \n- Tạo c&aacute;c b&aacute;o biểu, c&aacute;c điều khiển bằng Control Wizard<\/p>\n\nĐối Tượng Tham Gia<\/strong> \nD&agrave;nh cho người c&oacute; tr&igrave;nh độ tương đương chứng chỉ A ( kh&ocirc;ng bắt buộc c&oacute; CCA )<\/p>\n\n<img alt=\"\" src=\"\/datafiles\/35580\/upload\/images\/san-pham\/chung-chi-tin-hoc-b-co-thoi-han-bao-lau.jpg\" \/><\/p>\n\nThời Lượng<\/strong> \n3 Th&aacute;ng<\/p>\n\nNội Dung Kh&oacute;a Học Tin Học Chứng Chỉ B<\/strong> \n- Tổng quan về CSDL Access \n- Bảng dữ liệu (Table) \n- Tạo m&agrave;n h&igrave;nh nhập liệu với c&ocirc;ng cụ Form wizard \n- Truy vấn dữ liệu (Query)<\/p>\n","image_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/images\/san-pham\/khoahoc-1%281%29.jpg","image_thumb_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/thumb_images\/san-pham\/khoahoc-1%281%29.jpg","tags":["Tin Học","Chứng Chỉ B"],"count_view":81,"seo_name":"tin-hoc-chung-chi-b","date_update":"1761167767","date_created_format":"","meta_title":"","meta_desc":"","meta_keyword":"","sku":"","code":"","rate":5,"image_2_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/images\/san-pham\/khoahoc-5.jpg","image_2_thumb_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/\/thumb_images\/san-pham\/khoahoc-5.jpg","image_list":[{"image_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/images\/san-pham\/khoahoc-1%281%29.jpg","image_thumb_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/\/thumb_images\/san-pham\/khoahoc-1%281%29.jpg"},{"image_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/images\/san-pham\/khoahoc-5.jpg","image_thumb_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/\/thumb_images\/san-pham\/khoahoc-5.jpg"},{"image_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/images\/san-pham\/chung-chi-tin-hoc-b-co-thoi-han-bao-lau.jpg","image_thumb_url":"https:\/\/www.ptyen.id.vn\/datafiles\/81117\/upload\/\/thumb_images\/san-pham\/chung-chi-tin-hoc-b-co-thoi-han-bao-lau.jpg"}],"product_articles":[],"total_point_review":0,"link_youtube":"https:\/\/www.youtube.com\/embed\/","video_url":"","booking_url":"javascript:void(0)","brand_name":"","qr_code":"https:\/\/www.ptyen.id.vn\/tin-hoc-chung-chi-b","promotion_name":"","status_inventory_value":1,"status_inventory":"Còn hàng","price":false,"price_final":false,"percent_discount":false,"price_discount":false}],"content_pagging":{"firstCurrentItem":1,"lastCurrentItem":3,"total":3,"limit":9,"currentPage":1,"total_page":1,"pages":[{"active":false,"disable":true,"type":"first","page":1,"url":"javascript:void(0)"},{"active":false,"disable":true,"type":"prev","page":1,"url":"javascript:void(0)"},{"active":true,"disable":false,"type":"page","page":1,"url":"javascript:void(0)"},{"active":false,"disable":false,"type":"next","page":1,"url":"javascript:void(0)"},{"active":false,"disable":false,"type":"last","page":1,"url":"javascript:void(0)"}]}},"widget_15723633":{"content_data":{"content":"Danh sách"}},"widget_15723641":{"content_data":{"content":"Xem thêm"}},"widget_15723457":{"content_data":{"content":"Thông tin"}},"widget_15723459":{"content_data":{"content":"Edubost is proud to be a pioneer, providing comprehensive educational solutions, harmoniously combining the quintessence of international education with Vietnamese cultural identity, aiming to create a generation of excellent global citizens."}},"widget_15723460":{"content_data":{"content":"Edubost is not only a school but also a dynamic and creative educational environment where students are encouraged to develop comprehensively in knowledge, skills and personality."}},"widget_15723461":{"content_data":{"content":"Contact information"}},"widget_15723466":{"content_data":{"content":"Service"}},"widget_15723472":{"content_data":{"content":"Video library"}},"widget_15723863":{"content_data":{"content":""}},"widget_15723878":{"content_data":{"content":"Send<\/span>"}},"widget_15723864":{"content_data":{"content":"Thông tin liên hệ"}},"widget_15723879":{"content_data":{"content":"Reset Form<\/span>"}},"widget_15723435":{"content_data":{"content":"Web designed by P.A Vietnam"}},"title_page":"Office Information Technology"}