630 Courses

Description: This Microsoft Office 2013 Word Intermediate - Complete Video Course series covers the intermediate functions and features of Word 2013. It will provide you with sufficient 2013 Word Intermediate skills to create sophisticated analytical spreadsheets and master advanced formulae. By this course you will learn about working with tables and charts, customizing formats, using images and creating graphics. You will also learn how to use Quick Parts, controlling text flow, and using templates, mail merge and macros. Learn to use Word 2013's advanced editing tools, work with images, including placing and sizing images, wrapping text around images, and using borders and effects, adjust page orientation and layout, work with columns, work with page and section breaks, document views, using the navigation pane, and viewing multiple windows. If you want to take your Microsoft Word 2013 skills to the next level, you should join this course now. 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 Word Intermediate - 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 Word Intermediate - 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. Working with Tables and Charts Sort Table Data FREE 00:05:00 Control Cell Layout 00:09:00 Perform Calculations in a Table 00:09:00 Create a Chart 00:08:00 Customizing Formats Using Styles and Themes Create and Modify Text Styles 00:17:00 Create Custom List or Table Styles 00:09:00 Apply Document Themes 00:06:00 Using Images in a Document Resize an Image 00:08:00 Adjust Image Appearance 00:17:00 Integrate Pictures and Text 00:15:00 Insert and Format Screenshots 00:05:00 Insert Video 00:05:00 Creating Custom Graphic Elements Create Text Boxes and Pull Quotes 00:10:00 Draw Shapes 00:05:00 Add WordArt and Other Text Effects 00:05:00 Create Complex Illustrations with SmartArt 00:06:00 Inserting Content Using Quick Parts Insert Building Blocks 00:09:00 Create and Modify Building Blocks 00:06:00 Insert Fields Using Quick Parts 00:11:00 Controlling Text Flow Control Paragraph Flow 00:07:00 Insert Section Breaks 00:10:00 Insert Columns 00:07:00 Link Text Boxes to Control Text Flow 00:06:00 Using Templates Create a Document Using a Template 00:08:00 Create a Template 00:08:00 Using Mail Merge The Mail Merge Features 00:22:00 Merge Envelopes and Labels 00:06:00 Create a Data Source Using Word 00:05:00 Using Macros Automate Tasks Using Macros 00:08:00 Create a Macro 00:09:00 Mock Exam Mock Exam- Microsoft Office 2013 Word Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Word Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview This comprehensive course on Adobe Illustrator CC Masterclass will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Adobe Illustrator CC Masterclass 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 Adobe Illustrator CC Masterclass. It is available to all students, of all academic backgrounds. Requirements Our Adobe Illustrator CC Masterclass 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 10 sections • 54 lectures • 05:26:00 total length •Learning Objectives: 00:03:00 •Understanding Raster: 00:03:00 •A Crash Course In Graphic File Formats: 00:05:00 •Opening, Creating and Working with Multiple Documents: 00:10:00 •A Tour Of The Illustrator Interface: 00:10:00 •Customizing The Illustrator Environment: 00:09:00 •Saving Saving Interface Workspaces: 00:03:00 •Zooming and Navigation Techniques: 00:11:00 •Using Illustrator's Outline Mode: 00:02:00 •Using the Selection Tool: 00:05:00 •Using the Direct Selection Tool: 00:05:00 •Free-Handing Selections With The Lasso Tool: 00:04:00 •Selecting Objects Based On Colour: 00:05:00 •Advanced Selection Techniques: 00:05:00 •Saving and Reloading Selections: 00:04:00 •Drawing Rectangles and Squares: 00:08:00 •Drawing Ovals and Circles: 00:02:00 •Drawing Rounded Rectangles, Polygons and Stars: 00:07:00 •Drawing Lines, Arcs and Grids: 00:05:00 •Drawing With The Pencil Tool (And Erasing Mistakes): 00:06:00 •Understanding Vector Paths: 00:03:00 •Introducing Illustrator Brushes: 00:09:00 •Using The Blob Brush: 00:06:00 •Moving And Duplicating Objects: 00:05:00 •Scaling, Rotating, Reflecting, Sheering: 00:09:00 •Precisely Transforming And Positioning Objects: 00:07:00 •Precise Positioning Using The Transform Panel: 00:05:00 •Automatically Calculating In The Transform Panel: 00:04:00 •Controlling Stacking Order: 00:03:00 •Grouping And Ungrouping Objects: 00:05:00 •Locking And Hiding: 00:04:00 •Aligning And Spacing Objects Apart: 00:06:00 •Aligning To A Key Object: 00:02:00 •Methods For Applying Fills And Strokes: 00:11:00 •Setting Stroke Options: 00:05:00 •Creating A Dashed Outline Effect: 00:04:00 •Exploring Illustrator's Swatch Libraries: 00:06:00 •Mixing And Saving Custom Colours: 00:08:00 •Creating, Saving, And Using Custom Gradients: 00:11:00 •Filling Objects With Patterns: 00:04:00 •Copying Fills And Strokes: 00:05:00 •Creating Point And Area Type: 00:06:00 •Importing Large Amounts Of Text: 00:07:00 •Formatting Text: 00:11:00 •Area Type Options: 00:04:00 •Creating Type on a Path: 00:06:00 •Converting Text To Shapes: 00:03:00 •Introducing Layers: 00:09:00 •Using Illustrator's Pathfinders: 00:06:00 •Applying Special Effects: 00:12:00 •Exploring The Appearance Pane: 00:07:00 •Saving Your Work In Different File Formats: 00:08:00 •Saving Your Work For The Web: 00:08:00 •Where to Go From Here: 00:05:00

