Office Information Technology

{"company_logo":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/files\/Thi%E1%BA%BFt%20k%E1%BA%BF%20ch%C6%B0a%20c%C3%B3%20t%E1%BB%87ngsdg%281%29.png","company_name":"HUE ALUMNI","company_email":"alumni.hue@gmail.com","company_phone":"088 880 04 98","company_address":"99 Hồ Đắc Di, Thành phố Huế","company_fax":"","date_now":1780946769,"company_tags":[],"search_keyword":null,"facebook_comment":"https:\/\/huealumni.id.vn\/office-information-technology","breadscrumb":[{"url":"https:\/\/huealumni.id.vn","name":"Homepage","icon":"","active":false},{"url":"https:\/\/huealumni.id.vn\/san-pham","name":"Dịch vụ visa","icon":"","active":false},{"url":"javascript:void(0)","name":"Office Information Technology","icon":"","active":true}],"list_products_tmp":[],"list_section":[{"id":658462,"name":"Header","seo_name":"#w30s-section-658462","url":"#w30s-section-658462"},{"id":658466,"name":"Header fixed","seo_name":"#w30s-section-658466","url":"#w30s-section-658466"},{"id":658465,"name":"Banner detail","seo_name":"#w30s-section-658465","url":"#w30s-section-658465"},{"id":658481,"name":"Content","seo_name":"#w30s-section-658481","url":"#w30s-section-658481"},{"id":658463,"name":"Footer","seo_name":"#w30s-section-658463","url":"#w30s-section-658463"}],"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:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/files\/ky-nang-tin-hoc-van-phong.jpg?t=1747975685","category_icon_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/files\/Thi%E1%BA%BFt%20k%E1%BA%BF%20ch%C6%B0a%20c%C3%B3%20t%E1%BB%87ngsdg%281%29.png","slider_range_min":0,"slider_range_max":0,"type_page":3,"id_page":458339,"widget_15280344":{"content_data":{"content":"Tìm kiếm"}},"widget_15280348":{"content_data":{"content":"Tìm kiếm"}},"widget_15280345":{"content_data":[{"id":94272,"title":"American","code":"us","is_expires":false,"is_active":0},{"id":94271,"title":"Tiếng Việt","code":"vn","is_expires":false,"is_active":1}]},"widget_15280355":{"content_data":{"content":"Enter an appointment "}},"widget_15280351":{"content_data":{"content":"Search"}},"widget_15280352":{"content_data":[]},"widget_15280354":{"content_data":{"content":"Search"}},"widget_15280356":{"content_data":[{"id":94272,"title":"American","code":"us","is_expires":false,"is_active":0},{"id":94271,"title":"Tiếng Việt","code":"vn","is_expires":false,"is_active":1}]},"widget_15280357":{"content_data":{"content":"Tìm kiếm"}},"widget_15280346":{"content_data":[]},"widget_15280402":{"content_data":{"content":"Enter an appointment "}},"widget_15280398":{"content_data":{"content":"Search"}},"widget_15280399":{"content_data":[]},"widget_15280401":{"content_data":{"content":"Search"}},"widget_15280403":{"content_data":[{"id":94272,"title":"American","code":"us","is_expires":false,"is_active":0},{"id":94271,"title":"Tiếng Việt","code":"vn","is_expires":false,"is_active":1}]},"widget_15280578":{"content_data":{"content":"Danh sách"}},"widget_15280579":{"content_data":[{"id":3627862,"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:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/images\/san-pham\/khoahoc-19.jpg?t=1753113029","image_thumb_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/thumb_images\/san-pham\/khoahoc-19.jpg?t=1753113008","tags":["Computer Science","Advanced Power Query"],"count_view":130,"seo_name":"advanced-power-query","date_update":"1758770649","date_created_format":"","meta_title":"","meta_desc":"","meta_keyword":"","sku":"","code":"","rate":5,"image_2_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/images\/san-pham\/khoahoc-5.jpg","image_2_thumb_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/\/thumb_images\/san-pham\/khoahoc-5.jpg","image_list":[{"image_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/images\/san-pham\/khoahoc-19.jpg","image_thumb_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/\/thumb_images\/san-pham\/khoahoc-19.jpg"},{"image_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/images\/san-pham\/khoahoc-5.jpg","image_thumb_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/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:\/\/huealumni.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":3627861,"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:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/images\/san-pham\/khoahoc-18.jpg?t=1753113029","image_thumb_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/thumb_images\/san-pham\/khoahoc-18.jpg?t=1753113008","tags":["Tin Học","Ứng dụng VBA"],"count_view":111,"seo_name":"vba-application-in-warehouse-management","date_update":"1758770649","date_created_format":"","meta_title":"","meta_desc":"","meta_keyword":"","sku":"","code":"","rate":5,"image_2_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/images\/san-pham\/khoahoc-17.jpg","image_2_thumb_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/\/thumb_images\/san-pham\/khoahoc-17.jpg","image_list":[{"image_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/images\/san-pham\/khoahoc-18.jpg","image_thumb_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/\/thumb_images\/san-pham\/khoahoc-18.jpg"},{"image_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/images\/san-pham\/khoahoc-17.jpg","image_thumb_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/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:\/\/huealumni.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":3627857,"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:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/images\/san-pham\/khoahoc-1%281%29.jpg","image_thumb_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/thumb_images\/san-pham\/khoahoc-1%281%29.jpg","tags":["Tin Học","Chứng Chỉ B"],"count_view":82,"seo_name":"tin-hoc-chung-chi-b","date_update":"1758770649","date_created_format":"","meta_title":"","meta_desc":"","meta_keyword":"","sku":"","code":"","rate":5,"image_2_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/images\/san-pham\/khoahoc-5.jpg","image_2_thumb_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/\/thumb_images\/san-pham\/khoahoc-5.jpg","image_list":[{"image_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/images\/san-pham\/khoahoc-1%281%29.jpg","image_thumb_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/\/thumb_images\/san-pham\/khoahoc-1%281%29.jpg"},{"image_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/images\/san-pham\/khoahoc-5.jpg","image_thumb_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/\/thumb_images\/san-pham\/khoahoc-5.jpg"},{"image_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/upload\/images\/san-pham\/chung-chi-tin-hoc-b-co-thoi-han-bao-lau.jpg","image_thumb_url":"https:\/\/huealumni.id.vn\/datafiles\/71341\/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:\/\/huealumni.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":6,"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_15280586":{"content_data":{"content":"Đọc thêm"}},"widget_15280605":{"content_data":{"content":"Tags"}},"widget_15280596":{"content_data":{"content":"Tin tức mới"}},"widget_15280593":{"content_data":{"content":"Danh mục"}},"widget_15280588":{"content_data":{"content":"Từ khóa tìm kiếm"}},"widget_15280600":{"content_data":{"content":" "}},"widget_15280589":{"content_data":[]},"widget_15280591":{"content_data":{"content":"Tìm kiếm"}},"widget_15280359":{"content_data":{"content":"Thông tin"}},"widget_15280361":{"content_data":{"content":"RouteX<\/strong> is a professional study abroad consulting company, with the mission of supporting Vietnamese students to realize their dream of studying abroad in many countries around the world. The company has an office in Ho Chi Minh City and organizes many seminars and events related to studying abroad.Bookle doesn't try to be a giant bookstore, but focuses on creating a cozy, intimate space like a personal library.<\/p>\n"}},"widget_15280363":{"content_data":{"content":"Visa category"}},"widget_15280369":{"content_data":{"content":"Featured videos"}},"widget_15280376":{"content_data":{"content":" "}},"widget_15280379":{"content_data":{"content":"Sign up to receive news"}},"widget_15280386":{"content_data":{"content":"Register"}},"widget_15280383":{"content_data":{"content":"Sign up for our weekly newsletter to get the latest updates.<\/p>\n"}},"widget_15280338":{"content_data":{"content":""}},"widget_15280887":{"content_data":{"content":""}},"widget_15280902":{"content_data":{"content":"Send<\/span>"}},"widget_15280888":{"content_data":{"content":"Send contact information"}},"widget_15280903":{"content_data":{"content":"Reset Form<\/span>"}},"widget_15280906":{"content_data":{"content":""}},"widget_15280388":{"content_data":{"content":"Web designed by P.A Vietnam"}},"title_page":"Office Information Technology"}