624 Computer Skills courses in Leicester delivered Online

Corel WordPerfect is a word processing application with a long history on multiple personal computer platforms. Level 3 Diploma in Corel WordPerfect 12 is designed to help you in using WordPerfect 12 to become much more productive and efficient. The course is divided into three sections. In the first section of the course, you will get basic knowledge on foundation training along with Workspace manager, customizing spelling and grammar. Following that, you will move to an intermediate level where you will learn about creating and modifying charts, sorting data, basics of mail merge, creating XML document and so much more. After completing the intermediate level you will look forward to advanced modules. This module covers Macros, uses of the OfficeReady browser, WordPerfect, and Windows. By the end of this course, you will be able to customize toolbars, property bars, keyboards, menu bar, display settings etc. This course is a complete course for you. So save your time and money by enrolling in this course today. Learning Outcomes: Opening and closing the program; understanding the interface; using menus, quickmenus, toolbars and dialog boxes How to use the programs toolbar and property bar, showing or hiding toolbars, customizing and managing it Typing text basics, selecting text with mouse, keyboard and menu, general tips and tricks Working with text via cutting, copying, pasting, using drag and drop, understanding insert and typeover mode, and using undo and redo How to save files for the first and second times, opening and closing files and/or document Utilizing the help menu, help topics, Corel tutor, specialized help, contextual help amd 'What's This' option Navigation through your cursor, scroll bars, keyboard, and the toolbar Using the object browser, go to dialog box, find the dialog box, and find and replace words Managing fonts through font face, size, bold, underline, italics, colour, quickfonts button, highlighting, and text's case through the property bar More font options through the dialog box, and advanced font tasks like embedding fonts and more Managing text position using the alignment, justification, line and paragraph spacing, ruler, tabs, margins and more options Spelling and grammar checking, using prompt-as-you-go, Grammatik, thesaurus, and the dictionary Opening, using, creating a template and organising projects Using PerfectExpert, and creaing envelopes and labels from the menu option Inserting data, time, symbols, using QuickWords, QuickCorrect, and smart quotes Ways to insert, suppress, remove page numbers, force pages and further insert line numbers Inserting clipart and pictures, reshaping and resizing graphics, positioning through the QuickMenu, ordering and flipping pictures, and adding borders How to use page view, draft view, two page view and zoom Using the print preview option to make adjustments and printing through various settings and options Switching between various documents, arranging document windows, moving text between documents, saving text in a separate file, and inserting documents Emailing and faxing your documents, and publishing them as PDF Affects of HTML on your document, previewing file in your browser, and publishing to HTML Making WordPerfect look like MS Office, opening office documents, saving office files, and using outlook contacts in WordPerfect Utilizing the WordPerfect file dialog box and toolbar options Saving your files using file extensions, viewing file properties, backing up your documents, and saving different versions Using page setup through margins, layout options, page size and orientation Explore the various printing options in order to get printouts Creating, expanding and saving Master documents; also creating, editing and removing subdocuments Understanding reveal codes window and un-revealing codes Examining code - like modifying, deleting, hard vs. soft; working with specific codes - character, sentence and paragraphs, etc.; and finding and replacing codes Applying built-in style using the property bar, updating existing styles, and creating your own style using QuickStyles and dialog boxes Creating and using document styles; and managing styles through the adding, saving and settings options Inserting and creating different list styles, and managing these list styles Utilizing QuickFormat and other formatting tools like the Make-It-Fit command and more Creating headers and footers, using the property bar, placing, suppressing, and deleting headers and footers Formatting text into columns, commenting on documents and reviewing them as well How to create watermark or text boxes Moving, resizing, adding borders and fill, adding captions, and wrapping text in text boxes Understand the basics of custom graphics and how to edit them to meet your needs Creating hyperlink and speed link within your documents Working with bookmarks and quickmarks Create table of contents, setting it up, generating and re-generating it, and using the document map Discover how to use WordPerfect, Microsoft Word, WordPerfect Classic, and Legal mode Customize toolbars, property bars, menus, keyboards, display settings and application bar options Modify WordPerfect environment, file settings, setting summary and conversion options Keep your spelling and grammar on check, change language preferences, add words to dictionary, and customize word list Understand the table structure and use tables property bar, QuickCreate, table menu and perfect expert to manage tables Insert, delete, resize, join and split cells or columns and rows Format tables through cells rotation option, setting vertical alignment, adding borders and fill, using speedformat, and creating or deleting speedformat styles Carry out advanced table tasks by using QuickSum, creating formulas, changing numeric formula of a cell, converting table to tabbed text and vice versa Understand the structure of charts, insert charts, how interface differs when working with them, move, resize, and delete them Changing chart type, chart colours and fonts, legend box, and your perspective Sort out data using sort dialog, setting sort options, creating custom sort, and outputting sort results to a disk Importing and linking spreadsheets or databases, and inserting objects and other file types Merging mail, creating data file, entering your data, using meal merge toolbar in data file Finding records; navigating between records and fields; modifying field names; adding, deleting and editing records Create form documents, add merge fields and merge codes, performing the merge, and creating envelopes during the merge Get an overview of the XML interface, creating new documents, publishing to XML, and converting existing documents to XML Using macro toolbars and visual basic editor along with recording, playing, editing and deleting macros Downloading the OfficeReady browser, using it and templates from the browser How to searchfor files in WordPerfect, starting the WordPerfect when Windows starts, and the differences between Windows Clipboard vs. Corel Clipbook 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? Level 3 Diploma in Corel WordPerfect 12 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 Level 3 Diploma in Corel WordPerfect 12 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. Module : 1 OPENING COREL WORDPERFECT 12 00:30:00 MORE ABOUT TOOLBARS 00:30:00 CREATING AND SELECTING TEXT 00:30:00 WORKING WITH TEXT 00:30:00 WORKING WITH YOUR DOCUMENT 00:30:00 FINDING HELP 00:30:00 BASIC NAVIGATION 00:15:00 USING WORDPERFECT'S TOOLS TO NAVIGATE THROUGH YOUR DOCUMENT 00:30:00 USING FONTS ON THE PROPERTY BAR 00:30:00 USING THE FONTS DIALOG BOX 00:30:00 ADVANCED FONT TASKS 01:00:00 CHANGING TEXT'S POSITION 00:30:00 ADVANCED TEXT POSITIONING 00:30:00 LANGUAGE TOOLS 00:30:00 PROJECTS 01:00:00 OTHER PRE-FORMATTED DOCUMENTS 00:30:00 USING TIMESAVING TOOLS 01:00:00 USING PAGE NUMBERS 00:30:00 ADDING PICTURES 01:00:00 VIEWING YOUR DOCUMENT 00:30:00 USING PRINT PREVIEW 00:30:00 PRINTING YOUR DOCUMENT 00:30:00 WORKING WITH MULTIPLE DOCUMENTS 00:30:00 SENDING YOUR DOCUMENT ELSEWHERE 00:30:00 CREATING A WEB PAGE 00:15:00 WORDPERFECT AND MICROSOFT OFFICE 00:30:00 Module : 2 USING THE FILE DIALOG BOX 01:00:00 USING TOOLBARS 00:15:00 SAVING YOUR FILES 00:30:00 USING PAGE SETUP 00:30:00 PRINTING YOUR FILES 00:30:00 USING MASTER DOCUMENTS AND SUBDOCUMENTS 01:00:00 REVEALING CODES 00:30:00 EXAMINING CODE 00:30:00 SPECIFIC CODES 00:30:00 FINDING AND REPLACING CODES 00:30:00 APPLYING A BUILT-IN STYLE 00:30:00 CREATING A STYLE 00:30:00 USING DOCUMENT STYLES 00:30:00 MANAGING STYLES 00:30:00 USING LIST STYLES 01:00:00 MANAGING LIST STYLES 00:30:00 USING QUICKFORMAT 01:00:00 OTHER FORMATTING TOOLS 01:00:00 CREATING HEADERS AND FOOTERS 00:30:00 FORMATTING TEXT INTO COLUMNS 01:00:00 COMMENTING ON A DOCUMENT 01:00:00 REVIEWING A DOCUMENT 01:00:00 CREATING A WATERMARK 00:30:00 CREATING TEXT BOXES 00:30:00 JAZZING UP TEXT BOXES 01:00:00 THE BASICS OF CUSTOM GRAPHICS 00:30:00 EDITING CUSTOM GRAPHICS 01:00:00 CREATING LINKS TO OUTSIDE YOUR DOCUMENT 00:30:00 WORKING WITH BOOKMARKS 00:30:00 WORKING WITH QUICKMARKS 00:30:00 CREATING A TABLE OF CONTENTS 01:00:00 Module : 3 Using the Workspace Manager 00:30:00 Customizing How You Interact With Word 00:15:00 Customizing How WordPerfect Interacts With Data 00:30:00 Customizing Spelling and Grammar 00:30:00 Creating a Basic Table 01:00:00 Working With Rows and Columns 00:30:00 Formatting a Table 00:30:00 Advanced Table Tasks 01:00:00 Creating Charts 00:30:00 Modifying Charts 00:30:00 Sorting Data 01:00:00 Using Data From Other Applications 00:30:00 Mail Merge Basics 00:30:00 Modifying Your Data 00:30:00 Finalizing the Merge 00:30:00 Creating an XML Document 01:00:00 Macros 01:00:00 Using the OfficeReady Browser 00:30:00 WordPerfect and Windows 01:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Corel WordPerfect 12 is a word processing application with a long history on multiple personal computer platforms. In the first section of the course, you will get basic knowledge on foundation training along with Workspace manager, customizing spelling and grammar. You will be able to create, edit, and save documents. Secondly, the intermediate level explains to you how to use the file dialogue box, toolbar, page set up, save and print files, etc. It will also teach you all the tools and techniques required to operate any work making it more valuable. Moving on to the advanced level, you will learn the stuff such as creating and modifying charts, making tables, working with rows and columns, sorting data, etc. Following that, you will learn about the basic introduction, applications and advantages of using email. Besides, you will get a clear idea of the anatomy, interface, shortcut keys, inbox, outbox, basic email etiquette, and so much more. Finally, application training section teaches you about email applications, opening and closing the WordPerfect email application. Corel WordPerfect Complete Training Course is created to help you stand out among other co-workers and to perform better at work. Learning Outcomes: Opening and closing the program; understanding the interface; using menus, quickmenus, toolbars and dialog boxes How to use the programs toolbar and property bar, showing or hiding toolbars, customizing and managing it Typing text basics, selecting text with mouse, keyboard and menu, general tips and tricks Working with text via cutting, copying, pasting, using drag and drop, understanding insert and typeover mode, and using undo and redo How to save files for the first and second times, opening and closing files and/or document Utilizing the help menu, help topics, Corel tutor, specialized help, contextual help amd 'What's This' option Navigation through your cursor, scroll bars, keyboard, and the toolbar Using the object browser, go to dialog box, find the dialog box, and find and replace words Managing fonts through font face, size, bold, underline, italics, colour, quickfonts button, highlighting, and text's case through the property bar More font options through the dialog box, and advanced font tasks like embedding fonts and more Managing text position using the alignment, justification, line and paragraph spacing, ruler, tabs, margins and more options Spelling and grammar checking, using prompt-as-you-go, Grammatik, thesaurus, and the dictionary Opening, using, creating a template and organising projects Using PerfectExpert, and creaing envelopes and labels from the menu option Inserting data, time, symbols, using QuickWords, QuickCorrect, and smart quotes Ways to insert, suppress, remove page numbers, force pages and further insert line numbers Inserting clipart and pictures, reshaping and resizing graphics, positioning through the QuickMenu, ordering and flipping pictures, and adding borders How to use page view, draft view, two page view and zoom Using the print preview option to make adjustments and printing through various settings and options Switching between various documents, arranging document windows, moving text between documents, saving text in a separate file, and inserting documents Emailing and faxing your documents, and publishing them as PDF Affects of HTML on your document, previewing file in your browser, and publishing to HTML Making WordPerfect look like MS Office, opening office documents, saving office files, and using outlook contacts in WordPerfect Utilizing the WordPerfect file dialog box and toolbar options Saving your files using file extensions, viewing file properties, backing up your documents, and saving different versions Using page setup through margins, layout options, page size and orientation Explore the various printing options in order to get printouts Creating, expanding and saving Master documents; also creating, editing and removing subdocuments Understanding reveal codes window and un-revealing codes Examining code - like modifying, deleting, hard vs. soft; working with specific codes - character, sentence and paragraphs, etc.; and finding and replacing codes Applying built-in style using the property bar, updating existing styles, and creating your own style using QuickStyles and dialog boxes Creating and using document styles; and managing styles through the adding, saving and settings options Inserting and creating different list styles, and managing these list styles Utilizing QuickFormat and other formatting tools like the Make-It-Fit command and more Creating headers and footers, using the property bar, placing, suppressing, and deleting headers and footers Formatting text into columns, commenting on documents and reviewing them as well How to create watermark or text boxes Moving, resizing, adding borders and fill, adding captions, and wrapping text in text boxes Understand the basics of custom graphics and how to edit them to meet your needs Creating hyperlink and speed link within your documents Working with bookmarks and quickmarks Create table of contents, setting it up, generating and re-generating it, and using the document map Discover how to use WordPerfect, Microsoft Word, WordPerfect Classic, and Legal mode Customize toolbars, property bars, menus, keyboards, display settings and application bar options Modify WordPerfect environment, file settings, setting summary and conversion options Keep your spelling and grammar on check, change language preferences, add words to dictionary, and customize word list Understand the table structure and use tables property bar, QuickCreate, table menu and perfect expert to manage tables Insert, delete, resize, join and split cells or columns and rows Format tables through cells rotation option, setting vertical alignment, adding borders and fill, using speedformat, and creating or deleting speedformat styles Carry out advanced table tasks by using QuickSum, creating formulas, changing numeric formula of a cell, converting table to tabbed text and vice versa Understand the structure of charts, insert charts, how interface differs when working with them, move, resize, and delete them Changing chart type, chart colours and fonts, legend box, and your perspective Sort out data using sort dialog, setting sort options, creating custom sort, and outputting sort results to a disk Importing and linking spreadsheets or databases, and inserting objects and other file types Merging mail, creating data file, entering your data, using meal merge toolbar in data file Finding records; navigating between records and fields; modifying field names; adding, deleting and editing records Create form documents, add merge fields and merge codes, performing the merge, and creating envelopes during the merge Get an overview of the XML interface, creating new documents, publishing to XML, and converting existing documents to XML Using macro toolbars and visual basic editor along with recording, playing, editing and deleting macros Downloading the OfficeReady browser, using it and templates from the browser How to searchfor files in WordPerfect, starting the WordPerfect when Windows starts, and the differences between Windows Clipboard vs. Corel Clipbook Email address structure, the benefits of email, email etiquette, understand spam and viruses, and digital signatures Common email applications, opening and closing the WordPerfect email application, understanding its structure and getting help Using the folder list, main menus, toolbar, shortcut menus, shortcut keys and dialogue boxes Opening your inbox and messages, switching between open messages, closing email messages, and adding and removing message list headings Using the contact list, searching for messages, creating folders, and moving messages to a folder Sorting and deleting messages, restoring and emptying deleted items Flagging messages, marking messages as read or unread, opening and saving attachments, using reply & reply to all, and forwarding messages options How to print your messages using the print preview, print commands, choosing a print range, and setting the number of copies Creating and addressing messages; adding a subject; composing message; using the cut, copy and paste options and sending the message Adding and removing attachments, changing priority, and copying text into a message Explore the differences between HTML and Plain text emails, set up default text fonts, add images, and spell checks Adding people to your contact list, how to create a distribution list, and adding and removing addresses from the distribution list Understanding the structure of email addresses, advantages of email, email etiquette, spams and viruses, and digital signatures Common email applications, opening and closing the WordPerfect email application, understanding its structure and getting help Utilizing the folder list, main menus, toolbar, shortcut menus, shortcut keys and dialogue boxes Opening your inbox and messages, switching between open messages, closing email messages, and adding and removing message list headings Best ways to use the contact list, search for messages, create folders, and moving messages to a folder Sorting and deleting messages, restoring and emptying deleted items Discover more about message tools through flagging, marking messages as read or unread, opening and saving attachments, using reply and forwarding messages options How to print your messages using the print preview, print commands, choosing a print range, and setting the number of copies Creating and addressing messages; adding a subject; composing message; using the cut, copy and paste options and sending the message Advanced message tools like adding and removing attachments, changing priority, copying text into a message Compare HTML vs. Plain text emails, set up default text fonts, add images, and check spellings Adding people to your contact list, how to create a distribution list, and changing the addresses from the distribution list 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? Corel WordPerfect Complete Training 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 Corel WordPerfect Complete Training 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. Module - 1 OPENING COREL WORDPERFECT 12 00:30:00 MORE ABOUT TOOLBARS 00:30:00 CREATING AND SELECTING TEXT 00:30:00 WORKING WITH TEXT 00:30:00 WORKING WITH YOUR DOCUMENT 00:30:00 FINDING HELP 00:30:00 BASIC NAVIGATION 00:15:00 USING WORDPERFECT'S TOOLS TO NAVIGATE THROUGH YOUR DOCUMENT 00:30:00 USING FONTS ON THE PROPERTY BAR 00:30:00 USING THE FONTS DIALOG BOX 00:30:00 ADVANCED FONT TASKS 01:00:00 CHANGING TEXT'S POSITION 00:30:00 ADVANCED TEXT POSITIONING 00:30:00 LANGUAGE TOOLS 00:30:00 PROJECTS 01:00:00 OTHER PRE-FORMATTED DOCUMENTS 00:30:00 USING TIMESAVING TOOLS 01:00:00 USING PAGE NUMBERS 00:30:00 ADDING PICTURES 01:00:00 VIEWING YOUR DOCUMENT 00:30:00 USING PRINT PREVIEW 00:30:00 PRINTING YOUR DOCUMENT 00:30:00 WORKING WITH MULTIPLE DOCUMENTS 00:30:00 SENDING YOUR DOCUMENT ELSEWHERE 00:30:00 CREATING A WEB PAGE 00:15:00 WORDPERFECT AND MICROSOFT OFFICE 00:30:00 Module - 2 USING THE FILE DIALOG BOX 01:00:00 USING TOOLBARS 00:15:00 SAVING YOUR FILES 00:30:00 USING PAGE SETUP 00:30:00 PRINTING YOUR FILES 00:30:00 USING MASTER DOCUMENTS AND SUBDOCUMENTS 01:00:00 REVEALING CODES 00:30:00 EXAMINING CODE 00:30:00 SPECIFIC CODES 00:30:00 FINDING AND REPLACING CODES 00:30:00 APPLYING A BUILT-IN STYLE 00:30:00 CREATING A STYLE 00:30:00 USING DOCUMENT STYLES 00:30:00 MANAGING LIST STYLES 00:30:00 USING LIST STYLES 01:00:00 MANAGING LIST STYLES 00:30:00 USING QUICKFORMAT 01:00:00 OTHER FORMATTING TOOLS 01:00:00 CREATING HEADERS AND FOOTERS 00:30:00 FORMATTING TEXT INTO COLUMNS 01:00:00 COMMENTING ON A DOCUMENT 01:00:00 REVIEWING A DOCUMENT 01:00:00 CREATING A WATERMARK 00:30:00 CREATING TEXT BOXES 00:30:00 JAZZING UP TEXT BOXES 01:00:00 THE BASICS OF CUSTOM GRAPHICS 00:30:00 EDITING CUSTOM GRAPHICS 01:00:00 CREATING LINKS TO OUTSIDE YOUR DOCUMENT 00:30:00 WORKING WITH BOOKMARKS 00:30:00 WORKING WITH QUICKMARKS 00:30:00 CREATING A TABLE OF CONTENTS 01:00:00 Module - 3 Using the Workspace Manager 00:30:00 Customizing How You Interact With Word 00:15:00 Customizing How WordPerfect Interacts With Data 00:30:00 Customizing Spelling and Grammar 00:30:00 Creating a Basic Table 01:00:00 Working With Rows and Columns 00:30:00 Formatting a Table 00:30:00 Advanced Table Tasks 01:00:00 Creating Charts 00:30:00 Modifying Charts 00:30:00 Sorting Data 01:00:00 Using Data From Other Applications 00:30:00 Mail Merge Basics 00:30:00 Modifying Your Data 00:30:00 Finalizing the Merge 00:30:00 Creating an XML Document 01:00:00 Macros 01:00:00 Using the OfficeReady Browser 00:30:00 WordPerfect and Windows 01:00:00 Module - 4 All About E-mail 00:30:00 Getting Started 01:00:00 Components of the Mail Interface 00:30:00 Working with Messages 01:00:00 Managing Mail 01:00:00 Working With Messages 00:30:00 Message Tools 01:00:00 Printing Messages 00:30:00 Creating Messages 01:00:00 Advanced Message Tools 01:00:00 Working With E-mail 01:00:00 Address Tools 01:00:00 Module - 5 All About E-mail 00:15:00 Getting Started 00:30:00 Components of the Mail Interface 00:30:00 Working with Messages 00:30:00 Managing Mail 01:00:00 Working With Messages 00:30:00 Message Tools 00:30:00 Printing Messages 00:30:00 Creating Messages 00:30:00 Advanced Message Tools 00:30:00 Working With E-mail 00:30:00 Address Tools 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Advanced Diploma in Microsoft Excel Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Advanced Diploma in Microsoft Excel Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Advanced Diploma in Microsoft Excel Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Advanced Diploma in Microsoft Excel Course, like every one of Study Hub's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Advanced Diploma in Microsoft Excel? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD QS-accredited qualifications after course completion Receive one-to-one assistance 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 Advanced Diploma in Microsoft Excel 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Advanced Diploma in Microsoft Excel course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Advanced Diploma in Microsoft Excel does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Advanced Diploma in Microsoft Excel was made by professionals and it is compatible with all PCs, Macs, 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 As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Advanced Diploma in Microsoft Excel is a great way for you to gain multiple skills from the comfort of your home.

