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.
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.
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
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.
Description Learn the advanced features and options of PDF by enrolling the Adobe Acrobat DC Pro Foundation course. At first, the process of creating and closing the PDF document will be discussed. Throughout the course, you will learn how to access, create, and navigate PDFs. You will learn how to create a PDF from Word, Excel, Photoshop or other application. The usage of bookmarks, scrolling and setting or the whole process of navigating will be shown. The course also guides you the procedures for reviewing, modifying and organizing the PDFs. These will help you to improve your PDFs by reading the reviews of others or by minimizing or optimizing the file size. Finally, the course shows you how to export and protect your PDFs. If you need to convert a PDF into Excel or word, you can do that by studying the export session. The system of creating a password or blocking any other edit in the file will be explained in the session protecting PDFs. In short, the course covers all the advanced areas that you need to know for editing, modifying or securing your PDF file. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? Adobe Acrobat DC Pro Foundation 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 Adobe Acrobat DC Pro Foundation 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. Introduction Introduction FREE 00:02:00 Accessing PDFs Introducing Acrobat and PDFs 00:03:00 Opening and Viewing PDFs 00:07:00 Using Tools and the Menu Bar 00:03:00 Using the Navigation Panels 00:02:00 Changing Preferences 00:03:00 Creating PDFs Creating PDFs from Office 00:06:00 Creating PDFs from Creative Cloud 00:10:00 Creating PDFs from Browsers 00:04:00 Storing a PDF 00:00:00 Combining PDFs 00:03:00 Navigating PDFs Using Search 00:05:00 Creating Bookmarks 00:08:00 Creating Links 00:09:00 Reviewing PDFs Commenting on a PDF 00:07:00 Sending for Review 00:07:00 Modifying PDFs Editing Text and Images 00:06:00 Cropping Images 00:02:00 Adding, Updating, and Removing Headers and Footers 00:06:00 Using Watermarks 00:06:00 Rotating Pages 00:02:00 Extracting Pages 00:03:00 Deleting Pages 00:01:00 Inserting Pages 00:02:00 Replacing Pages 00:04:00 Optimizing PDFs Reducing File Size 00:04:00 Advanced Optimization 00:09:00 Advanced Optimization 00:09:00 Using Actions 00:06:00 Creating Actions 00:07:00 Exporting PDFs Exporting to Word 00:05:00 Exporting to Excel 00:02:00 Exporting to Rich Text Format 00:02:00 Protecting PDFs Redacting Content 00:06:00 Protecting a PDF 00:09:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Register on the Basic HTML 5 today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Basic HTML 5 is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Basic HTML 5 Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Basic HTML 5, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Basic HTML 5 Module 01: HTML Introduction 00:04:00 Module 02: Layout and Elements 00:09:00 Module 03: Inline Elements 00:07:00 Module 04: Specific Elements 00:05:00 Module 05: CSS Introduction 00:02:00 Module 06: CSS Implementation 00:07:00 Module 07: CSS Elements 00:03:00 Module 08: Borders and Backgrounds 00:10:00 Module 09: Navigation Styling 00:07:00 Module 10: Tips and Tricks 00:06:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
This course will help you to master all the skills you require to become a successful web designer using WordPress.
Duration 3 Days 18 CPD hours This course is intended for This class is designed for experienced Salesforce Administrators with little or no Flow experience who need to streamline business processes with no-code automated solutions. This class is not recommended for developers. However, if you are a developer interested in learning Flow, we highly recommend Declarative Development for Platform App Builders in Lightning Experience (DEX403). Overview When you complete this course, you will be able to: Create automated no-code solutions with Salesforce Flow. Analyze use cases and effectively translate requirements into design plans that detail accurate Flow building processes. Understand and leverage various Flow types, elements, and resources. Build Screen Flows and manage screen layouts and field visibility. Implement Flows on Home and Record pages. Automate business processes by creating Record-Triggered Flows (based on record create, update, or delete) to perform specific actions. Identify best practices for creating and managing Flows. Streamline business processes and automate manual tasks across your organization by building no-code automation solutions with Flow Builder. In this 3-day class designed for administrators, our experts will introduce you to Screen and Record-Trigger Flows, in addition to various Flow elements and resources. Learn how to effectively create and manage Flows that champion automation best practices, solve for user requirements, and empower you to get more out of Salesforce. Foundations of Flow Create Variables Understand Algorithms Explore Control Structures Examine Flow Best Practices Screen Flows Use Elements and Resources Control Field Visibility Manage Data and Navigation Surface a Flow Complete the Flow Record-Triggered Flows Define Flow Triggers Use Flow Triggers to Replace Formula Fields Share Records with Flow Additional course details: Nexus Humans Salesforce Automate No-Code Solutions Using Flow (ADX301) 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 Salesforce Automate No-Code Solutions Using Flow (ADX301) 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