3036 Microsoft courses delivered Online

In the dynamic landscape of the UK job market, staying abreast of industry demands is paramount. The recent surge in construction hazards in the UK has underscored the critical need for adept professionals in Payroll Management. Our comprehensive diploma courses not only address this pressing issue but also equip you with a multifaceted skill set crucial for diverse financial roles. Learning Outcomes Upon completion of this Payroll Management bundle, you should be able to: Master payroll administration for effective financial management. Navigate accounting complexities with a diploma in accounting and bookkeeping. Understand the intricacies of UK pension systems for sound financial planning. Enhance legal acumen through Law and Contracts - Level 2. Harness the power of Sage 50 Accounts for streamlined financial processes. Develop essential office skills and advanced proficiency in Microsoft Excel. Gain expertise in GDPR data protection and anti-money laundering practices. Our curriculum, ranging from Payroll Management to Bookkeeping and Payroll Administration, not only delves into the intricacies of financial management but also extends to areas like pension schemes, legalities, and data protection. Moreover, our courses integrate practical tools such as Sage 50 Accounts and Microsoft Excel Level 3, ensuring you are proficient in the latest technologies. This Payroll Management Bundle Consists of the following Premium courses: Course 01: Payroll Management - Diploma Course 02: Bookkeeping and Payroll Administration Diploma Course 03: Payroll Management - Diploma Course 04: Diploma in Accounting and Bookkeeping Course 05: Pension UK Course 06: Law and Contracts - Level 2 Course 07: Sage 50 Accounts Course 08: Office Skills Course 09: Microsoft Excel Level 3 Course 10: GDPR Data Protection Course 11: Certificate in Anti-Money Laundering (AML) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals seeking a comprehensive understanding of financial management. Professionals aiming to enhance their proficiency in payroll administration. Aspirants looking to broaden their knowledge in accounting and bookkeeping. Those interested in gaining insights into pension schemes and financial planning. Individuals keen on advancing their legal acumen in contracts and legislation. Anyone desiring expertise in data protection and anti-money laundering practices. Requirements No requirements to enrol this Payroll Management Training course. Career path Payroll Administrator: £25,000 - £35,000 per annum Bookkeeper: £22,000 - £30,000 per annum Accounting Assistant: £23,000 - £32,000 per annum Legal Support Officer: £26,000 - £35,000 per annum Compliance Analyst: £30,000 - £40,000 per annum Data Protection Officer: £35,000 - £45,000 per annum Certificates CPDQS Accredited e-Certificate Digital certificate - Included CPDQS Accredited Hard-Copy Certificate Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Payroll Management - Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Master the magic of Microsoft Excel's sought-after functions with the 'Excel Vlookup; Xlookup; Match and Index' course. This tailored journey beckons those eager to navigate datasets with dexterity, turning raw data into actionable insights. From the foundational intricacies of Vlookup to the advanced functionalities of Xlookup, this course provides a comprehensive roadmap for all spreadsheet enthusiasts. Learning Outcomes Gain proficiency in implementing and mastering the Vlookup function. Understand the nuanced differences and applications of Xlookup. Recognise when and how to best use each of these Excel functions. Enhance efficiency in data processing and analysis tasks. Elevate your Excel proficiency, becoming a reliable resource for data-driven decisions. Why choose this Excel Vlookup; Xlookup; Match and Index course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Excel Vlookup; Xlookup; Match and Index Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Excel Vlookup; Xlookup; Match and Index course for? Data enthusiasts keen on enhancing their Excel skillset. Business professionals aiming to streamline data analysis. Students looking to gain a competitive edge in data-driven fields. Analysts aiming for faster, more accurate data interpretations. Excel users seeking to optimise their use of lookup functionalities. Career path Data Analyst: £25,000 - £40,000 Excel Consultant: £30,000 - £55,000 Finance Analyst: £28,000 - £45,000 Marketing Analyst: £24,000 - £48,000 Operations Analyst: £26,000 - £42,000 Report Developer: £27,000 - £51,000 Prerequisites This Excel Vlookup; Xlookup; Match and Index does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel Vlookup; Xlookup; Match and Index was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Excel Vlookup; Xlookup; Match and Index 1.1 Excel vlookup 00:08:00 1.2 Excel xlookup 00:06:00 1.3 Excel vlookup 00:08:00 1.4 Excel vlookup 00:03:00 1.5 Excel vlookup 00:11:00 1.6 Excel vlookup 00:05:00 1.7 Excel vlookup 00:05:00 Assignment Assignment - Excel Vlookup; Xlookup; Match and Index 00:00:00 Resource Resource 00:00:00