Operating system is a special purpose software that is used to manage the overall computer. It is the fundamental and building block of any working computer system. Thus, knowing about how to use computer operating systems is a must for any end user. Our course is designed to deliver you the fundamental knowledge related to operating a computer. It will also teach you the attributes that are very useful to make the computer functional. Besides that, you will get to know about the the standards and how to use them properly. Most importantly, you will get to learn about different types of operating systems including windows, Mac, Linux and Unix. If you think you are ready to understand how your computer works and how get the best out of your PC, then enrol and be a computer master in no time. Course Highlights Computer Operating System Certificate Course is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Computer Operating System Certificate Course into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 9 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Computer Operating System Certificate Course Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Computer Operating System Certificate Course is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Computer Operating System Certificate 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Introduction 00:15:00 What is an Operating System? 00:30:00 History of Operating System 00:30:00 What an Operating System Does 01:00:00 Microsoft Windows 01:00:00 MAC OS 01:00:00 UNIX 00:30:00 LINUX 00:30:00 GNU 00:30:00 Other Operating Systems 01:00:00 Installing an Operating System 01:00:00 Defining The Processes 01:00:00 Conclusion 00:15:00 Mock Exam Final Exam

The Word 2016 Intermediate course is intended to sharpen your skills and knowledge by explaining precise documentation making features including working with multiple documents, formatting tables, tags, lists, templates, merging, etc. This course covers a variety of topics including working with Word 2016, creating, and customising styles, templates, and themes in the most effective way possible. You'll also work with diverse sorts of data in Word, copy and paste commands, and study advanced document layout options and different collaboration tools. Learn how to work with graphic elements such as pictures, text boxes, text effects, shapes, the drawing canvas, SmartArt, WordArt, typography effects, advanced graphics component features, and more. What you'll learn Work with, create, manage, and customize Styles, Templates, and Themes. Work with various types of data in Word using Tables, advanced Copy and Paste commands, and Charts. Review advanced document layout options in Word and various collaboration tools. Work with graphic elements such as pictures, text boxes, shapes, the Drawing Canvas, SmartArt, Text Effects, Typography Effects, WordArt, and Equations. Learn additional graphic element features such as grouping, layering, and moving objects Requirements Word 2016 Introduction course or equivalent experience Who this course is for: Students who need to expand their knowledge and skills in Microsoft Word. Introduction Intro 00:02:00 Working with Styles Using Styles 00:08:00 Creating a Style Based on Text 00:04:00 Modifying a Style 00:03:00 Managing and Exporting Styles 00:06:00 Using Styles to Reorder Text 00:06:00 Working with Style Sets 00:04:00 Creating and Applying Fonts and Color Sets 00:03:00 Working with Themes 00:03:00 What are Templates? 00:03:00 Modifying the Normal and Custom Template 00:06:00 Changing the Custom Office Template Location 00:03:00 Working with Data in Word Sorting a Table 00:04:00 Repeating Table Header Rows and Setting Page Breaks 00:04:00 Working with Calculations in a Table 00:04:00 Working with Excel Data in Word 00:04:00 Copying, Pasting, and Linking Excel Data 00:09:00 Creating a Chart in Word 00:06:00 Editing Chart Data 00:04:00 Formatting a Chart 00:05:00 Advanced Document Layouts Controlling Page Breaks 00:05:00 Working with Section Breaks 00:06:00 Using Section Breaks with Margins and Page Orientation 00:04:00 Applying Columns 00:04:00 Modifying Columns 00:06:00 Adding Borders and Shading to a Paragraph 00:04:00 Applying Different Headers and Footers 00:06:00 Creating a Signature Line 00:03:00 Collaborating in Word Working with Comments 00:07:00 Using Track Changes 00:06:00 Reviewing and Accepting Changes 00:06:00 Customizing Markups 00:06:00 Comparing and Merging Two Documents 00:07:00 Combining Documents 00:06:00 Working with Pictures, Shapes and Drawing Tools Applying a Picture Style 00:04:00 Adjusting a Picture 00:06:00 Removing a Picture Background 00:03:00 Inserting a Text Box from the Gallery 00:04:00 Drawing and Formatting a Text Box 00:05:00 Adding, Selecting, Deleting Shapes 00:06:00 Resizing, Rotating, Replacing a Shape 00:05:00 Using the Selection Pane 00:04:00 Copying or Duplicating a Shape 00:03:00 Customizing Fill Color and Outline for a Shape 00:06:00 Using a Shape Effect 00:06:00 Using a Drawing Canvas 00:07:00 Positioning or Moving Shapes or Objects 00:05:00 Using Wrapping Text 00:06:00 Grouping and Layering Objects 00:05:00 Aligning Objects 00:04:00 Inserting Special Graphics Creating SmartArt Graphics 00:06:00 Formatting and Customizing SmartArt 00:06:00 Working with Text and Typography Effects 00:07:00 Working with Equations 00:06:00 Conclusion Course Recap 00:02:00

