520 Courses in Cardiff delivered Online

Description Register on the Web Development Bootcamp: Learn Web Development from Scratch today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion. The Web Development Bootcamp: Learn Web Development from Scratch course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With This Course Receive a digital certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment You need to attend an assessment right after the completion of this course to evaluate your progression. For passing the assessment, you need to score at least 60%. After submitting your assessment, you will get feedback from our experts immediately. Who Is This Course For The course is ideal for those who already work in this sector or are aspiring professionals. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge.   Course Content Section 01: Getting Started Introduction 00:03:00 How to Get Course requirements 00:02:00 Getting Started on Windows, Linux or Mac 00:02:00 How to ask a Great Questions 00:01:00 FAQ's 00:01:00 Section 02: HTML Introduction HTML 00:05:00 Choosing Code Editor 00:06:00 Installing Code Editor (Sublime Text) 00:04:00 Overview of a Webpage 00:05:00 Structure of a Full HTML Webpage 00:07:00 First Hello World! Webpage 00:09:00 Section 03: HTML Basic Heading tags 00:09:00 Paragraph 00:08:00 Formatting Text 00:12:00 List Items Unordered 00:05:00 List Items Ordered 00:04:00 Classes 00:09:00 IDs 00:06:00 Comments 00:04:00 Section 04: HTML Intermediate Images 00:12:00 Forms 00:05:00 Marquee 00:06:00 Text area 00:06:00 Tables 00:06:00 Links 00:07:00 Navbar - Menu 00:04:00 HTML Entities 00:05:00 Div tag 00:06:00 Google Maps 00:07:00 Section 05: HTML Advanced HTML Audio 00:07:00 HTML Video 00:05:00 Canvas 00:06:00 Iframes 00:05:00 Input Types 00:04:00 Input Attributes 00:06:00 Registration Form 00:04:00 Contact Us Form 00:10:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:02:00 Section 06: JavaScript Introduction What is JavaScript 00:09:00 Hello World Program 00:14:00 Getting Output 00:11:00 Internal JavaScript 00:13:00 External JavaScript 00:09:00 Inline JavaScript 00:04:00 Async and defer 00:06:00 Section 07: JavaScript Basics Variables 00:13:00 Data Types 00:10:00 Numbers 00:06:00 Strings 00:06:00 String Formatting 00:05:00 Section 08: JavaScript Operators Arithmetic operators 00:07:00 Assignment operators 00:03:00 Comparison operators 00:06:00 Logical operators 00:08:00 Section 09: JavaScript Conditional Statements If-else statement 00:05:00 If-else-if statement 00:04:00 Section 10: JavaScript Control Flow Statements While loop 00:09:00 Do-while loop 00:03:00 For loop 00:08:00 Coding Exercise 00:02:00 Solution for Coding Exercise 00:02:00 Section 11: JavaScript Functions Creating a Function 00:07:00 Function Call() 00:07:00 Function with parameters 00:05:00 Section 12: JavaScript Error Handling Try-catch 00:05:00 Try-catch-finally 00:17:00 Section 13: JavaScript Client-Side Validations On Submit Validation 00:09:00 Input Numeric Validation 00:12:00 Section 14: Python Introduction Introduction to Python 00:02:00 Python vs Other Languages 00:04:00 Why It's Popular 00:04:00 Command Line Basics 00:07:00 Python Installation (Step By Step) 00:06:00 PyCharm IDE Installation 00:08:00 Getting Start PyCharm IDE 00:05:00 First Python Hello World Program 00:07:00 Section 15: Python Basic Variables 00:16:00 Data Types 00:13:00 Type Casting 00:07:00 User Inputs 00:08:00 Comments 00:04:00 Section 16: Python Strings Strings 00:05:00 String Indexing 00:05:00 String Slicing 00:04:00 String Built-in Functions 00:09:00 Formatting String (Dynamic Data) 00:05:00 Section 17: Python Operators Arithmetic Operators 00:08:00 Assignment Operators 00:05:00 Comparison Operators 00:05:00 Logical Operators 00:02:00 AND Operator 00:04:00 OR Operator 00:02:00 NOT Operator 00:03:00 Booleans 00:02:00 Section 18: Python Data Structures Arrays in Earler 00:02:00 Lists 00:06:00 Add List Items 00:03:00 Remove List Items 00:01:00 Sort Lists 00:03:00 Join Lists 00:08:00 Tuples 00:08:00 Update tuples 00:07:00 Join tuples 00:02:00 Dictionaries 00:06:00 Add Dictionary Items 00:04:00 Remove Dictionary Items 00:03:00 Nested Disctionaries 00:04:00 Sets 00:04:00 Add Set Items 00:03:00 Remove Set Items 00:01:00 Join Set Items 00:04:00 Section 19: Python Conditional Statements If Statement 00:03:00 If-else Statement 00:04:00 If-elif-else Statement 00:04:00 If Statement Coding Excercise 00:05:00 Section 20: Python Control Flow Statements Flow Charts 00:06:00 While Loops Statement 00:10:00 For Loops Statement 00:06:00 The range() Function 00:04:00 Nested Loops 00:04:00 2D List using Nested Loop 00:04:00 Section 21: Python Core Games Guessing Game 00:07:00 Car Game 00:10:00 Section 22: Python Functions Creating a Function 00:03:00 Calling a Function 00:06:00 Function with Arguments 00:05:00 Section 23: Python Args, KW Args For Data Science args, Arbitary Arguments 00:04:00 kwargs, Arbitary Keyword Arguments 00:06:00 Section 24: Python Project Project Overview 00:04:00 ATM RealTime Project 00:13:00