The focus of this Windows 10 End User course is to introduce you to the Microsoft Windows 10 operating system and explain the basics of navigating the new Windows 10 operating system for becoming more productive and efficient. You'll know how to log in and learn essential functionality and review new functionality and features in Windows 10, following with review file management and customisation with File Explorer, customise and personalise desktop and other areas of the Windows 10 operating setting. You'll also learn to work with applications and programs including installing, updating, and troubleshooting, and get accustomed with Cortana, learn to use the new Maps, Mail, People, Calendar, and Weather features. Furthermore, you'll learn more about Microsoft Edge, its functionality and new features. What you'll learn Get started by logging in and navigating the Windows 10 environment. Personalize the interface and customize settings. Manage files and folders, and learn about OneDrive. Become familiar with Edge, Microsoft's newest browser, and explore the features. Learn to use Cortana, Maps, Photos, Mail, People, Calendar and Weather. Learn to install applications, set defaults, and manage updating and troubleshooting settings. Requirements Basic familiarity with computers and navigating the Internet. Who this course is for: Students who want to become familiar with the new Windows 10 environment. Introduction Intro- No Animation FREE 00:01:00 Getting Started in Windows 10 Logging In 00:02:00 The Startup Screen 00:04:00 Exploring the Desktop 00:02:00 General Navigation 00:04:00 Introducing the Action Center and Control Panel 00:02:00 Tablet Mode 00:03:00 Launching Applications 00:03:00 Interacting with Windows 00:06:00 Quitting Applications 00:04:00 Pinning Applications 00:03:00 Customizing the Start Menu 00:03:00 Customizing the Task Bar 00:02:00 Multitasking to Switch Between Multiple Applications 00:03:00 Managing several deskstops Using Task View 00:03:00 Using Cortana 00:03:00 Cortana Setup 00:03:00 File Management Overview of the drive and folder structure 00:04:00 Using Navigation Pane, Details Pane, Preview Pane 00:04:00 Menus and Ribbons 00:03:00 Viewing and Editing File Properties_Revised 00:04:00 Creating Files 00:06:00 Selecting, Moving, and Copying Files_Revised 00:06:00 Renaming Files and Folders 00:03:00 Deleting and Restoring from the Recycle Bin 00:05:00 Create and use shortcuts_Revised 00:05:00 Zip and Unzip 00:07:00 Changing the Sort and Group by 00:06:00 Add Columns to the Explorer View 00:04:00 Creating and Using a Library 00:07:00 Adding Files to a Library 00:09:00 Pin Frequent Places Customizing File Explorer 00:04:00 Configuring Files and Explore Options 00:03:00 Logging In or Setting Up OneDrive 00:02:00 Storing and acessing files on OneDrive 00:03:00 Sharing Files Through OneDrive 00:05:00 Syncing Files on OneDrive 00:03:00 Using Edge Browsing the Web 00:02:00 Customize Top Sites 00:02:00 Using Tabs 00:03:00 Organize Favorites with Folders 00:02:00 Using the Reading List and Reading View 00:03:00 Using Saving Sharing Web Notes 00:04:00 Downloading Files 00:02:00 Viewing and Clearing History 00:02:00 Using Windows Apps Maps- Search Get Directions Choose View 00:04:00 Maps- Search Tips and Favorites 00:04:00 Maps- More Search Tips and Map Settings 00:03:00 Photos - Browsing_REVISED 00:05:00 Photos - Using Editing Tools_REVISED 00:04:00 Mail- Add Accounts 00:05:00 Mail- Personalizing and Configuring 00:04:00 Mail Send a Message 00:04:00 People Search Link and Share Contacts 00:04:00 People Search Link and Share Contacts 00:04:00 Calendar Configuring and Viewing 00:04:00 Calendar Changing Views Creating and Editing Events 00:07:00 Weather Add Favorite Locations and Viewing the Weather 00:04:00 Weather- Viewing Historical Data nad Weather Maps 00:03:00 Customizing Windows 10 Managing Accounts and Sign In Options 00:03:00 Background Settings 00:04:00 Lock Screen 00:02:00 Change Windows Themes 00:02:00 Personalize Start 00:04:00 Change Screen Resolution 00:02:00 Adjust Audio Settings 00:02:00 Manage Sleep and Screen Saver 00:04:00 Change Default Storage Locations 00:02:00 Managing Devices 00:03:00 Change Type Settings 00:01:00 Adjust Mouse and Touchpad Settings 00:03:00 Adjust Autoplay Settings 00:02:00 Installing, Updating, and Troubleshooting Installing Applications from the Windows Store 00:03:00 Installing Applications From the Web 00:03:00 Setting Application Defaults 00:03:00 Setting App Privacy and Permissions 00:02:00 Uninstalling Applications 00:01:00 Configure Windows Defender and Windows Updates 00:02:00 Access Task Manage 00:02:00 Accessing the Action Center to View Messages 00:02:00 Backing Up and Restoring Files and Using Recover to Reset Your PC 00:07:00 Conclusion Course Recap 00:01:00

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Accountancy will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate skills for your next promotion, this Accountancy will help you keep ahead of the pack. The Accountancy incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Further, this Accountancy will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in this job sector. Consequently, you'll sharpen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Accountancy, you can equip yourself with the essentials to keep you afloat in the competition. Along with this Accountancy course, you will get 10 premium courses, an original Hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Accountancy Bundle Consists of the following Premium courses: Course 01: Accountancy Course 02: Positive Psychology Masterclass Course 03: Level 3 Tax Accounting Course 04: Level 3 Xero Training Course 05: Theory of Constraints, Throughput Accounting and Lean Accounting Course 06: Internal Audit Training Diploma Course 07: Team Management Course 08: Business Analysis Level 3 Course 09: Microsoft Excel Training: Depreciation Accounting Course 10: GDPR Data Protection Level 5 Course 11: Microsoft Excel Level 3 As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the Accountancy to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere. So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Accountancy: Pay once and get lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But with this special offer, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. Curriculum of Accountancy Bundle Course 01: Accountancy Introduction The Role of an Accountant Accounting Concepts and Standards Double-Entry Bookkeeping Balance Sheet Income statement Financial statements Cash Flow Statements Understanding Profit and Loss Statement Financial Budgeting and Planning Auditing Course 02: Positive Psychology Masterclass Turn Negativity into Positivity Turn Anxiety & Frustrations into Positivity Turn Surviving Into Thriving Create a Positive Mental Aptitude Master the Top Six Positivity Traits Turn Adversity into Resilience Master Your Grit Scale Turn Physical Dexterity into Positive Psychology Set Positive Boundaries Become More Genuine and Authentic Live Out Giving First Detach Yourself from the End Result Course 03: Level 3 Tax Accounting Tax System and Administration in the UK Tax on Individuals National Insurance How to Submit a Self-Assessment Tax Return Fundamentals of Income Tax Advanced Income Tax Payee, Payroll and Wages Capital Gain Tax Value Added Tax Import and Export Corporation Tax and many more ... Course 04: Level 3 Xero Training Introduction Getting Started Invoices and Sales Bills and Purchases Bank Accounts Products and Services Fixed Assets Payroll VAT Returns Course 05: Theory of Constraints, Throughput Accounting and Lean Accounting The Theory of Constraints and Throughput Accounting Lean Accounting Part 1 Lean Accounting Part 2 Summary and Lean Accounting Assignment Course 06: Internal Audit Training Diploma Auditing as a Form of Assurance Internal Audit Procedures Technology-based Internal Audit Internal Control and Control Risk Audit Interviews Reporting Audit Outcome UK Internal Audit Standards Career as an Auditor Course 07: Presenting Financial Information Presenting Financial Information The Hierarchy of Performance Indicators The Principle of Effective Reports Guidelines for Designing Management Reports Methods of Presenting Performance Data The Control Chart: Highlighting the Variation in the Data The Pareto Chart: Highlighting Priorities Exercise: The Control Chart An Example Management Report Interpreting Performance Data Supporting Colleagues by Giving Feedback Data Visualisation Part 01 Data Visualisation Part 02 Data Visualisation Part 03 Data Visualisation Part 04 Final Thoughts on Presenting Financial Information Course 08: Business Analysis Level 3 Introduction to Business Analysis Business Processes Business Analysis Planning and Monitoring Strategic Analysis and Product Scope Solution Evaluation Investigation Techniques Ratio Analysis Stakeholder Analysis and Management Process Improvement with Gap Analysis Documenting and Managing Requirements Career Prospect as a Business Analyst in the UK Course 09: Microsoft Excel Training: Depreciation Accounting Introduction Depreciation Amortization and Related Terms Various Methods of Depreciation and Depreciation Accounting Depreciation and Taxation Master Depreciation Model Conclusion Course 10: GDPR Data Protection Level 5 GDPR Basics GDPR Explained Lawful Basis for Preparation Rights and Breaches Responsibilities and Obligations Course 11: Microsoft Excel Level 3 Microsoft Excel 2019 New Features Getting Started with Microsoft Office Excel Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Excel Templates CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Accountancy bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Accountancy is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones, so you can access your course on Wi-Fi, 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 this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