Learn to fully utilize your Computer with the help of this Course If you are a little weak when it comes to understanding how computer works then don't worry. This course will feed you some of the most important information about a computer, its operating system. An operating system is the most important software that runs on a computer. It manages the computer's memory and processes, as well as all of its software and hardware. It also allows you to communicate with the computer without knowing how to speak the computer's language. Without an operating system, a computer is useless. Your computer's operating system (OS) manages all of the software and hardware on the computer. Most of the time, there are several different computer programs running at the same time, and they all need to access your computer's central processing unit (CPU), memory, and storage. The operating system coordinates all of this to make sure each program gets what it needs. You will not only learn the basics of computer OS, but you will also learn about the different operating systems in this course. So without further delay, get started now. Course Highlights Certified Computer Operating System Course is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Computer Operating System Course into 23 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 17 hours, 45 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Computer Operating System Course Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Computer Operating System Course is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certified Computer Operating System 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module 1: Introduction to Computer Operating System Introduction 00:15:00 What is an Operating System? 00:30:00 History of Operating System 00:30:00 What an Operating System Does 01:00:00 Microsoft Windows 01:00:00 MAC OS 01:00:00 UNIX 00:30:00 LINUX 00:30:00 GNU 00:30:00 Other Operating Systems 01:00:00 Installing an Operating System 01:00:00 Defining The Processes 01:00:00 Conclusion 00:15:00 Module 2: MAC Operating System Introduction to Mac 01:00:00 Features of Mac Desktops 01:00:00 Networking System of Mac 01:00:00 Types of Mac 01:00:00 Mac your way to cyberspace 00:30:00 Benefits of Using Mac 01:00:00 How to print & fax using Mac 01:00:00 Managing music with iTunes 01:00:00 Having fun with photos 01:00:00 Wrapping Up 00:15:00 Mock Exam Final Exam