Overview We live in an era where data, data and data surround us. You need to share something one way or another to use most of the services around you; just name it. Whether it is about reading a blog post, visiting a website, surveying for a service, seeing any social media post, or looking for offers, you must share some data, if not anything, and your email, at least.But do you ever realise why, in all these situations, you need to share your data? Because your data is oxygen in this world. Companies want to know what you are thinking or what you are about to do before you even think or are about to do it. Sounds crazy, right? Don't be.It is a new branch of knowledge and profession. A data analyst gathers, cleans, and evaluates data sets to find an explanation or resolve an issue. The most common tool for doing these is Microsoft Excel. Our Data Analysis in Microsoft Excel Complete Training course will prepare you to use Microsft Excel in data analysis. What Can You Expect To Achieve By Completing This Course? Proficiency in modifying and organising data within Excel worksheets. Skills in working with lists and effectively analysing data. Ability to create visual representations of data using charts and graphs. Competence in using PivotTables and PivotCharts for data summarisation and analysis. Command in managing multiple worksheets, workbooks, and advanced Excel functions for data manipulation and forecasting. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Data Analysis in Microsoft Excel Complete Training. It is available to all students, of all academic backgrounds. Requirements Our Data Analysis in Microsoft Excel Complete Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 31 lectures • 04:46:00 total length •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:10:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:05:00 •Watch and Evaluate Formulas: 00:10:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00