This course is aimed at anyone looking to gain entry into the IT field as an IT Support Technician. Support Technicians are the backbone of any IT department. They ensure the smooth running of the IT within a company or organisation and offer guidance to anyone needing assistance. As a result, technical support is one of the most abundant jobs available within the IT industry.

Get to grips with all the features of Teams, including calls and chats, Teams and Channels and Meetings Course overview Duration: 2 hours This session is aimed at those new or self-taught users of Teams to show them the features and how to setup and use it effectively. Objectives  By the end of the course you will be able to: Use the core functions of Microsoft Teams Set up Microsoft Teams Make Calls Send Chats to colleagues via teams Set up channels Run Teams meetings Content What is Teams Teams elements Setting up your Teams Setting up audio and video Using voicemail Setting voicemail language Calls and Chats Sending individual and group chats Making and receiving calls Missed call notification Searching Teams and Channels Creating channels Channel settings Setting channel notifications Emailing channels Creating private channels Posting to channels Alerting specific people in a channel Adding files to channels Sending links to channels Teams Meetings Setting up meetings Running meetings from channels Setting backgrounds Screen sharing in meetings Handing over control Creating meeting notes Adding files to teams or meetings Using the meeting chat

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

Learning Objectives Introduction , Getting Started with Access , Working with Data , Creating Databases and Objects , Working with Queries , Working with Reports , Working with Forms , Conclusion   Pre-Requisites Basic computer skills. Knowledge of basic database concepts is helpful but not required.   Description This course is an introduction to Microsoft Access 2019. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2019 Intermediate course. Access 2019 Beginner Module 1: Introduction to the course 00:01:00 Module 2: What is Database 00:03:00 Module 3: Understanding Database terminology 00:04:00 Module 4: Navigating the Access Interface 00:09:00 Module 5: What is Flat file Database 00:03:00 Module 6: What is Relational Database 00:10:00 Module 7: Relating Tables 00:08:00 Module 8: Reviewing the Access Ribbon 00:02:00 Module 9: Working with Tables 00:07:00 Module 10: Navigating Tables 00:03:00 Module 11: Editing Data 00:03:00 Module 12: Adding New Records 00:03:00 Module 13: Using Subdatasheets 00:04:00 Module 14: Understanding Database and Table Design Principles 00:09:00 Module 15: Using Table Data Sheet View 00:04:00 Module 16: Working with Field Data Types 00:07:00 Module 17: Using Table Design View 00:04:00 Module 18: Using Calculated Fields 00:08:00 Module 19: Calculating Dates 00:04:00 Module 20: Calculating Strings 00:04:00 Module 21: Using the Lookup Wizard 00:11:00 Module 22: Lookup Wizard Linking Tables 00:06:00 Module 23: Using Indexes 00:05:00 Module 24: What are Queries 00:06:00 Module 25: Creating Simple Queries 00:05:00 Module 27: Entering Criteria-Exact Match and Ranger Operators 00:06:00 Module 28: Understanding And VS Or 00:06:00 Module 29: Using Wild Cards 00:04:00 Module 30: Using Key Words 00:04:00 Module 31: Sorting and Hiding Fields 00:03:00 Module 32: Creating Multi-Table Queries 00:03:00 Module 33: Creating a Calculated Field in Query 00:05:00 Module 34: Additional Tips 00:05:00 Module 35: What are Reports 00:04:00 Module 36: Understanding Report Types 00:03:00 Module 37: Building Good Reports 00:02:00 Module 38: Using Autoreport 00:06:00 Module 39: The Report Wizard 00:12:00 Module 40: Using the Report Design View 00:07:00 Module 41: Printing Reports 00:04:00 Module 42: Creating Labels 00:05:00 Module 43: Additional Tips 00:09:00 Module 44: What are Forms 00:03:00 Module 45: Understanding Form Types 00:03:00 Module 46: Creating Forms 00:02:00 Module 47: Navigating Forms 00:02:00 Module 48: Editing Data in Forms 00:05:00 Module 49: Understanding the Form Wizard 00:05:00 Module 50: Using the Form Design View 00:04:00 Module 51: Working with Controls 00:07:00 Module 52: Using the Form Layout View 00:03:00 Module 53: Additional Tips 00:07:00 Downloadable Resources Resources - Access 2019 Beginner 00:00:00 Final Exam Final Exam - Access 2019 Beginner 00:20:00