Description: Are you interested in a career in computer science? Programming is the art of writing useful, maintainable, and extensible source codes which can be read or compiled by a computer system to perform a significant task. Take your first step towards learning core programming concepts and equip yourself with the practical knowledge and skills to resolve complicated problems. Discover all you need to know about programming language with this computer science course. By learning the correct programming theory, you will be able to analyse a problem and identify suitable solutions to those problems, which is a key part of web development. Apart from the theories of Algorithm analysis, this computer programming course also teaches the number system, arrays and their advantages, the process of analysing a problem, nodes and their Importance, and various sorting algorithms and their comparisons. There are no entry requirements for this course and you can study from the comfort of your own home. Enrol in this Diploma in Computer Science and Programming course today and learn to write code like an expert. Who is the course for? Anyone who wants to become a Good Programmer Anyone interested in the Computer Science Discipline Anyone who wants to learn how to problem solve like a Computer Scientist Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. 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 £14.99 or in PDF format at a cost of £11.99. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. 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 Kurt Anderson - Promo FREE 00:02:00 Kurt Anderson - 1 Introduction 00:01:00 Kurt Anderson - 2 Binary System 00:11:00 Analyzing Algorithms Kurt Anderson - 3 Complexity Introduction 00:02:00 Kurt Anderson - 4 Math Refresher Logarithmic Functions 00:11:00 Kurt Anderson - 5 Math Refresher Factorial Functions.TS 00:03:00 Kurt Anderson - 6 Math Refresher Algebraic Expressions.TS 00:03:00 Kurt Anderson - 7 n-notation 00:18:00 Kurt Anderson - 8 Big O 00:13:00 Kurt Anderson - 9 Big O Real World Example 00:10:00 Arrays Kurt Anderson - 10 How is Data Stored 00:09:00 Kurt Anderson - 11 Fixed Arrays 00:20:00 Kurt Anderson - 12 Circular Arrays 00:08:00 Kurt Anderson - 13 Dynamic Arrays 00:16:00 Kurt Anderson - 14 Array Review 00:08:00 Kurt Anderson - 15 Array Real World Examples 00:06:00 Linked Lists Kurt Anderson - 16 Nodes 00:04:00 Kurt Anderson - 16 Linked List 00:14:00 Kurt Anderson - 17 Linked List Run Times 00:15:00 Kurt Anderson - 18 Doubly Linked Lists 00:08:00 Kurt Anderson - 19 Tail Pointer 00:05:00 Kurt Anderson - 20 Linked List Real World Examples 00:03:00 Kurt Anderson - 21 Linked List Review 00:04:00 Stacks and Queues Kurt Anderson - 22 Stacks 00:10:00 Kurt Anderson - 20 Stack Example 00:11:00 Kurt Anderson - 23 Queues 00:09:00 Kurt Anderson - 24 Queue Examples 00:10:00 Kurt Anderson - 25 Queue and Stack Run Times 00:06:00 Kurt Anderson - 26 Stack and Queues Real World Examples 00:07:00 Sorting Algorithms Kurt Anderson - 27 Sorting Algorithm Introdcution 00:02:00 Kurt Anderson - 28 Bubble Sort 00:10:00 Kurt Anderson - 29 Selection Sort 00:10:00 Kurt Anderson - 30 Insertion Sort 00:09:00 Kurt Anderson - 31 Quick Sort 00:15:00 Kurt Anderson - 32 Quick Sort Run Times 00:10:00 Kurt Anderson - 33 Merge Sort 00:12:00 Kurt Anderson - 34 Merge Sort Run Times 00:08:00 Kurt Anderson - 35 Stable vs Nonstable 00:07:00 Kurt Anderson - 36 Sorting Algorithm Real World Examples 00:04:00 Trees Kurt Anderson - 37 Basics of Trees 00:08:00 Kurt Anderson - 38 Binary Search Tree 00:09:00 Kurt Anderson - 39 BST Run Times 00:08:00 Kurt Anderson - 40 Tree Traversals 00:13:00 Kurt Anderson - 41 Tree Real World Examples 00:05:00 Heaps Kurt Anderson - 42 Heap Introduction 00:04:00 Kurt Anderson - 43 Heap Step by Step 00:12:00 Kurt Anderson - 44 Heap Real World Examples 00:07:00 Conclusion Kurt Anderson - 45 Thank You 00:01:00 Course Certification Order Your Certificates and Transcripts 00:00:00