Tired of clunky web interactions that feel like they’ve time-travelled from 2005? It’s time your development knowledge caught up with the standards of today’s API-driven internet. This PHP and MySQL Bootcamp gives you a proper foundation in building RESTful web services that are smooth, scalable, and ready to communicate across platforms—without sounding like a confused robot trying to speak JSON. Whether you're coding solo or part of a team that thinks ‘REST’ just means a tea break, this course walks you through how APIs actually work. You’ll explore how to build structured endpoints, connect databases securely, manage HTTP methods, and shape responses like a true digital diplomat. With PHP and MySQL at the core, you’ll learn how to send and fetch data the right way—clean, fast, and future-ready. It’s not magic. It’s just code that behaves properly. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Introduction Introduction to Getting Started Course Curriculum How to Get Pre-Requisites Getting Started on Windows, Linux or Mac How to ask a Great Questions FAQ's Setting up Local Development Environment Section Introduction XAMPP Installation for PHP, MySQL and Apache Choosing code editor Installing code editor (Sublime text) Installing code editor (VS code) Postman API platform installation Composer installation Creating a project on xampp PHP hello world program Summary Restful API Basic Section Introduction What is PHP What is Restful API HTTP request GET, POST, PUT or DELETE REST API project structure Summary Project1: Restful API Login and Registration Section Introduction Create Database and table Creating Project forms and folders Database Connection JSON Web Token Handler(JWT) Auth Middleware Token Validation Register form Login form User Token Authorization check form Summary Project2: Restful API - MySQL Database Section Introduction Create Database and table Adding Data to table - insert query MySQL Select query MySQL Update query MySQL Delete query Get Project2 Source Code Create Database Connection Summary Restful API - Web Services Section Introduction Create Items Class PHP File Create Method form Creating Record Using Restful API Reading Method form Reading Record Using Restful API Update Method form Update Record Using Restful API Delete Method form Delete Method Using Restful API Coding Exercise Solution for Coding Exercise Summary Apache .htaccess file SEO friendly Request URLs of REST API Course Assessment To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%. When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Restful API Web Services with PHP and MySQL: Bootcamp course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Restful API Web Services with PHP and MySQL: Bootcamp course is open to all, with no formal entry requirements. Career path Upon successful completion of the Restful API Web Services with PHP and MySQL: Bootcamp Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

Data Analysis In Excel for School Administrators is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Data Analysis In Excel for School Administrators and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 5 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language numeracy and IT Desire for entrepreneurship over the age of 16. Assessment The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.  After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:06:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:13:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:08:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:06:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:09:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:09:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:06:00

Duration 2.25 Days 13.5 CPD hours This course is intended for The job roles best suited to the material in this course are: sales personnel, accountants, administrators, auditors, lab assistants, office job positions. Overview Work with functions. Work with lists. Analyze data. Visualize data with charts. Use PivotTables and PivotCharts. Work with multiple worksheets and workbooks. Share and protect workbooks. Automate workbook functionality. Use Lookup functions and formula auditing. Forecast data. Create sparklines and map data This course provides the knowledge to create advanced workbooks and worksheets that can deepen the understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it and present that information to decision makers. In addition this course will give you the ability to collaborate with colleagues, automate complex or repetitive tasks and use conditional logic to construct and apply elaborate formulas and functions which will allow you to work through a lot of data and generate the answers that your organisation needs. WORKING WITH FUNCTIONS Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date and Time Functions Topic E: Work with Text Functions WORKING WITH LISTS Topic A: Sort Data Topic B: Filter Data Topic C: Query Data with Database Functions Topic D: Outline and Subtotal Data ANALYZING DATA Topic A: Create and Modify Tables Topic B: Apply Intermediate Conditional Formatting Topic C: Apply Advanced Conditional Formatting VISUALIZING DATA WITH CHARTS Topic A: Create Charts Topic B: Modify and Format Charts Topic C: Use Advanced Chart Features USING PIVOTTABLES AND PIVOTCHARTS Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Timelines and Slicers WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS Topic A: Use Links and External References Topic B: Use 3-D References Topic C: Consolidate Data SHARING AND PROTECTING WORKBOOKS Topic A: Collaborate on a Workbook Topic B: Protect Worksheets and Workbooks AUTOMATING WORKBOOK FUNCTIONALITY Topic A: Apply Data Validation Topic B: Search for Invalid Data and Formulas with Errors Topic C: Work with Macros USING LOOKUP FUNCTIONS AND FORMULAS AUDITING Topic A: Use Lookup Functions Topic B: Trace Cells Topic C: Watch and Evaluate Formulas FORECASTING DATA Topic A: Determine Potential Outcomes Using Data Tables Topic B: Determine Potential Outcomes Using Scenarios Topic C: Use the Goal Seek Feature Topic D: Forecast Data Trends CREATING SPARKLINES AND MAPPING DATA Topic A: Create Sparklines Topic B: Map Data

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases. Overview After completing this course, you will be able to: Authenticate and authorize users Assign server and database roles Authorize users to access resources Use encryption and auditing features to protect data Describe recovery models and backup strategies Backup and Restore SQL Server databases Automate database management Configure security for the SQL Server agent Manage alerts and notifications Managing SQL Server using PowerShell Trace access to SQL Server Monitor a SQL Server infrastructure Troubleshoot a SQL Server infrastructure Import and export data This course will provide training in how to administer and maintain SQL Server, Azure SQL Database and other cloud-based SQL Server databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, students will learn to carry out these important tasks. This course covers content that was in retired Microsoft Course 20764: Administering a SQL Database Infrastructure. 1 - Creating advanced functions Lesson 1: Converting a command into an advanced function Lesson 2: Creating a script module Lesson 3: Defining parameter attributes and input validation Lesson 4: Writing functions that accept pipeline input Lesson 5: Producing complex pipeline output Lesson 6: Using comment-based Help Lesson 7: Using Whatif and Confirm parameters 2 - Using Microsoft .NET Framework and REST API in Windows PowerShell Lesson 1: Using .NET Framework in PowerShell Lesson 2: Using REST API in PowerShell 3 - Writing controller scripts Lesson 1: Understanding controller scripts Lesson 2: Writing controller scripts with a user interface Lesson 3: Writing controller scripts that create reports 4 - Handling script errors Lesson 1: Understanding error handling Lesson 2: Handling errors in a script 5 - Using XML, JSON, and custom-formatted data Lesson 1: Working with XML formatted data Lesson 2: Working with JSON formatted data Lesson 3: Working with custom-formatted data 6 - Enhancing server management with Desired State Configuration and Just Enough Administration Lesson 1: Implementing Desired State Configuration Lesson 2: Implementing Just Enough Administration 7 - Analyzing and debugging scripts Lesson 1: Debugging in Windows PowerShell Lesson 2: Analyzing and debugging an existing script 8 - Understanding Windows PowerShell Workflow Lesson 1: Understanding Windows PowerShell Workflows Lesson 2: Running Windows PowerShell Workflows