Become efficient on the basic functionalities of SAP UI5 with the SAP UI5 Development Complete Course. Learn web

Supercharge your career with our comprehensive RPA UiPath developer course and dive into real projects to master UiPath, gain unwavering confidence, and pave your way to success. Elevate your career prospects with access to an extensive resource of 100+ RPA UiPath interview questions and become a highly proficient RPA expert today.

The RYA Yachtmaster Fast Track Online Theory Course is an online theory course designed to suit those who have a lot of experience at sea but have no formal qualifications. Alternatively, perhaps you have completed the Day Skipper course but your skills are a little rusty and underused. The RYA Yachtmaster Course Fast Track course will provide a little more background on each topic before moving onto the advanced skills of the Yachtmaster syllabus.

Embark on a transformative journey into the heart of collaborative digital workplaces with our dynamic course, 'Learn the Fundamentals of Microsoft SharePoint.' Unveil the power of SharePoint as you traverse through meticulously crafted lessons, each a key to unlocking the full potential of this versatile platform. From creating seamless team sites to integrating with Microsoft Teams, this course is your gateway to mastering SharePoint's intricacies. Dive into the world of web part customization, site management, and effective collaboration, ensuring that every minute spent in this course adds a valuable layer to your skill set. Whether you're a budding professional or a seasoned enthusiast, join us in demystifying SharePoint and reshaping the way you collaborate and manage content. Learning Outcomes Gain a comprehensive understanding of SharePoint's core features and functionalities. Master the art of creating and customizing team sites, fostering efficient collaboration. Explore advanced concepts like web part addition, layout editing, and section customization. Learn to seamlessly integrate Microsoft Teams with SharePoint for enhanced communication. Acquire the skills to manage site access, create news posts, and utilize SharePoint as a communication hub. Why choose this Learn the Fundamentals of Microsoft SharePoint 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 Learn the Fundamentals of Microsoft SharePoint course for? Professionals aiming to enhance their digital collaboration skills. Individuals seeking a comprehensive grasp of Microsoft SharePoint fundamentals. Team leaders looking to optimize team sites and streamline content management. Project managers wanting to leverage SharePoint for efficient project collaboration. Anyone interested in harnessing the power of Microsoft Teams and SharePoint integration. Career path SharePoint Administrator: £30,000 - £50,000 Digital Collaboration Specialist: £35,000 - £55,000 Project Manager (SharePoint): £40,000 - £60,000 IT Support Specialist: £25,000 - £45,000 Business Analyst (Collaboration Tools): £35,000 - £55,000 Information Architect: £45,000 - £70,000 Prerequisites This Learn the Fundamentals of Microsoft SharePoint does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Learn the Fundamentals of Microsoft SharePoint 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 Learn The Fundamentals Of Microsoft PowerPoint Lesson 01: What is Sharepoint? 00:02:00 Lesson 02: The SharePoint LookBook 00:02:00 Lesson 03: Getting Sharepoint and home page overview 00:02:00 Lesson 04: Create a new team site 00:03:00 Lesson 05: Team site home page 00:02:00 Lesson 06: Uploading files 00:03:00 Lesson 07: Creating a New List 00:06:00 Lesson 08: Adding web parts 00:04:00 Lesson 09: Reorganising and customising web parts 00:02:00 Lesson 10: Republish the team site 00:01:00 Lesson 11: Add members to the team site 00:02:00 Lesson 12: Microsoft Teams & SharePoint integration 00:06:00 Lesson 13: Create a new communication site 00:02:00 Lesson 14: Add countdown timer web part 00:03:00 Lesson 15: Edit web part layouts 00:02:00 Lesson 16: Edit sections 00:03:00 Lesson 17: Add Youtube web part 00:01:00 Lesson 18: Change page look and edit top navigation 00:03:00 Lesson 19: Create a News post 00:03:00 Lesson 20: Manage Site Access 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 With a single payment you will gain access to Learning Computers and Internet Level 2 including 10 Career development courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Learn the basics of Computer Operations and make sure your career prospects and social interactions are in the 21st Century. Don't feel left behind in the changing world of technology. By taking this innovative course, you'll soon become skilled in using the Internet and your online device. This Learning Computers and Internet Level 2course provides all the information and tips that you will need to go online and gather new skills to boost your career and lifestyle. You will be taught a multitude of abilities, including accessing the Cloud, fixing files, stopping viruses, customising your keyboard, and so much more. Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Learning Computers and Internet Level 2 will provide you with the CPD certificate that you'll need to succeed. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. Learning Computers and Internet Level 2 has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take Learning Computers and Internet Level 2 is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Benefits you'll get choosing Apex Learning for this Learning Computers and Internet Level 2: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught 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 Gain valuable knowledge without leaving your home What other courses are included with this Learning Computers and Internet Level 2? Level 2 Microsoft Office Essentials Microsoft Teams Leadership & Management Diploma Working from Home Essentials Mental Health and Working from Home Online Meeting Management Effective Communication Skills Time Management Report Writing Emotional Intelligence and Human Behaviour Course Curriculum of Learning Computers and Internet Level 2 Module 01 : Computer Operating and Troubleshooting What is an Operating System Configuring the Operating System What is an Application Using Control Panel Hardware and Peripherals Storage Connectivity Devices Network Components Software and Concepts Licensing Using Software Software Tools Software Hardware, Devices, and Peripherals Backup and Restore Module 02 : Internet and Computing - Key Applications Application Features Working with Word Processing Working with Spreadsheets Making a Presentation Databases Collaboration Module 03 : Internet and Computing - Tools & Networking Course Introduction Web Browsers Networking Terminology E-mail Communicating in the Modern World Protecting Yourself Web Searching Protecting Yourself Module 04 : Windows 8 for PC Identify Components of a Personal Computer IPU Sign In to Windows 8 Signing In to Windows 8 and Managing Tiles Navigate the Start Screen Using the Account ID Menu Access and Identify the Charms Viewing the Charms Modern Apps and Common Navigation Features Navigating a Modern App Multitasking with Apps Working with Multiple Apps Navigate the Desktop IPU Navigating The desktop Manage Files and Folders with File Explorer IPU Managing Files and Folders Elements of a Desktop Window Working with the Elements of a Desktop Window Creating and Modifying Files with Wordpad Printing a Document Navigate Internet Explorer 10 Navigating Internet Explorer 10 Browse the Web Using Internet Explorer and Share Customize the Start Screen Creating Groups on the Start Screen Changing PC Setting Customize the Desktop IPU Personalizing the Desktop Set Privacy Levels and Passwords Changing Your Password Use Windows Defender IPU Changing Windows Defender Settings Store and Share Files with SkyDrive Module 05 : Windows 10 - New Developments What Makes Windows 10 Different? Primary Feature Overview Navigating and Using Windows 10 Module 06 : Cyber Security Awareness Course Overview Types of Security Threats Social Engineering Identity Theft Data Classification Types of Classifications Protecting Your Digital Information Password Management Malware Software Detection Security from End-to-End Secure E-mail Use Secure Web Browsing Piracy Security Policies Moving Forward 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 £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery inside the U.K. is Free. International students have to pay a £3.99 postal charge. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Learning Computers and Internet Level 2. It is available to all students, of all academic backgrounds. Requirements 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 CPD certificate 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. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Computer Operating and Troubleshooting) 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.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that 52% of UK employers cite poor digital functional skills as a barrier to recruitment? Or that effective communication and presentation skills can boost your salary by 15%? In a world increasingly driven by technology, honing your functional skills is no longer optional; it's crucial for career success. This Functional Skills: IT, CSS & Office Administration Bundle equips you with the essential tools to thrive in the digital age. From mastering essential IT skills and web development fundamentals to acing office administration and presentation techniques, this comprehensive Functional Skills package empowers you to become a well-rounded professional, ready to tackle any challenge. This Functional Skills: IT, CSS & Time Management Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Essential IT Skills Level 2 Course 02: Fundamentals of CSS Course 03: Office Administration & Skills Diploma Course 04: Time Management Investing in yourself is the smartest investment you can make. This Functional Skills: IT, CSS & Office Administration bundle is your passport to a brighter career future. Don't wait! Enrol today in our Functional Skills: IT, CSS & Office Administration bundle and watch your confidence and opportunities soar. Learning Outcomes of Functional Skills: IT, CSS & Office Administration Gain proficiency in essential IT skills for workplace applications. Master CSS fundamentals for creating visually stunning web designs. Develop comprehensive office administration and management skills. Acquire effective time management strategies for increased productivity. Enhance problem-solving and critical thinking abilities in IT. Understand web development principles and best practices. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Functional Skills: IT Get a free student ID card with Functional Skills: IT Training program (£10 postal charge will be applicable for international delivery) The Functional Skills: IT is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Functional Skills: IT course materials The Functional Skills: IT comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Essential IT Skills Level 2 Module 01: Introduction: A Transforming Technology Module 02: Importance of Information Technology Module 03: Communication and Network Module 04: Future Skills Required in Information Technology Module 05: Technology as a Foundation Skill Area Module 06: Word Processing Software Module 07: Presentation Software Module 08: Creating and Editing Spreadsheet (Part 1: The Basics of Spreadsheets) Module 09: Creating and Editing Spreadsheet (Part 2: Navigation and Edit) Module 10: Storing Database Module 11: Information Technology Project Management Course 02: Fundamentals of CSS Unit 01: CSS In Context Module 01: What Was CSS Originally Intended To Do? Module 02: DEMO: The Most Basic CSS Usage Module 03: Responsive Design Module 04: Chapter Summary Unit 02: Overview Of CSS Module 01: What is CSS? Module 02: Where Can You Find CSS? Module 03: What CSS Can and Can't Do Module 04: Optional Demo - Serving an HTML Application Module 05: How Do we Add CSS to a Website? Unit 03: Styling HTML Elements With CSS Module 01: Why do We Style CSS Elements? Module 02: CSS and Fonts Module 03: DEMO: Styling Text with CSS Module 04: Sizing HTML Elements with CSS Module 05: DEMO: Sizing HTML Elements with CSS Unit 04: Arranging Elements With CSS Module 08: Summary of this Chapter Module 01: Introduction Module 02: Adding Margin with CSS Module 03: Advanced Positioning with CSS Module 04: DEMO: Positioning Elements Absolutely and Relatively Module 05: Positioning HTML Elements with Float Course 03: Office Administration & Skills Diploma Module 01: Personal Assistant Module 02: Admin Support Module 03: Administrative Management Module 04: Organisational Skills Module 05: Telephone Etiquette Module 06: Business Writing Module 07: Time Management Module 08: Body Language And Effective Communication Module 09: Meeting Management Module 10: Excel Basics Module 11: PowerPoint Basic Course 04: Time Management Module 01: Importance And Benefits Of Time Management Module 02: Assess Your Current Work Practice Module 03: Identify The Priorities Module 04: Overcome Procrastination Module 05: Set Your Goals Module 06: Plan The Work And Work The Plan Module 07: Effective Time Management Techniques Module 08: The Art Of Anticipating 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*4 = £51) CPD Hard Copy Certificate: £29.99 CPD 40 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: IT, CSS & Office Administration bundle. This bundle is ideal for: Office professionals School leavers Job seekers Anyone seeking in-demand skills Requirements You will not need any prior background or expertise to enrol in this Functional Skills: IT, CSS & Office Administration bundle. Career path After completing this Functional Skills: IT, CSS & Office Administration bundle, you are to start your career or begin the next phase of your career. Admin Assistant IT Support Web Developer Project Manager Office Manager Business Analyst 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 - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.

