5322 Productivity courses in Cardiff delivered Online

This Employability Skills course is designed for students who want to improve their employability skills and prepare for the world of work. This Employability Skills course aims to help learners develop and improve skills required for the workplace and increase learners' confidence and communication skills to prepare them for employment or a change in employment. This Employability Skills course will make you more aware of what employers are currently looking for when hiring new employees and how you can make the most of your technical qualifications, skills, experience, and personal qualifications when applying for jobs. Apart from technical qualifications, the Employability Skills course considers a variety of generic skills and capabilities that employers look for. Learning Outcomes After completing this Employability Skills, you will be able to: Understand a Mindset that can improve employability. Know how to deal with your first days at work. Recognise the key motivators and de-motivators that impact work situations. Understand how to set your targets. Understand how to manage time. Know how to present yourself. Know how to solve problems in a place of work. Recognise creative thinking. Know how to work in a team. Know how to deal with conflict. Gain a solid understanding of health, safety and security in the place of work. Why Choose Level 2 Certificate in Employability Skills Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Courses are included in this Employability Skills Course Course 01: Employability Skills Course 02: Workplace Stress Management Course 03: Dealing With Difficult People ***Other Benefits of this Course Free 3 PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the course] ***Employability Skills*** Detailed course curriculum of the Employability Skills: Module 01: Understanding Mindset Module 02: Dealing with Your First Days at Work Module 03: Understanding Motivation Module 04: Setting Your Targets Module 05: Managing Your Time Module 06: Presenting Yourself Module 07: Problem Solving in a Place of Work Module 08: Creative Thinking Module 09: Understanding Risk Module 10: Working in a Team Module 11: Dealing with Conflict Module 12: Health, Safety and Security in the Place of Work ------------------ Assessment Method After completing each module of the Employability Skills Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Employability Skills course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Employability Skills is ideal for people looking for employment or a change in employment. Requirements There are no specific requirements for this Employability Skills course because it does not require any advanced knowledge or skills. Certificates Certificate of completion Digital certificate - Included