Duration 3 Days 18 CPD hours This course is intended for This class is ideal for business users - the people who need to learn what's possible with Salesforce functionality across the suite of products, but aren't necessarily responsible for managing the application. If you're a customer service manager, business executive, business operations manager, sales operations manager, or any other operations, management, or process analysis 'super user,' this class is just what you need to better understand the business value of the Salesforce Platform. Overview Describe the primary business value of each major Salesforce Cloud. Manage users and data. Manage basic org configuration. Create email templates. Create reports and dashboards. Apply and champion Chatter. Understand the Salesforce implementation and maintenance lifecycle. Extend Salesforce functionality beyond basic configuration. Explore what?s possible with Salesforce. In this 3-day class, our Salesforce experts will walk you through the Salesforce Platform, its specific applications, and their business values and benefits. Familiarize yourself with Salesforce Cloud, and learn about platform features and processes to more effectively support day-to-day Salesforce operations within your organization. Through interactive lectures, discussions, and hands-on exercises, you?ll recognize the core elements of the implementation lifecycle, the key considerations to drive user adoption, and the important components of ongoing management of your Salesforce environment. Introduction Understand How Salesforce Works Explore Salesforce Applications Review Salesforce Organization Data Access and Security Control Org Access Manage Who Views and Modifies Objects Unlock Access to Records Share Access to Records Lock Down Individual Fields User Management and Troubleshooting Create New Users Troubleshoot Login, Record Access, and Field Visibility Issues Salesforce Customizations Think About Your Implementation Explore Custom Fields, Picklists, Page Layouts, and Record Types Create Email Templates Business Processes Automation Review Validation Rules Review Assignment and Escalation Rules Review Web-to-Lead and Entitlements Review Lightning Process Builder and Workflow Review Approval Processes and Visual Workflow Reports Explore the Reports Tab, Folders, and Formats Explore the Report Builder Summarize Your Data Dashboards and Data Insights Get More Insight from Your Data Visualize Your Data with Dashboards Create Your Analytics Strategy Everyday Salesforce Collaborate with Chatter, Groups, and Communities Share Feedback with Chatter Answers and Ideas Go Mobile with Salesforce1 Make Salesforce Part of Your Day Data Management Create a Data Migration Strategy Ensure Data Quality Extending Salesforce Drive a Salesforce Implementation Customize Salesforce Using Custom Objects, Apps, and the Salesforce AppExchange Build It Yourself Wrap-up and Certification Review the Certification Process and Resources