Learning Objectives Introduction , Designing Tables for Better Data Entry , Sharing Data with Other Applications , Working with Action Queries , Advanced Query Techniques , Automating Processes with Macros , Advanced Form Techniques , Advanced Report Techniques , Conclusion   Pre-Requisites Access 365 Beginner or equivalent experience.   Description This course is designed to teach students intermediate level skills in Microsoft Access 365. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 365 Advanced course.   Module 1: Design Tables for Better Data Entry Reviewing Table Design Principles 00:11:00 Setting Field Size, Formats, and Captions 00:11:00 Setting Default Values and Required Fields 00:05:00 Restricting Data Entry-Validation Rules 00:07:00 Restricting Data Entry-Input Masks 00:09:00 Module 2: Share Data with Other Apps Exporting Tables and Queries to Excel 00:05:00 Exporting Data to a SharePoint List 00:02:00 Importing Data from Excel 00:06:00 Importing Data from a SharePoint List 00:02:00 Linking External Data Sources 00:05:00 Using Word Merge 00:06:00 Module 3: Work with Action Queries What are Action Queries 00:04:00 Creating an Update Query 00:06:00 Creating an Append Query 00:04:00 Creating a Delete Query 00:04:00 Creating a Make Table Query 00:04:00 Changing Start Number of an Auto Number Field 00:04:00 Module 4: Advanced Query Techniques Modifying Query Joins 00:06:00 Using Self Joins to Combine Data 00:06:00 Creating Find Unmatched and Find Duplicate Queries 00:09:00 Creating Parameter Queries 00:05:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:06:00 Summarizing Query Data with Totals 00:04:00 Creating Crosstab Queries 00:06:00 Module 5: Automate Processes with Macros Understanding Macro Basics 00:14:00 Creating Macros to Open Forms by Record 00:09:00 Validating Data Entry with Macros 00:10:00 Creating a Macro to Automate Data Entry 00:08:00 Advanced Data Entry Using Macros and DLOOKUP 00:11:00 Module 6: Advanced Form Techniques Using Conditional Formatting 00:04:00 Working with the New Label Name Property 00:03:00 Organizing Form Fields with Tab Controls 00:09:00 Creating an Option Group Control 00:06:00 Creating a Combo Box Control 00:04:00 Configuring a Combo Box Control to Show Search Results 00:04:00 Using a Subform to Show Data From a Related Table 00:06:00 Module 7: Advanced Report Techniques Inserting a Chart on a Report 00:07:00 Showing Data in Columns 00:07:00 Inserting a Subreport 00:05:00 Configuring Reports with Parameter Queries 00:03:00 Sending Reports 00:03:00 Resource Resource - Access 365 Intermediate 00:00:00 Final Exam Final Exam - Access 365 Intermediate 00:20:00