Functional Skills English Level 2 | Functional Skills Maths Level 2 | Functional Skills IT Level 2 with PDF Certificates Are you tired of feeling held back by those frustrating math equations or the words that seem to elude you in English? Our comprehensive Functional Skills bundle can help you as it comprises three individual courses - Functional Skills Maths, Functional Skills English, and Functional Skills IT. Each one is tailored to empower you with vital Functional Skills that are essential for the modern workplace. This course bundle provides a solid foundation of Functional Skills in English, Maths, and IT, essential for both personal development and professional success. The English course focuses on improving Reading, Writing, Speaking, and Listening skills, while the Maths course offers Practical Applications and Problem-solving Techniques. IT training covers essential Digital Skills, and the Fitness course introduces Health and Well-being into the mix. Additional courses on English Grammar and Math Tricks offer unique strategies to further enhance your proficiency and confidence in these core areas. Additionally, we are offering 2 more courses related to Functional Skills absolutely FREE. Courses Included In this Functional Skills Package Are: Course 01: Functional Skills English Level 2 Course 02: Functional Skills Maths Level 2 Course 03: Functional Skills IT Level 2 Course 04: Functional Skills Fitness Level 2 Course 05: English Spelling, Punctuation, and Grammar Training Course 06: Math Tricks & Tips- Best Techniques to Speed up Your Math Learning Outcomes of the Functional Skills Bundle: Develop strong written and verbal communication skills in English. Demonstrate proficiency in asking and answering questions. Improve spelling accuracy and employ correct spelling strategies. Acquire essential mathematical skills. Apply mathematical rules and formulas to solve real-life problems. Demonstrate proficiency in using computer hardware and software. Understand and mitigate IT security threats while troubleshooting computer issues. Why Choose Us? Opportunity to get a Free CPD Accredited / QLS Endorsed Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Curriculum Breakdown Course 01: Functional Skills English Level 2 Module 01: Introduction to the Course Module 02: Basics of Grammar Module 03: The Basics of Sentence Module 04: Structure of Sentence Module 05: Questions Module 06: Punctuation and Capitalisation Module 07: Spelling Module 08: Common Mistakes and Ways to Improve Course 02: Functional Skills Maths Level 2 Module 01: Numbers and Negative Numbers Module 02: Multiple Factors Module 03: Fractions and Power Module 04: Percentages Module 05: Expressions Module 06: Decimals Module 07: Ratio and Proportion Module 08: Exponents and Radicals Module 09: Graphs Module 10: The Profit and Loss Module 11: Perimeter and Area Module 12: Averages Module 13: Probability Course 03: Functional Skills IT Level 2 Section 01: How People Use Computers Section 02: System Hardware Section 03: Device Ports And Peripherals Section 04: Data Storage And Sharing Section 05: Understanding Operating Systems Section 06: Setting Up And Configuring A PC Section 07: Setting Up And Configuring A Mobile Device Section 08: Managing Files Section 09: Using And Managing Application Software Section 10: Configuring Network And Internet Connectivity Section 11: IT Security Threat Mitigation Section 12: Computer Maintenance And Management Section 13: IT Troubleshooting Section 14: Understanding Databases Section 15: Developing And Implementing Software Course 04: Functional Skills Fitness Level 2 Module 01: Introduction To Functional Fitness Training Module 02: What Is Functional Fitness Module 03: Benefits Of Functional Fitness Module 04: Functional Fitness & Other Exercises Module 05: Common Mistakes With Functional Fitness Module 06: Functional Fitness & Power Module 07: Functional Fitness & Strength Module 08: Functional Fitness & Range Of Motion Module 09: Functional Fitness & Balance & Endurance Assessment Process After completing this online course, you will be given immediate access to a specially designed MCQ test. The results will be analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the Functional Skills exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 360 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is ideal for: Students seeking mastery in this field Professionals seeking to enhance their skills Anyone who is passionate about this topic Our Course is Knowledge-based not a regulated course. To get Qualified, you may choose the following options: IGCSE Maths A-Level Maths Functional Skills Qualification in Maths at Level 2 Functional Skills Qualification in Mathematics at Level 2 - GCSE Equivalent for Maths A-level Mathematics Functional Skills Qualification in Mathematics at Entry 1 Functional Skills Qualification in Mathematics at Level 1 Functional Skills Qualification in English at Entry 1 Functional Skills Qualification in English at Entry 2 Functional Skills Qualification in English at Level 1 Functional Skills Qualification in ICT at Level 2 Functional Skills Qualification in Information & Communication Technology (ICT) at Level 1 Requirements You will not need any prior background or expertise to enrol in this Bundle. Career path Enrolling on our Bundle can lead you to the following career path: Teacher Teacher Assistant Private Tutor Customer Service Fire service Police Certificates CPDQS Accredited Certificate Digital certificate - £12.99 Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. Certificate in Functional Skills English at QLS Level 2 Hard copy certificate - £79 Show off Your New Skills with a Certification of Completion After successfully completing the Certificate in Functional Skills English at QLS Level 2course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 79 GBP inside the UK 89 GBP (including postal fees) for international delivery CPDQS Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! In winter, you plot and plan. In spring, you move! If you are looking to embark on a long-standing, sought-after career, take the first step to a successful walk of life with this highly regarded Functional Skills course. Are you looking to improve your current abilities or make a career move? Our unique Functional Skills course might help you get there! Expand your expertise with high-quality training - study the Functional Skills and get an expertly designed, great-value training experience. The Functional Skills course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Functional Skills course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Functional Skills training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! What you'll learn in this course Learn about integers, Integers and ordering of integers, Addition and Subtractions of Integers Gain Complete knowledge about factors and multiples, Relations between LCM and HCF Acquire a basic grasp of Fractions, Convert mixed to improper and improper to mixed fractions. Learn Simplification Rule- BODMAS Decimal numbers about fractions, Addition and subtraction of Decimal Representation of Rational Numbers on Number line Rounding to the whole number, Rounding to the required number of decimals Estimation and Scientific Notation or Standard form Percentage, Ratio, Proportion, Unitary Method and its Application Profit, Loss, discount and Tax Why People Love this course From Academy for Health & Fitness: Opportunity to earn a certificate accredited by CPDQS Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Start your learning journey straight away with this Functional Skills Maths course and take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Functional Skills course: Module 1: Numbers and Negative Numbers Module 2: Multiples Factors Module 3: Fractions and Power Module 4: Percentages Module 5: Expressions Module 6: Decimals Module 7: Ratio and Proportion Module 8: Exponents and Radicals Module 9: Graphs Module 10: The Profit and Loss Module 11: Perimeter and Area Module 12: Averages Module 13: Probability Assessment Process Your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the Functional Skills course. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Functional Skills course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path Enrolling on our Functional Skills Maths programme can lead you to the following career path: Teacher Teacher Assistant Private Tutor Customer Service HR Manager Accountant Finance Manager And many more. Certificates Certificate of completion Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Knowing about Microsoft Outlook Essentials will not just help us organise our emails but will help us in being productive. Through this Workshop, you will learn how to organise your emails and files the way you want it. You will know how to send robust messages, taking advantage of text formatting and insertion tools. You will also learn how Outlook's tools can help you filter out the messages you don't want to read. Learn to stay organised by creating folders to store your Outlook items and keep in touch by using Outlook to manage your contacts.In this course you will learn the necessary skills, knowledge and information of Microsoft Outlook.  Course Highlights Certificate in Microsoft Outlook 2007 for Beginners is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certificate in Microsoft Outlook 2007 for Beginners into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certificate in Microsoft Outlook 2007 for Beginners Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment, and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certificate in Microsoft Outlook 2007 for Beginners is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certificate in Microsoft Outlook 2007 for Beginners is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 00:30:00 Module Two - Opening and Closing Outlook 01:00:00 Module Three - Working with E-mail 01:00:00 Module Four - Creating a New E-mail 01:00:00 Module Five - Managing E-mail 01:00:00 Module Six - Managing Junk Mail 01:00:00 Module Seven - Outlook's Organization Tools 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contacts 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Certificate in Microsoft Outlook 2007 for Beginners 00:00:00 Mock Exam Final Exam

