Overview This comprehensive course on Complete SAP UI5 Development will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete SAP UI5 Development comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. 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 Complete SAP UI5 Development. It is available to all students, of all academic backgrounds. Requirements Our Complete SAP UI5 Development is fully compatible with PC's, Mac's, Laptop, Tablet 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 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 8 sections • 39 lectures • 08:22:00 total length •Module 01: Introduction: 00:01:00 •Module 02: Tools for this Course: 00:03:00 •Module 01: HTML Introduction: 00:16:00 •Module 02: CSS and CSS Selectors: 00:17:00 •Module 03: CSS Box Model: 00:11:00 •Module 04: CSS Layout Flexbox and Grid: 00:18:00 •Module 05: CSS Responsive Design Concept: 00:06:00 •Module 01: Data Types and Operations: 00:34:00 •Module 02: Functions: 00:13:00 •Module 03: Conditions and Loops: 00:19:00 •Module 04: Promise and Async await: 00:16:00 •Module 05: Events: 00:08:00 •Module 01: Load UI5 Libraries: 00:17:00 •Module 02: Views and Controllers: 00:27:00 •Module 03: Component and Descriptor: 00:12:00 •Module 04: JSON Model and Data Binding: 00:14:00 •Module 05: Layout: 00:14:00 •Module 06: Data Format and Icons: 00:14:00 •Module 07: MVC in UI5: 00:05:00 •Module 01: SAP Web IDE and SAP Fiori Launchpad Introduction: 00:11:00 •Module 02: Migrate Project to SAP Web IDE: 00:17:00 •Module 03: Resource Model and Multi-language Support: 00:11:00 •Module 04: Fragments and Dialog: 00:20:00 •Module 05: Routing and Navigation: 00:23:00 •Module 06: Device API: 00:12:00 •Module 01: Use Rest API: 00:07:00 •Module 02: OData Service Introduction: 00:12:00 •Module 03: Use OData Service V2: 00:14:00 •Module 04: Sort and Filter Data: 00:14:00 •Module 05: Create Update Delete Read with OData Service V2: 00:14:00 •Module 06: Use OData Service V4: 00:06:00 •Module 07: Create Update Delete and Auto Data Type Detection with OData Service V4: 00:13:00 •Module 08: Action and Function Binding in OData Service V4: 00:08:00 •Module 09: Troubleshooting: 00:11:00 •Module 01: SAP Fiori Launchpad Core Concept: 00:06:00 •Module 02: Deploy to SAP Cloud Platform: 00:12:00 •Module 03: Deploy to SAP Gateway System: 00:22:00 •Module 04: Deploy to non-SAP Environment: 00:04:00 •Assignment - Complete SAP UI5 Development: 00:00:00
24-Hour Flash Sale! Prices Reduced Like Never Before!! Level 2 Certificate in Principles of Business Administration Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Did you know that 82% of UK businesses report difficulties finding qualified staff with the right skills? With over 5.5 million SMEs in the UK, demand for business leadership has surged and If you want to effectively utilise this opportunity and manage teams, operations and strategy, then this Level 2 Certificate in Principles of Business Administration bundle delivers the expertise today's organisations need. From Project Management and Product Management to Financial Analysis and proposals, gain comprehensive business abilities. Understand core principles around Operations, Administration, Management and more. Build Strategic Plans and Process Improvements that drive results. Lead with agility while ensuring Business Etiquette and Communication finesse. Courses Are Included In This Level 2 Certificate in Principles of Business Administration Bundle: Course 01: Level 2 Certificate in Principles of Business Administration Course 02: Advanced Diploma in Business Management at QLS Level 7 Course 03: Business Plan for Entrepreneurs Course 04: Agile Project Management Course 05: Workplace Performance Management Course 06: Diploma in Operations Management Course 07: Research Methods in Business Course 08: Strategic Business Management Course 09: Change Management Course 10: Corporate Paralegal Course 11: Diploma in Business Proposal Writing Course 12: Business Improvement Course 13: Internal Audit Skills Course 14: International Business Principles Course 15: Level 3 Diploma in Business Etiquette Course 16: Product Management Course 17: Financial Analysis Course Course 18: Capital Budgeting & Investment Decision Rules Course 19: Managerial Accounting Training Course 20: Certificate in Purchasing and Procurement Course 21: Sales Skills Course Course 22: Negotiation Skills Certificate Course 23: Retail Management Skills Course 24: Delegation Skills Training Course 25: Presentation Skills Guideline Course 26: Customer Service Training Course 27: Visual Merchandising Diploma Course 28: Strategic Marketing & Planning Course 29: Compliance Officer Training Level 3 Course 30: Workplace Confidentiality Joining in on this Level 2 Certificate in Principles of Business Administration is more than just taking an online course; it's an investment in your future. By completing this bundle, you'll not only gain invaluable skills but also open doors to new career opportunities and advancements, boosting your earning potential. Enrol on this course today and take the first step towards achieving your goals and dreams in Business Administration! Learning Outcomes of Level 2 Certificate in Principles of Business Administration Gain a solid foundation in business administration principles. Develop strategic thinking and decision-making skills. Master essential project management methodologies. Become an effective communicator and leader. Learn to write impactful business plans and proposals. Gain confidence in navigating the global business environment. With this Level 2 Certificate in Principles of Business Administration course, you will get 30 CPD Accredited PDF Certificates, Hardcopy Certificate of 1st Course and our exclusive student ID card absolutely free. Why Prefer this Course? Get a Free CPD Accredited 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 with our Level 2 Certificate in Principles of Business Administration Training! This premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of this course is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Course 01: Level 2 Certificate in Principles of Business Administration Module 01: What is Business Administration? Module 02: Business and Organisations Module 03: Management of Business Module 04: Business Organization Perspectives Module 05: Decision Making Module 06: Approaches to Leadership Module 07: Management Module 08: Definition of Management Module 09: Characteristics of Management Module 10: Management Functions/Process of Management Module 11: Nature of Management Module 12: Levels of Management Module 13: Characteristics of Professional Managers Module 14: Principles of Management Module 15: What Is Payroll? Module 16: Principles Of Payroll Systems Module 17: Confidentiality And Security Of Information Module 18: Effective Payroll Processing Module 19: Increasing Payroll Efficiency Module 20: Risk Management in Payroll Module 21: Time Management Module 22: Personnel Filing Module 23: When Workers Leave Employment Module 24: Hiring Employees Module 25: Paye and Payroll for Employers Module 26: Tell HMRC about a New Employee Module 27: Net And Gross Pay Module 28: Statutory Sick Pay Module 29: Minimum Wage for Different types of Work Course 02: Advanced Diploma in Business Management at QLS Level 7 Module 01: Introduction to Business Management Module 02: Operations Management Module 03: Introduction to Business Analysis Module 04: Strategic Analysis and Product Scope Module 05: Project Management Module 06: Business Development and Succession Planning Module 07: Business Process Management Module 08: Planning & Forecasting Operations Module 09: Performance Management Module 10: Management of Cash and Credit Module 11: Managing Risk and Recovery Module 12: Quality Management Module 13: Communication Skills Module 14: Business Environment Module 15: Organisational Skills Module 16: Negotiation Techniques Module 17: Human Resource Management Module 18: Motivation and Counselling Module 19: Customer Service Module 20: Time Management Module 21: Conflict Management Course 03: Business Plan for Entrepreneurs Module 01: Add Navigation Links and Copyright Module 02: Things to Consider Before Starting a Business Plan Module 03: The Elements of a Business Plan Module 04: Who Are You Writing the Business Plan For Module 05: The Purpose of a Business Plan Module 06: How a Business Plan Can Help with Long Term Success Module 07: Adding Container for iScroll and Google Map Module 08: Reasons You Need a Business Plan Module 09: The Conclusion To The Course =========>>>>> And 27 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*30 = £390) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) CPD 470 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 bundle. This bundle is ideal for: Aspiring business leaders Senior management staff Project managers Business consultants Operations managers Administrative professionals Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Business Administrator: £30,000 - £60,000 Project Manager: £35,000 - £70,000 Business Consultant: £40,000 - £100,000 Operations Manager: £30,000 - £70,000 Senior Executive: £50,000 - £120,000 Certificates CPD Accredited Digital Certificate Digital certificate - Included 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. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.
Overview In today's interconnected world, the art of seamless communication takes importance. Enter the realm of 'Zoom Meeting Course', your passport to mastering the dynamics of virtual interaction. Navigate the digital maze confidently, from understanding the core of Zoom to embracing its extensive features, ensuring you're equipped to face any online meeting challenge. Engage yourself in a meticulously crafted course curriculum, each module unravelling a layer of Zoom tailored to empower your digital communication journey. With the online ecosystem evolving, why stay behind? Leap forward with the prowess of Zoom under your belt. Learning Outcomes Learn the fundamental concepts and benefits associated with Zoom Meetings. Learn techniques to bolster security during virtual interactions. Develop the proficiency to create and manage personal Zoom accounts. Learn the distinct duties and navigation methods for both hosts and participants. Diving into the broader functionalities of Zoom, such as webinars, ensuring a holistic understanding. Why buy this ZOOM Meeting Course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the ZOOM Meeting Course there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This ZOOM Meeting Course is ideal for Enthusiasts eager to comprehend contemporary virtual platforms. Tutors aiming for flawless online teaching sessions. Business leaders focusing on enhanced remote coordination. Individuals yearn for protected digital interactions with peers or loved ones. Visionaries planning to venture into the world of webinars. Prerequisites This ZOOM Meeting Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This ZOOM Meeting Course 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. Career path Virtual Collaboration Specialist - Average Salary: £32,000 - £42,000 Per Year Remote Engagement Coordinator - Average Salary: £28,000 - £38,000 Per Year Online Instruction Facilitator - Average Salary: £27,000 - £37,000 Per Year Digital Meeting Strategist - Average Salary: £35,000 - £45,000 Per Year Webinar Organiser - Average Salary: £30,000 - £40,000 Per Year Virtual Security Consultant - Average Salary: £40,000 - £52,000 Per Year Course Curriculum ZOOM Meeting Course Module 01: Introduction 00:02:00 Module 02: What is Zoom Meeting? 00:03:00 Module 03: Why Use Zoom? 00:02:00 Module 04: Tighter Security 00:06:00 Module 05: Create Zoom Account 00:02:00 Module 06: Navigating Zoom as a Participant 00:03:00 Module 07: Scheduling a Meeting 00:04:00 Module 08: Navigating Zoom as the Host 00:07:00 Module 09: Live on Zoom as a Participant 00:05:00 Module 10: Live on Zoom as a Host 00:07:00 Module 11: Zoom Webinar Introduction 00:02:00 Module 12: Closing Remarks 00:01:00 Assignment Assignment - ZOOM Meeting Course 00:00:00
Build modern responsive websites and UIs with Sass, and get started with exploring Flex and CSS Grid
Description: Nowadays data management is absolutely crucial, and there's not much room for error. If you've already taken the basic Microsoft Access 2013 course, or know your way around the program already, then you're ready for this advanced level of Microsoft Access 2013. This Microsoft Office 2013 Access Advanced - Complete Video Course covers advanced functions and features of Access 2013. You will learn about implementing advanced form design, using data validation and using macros to improve user interfacer design. You will also learn how to use advanced database management, distribute and secure a database and manage switchboards. If you want to take your Microsoft Access 2013 skills to the next level, you'll learn how to use this program's advanced features to build a fully functional database from scratch. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 Access Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Microsoft Office 2013 Access Advanced - Complete Video Course 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Implementing Advanced Form Design Add Controls to Forms FREE 00:22:00 Create Subforms 00:03:00 Organize Information with Tabs Pages 00:05:00 Enhance Navigation of Forms 00:06:00 Apply Conditional Formatting 00:05:00 Using Data Validation Field and Record Validation 00:23:00 Form Validation 00:08:00 Using Macros to Improve User Interface Design Create a Macro 00:17:00 Restrict Records Using a Condition 00:05:00 Validate Data Using a Macro 00:06:00 Automate Data Entry Using a Macro 00:06:00 Convert a Macro to VBA 00:05:00 Using Advanced Database Management Link Tables to External Data Sources 00:05:00 Manage a Database 00:07:00 Determine Object Dependency 00:05:00 Document a Database 00:05:00 Analyze the Performance of a Database 00:05:00 Distributing and Securing a Database Splitting a Database for Multiple User Access 00:05:00 Implement Security 00:09:00 Set Passwords 00:07:00 Convert an Access Database to an ACCDE File999 00:07:00 Analyze the Performance of a Database 00:04:00 Managing Switchboards Create a Database Switchboard 00:07:00 Modify a Database Switchboard 00:04:00 Set Startup Options 00:06:00 Mock Exam Mock Exam- Microsoft Office 2013 Access Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Access Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
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!
Overview This comprehensive course on CSS Coding will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This CSS Coding comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. 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 CSS Coding. It is available to all students, of all academic backgrounds. Requirements Our CSS Coding is fully compatible with PC's, Mac's, Laptop, Tablet 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 7 sections • 67 lectures • 06:25:00 total length •Getting Started: 00:02:00 •Course Curriculum: 00:04: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 •Introduction CSS: 00:06:00 •Choosing Code Editor: 00:03:00 •Installing Code Editor (Sublime Text): 00:04:00 •CSS Syntax: 00:05:00 •Creating a first page with CSS Style: 00:13:00 •Summary: 00:02:00 •Introduction: 00:03:00 •Inline CSS: 00:06:00 •Internal CSS: 00:05:00 •External CSS: 00:10:00 •CSS Classes: 00:09:00 •CSS IDs: 00:06:00 •Colors: 00:08:00 •Backgrounds: 00:04:00 •Floating: 00:09:00 •Positioning: 00:06:00 •Margins: 00:07:00 •Padding: 00:04:00 •Borders: 00:03:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Styling Text: 00:07:00 •Aligning Text: 00:04:00 •Styling Links: 00:10:00 •Font Family: 00:07:00 •Font Styles: 00:03:00 •Applying Google Fonts: 00:07:00 •Box Model: 00:09:00 •Icons: 00:09:00 •Tables: 00:16:00 •Navigation-Menu: 00:11:00 •Dropdowns: 00:15:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Advanced Selectors: 00:05:00 •Forms: 00:17:00 •Website Layout: 00:21:00 •Rounded Corners: 00:08:00 •Color Keywords: 00:06:00 •Animations: 00:08:00 •Pseudo Classes: 00:03:00 •Gradients: 00:03:00 •Shadows: 00:03:00 •Calculations: 00:05:00 •Creating Responsive Page: 00:06:00 •Summary: 00:02:00 •Introduction: 00:01:00 •Button Styles: 00:06:00 •Pagination: 00:07:00 •Multiple Columns: 00:06:00 •Image Reflection: 00:03:00 •UI - UX Design: 00:09:00 •Social Media Icons: 00:08:00 •External CSS Style adding: 00:06:00 •Coding Exercise: 00:01:00 •Solution for Coding Exercise: 00:03:00 •Summary: 00:02:00 •Section Introduction: 00:01:00 •CSS Project Getting: 00:05:00 •CSS Project Overview: 00:08:00 •Summary: 00:01:00
MOS Core Excel - 77-727 : Complete Techniques for Exam Success
Embark on a transformative journey into the realm of app creation with our course, 'Master the Basics of Microsoft Power Apps.' Unleash your creativity and empower yourself to build dynamic, functional apps without the need for complex coding. The course begins with a seamless introduction to Power Apps, guiding you through the process of creating a data source in Excel and crafting your very own app. Dive into the intricacies of app previewing, tree view navigation, and property editing, gaining the confidence to shape your digital ideas into reality. With lessons on actions, screen insertion, and app distribution, this course ensures you master the fundamentals of Power Apps effortlessly. Whether you're a budding entrepreneur, a tech enthusiast, or someone with a passion for innovation, this course is your gateway to app development excellence. Learning Outcomes Gain a solid understanding of Microsoft Power Apps, from setup to app creation. Create and manage data sources seamlessly using Excel, enhancing your app's functionality. Navigate through the app creation process, mastering features like tree view and property editing. Develop the skills to insert new items, screens, and define actions for a dynamic user experience. Learn how to save, distribute, and even adapt your app for mobile usage, ensuring its accessibility across platforms. Why choose this Master the Basics of Microsoft Power Apps course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the 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. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Master the Basics of Microsoft Power Apps course for? Aspiring entrepreneurs looking to create their own apps without extensive coding. Individuals interested in exploring the world of app development in a user-friendly environment. Small business owners seeking cost-effective solutions for digital tools. Students and beginners in tech eager to delve into app creation. Innovators and dreamers with ideas waiting to be turned into functional applications. Career path App Developer: £30,000 - £50,000 Business Solutions Analyst: £35,000 - £55,000 Entrepreneur/Startup Founder: Earnings vary based on business success Digital Innovation Specialist: £35,000 - £55,000 IT Consultant: £40,000 - £60,000 Technology Solutions Architect: £45,000 - £70,000 Prerequisites This Master the Basics of Microsoft Power Apps does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Master the Basics of Microsoft Power Apps 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 Master The Basics Of Microsoft Power Apps Lesson 01: Get Power Apps 00:05:00 Lesson 02: Create Excel Data Source 00:02:00 Lesson 03: Creating the App 00:02:00 Lesson 04: Previewing the App 00:06:00 Lesson 05: Tree View 00:03:00 Lesson 06: Edit Properties 00:04:00 Lesson 07: Insert New Item 00:03:00 Lesson 08: Insert New Screen 00:04:00 Lesson 09: Actions 00:08:00 Lesson 10: Additional Options 00:01:00 Lesson 11: Save and Distribute the App 00:04:00 Lesson 12: Mobile App 00:02: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