24 Hour Flash Deal **25-in-1 IT Skills Proficiency: Mastering Information Technology Mega Bundle** IT Skills Proficiency: Mastering Information Technology Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the IT Skills Proficiency: Mastering Information Technology package online with Studyhub through our online learning platform. The IT Skills Proficiency: Mastering Information Technology bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This IT Skills Proficiency: Mastering Information Technology course provides complete 360-degree training on IT Skills Proficiency: Mastering Information Technology. You'll get not one, not two, not three, but twenty-five IT Skills Proficiency: Mastering Information Technology courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these IT Skills Proficiency: Mastering Information Technology courses are yours for as long as you want them once you enrol in this course This IT Skills Proficiency: Mastering Information Technology Bundle consists the following career oriented courses: Course 01: Foundations of IT Security: Protecting Digital Assets Course 02: Cyber Security Awareness Training Course 03: Cyber Security Incident Handling and Incident Response Course 04: Computer Networks Security from Scratch to Advanced Course 05: Python Basic Programming for Absolute Beginners Course 06: SQL for Data Science, Data Analytics and Data Visualization Course 07: AutoCAD VBA Programming - Beginner course Course 08: ASP.Net MVC and Entity Framework Course 09: Web Application Penetration Testing Course 10: Learn MySQL from Scratch Course 11: PHP Web Development with MySQL Course 12: Learn Spring & Angular Material with a Full Web Application Course 13: JavaScript Foundations Course 14: jQuery Masterclass Course: JavaScript and AJAX Coding Bible Course 15: Responsive Web Design Course 16: HTML and CSS Coding: Beginner to Advanced Course 17: CSS Fundamentals Course 18: Basic HTML 5 Course 19: Build Progressive Web Apps with Angular Course 20: Info Graphics Web Design - Affinity Designer Training Course 21: Web Design with Adobe XD Course 22: Digital Art - Sketching In Photoshop Course 23: Microsoft Excel Complete Course 2019 Course 24: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 25: Microsoft PowerPoint for Beginners The IT Skills Proficiency: Mastering Information Technology course has been prepared by focusing largely on IT Skills Proficiency: Mastering Information Technology career readiness. It has been designed by our IT Skills Proficiency: Mastering Information Technology specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The IT Skills Proficiency: Mastering Information Technology Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This IT Skills Proficiency: Mastering Information Technology bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This IT Skills Proficiency: Mastering Information Technology Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into IT Skills Proficiency: Mastering Information Technology Elementary modules, allowing our students to grasp each lesson quickly. The IT Skills Proficiency: Mastering Information Technology course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive IT Skills Proficiency: Mastering Information Technology bundle, you really hit the jackpot. Here's what you get: Step by step IT Skills Proficiency: Mastering Information Technology lessons One to one assistance from IT Skills Proficiency: Mastering Information Technologyprofessionals if you need it Innovative exams to test your knowledge after the IT Skills Proficiency: Mastering Information Technologycourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five IT Skills Proficiency: Mastering Information Technology courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your IT Skills Proficiency: Mastering Information Technology certificate and transcript on the next working day Easily learn the IT Skills Proficiency: Mastering Information Technology skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This IT Skills Proficiency: Mastering Information Technology training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in IT Skills Proficiency: Mastering Information Technology Progression: BCS Level 1 Award in IT User Skills (ECDL Essentials) (ITQ) BCS Level 2 Certificate in IT User Skills (ECDL Core) BCS Level 2 Certificate in IT User Skills (ECDL Extra) (ITQ) BCS Level 2 ECDL Award in IT User Skills BCS Level 2 ECDL Certificate in IT User Skills BCS Level 3 Certificate in IT User Skills (ICDL Advanced) (ITQ) NCFE Level 3 Diploma in Skills for Business: IT Requirements To participate in this IT Skills Proficiency: Mastering Information Technology course, all you need is - A smart device A secure internet connection And a keen interest in IT Skills Proficiency: Mastering Information Technology Career path You will be able to kickstart your IT Skills Proficiency: Mastering Information Technology career because this course includes various courses as a bonus. This IT Skills Proficiency bundle is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore IT Skills Proficiency: Mastering Information Technology career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free