Learning Objectives Introduction , Improving the Structure of a Database , Maintaining a Database , Working with Navigation Forms and Startup , Configuring Access for Multiple Users , Automating Processes with VBA , Using Table Events , Conclusion   Pre-Requisites Access Beginner and Intermediate courses or equivalent experience.   Description Access 2019 Advanced will further build upon the topics covered in the Access 2019 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create backups, create and modify Navigation Forms, set startup options, split a database, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), convert macros to VBA, and use Table Events. Access 2019 Advanced Module 1: Introduction to the course 00:01:00 Module 2: Using the table Analyzer Wizard 00:07:00 Module 3: Append Querying to Normalize a Table 00:06:00 Module 4: Creating a Junction Table 00:05:00 Module 5: Backing up a Database 00:02:00 Module 6: Using the Compact and Repair Database Tool 00:03:00 Module 7: Using the Object Dependencies Tool 00:02:00 Module 8: Using the Database Documenter Tool 00:02:00 Module 9: Using the Analyze Performance Tool 00:02:00 Module 10: Creating a Navigation Form 00:03:00 Module 11: Modifying a Navigation Form 00:03:00 Module 12: Setting the Startup Options 00:02:00 Module 13: Using the Database Splitter 00:03:00 Module 14: Configuring Trusted Locations 00:03:00 Module 15: Password Protecting a Database 00:03:00 Module 16: Password Protecting Modules 00:02:00 Module 17: Converting a Database to an ACCDE File 00:02:00 Module 18: Understanding VBA Basics 00:03:00 Module 19: Exploring Variables and Control Flow Statements 00:07:00 Module 20: Exploring a Table or Query with VBA 00:10:00 Module 21: Converting a Macro to VBA 00:03:00 Module 22: Understanding Table Events 00:02:00 Module 23: Using the Before Change Event Command 00:05:00 Module 24: Using the After Update Event Command 00:03:00 Module 25: Recap 00:01:00 Resource Resource - Access 2019 Advanced 00:00:00 Final Exam Final Exam - Access 2019 Advanced 00:20:00

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 , Improving the Structure of a Database , Maintaining a Database , Working with Navigation Forms and Startup Options , Configuring Access for Multiple Users , Automating Processes , Using Table Events , Conclusion   Pre-Requisites Access Beginner and Intermediate courses or equivalent experience.   Description Access 365 Advanced will further build upon the topics covered in the Access 365 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create backups, create and modify Navigation Forms, set startup options, split a database, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), convert macros to VBA, and use Table Events. Module 1: Improving the Structure of a Database Using the Table Analyzer Wizard 00:09:00 Append Querying to Normalize a Table 00:10:00 Creating a Junction Table 00:06:00 Module 2: Maintaining a Database Backup Up a Database 00:03:00 Using the Compact and Repair Database Tool 00:03:00 Using the Object Dependencies Tool 00:03:00 Using the Database Documenter Tool 00:02:00 Using the Analyze Performance Tool 00:02:00 Module 3: Working with Navigation Forms and Startup Options Creating a Navigation Form 00:03:00 Modifying a Navigation Form 00:05:00 Setting the Startup Options 00:03:00 Module 4: Configuring Access for Multiple Users Using the Database Splitter 00:04:00 Configuring Trusted Locations 00:03:00 Password Protecting a Database 00:04:00 Password Protecting Modules 00:02:00 Converting a Database to an ACCDE File 00:02:00 Module 5: Automating Processes with VBA Understanding VBA Basics 00:03:00 Exploring Variables and Control Flow Statements 00:10:00 Exporting a Table or Query with VBA 00:09:00 Converting a Macro to VBA 00:02:00 Module 6: Using Table Events Understanding Table Events 00:02:00 Using the Before Change Event Command 00:07:00 Using the After Update Event Command 00:04:00 Resource Resource - Access 365 Advanced 00:00:00 Final Exam Final Exam - Access 365 Advanced 00:20:00