Learning Objectives Introduction , Linking Workbooks and Worksheets , Working with Range Names , Sorting, Filtering, and Subtotaling , Analyzing and Organizing with Tables , Using Conditional Formatting , Displaying Data Graphically , Understanding PivotTables, PivotCharts, and Slicers , Working with Advanced PivotTables and PowerPivot Features , Conclusion   Pre-Requisites Excel 365 Introduction course or equivalent knowledge or experience.   Description In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features. Section 01 Lesson 01: Linking Workbooks and Worksheets 00:06:00 Lesson 02: Linking Workbooks with 3D References 00:05:00 Lesson 03: Understanding the Consolidate Feature 00:06:00 Section 02 Lesson 01: What are Range Names 00:04:00 Lesson 02: Creating Range Names Using the Name Box and Define Name 00:06:00 Lesson 03: Creating Range Names Using Create from Selection 00:03:00 Section 03 Lesson 01: Understanding the Differences Between Sorting and Filtering 00:03:00 Lesson 02: Sorting Lists 00:06:00 Lesson 03: Filtering Lists 00:08:00 Lesson 04: Creating Subtotals 00:06:00 Section 04 Lesson 01: Creating Tables and Understanding the Benefits 00:07:00 Lesson 02: Understanding the Elements of a Table 00:06:00 Lesson 03: Formatting a Table 00:08:00 Lesson 04: Sorting and Filtering Tables 00:03:00 Lesson 05: Filtering with Slicers 00:04:00 Lesson 06: Calculating with Tables 00:04:00 Lesson 07: Removing Erroneous Table Data 00:03:00 Lesson 08: Exporting, Refreshing, and Converting Tables 00:05:00 Section 05 Lesson 01: What is Conditional Formatting 00:04:00 Lesson 02: Conditional Formatting Highlight Cells and Top Bottom Rules 00:07:00 Lesson 03: Conditional Formatting Data Bars, Icon Sets, and Color Scales 00:06:00 Lesson 04: Using Custom Fonts and Colors 00:04:00 Lesson 05: Using Custom Conditional Formatting 00:06:00 Lesson 06: Modifying or Removing Conditional Formatting 00:05:00 Section 06 Lesson 01: What are Charts 00:05:00 Lesson 02: Creating Charts 00:06:00 Lesson 03: Understanding Chart Elements 00:05:00 Lesson 04: Modifying Chart Elements 00:09:00 Lesson 05: Changing and Moving Charts 00:04:00 Lesson 06: Filtering a Chart 00:04:00 Lesson 07: Formatting Charts 00:07:00 Lesson 08: Adjusting Numbering 00:06:00 Lesson 09: Creating Dual Axis Charts 00:05:00 Lesson 10: Forecasting with Trendlines 00:05:00 Lesson 11: Creating a Chart Template 00:04:00 Lesson 12: Displaying Trends with Sparklines 00:07:00 Section 07 Lesson 01: What is a PivotTable 00:06:00 Lesson 02: Creating a PivotTable 00:07:00 Lesson 03: Working with the PivotTable Fields Pane 00:09:00 Lesson 04: Basic Data Organization and Analysis with PivotTables 00:06:00 Lesson 05: Formatting PivotTables 00:06:00 Lesson 06: Creating a PivotChart 00:04:00 Lesson 07: Modifying and Formatting a PivotChart 00:04:00 Lesson 08: Adding Slicers and Timeline Slicers 00:03:00 Lesson 09: Formatting Slicers 00:04:00 Lesson 10: Using the Ideas Feature 00:03:00 Section 08 Lesson 01: Using the PivotTable and PivotChart Wizard 00:02:00 Lesson 02: Adding a Calculated Field 00:05:00 Lesson 03: Adding a Calculated Item 00:04:00 Lesson 04: Applying Conditional Formatting to a PivotTable 00:02:00 Lesson 05: Creating Filter Pages for a PivotTable_1 00:03:00 Lesson 06: Enabling the PowerPivot Add: In 00:06:00 Final Exam Final Exam - Excel 365 Intermediate 00:20:00