Unlock the full potential of Microsoft Office 2016 with our comprehensive course! From Word to Excel, PowerPoint, and more, master essential skills to boost your productivity and efficiency. Whether you're a beginner or seeking to enhance your proficiency, this course provides step-by-step guidance to navigate and utilize Office tools effectively. Enroll now and elevate your Microsoft Office skills to excel in your personal and professional endeavors!

This Access 2016 Intermediate is specially designed for you if you are thinking to take your Microsoft Access skills to the next level. Through the course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.  From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. You will learn to design tables for improved accuracy in data entry by setting default values and restricting data entry, review the various options to share data with other applications, including Word and Excel, learn about Action Queries to automate updating, appending and deleting table data, and review various advanced query techniques such as using Query Joins, Parameter queries, working with totals and Crosstab queries. Finally, you'll build a navigation form to make it easy for your users to find their way around your database.  What Will I Learn? Design Tables for Better Data Entry Share Data with Other Applications Work with Action Queries Advanced Query Techniques Automate Processes with Macros Advanced Forms Advanced Report Techniques Requirements Access 2016 Introduction or equivalent experience. Who is the target audience? Students who want to take Access to the next level and improve their database design skills. Introduction Introduction FREE 00:01:00 Designing Tables for Better Data Entry Reviewing Table Design Principles 00:04:00 Setting Field Size, Formats and Captions 00:06:00 Setting Default Value and Required Fields 00:03:00 Restricting Data Entry Using Data Validation 00:02:00 Restricting Data Entry Using Input Masks 00:06:00 Sharing Data with Other Applications Exporting Tables and Queries to Excel 00:03:00 Importing Data from a TXT File 00:03:00 Importing Data from Excel 00:02:00 Exporting Data to a TXT File 00:02:00 Linking External Data Sources 00:03:00 Using Word Merge 00:02:00 Working with Action Queries What are Action Queries 00:02:00 Creating an Update Query 00:02:00 Creating an Append Query 00:03:00 Creating a Delete Query 00:02:00 Creating a Make Table Query 00:02:00 Changing the Start Number of an Auto Number Field 00:03:00 Advanced Query Techniques Creating Query Joins 00:05:00 Creating Find Unmatached and Find Duplicate Queries 00:03:00 Creating Parameter Queries 00:04:00 Using -Like- Keyword in Parameter Queries 00:02:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:03:00 Summarizing Query Data with Totals 00:03:00 Inserting Where Statements in Summary Queries 00:01:00 Creating a Crosstab Query 00:03:00 Automating Processes with Macros Understanding Macro Basics 00:06:00 Creating Macros to Open Forms by Record 00:04:00 Validating Data Entry with Macros 00:04:00 Creating a Macro to Automate Data Entry 00:03:00 Advanced Data Entry Using Macros and DLOOKUP Function 00:06:00 Advanced Form Using Conditional Formatting 00:02:00 Organizing Form Fields with Tab Controls 00:03:00 Creating a Combo Box Control 00:02:00 Creating an Option Group Control 00:03:00 Using a Subform to Show Data from a Related Table 00:03:00 Advanced Report Techniques Inserting a Chart on a Report 00:03:00 Showing Data in Columns 00:02:00 Inserting a Subreport 00:02:00 Configuring Reports with Parameter Queries 00:04:00 Sending Reports 00:02:00 Conclusion Course Recap 00:01:00 Resources Resources - Access 2016 Intermediate 00:00:00 Course Certification

Master Go programming with an in-depth course covering advanced topics such as authentication, authorization, JWT tokens, and refresh tokens. Learn how to write reliable code with effective unit testing techniques, while exploring concepts such as logging, error handling, and modularization. Build secure and scalable web applications with Go to take your coding expertise to the next level.