Microsoft Access 2016 is an information management tool that allows you to store, report, and analyze information within a relational database. This Access 2016 Introduction is designed for beginners so that even if you've never so much as opened the program before, you can learn how to use it like a pro. This course covers all the important features of Access 2016 and demonstrates how to use them. Here you'll learn how to harness the power of Microsoft Access 2016 to organize, store, edit, manage, and report on hundreds of thousands of records. This course will help you master Access and put it to creative, confident use. You'll develop not only strong Access skills, but a solid understanding of good database design concepts. By the time you've finished the course, you'll know how to organize and assemble an effective database for any kind of information you need to store, document, and manage. What Will I Learn? Understand Databases and Database Terminology Work with Data Create Databases and Objects Work with Queries Work with Reports Work with Forms Requirements Basic computer skills. Knowledge of basic database concepts is helpful but not required. Who is the target audience? Students who want to learn database concepts and build basic databases. Introduction Intro FREE 00:01:00 Getting Started What is a database 00:02:00 Understanding Database terminology 00:05:00 Navigating the Access Interface 00:06:00 What is a flat file database 00:04:00 What is a relational database 00:09:00 Relating Tables 00:06:00 Reviewing the Access Ribbon 00:04:00 Working with Data Working with Tables 00:04:00 Navigating Tables 00:02:00 Editing Data 00:03:00 Adding New Records 00:02:00 Using Subdata Sheets 00:03:00 Creating Databases and Objects Understanding Database and Table Design Principles 00:10:00 Using Table Data Sheet View 00:04:00 Working with Field Data Types 00:04:00 Using Table Design View 00:03:00 Using Calculated Fields 00:04:00 Calculating Numbers 00:03:00 Calculating Dates 00:01:00 Calculating Strings 00:02:00 Using the Lookup Wizard 00:05:00 Editing Lookups 00:04:00 Using Indexes 00:02:00 Working with Queries What are Queries 00:03:00 Creating Simple Queries 00:04:00 Understanding the Dynaset 00:02:00 Entering Criteria- Exact Match and Range Operators 00:04:00 Understanding AND v. OR 00:03:00 Using Wild Cards 00:02:00 Using Key Words 00:03:00 Sorting and Hiding Fields 00:02:00 Creating Multi-Table Queries 00:03:00 Additional Tips 00:03:00 Working with Reports What are Reports 00:03:00 Understanding Report Types 00:03:00 Building Effective Reports 00:02:00 Using AutoReport 00:04:00 Understanding the Report Wizard 00:04:00 Using the Report Design View 00:08:00 Creating Labels 00:02:00 Working with Forms What are Forms 00:04:00 Understanding Form Types 00:02:00 Creating Forms 00:02:00 Navigating Forms 00:02:00 Editing Data in Forms 00:03:00 Understanding the Form Wizard 00:03:00 Using the Form Design View 00:04:00 Working with Controls 00:03:00 Using Form Layout View 00:02:00 Additional Tips (2) 00:02:00 Conclusion Course Recap 00:01:00 Resources Resources - Access 2016 Introduction 00:00:00 Course Certification

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 2019 Beginner or equivalent experience.   Description This course is designed to teach students intermediate level skills in Microsoft Access 2019. 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 2019 Advanced course. Access 2019 Intermediate Module 01: Introduction to the Course 00:02:00 Module 02: Reviewing Table Design Principles 00:11:00 Module 03: Setting Field Size, Formats and Captions 00:09:00 Module 04: Setting Default Values and Required Fields 00:06:00 Module 05: Restricting Data Entry-Validation Rules 00:06:00 Module 06: Restricting Data Entry-Input Masks 00:07:00 Module 07: Exploring Tables and Queries to Excel 00:04:00 Module 08: Exporting Data to a SharePoint List 00:02:00 Module 09: Importing Data from Excel 00:06:00 Module 10: Importing Data from a Sharepoint List 00:02:00 Module 11: Linking External Data Sources 00:06:00 Module 12: Using Word Merge 00:07:00 Module 13: What are Action Queries 00:03:00 Module 14: Creating an Update Query 00:06:00 Module 15: Creating an Append Query 00:04:00 Module 16: Creating a Delete Query 00:05:00 Module 17: Creating a Make Table Query 00:04:00 Module 18: Changing Start Number of an Auto Number Field 00:04:00 Module 19: Modifying Query Joins 00:09:00 Module 20: Using Self Joins to Combine Data 00:06:00 Module 21: Creating Find Unmatched and Find Duplicate Queries 00:09:00 Module 22: Creating Parameter Queries 00:07:00 Module 23: Creating a Top X Query 00:03:00 Module 24: Reviewing Calculated Query Fields 00:05:00 Module 25: Summarising Query Data with Totals 00:05:00 Module 26: Creating a Crosstab Query 00:07:00 Module 27: Understanding Macro Basics 00:14:00 Module 28: Creating Macros to Open Forms by Record 00:08:00 Module 29: Validating Data Entry with Macros 00:09:00 Module 30: Creating a Macro to Automate Data Entry 00:08:00 Module 31: Advanced Data Entry Using Macros and DLOOKUP Functions 00:09:00 Module 32: Using Conditional Formatting 00:04:00 Module 33: Working with the New Label Name Property 00:02:00 Module 34: Organising Form Fields with Tab Controls 00:05:00 Module 35: Creating an Option Group Control 00:06:00 Module 36: Creating a Combo Box Control 00:05:00 Module 37: Configuring a Combo Box Control to Show Search Results 00:04:00 Module 38: Using a Subform to Show Data from a Related Table 00:05:00 Module 39: Inserting a Chart on a Report 00:07:00 Module 40: Showing Data in Columns 00:08:00 Module 41: Inserting a Subreport 00:04:00 Module 42: Configuring Reports with Parameter Queries 00:05:00 Module 43: Sending Reports 00:02:00