This Access 2016 Intermediate is specially designed for you if you are thinking to take your Microsoft Access skills to the next level. Through the course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.  From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. You will learn to design tables for improved accuracy in data entry by setting default values and restricting data entry, review the various options to share data with other applications, including Word and Excel, learn about Action Queries to automate updating, appending and deleting table data, and review various advanced query techniques such as using Query Joins, Parameter queries, working with totals and Crosstab queries. Finally, you'll build a navigation form to make it easy for your users to find their way around your database.  What Will I Learn? Design Tables for Better Data Entry Share Data with Other Applications Work with Action Queries Advanced Query Techniques Automate Processes with Macros Advanced Forms Advanced Report Techniques Requirements Access 2016 Introduction or equivalent experience. Who is the target audience? Students who want to take Access to the next level and improve their database design skills. Introduction Introduction FREE 00:01:00 Designing Tables for Better Data Entry Reviewing Table Design Principles 00:04:00 Setting Field Size, Formats and Captions 00:06:00 Setting Default Value and Required Fields 00:03:00 Restricting Data Entry Using Data Validation 00:02:00 Restricting Data Entry Using Input Masks 00:06:00 Sharing Data with Other Applications Exporting Tables and Queries to Excel 00:03:00 Importing Data from a TXT File 00:03:00 Importing Data from Excel 00:02:00 Exporting Data to a TXT File 00:02:00 Linking External Data Sources 00:03:00 Using Word Merge 00:02:00 Working with Action Queries What are Action Queries 00:02:00 Creating an Update Query 00:02:00 Creating an Append Query 00:03:00 Creating a Delete Query 00:02:00 Creating a Make Table Query 00:02:00 Changing the Start Number of an Auto Number Field 00:03:00 Advanced Query Techniques Creating Query Joins 00:05:00 Creating Find Unmatached and Find Duplicate Queries 00:03:00 Creating Parameter Queries 00:04:00 Using -Like- Keyword in Parameter Queries 00:02:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:03:00 Summarizing Query Data with Totals 00:03:00 Inserting Where Statements in Summary Queries 00:01:00 Creating a Crosstab Query 00:03:00 Automating Processes with Macros Understanding Macro Basics 00:06:00 Creating Macros to Open Forms by Record 00:04:00 Validating Data Entry with Macros 00:04:00 Creating a Macro to Automate Data Entry 00:03:00 Advanced Data Entry Using Macros and DLOOKUP Function 00:06:00 Advanced Form Using Conditional Formatting 00:02:00 Organizing Form Fields with Tab Controls 00:03:00 Creating a Combo Box Control 00:02:00 Creating an Option Group Control 00:03:00 Using a Subform to Show Data from a Related Table 00:03:00 Advanced Report Techniques Inserting a Chart on a Report 00:03:00 Showing Data in Columns 00:02:00 Inserting a Subreport 00:02:00 Configuring Reports with Parameter Queries 00:04:00 Sending Reports 00:02:00 Conclusion Course Recap 00:01:00 Resources Resources - Access 2016 Intermediate 00:00:00 Course Certification