Duration 4 Days 24 CPD hours This course is intended for Application Consultants, Developers, System Administrators, and System Architects Overview Understand the need for an enterprise portalLog on to, navigate, and personalize the portalDescribe the components of SAP Enterprise PortalBuild-up a portal navigation structureAdapt the portal user interface to company specificationsExplain and use the main functions of the SAP Enterprise Portal, Knowledge Management and CollaborationExplain and use the community features of the portal add-ons Forums and WikisExplain and use the SAP Fiori Launchpad on Portal' In this course, students will gain knowledge of the basic fundamentals surrounding the SAP Enterprise Portal. Enterprise Portal Explaining Business Motivations for Portals Describing SAP NetWeaver Explaining the Basics of SAP Enterprise Portal The End User's Perspective Logging On and Navigating in SAP Enterprise Portal Personalizing SAP Enterprise Portal Technical Infrastructure Determining System Requirements Outlining SAP Enterprise Portal's Architecture Portal Platform Content Explaining the Object Model for Portal Content Managing iViews Managing Portal Pages Managing Worksets and Portal Roles Explaining Business Packages Outlining Portal Content Development Tools Translating Portal Content Look and Feel of the Portal Managing Portal Themes Managing Framework Pages Managing Portal Desktops Managing Portal Rules (Rule Collections) Security Aspects Identifying Security Aspects Managing Users and Authentication Options Describing Authorization Concepts Describing Single Sign-On (SSO) Evaluating Network Security Knowledge Management (KM) Outlining Knowledge Management (KM) Describing Content Management (CM) Functions Using Web Page Composer (WPC) Describing Search and Classification (TREX) Enterprise Workspaces Explaining Enterprise Workspaces Managing Personal Workspaces Managing Shared Workspaces Collaboration Outlining Collaboration Functions Using Forums Using Wikis Fiori Launchpad on the Portal Outlining SAP Fiori Launchpad on Portal Additional course details: Nexus Humans SAPEP SAP Enterprise Portal - Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SAPEP SAP Enterprise Portal - Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Office 365. Overview In this course, you will optimize an Access database. You will: Provide input validation features to promote the entry of quality data into a database. Organize a database for efficiency and performance, and to maintain data integrity. Improve the usability of Access tables. Create advanced queries to join and summarize data. Use advanced formatting and controls to improve form presentation. Use advanced formatting and calculated fields to improve reports. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 365 and Office 2019): Exam MO-500 certification. Improving Table Usability Topic A: Create Lookups Within a Table Topic B: Work with Subdatasheets Creating Advanced Queries Topic A: Create Query Joins Topic B: Create Subqueries Topic C: Summarize Data Improving Form Presentation Topic A: Apply Conditional Formatting Topic B: Create Tab Pages with Subforms and Other Controls Creating Advanced Reports Topic A: Apply Advanced Formatting to a Report Topic B: Add a Calculated Field to a Report Topic C: Control Pagination and Print Quality Topic D: Add a Chart to a Report Importing and Exporting Table Data Topic A: Import and Link Data Topic B: Export Data Topic C: Create a Mail Merge Using Queries to Manage Data Topic A: Create Action Queries Topic B: Create Unmatched and Duplicate Queries Creating Complex Reports and Forms Topic A: Create Subreports Topic B: Create a Navigation Form Topic C: Show Details in Subforms and Popup Forms Creating Access Macros Topic A: Create a Standalone Macro to Automate Repetitive Tasks Topic B: Create a Macro to Program a User Interface Component Topic C: Filter Records by Using a Condition Topic D: Create a Data Macro Using VBA to Extend Database Capabilities Topic A: Introduction to VBA Topic B: Using VBA with Form Controls Managing a Database Topic A: Back Up a Database Topic B: Manage Performance Issues Topic C: Document a Database Distributing and Securing a Database Topic A: Split a Database for Multiple-User Access Topic B: Implement Security Topic C: Convert an Access Database to an ACCDE File Topic D: Package a Database with a Digital Signature