Learning Objectives Introduction , Designing Tables for Better Data Entry , Sharing Data with Other Applications , Working with Action Queries , Advanced Query Techniques , Automating Processes with Macros , Advanced Form Techniques , Advanced Report Techniques , Conclusion   Pre-Requisites Access 2019 Beginner or equivalent experience.   Description This course is designed to teach students intermediate level skills in Microsoft Access 2019. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 2019 Advanced course. Access 2019 Intermediate Module 01: Introduction to the Course 00:02:00 Module 02: Reviewing Table Design Principles 00:11:00 Module 03: Setting Field Size, Formats and Captions 00:09:00 Module 04: Setting Default Values and Required Fields 00:06:00 Module 05: Restricting Data Entry-Validation Rules 00:06:00 Module 06: Restricting Data Entry-Input Masks 00:07:00 Module 07: Exploring Tables and Queries to Excel 00:04:00 Module 08: Exporting Data to a SharePoint List 00:02:00 Module 09: Importing Data from Excel 00:06:00 Module 10: Importing Data from a Sharepoint List 00:02:00 Module 11: Linking External Data Sources 00:06:00 Module 12: Using Word Merge 00:07:00 Module 13: What are Action Queries 00:03:00 Module 14: Creating an Update Query 00:06:00 Module 15: Creating an Append Query 00:04:00 Module 16: Creating a Delete Query 00:05:00 Module 17: Creating a Make Table Query 00:04:00 Module 18: Changing Start Number of an Auto Number Field 00:04:00 Module 19: Modifying Query Joins 00:09:00 Module 20: Using Self Joins to Combine Data 00:06:00 Module 21: Creating Find Unmatched and Find Duplicate Queries 00:09:00 Module 22: Creating Parameter Queries 00:07:00 Module 23: Creating a Top X Query 00:03:00 Module 24: Reviewing Calculated Query Fields 00:05:00 Module 25: Summarising Query Data with Totals 00:05:00 Module 26: Creating a Crosstab Query 00:07:00 Module 27: Understanding Macro Basics 00:14:00 Module 28: Creating Macros to Open Forms by Record 00:08:00 Module 29: Validating Data Entry with Macros 00:09:00 Module 30: Creating a Macro to Automate Data Entry 00:08:00 Module 31: Advanced Data Entry Using Macros and DLOOKUP Functions 00:09:00 Module 32: Using Conditional Formatting 00:04:00 Module 33: Working with the New Label Name Property 00:02:00 Module 34: Organising Form Fields with Tab Controls 00:05:00 Module 35: Creating an Option Group Control 00:06:00 Module 36: Creating a Combo Box Control 00:05:00 Module 37: Configuring a Combo Box Control to Show Search Results 00:04:00 Module 38: Using a Subform to Show Data from a Related Table 00:05:00 Module 39: Inserting a Chart on a Report 00:07:00 Module 40: Showing Data in Columns 00:08:00 Module 41: Inserting a Subreport 00:04:00 Module 42: Configuring Reports with Parameter Queries 00:05:00 Module 43: Sending Reports 00:02:00