1291 Courses delivered Online

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students looking to establish a foundational understanding of Microsoft Access for Office 365, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries. Overview In this course, you will create and manage an Access database. You will: Navigate within the Access application environment, create a simple database, and customize Access configuration options. Organize and manage data stored within Access tables. Use queries to join, sort, and filter data from different tables. Use forms to make it easier to view, access, and input data. Create and format custom reports. In this introductory course, you will discover the capabilities of Microsoft© Access©, a relational database application that can help you and your organization manage your complex data. Working with an Access Database Topic A: Launch Access and Open a Database Topic B: Use Tables to Store Data Topic C: Use Queries to Combine, Find, Filter, and Sort Data Topic D: Use Forms to View, Add, and Update Data Topic E: Use Reports to Present Data Topic F: Get Help and Configure Options in Microsoft Access Creating Tables Topic A: Plan an Access Database Topic B: Start a New Access Database Topic C: Create a New Table Topic D: Establish Table Relationships Creating Queries Topic A: Create Basic Queries Topic B: Add Calculated Columns in a Query Topic C: Sort and Filter Data in a Query Creating Forms Topic A: Start a New Form Topic B: Enhance a Form Creating Reports Topic A: Start a New Report Topic B: Enhance Report Layout Promoting Quality Data Input Topic A: Restrict Data Input through Field Validation Topic B: Restrict Data Input through Forms and Record Validation Improving Efficiency and Data Integrity Topic A: Data Normalization Topic B: Associate Unrelated Tables Topic C: Enforce Referential Integrity Additional course details: Nexus Humans Microsoft Access for Office 365 (Desktop or Online) - Part 1 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 Microsoft Access for Office 365 (Desktop or Online) - Part 1 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 1 Days 6 CPD hours This course is intended for This course is designed for students looking to establish a foundational understanding of Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries. Overview In this course, you will create and manage an Access database. You will: Navigate within the Access application environment, create a simple database, and customize Access configuration options. Organize and manage data stored within Access tables. Use queries to join, sort, and filter data from different tables. Use forms to make it easier to view, access, and input data. Create and format custom reports. Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft© Access© can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access. Microsoft© Access© for Office 365?: Part 1 (this course): Focuses on the design and construction of an Access database?viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports. Microsoft© Access© for Office 365?: Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports. Microsoft© Access© for Office 365?: Part 3 : Focuses on managing the database and supporting complex database designs, including import and export of data, using action queries to manage data, creating complex forms and reports, macros and VBA, and tools and strategies to manage, distribute, and secure a database. This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam. Lesson 1: Working with an Access Database Topic A: Launch Access and Open a Database Topic B: Use Tables to Store Data Topic C: Use Queries to Combine, Find, Filter, and Sort Data Topic D: Use Forms to View, Add, and Update Data Topic E: Use Reports to Present Data Topic F: Get Help and Configure Options in Access Lesson 2: Creating Tables Topic A: Plan an Access Database Topic B: Start a New Access Database Topic C: Create a New Table Topic D: Establish Table Relationships Lesson 3: Creating Queries Topic A: Create Basic Queries Topic B: Add Calculated Columns in a Query Topic C: Sort and Filter Data in a Query Lesson 4: Creating Forms Topic A: Start a New Form Topic B: Enhance a Form Lesson 5: Creating Reports Topic A: Start a New Report Topic B: Enhance Report Layout Additional course details: Nexus Humans Microsoft Access for Office 365: Part 1 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 Microsoft Access for Office 365: Part 1 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.

Executive Secretary & PA Training Course Online For confident candidates with outgoing personalities and a relentless attention to detail, the field of Secretary & PA Diploma services is wide open. Professional personal assistants (PAs) are the ultimate multitaskers, hired to manage the personal affairs and activities of those they support. Some secretaries and PAs work for large corporations, while others are hired by a single executive, entrepreneur, or influential figure. Regardless of which path you take, becoming a trusted and respected PA or Secretary opens the door to a world of incredible career opportunities. Personal qualities and character, as well as hard skills, are important for success as a PA or secretary. It's simply a matter of learning the roles of PAs and secretaries in order to prepare for a rewarding career in the field. This Executive Secretary & PA Training could be the key to your dream job. Transform your ambition and enthusiasm into a rewarding career for life by studying from home at your own pace and time. Learn how to handle a wide range of essential office administration tasks, as well as how to write important business letters and handle complex mail and shipping requirements. Making travel arrangements on behalf of others, organising meetings and events, the importance of time management as a PA, and how to become a better communicator are also covered in the course. Why choose this Executive Secretary & PA Training Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Executive Secretary & PA Training Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Executive Secretary & PA Training Course.. Other Benefits of This Executive Secretary & PA Training Course FREE PDF Certificates Lifetime Access Free Retake Exam Expert Tutor Support Main Course: Executive Secretary & PA Training Course Free Courses Course 01: Level 2 Certificate in Law and Legal Work Course 02: Level 4 Diploma In Paralegal Studies [ Note: Free PDF certificate will provide as soon as completing the Executive Secretary & PA Training Course] Executive Secretary & PA Training Course Online Our Executive Secretary & PA Training course has been designed to equip you with the essential knowledge and skills needed to become an expert executive secretary or personal assistant and will give you all the practical knowledge & credentials that you need to excel in your new role. Enrol on our Executive Secretary & PA Training course today and begin your journey to improve your career prospects with the latest skills and the power of self-belief! Learning Outcomes After completing this Executive Secretary & PA Training course, learner will be able to: Understand personal assistant fundamentals Understand business telephone approaches Understand information regarding shipping and mail services Understand travel arrangements Understand outline setting up conferences and meetings Understand management of time Understand systems for record keeping and filing Understand business writing techniques Understand communication skills Understand customer service Understand basics of microsoft office skills Assessment Method of Executive Secretary & PA Training Course After completing Executive Secretary & PA Training Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Executive Secretary & PA Training Course After completing the Executive Secretary & PA Training course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Executive Secretary & PA Training Course Online This Executive Secretary & PA Training course is designed for existing secretarial/administrative workers seeking advancement or newcomers seeking their first professional position. Requirements Executive Secretary & PA Training Course Online To enrol in this Executive Secretary & PA Training Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Executive Secretary & PA Training Course. Be energetic and self-motivated to complete our Executive Secretary & PA Training Course. Basic computer Skill is required to complete our Executive Secretary & PA Training Course. If you want to enrol in our Executive Secretary & PA Training Course, you must be at least 15 years old. Career path Executive Secretary & PA Training Course Online After completing this Executive Secretary & PA Training course, you may able to pursue a formal position in professional Executive PA services such as: Personal Executive Assistant Receptionist Office Assistant Support Secretary Office Manager Personal Concierge Executive Assistant

Overview Do you face struggle when you open a Power Query seeing the number of things to do then and cannot make good use of your time? Then this Microsoft Excel: Master Power Query in 120 Minutes! Course is just what you need.to break free of your worries. Power Query is a business intelligence tool available in Excel that allows you to import data from many sources and then clean, transform and reshape your data as needed. The course is designed for learners opting to learn Power Query, a feature available in Excel. Power query is a data connection technology that enables you to connect combine refine and discover data from various sources to meet analysis needs.  The course will introduce you to the basic features of Power query and then show how to trim and transform Data in Excel Power Query, Format Dates and Values in Excel Power Query. You will also learn how to extract data from folders and doing auto clean up on Excel Power Query. You will also learn to merge and shape data according to analysis requirements and prepare models by tools such as power pivot. Learning Outcomes: Acquire proficiency in using Excel Power Query for efficient data management. Master the art of transforming raw data into actionable insights. Learn advanced techniques for data manipulation and analysis. Develop the ability to streamline complex data processes. Enhance your analytical thinking and problem-solving skills. How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Why study this 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. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! 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 paths Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Financial Analyst: £28,000 - £45,000 Per Annum Marketing Analyst: £24,000 - £40,000 Per Annum Operations Analyst: £26,000 - £42,000 Per Annum Management Consultant: £35,000 - £55,000 Per Annum Course Curriculum Microsoft Excel: Master Power Query in 120 Minutes! Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Excel Power Query - Query Editor Ribbon 00:09:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Transform Data - Split Text Fields in Excel Power Query 00:10:00 Transform Data - Group By in Excel Power Query 00:03:00 Transform Data - Unpivoting Columns in Excel Power Query 00:05:00 Transform Data - Pivoting Columns in Excel Power Query 00:02:00 Transform Data - Split Columns into Other Columns in Excel Power Query 00:04:00 Transform Data - Filtering Rows in Excel Power Query 00:05:00 Transform Data - Sorting Columns in Excel Power Query 00:02:00 Transform Data - Transform and Add Columns in Excel Power Query 00:07:00 From Folder - Import From Folder in Excel Power Query 00:07:00 From Folder - Doing Auto Cleanup in Excel Power Query 00:13:00 From Folder - Extract Data from Forms in Excel Power Query 00:13:00 From Workbook - Extract Multiple Criteria in Excel Power Query 00:05:00 From Workbook - Extract Multiple Worksheets in Excel Power Query 00:04:00 Joins - Intro to Joins 00:04:00 Joins - Merging 00:08:00 Joins - Full Outer Join 00:06:00 Joins - Right Anti Join 00:09:00 Power Query - Convert Reports into Pivot Tables 00:05:00 Modulo 00:06:00

Description Register on the Learn AutoCAD Programming using VB.NET - Hands On! 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 a certificate as proof of your course completion. The Learn AutoCAD Programming using VB.NET - Hands On! course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, 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 This Course Receive a digital 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) Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment You need to attend an assessment right after the completion of this course to evaluate your progression. For passing the assessment, you need to score at least 60%. After submitting your assessment, you will get feedback from our experts immediately. Who Is This Course For The course is ideal for those who already work in this sector or are aspiring professionals. 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.   Course Content Unit 01: Introduction Module 01: Course Outline 00:05:00 Module 02: Introduction 00:01:00 Module 03: Who is this Course for? 00:01:00 Module 04: What will I learn from this Course? 00:01:00 Module 05: What is VB.NET? 00:01:00 Module 06: What is AutoCAD .NET API? 00:01:00 Module 07: What are the advantages of programming in AutoCAD .NET API? 00:01:00 Module 08: Hands-on Projects overview 00:06:00 Unit 02: Exploring AutoCAD .NET API Components Module 01: AutoCAD .NET API Components Overview 00:01:00 Module 02: AutoCAD .NET API Assemblies 00:02:00 Module 03: Understanding AutoCAD Object Hierarchy 00:03:00 Module 04: AutoCAD .NET API Application Object 00:02:00 Module 05: AutoCAD .NET API Document Object 00:02:00 Module 06: AutoCAD .NET API Database Object 00:04:00 Unit 03: Hello AutoCAD from VB.NET Module 01: Section Overview 00:01:00 Module 02: Installing Visual Studio 2019 00:05:00 Module 03: Setting up Visual Studio 2019 Integrated Development Environment (IDE) 00:04:00 Module 04: Creating First VB.NET Plugin (Hello AutoCAD) 00:12:00 Module 05: Different ways to communicate with the User 00:04:00 Module 06: Configuring VS2019 Target Processor 00:10:00 Unit 04: Creating AutoCAD Objects using VB.NET Module 01: Creating AutoCAD Object using VB.NET Overview 00:01:00 Module 02: Creating DrawObjects Project 00:04:00 Module 03: Creating a Line Object using VB.NET 00:15:00 Module 04: Creating a MText Object using VB.NET 00:12:00 Module 05: Creating a Circle Object using VB.NET 00:09:00 Module 06: Creating an Arc Object using VB.NET 00:07:00 Module 07: Creating a Polyline Object using VB.NET 00:08:00 Module 08: Creating Multiple Circles Vertically 00:09:00 Module 09: Creating Multiple Circles Horizontally 00:05:00 Unit 05: Manipulating AutoCAD Objects using VB.NET Module 01: Manipulating AutoCAD Objects Overview 00:01:00 Module 02: Creating the Project ManipulateObjects 00:04:00 Module 03: Creating the SingleCopy Method 00:13:00 Module 04: Creating the MultipleCopy Method 00:11:00 Module 05: Creating the EraseObject Method 00:12:00 Module 06: Creating the MoveObject method 00:07:00 Module 07: Creating the MirrorObject method 00:10:00 Module 08: Creating the RotateObject method 00:07:00 Module 09: Creating the ScaleObject method 00:05:00 Module 10: Creating the OffsetObject method 00:05:00 Unit 06: Exploring AutoCAD Dictionaries using VB.NET Module 01: Exploring AutoCAD Dictionaries - Overview 00:02:00 Module 02: Creating LayersLineTypesAndStyles Project 00:06:00 Module 03: Creating the ListLayers Method 00:11:00 Module 04: Creating the CreateLayer Method 00:10:00 Module 05: Creating the UpdateLayer Method 00:12:00 Module 06: Creating the SetLayerOnOff Method 00:08:00 Module 07: Creating the SetLayerFrozenOrThaw Method 00:04:00 Module 08: Creating the DeleteLayer Method 00:05:00 Module 09: Creating the LockUnlockLayer Method 00:04:00 Module 10: Creating the SetLayerToObject Method 00:08:00 Module 11: Creating the ListLineTypes Method 00:09:00 Module 12: Creating the LoadLineType Method 00:07:00 Module 13: Creating the SetCurrentLineType Method 00:05:00 Module 14: Creating the DeleteLineType Method 00:09:00 Module 15: Creating the SetLineTypeToObject Method 00:05:00 Protected: Module 16: Exploring TextStyles - Overview 00:01:00 Module 17: Creating the ListStyles Method 00:08:00 Module 18: Creating the UpdateCurrentTextStyleFont Method 00:12:00 Module 19: Creating the SetCurrentTextStyle Method 00:08:00 Module 20: Creating the SetTextStyleToObject Method 00:08:00 Unit 07: User Interactions in VB.NET Module 01: User Input Functions - Overview 00:02:00 Module 02: Creating the UserInteractions Project 00:03:00 Module 03: Creating the GetName Method 00:11:00 Module 04: Creating the SetLayer Method using the GetString function 00:12:00 Module 05: Creating the CreateLineUsingGetpoint Method 00:11:00 Module 06: Creating the CalculateDefinedArea Method 00:17:00 Module 07: Creating the DrawObjectsUsingGetKeywords Method 00:14:00 Module 08: Creating the GetDistanceBetweenTwoPoints Method 00:05:00 Module 09: Creating the CountObjects Method 00:15:00 Unit 08: Selection Sets and Filters Module 01: Selection Sets and Filters - Overview 00:13:00 Module 02: Creating the SelectionSets Project 00:05:00 Module 03: Creating the SelectAllAndChangeLayer Method 00:12:00 Module 04: Creating the SelectObjectOnScreen Method 00:08:00 Module 05: Creating the SelectWindowAndChangeColor Method 00:06:00 Module 06: Creating the SelectCrossingAndDelete Method 00:05:00 Module 07: Creating the SelectFenceAndChangeLayer Method 00:06:00 Module 08: Creating the CountPickFirstSelection Method 00:07:00 Module 09: Creating the SelectLines Method 00:13:00 Module 10: Creating the SelectMTexts Method 00:05:00 Module 11: Creating the SelectPlines Method 00:04:00 Module 12: Creating the SelectWalls Method 00:07:00 Module 13: Creating the SelectStairs Method 00:03:00 Module 14: Creating the SelectFrenchDoors Method 00:04:00 Module 15: Creating the SelectBifoldDoors Method 00:03:00 Module 16: Creating CountReceptacles Method 00:04:00 Module 17: Creating the CountLightingFixtures Method 00:10:00 Unit 09: Developing Projects - Hands On Module 01: Developing Projects - Hands on Overview 00:02:00 Module 02: BlocksCounter Plugin Demo 00:03:00 Module 03: Creating the BlocksCounter Project 00:04:00 Module 04: Creating the CountBlocksToTable Method 00:08:00 Module 05: Creating the PromptUser Function 00:08:00 Module 06: Creating the GatherBlocksAndDrawTable Method 00:12:00 Module 07: Continuation of GatherBlocksAndDrawTable Method 00:17:00 Module 08: Running and Debugging the BlocksCounter Project - Part 1 00:15:00 Module 09: Running and Debugging the BlocksCounter Project - Part 2 00:11:00 Module 10: Running and Debugging the BlocksCounter Project - Part 3 00:01:00 Module 11: Creating the ObjectExtractor Plugin Project 00:04:00 Module 12: Creating the ExtractObjects Method 00:07:00 Module 13: Creating the ExtractLine Method 00:16:00 Module 14: Running and Debugging the ExtractLine Method 00:05:00 Module 15: Creating the ExtractCircle Method 00:11:00 Module 16: Creating the ExtractMText Method 00:13:00 Module 17: Creating the ExtractPolyline Method 00:19:00 Module 18: Creating the ExtractBlock Method 00:10:00 Unit 10: Conclusion Module 01: Congratulations and Thank you very much! 00:01:00 Assignment Assignment - Learn AutoCAD Programming using VB.NET - Hands On! 00:00:00

This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports. This course will help participants: Plan and create a database Sort and filter records Use field data types Work with tables Create and manage a query Create and work with forms, and use the form wizard View, create and print reports 1 Access introduced Planning a database Creating a blank database Opening an existing database Security warnings The navigation pane Previewing database components Closing an Access database 2 Tables introduced Viewing and navigating table data Navigating using keyboard shortcuts Editing table data Adding records to tables Selecting and deleting records Finding and replacing data Filtering tables Summing table data 3 Queries introduced Opening a query in datasheet view Opening a query in design view Adding fields to a query Sorting query results Modifying datasheet view Saving and closing queries 4 Forms introduced Working with form data Sorting records Filtering records Working in design and layout views Changing object attributes 5 Reports introduced Opening and viewing reports Viewing a report in design view Previewing and printing report data Creating reports with auto report Creating reports with the report wizard Changing field attributes 6 Creating a new database Creating database tables Creating table fields Selecting field data types 7 Table relationships Introducing relationships Establishing table relationships The one-to-many relationship type Establishing referential integrity 8 Creating queries Streamline query criteria using wildcards Creating summary queries Creating queries based on criteria Running date queries Formatting field properties Building queries from multiple tables Summing in queries 9 Creating forms Creating a new form Inserting form fields Working with the property sheet The command button wizard The command button wizard Programming without typing Creating forms with embedded sub forms Creating forms with the sub form wizard Creating forms with the form wizard 10 Creating reports What are report bands? Managing report controls Basing reports on multiple tables Basing reports on queries Sorting and grouping records

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

Overview Learn AutoCAD Programming using VB.NET - Hands On! Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Learn AutoCAD Programming using VB.NET - Hands On! Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Unit 01: Introduction Module 01: Course Outline 00:05:00 Module 02: Introduction 00:01:00 Module 03: Who is this Course for? 00:01:00 Module 04: What will I learn from this Course? 00:01:00 Module 05: What is VB.NET? 00:01:00 Module 06: What is AutoCAD .NET API? 00:01:00 Module 07: What are the advantages of programming in AutoCAD .NET API? 00:01:00 Module 08: Hands-on Projects overview 00:06:00 Unit 02: Exploring AutoCAD .NET API Components Module 01: AutoCAD .NET API Components Overview 00:01:00 Module 02: AutoCAD .NET API Assemblies 00:02:00 Module 03: Understanding AutoCAD Object Hierarchy 00:03:00 Module 04: AutoCAD .NET API Application Object 00:02:00 Module 05: AutoCAD .NET API Document Object 00:02:00 Module 06: AutoCAD .NET API Database Object 00:04:00 Unit 03: Hello AutoCAD from VB.NET Module 01: Section Overview 00:04:00 Module 02: Installing Visual Studio 2019 00:05:00 Module 03: Setting up Visual Studio 2019 Integrated Development Environment (IDE) 00:04:00 Module 04: Creating First VB.NET Plugin (Hello AutoCAD) 00:12:00 Module 05: Different ways to communicate with the User 00:04:00 Module 06: Configuring VS2019 Target Processor 00:10:00 Unit 04: Creating AutoCAD Objects using VB.NET Module 01: Creating AutoCAD Object using VB.NET Overview 00:01:00 Module 02: Creating DrawObjects Project 00:04:00 Module 03: Creating a Line Object using VB.NET 00:15:00 Module 04: Creating a MText Object using VB.NET 00:12:00 Module 05: Creating a Circle Object using VB.NET 00:09:00 Module 07: Creating a Polyline Object using VB.NET 00:08:00 Module 08: Creating Multiple Circles Vertically 00:09:00 Module 09: Creating Multiple Circles Horizontally 00:05:00 Unit 05: Manipulating AutoCAD Objects using VB.NET Module 01: Manipulating AutoCAD Objects Overview 00:01:00 Module 02: Creating the Project ManipulateObjects 00:04:00 Module 03: Creating the SingleCopy Method 00:13:00 Module 04: Creating the MultipleCopy Method 00:11:00 Module 05: Creating the EraseObject Method 00:12:00 Module 06: Creating the MoveObject method 00:07:00 Module 07: Creating the MirrorObject method 00:10:00 Module 08: Creating the RotateObject method 00:07:00 Module 09: Creating the ScaleObject method 00:05:00 Module 10: Creating the OffsetObject method 00:05:00 Unit 06: Exploring AutoCAD Dictionaries using VB.NET Module 01: Exploring AutoCAD Dictionaries - Overview 00:02:00 Module 02: Creating LayersLineTypesAndStyles Project 00:06:00 Module 03: Creating the ListLayers Method 00:11:00 Module 04: Creating the CreateLayer Method 00:10:00 Module 05: Creating the UpdateLayer Method 00:12:00 Module 06: Creating the SetLayerOnOff Method 00:08:00 Module 07: Creating the SetLayerFrozenOrThaw Method 00:04:00 Module 08: Creating the DeleteLayer Method 00:05:00 Module 09: Creating the LockUnlockLayer Method 00:04:00 Module 10: Creating the SetLayerToObject Method 00:08:00 Module 11: Creating the ListLineTypes Method 00:09:00 Module 12: Creating the LoadLineType Method 00:07:00 Module 13: Creating the SetCurrentLineType Method 00:05:00 Module 14: Creating the DeleteLineType Method 00:09:00 Module 15: Creating the SetLineTypeToObject Method 00:05:00 Module 16: Exploring TextStyles - Overview 00:01:00 Module 17: Creating the ListStyles Method 00:08:00 Module 18: Creating the UpdateCurrentTextStyleFont Method 00:12:00 Module 19: Creating the SetCurrentTextStyle Method 00:08:00 Module 20: Creating the SetTextStyleToObject Method 00:08:00 Unit 07: User Interactions in VB.NET Module 01: User Input Functions - Overview 00:02:00 Module 02: Creating the UserInteractions Project 00:03:00 Module 03: Creating the GetName Method 00:11:00 Module 04: Creating the SetLayer Method using the GetString function 00:12:00 Module 05: Creating the CreateLineUsingGetpoint Method 00:11:00 Module 06: Creating the CalculateDefinedArea Method 00:17:00 Module 07: Creating the DrawObjectsUsingGetKeywords Method 00:14:00 Module 08: Creating the GetDistanceBetweenTwoPoints Method 00:05:00 Module 09: Creating the CountObjects Method 00:15:00 Unit 08: Selection Sets and Filters Module 01: Selection Sets and Filters - Overview 00:13:00 Module 02: Creating the SelectionSets Project 00:05:00 Module 03: Creating the SelectAllAndChangeLayer Method 00:12:00 Module 04: Creating the SelectObjectOnScreen Method 00:08:00 Module 05: Creating the SelectWindowAndChangeColor Method 00:06:00 Module 06: Creating the SelectCrossingAndDelete Method 00:05:00 Module 07: Creating the SelectFenceAndChangeLayer Method 00:06:00 Module 08: Creating the CountPickFirstSelection Method 00:07:00 Module 09: Creating the SelectLines Method 00:13:00 Module 10: Creating the SelectMTexts Method 00:05:00 Module 11: Creating the SelectPlines Method 00:04:00 Module 12: Creating the SelectWalls Method 00:07:00 Module 13: Creating the SelectStairs Method 00:03:00 Module 14: Creating the SelectFrenchDoors Method 00:04:00 Module 15: Creating the SelectBifoldDoors Method 00:03:00 Module 16: Creating CountReceptacles Method 00:04:00 Module 17: Creating the CountLightingFixtures Method 00:10:00 Unit 09: Developing Projects - Hands On Module 01: Developing Projects - Hands on Overview 00:02:00 Module 02: BlocksCounter Plugin Demo 00:03:00 Module 03: Creating the BlocksCounter Project 00:04:00 Module 04: Creating the CountBlocksToTable Method 00:08:00 Module 05: Creating the PromptUser Function 00:08:00 Module 06: Creating the GatherBlocksAndDrawTable Method 00:12:00 Module 07: Continuation of GatherBlocksAndDrawTable Method 00:17:00 Module 08: Running and Debugging the BlocksCounter Project - Part 1 00:15:00 Module 09: Running and Debugging the BlocksCounter Project - Part 2 00:11:00 Module 10: Running and Debugging the BlocksCounter Project - Part 3 00:01:00 Module 11: Creating the ObjectExtractor Plugin Project 00:04:00 Module 12: Creating the ExtractObjects Method 00:07:00 Module 13: Creating the ExtractLine Method 00:16:00 Module 14: Running and Debugging the ExtractLine Method 00:05:00 Module 15: Creating the ExtractCircle Method 00:11:00 Module 16: Creating the ExtractMText Method 00:13:00 Module 17: Creating the ExtractPolyline Method 00:19:00 Module 18: Creating the ExtractBlock Method 00:10:00 Unit 10: Conclusion Module 01: Congratulations and Thank you very much! 00:01:00 Assignment Assignment - Learn AutoCAD Programming using VB.NET - Hands On! 00:00:00

Duration 1 Days 6 CPD hours This course is intended for This course is intended for students who have a foundational working knowledge of PowerPoint, who wish to take advantage of the application's higher-level usability, security, collaboration, and distribution functionality. Overview In this course, you will use the advanced tools and features in PowerPoint to create and deliver engaging presentations.You will: Customize design templates. Add tables. Add charts. Work with media. Build advanced transitions and animations. Collaborate on a presentation. Customize the delivery of a presentation. Modify presentation navigation. Secure and distribute a presentation. Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But Microsoft© PowerPoint© provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don't consume all of your available time. Note: Most Office users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Microsoft 365? subscription. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version. This course may be a useful component in your preparation for the PowerPoint Associate (Microsoft 365 Apps and Office 2019): Exam MO-300 certification exam. Lesson 1: Customizing Design Templates Topic A: Modify Slide Masters and Slide Layouts Topic B: Modify the Notes Master and the Handout Master Topic C: Add Headers and Footers Lesson 2: Adding Tables Topic A: Create a Table Topic B: Format a Table Topic C: Insert a Table from Other Office Applications Lesson 3: Adding Charts Topic A: Create a Chart Topic B: Format a Chart Topic C: Insert a Chart from Microsoft Excel Lesson 4: Working with Media Topic A: Add Audio to a Presentation Topic B: Add Video to a Presentation Topic C: Add a Screen Recording Lesson 5: Building Advanced Transitions and Animations Topic A: Use the Morph Transition Topic B: Customize Animations Lesson 6: Collaborating on a Presentation Topic A: Review a Presentation Topic B: Co-author a Presentation Lesson 7: Customizing Presentation Delivery Topic A: Enhance a Live Presentation Topic B: Record a Presentation Topic C: Set Up a Slide Show Lesson 8: Modifying Presentation Navigation Topic A: Divide a Presentation into Sections Topic B: Add Links Topic C: Create a Custom Slide Show Lesson 9: Securing and Distributing a Presentation Topic A: Secure a Presentation Topic B: Create a Video or a CD

Overview This comprehensive course on AutoCAD VBA Programming - Beginner course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This AutoCAD VBA Programming - Beginner course 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 AutoCAD VBA Programming - Beginner course. It is available to all students, of all academic backgrounds. Requirements Our AutoCAD VBA Programming - Beginner course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 11 sections • 42 lectures • 03:37:00 total length •Module 01: Introduction: 00:04:00 •Module 02: Course Content Identified: 00:06:00 •Module 01: Setting-up the Environment (Installing VBA IDE): 00:01:00 •Module 02: Downloading and Installing AutoCAD VBA IDE: 00:04:00 •Module 03: Identify and Understand VBA IDE Components (Toolbars and Windows): 00:03:00 •Module 04: VBA IDE Walkthrough: 00:14:00 •Module 01: Examining AutoCAD VBA Object Model Structure: 00:07:00 •Module 02: Examining AutoCAD Object Model Structure Part 2: 00:06:00 •Module 01: Working on Variables: 00:01:00 •Module 02: Using Variables in the Program: 00:14:00 •Module 01: User Forms and Controls Topic Breakdown: 00:02:00 •Module 02: Using Label, Textbox and Command Button Controls: 00:10:00 •Module 03: Using ListBox Control: 00:06:00 •Module 04: Using ComboBox Control: 00:09:00 •Module 05: Using CheckBox Control: 00:08:00 •Module 06: Using OptionButton Control: 00:03:00 •Module 07: Using MultiPage Control: 00:10:00 •Module 08: Using MultiPage Control Continued: 00:14:00 •Module 09: Using Frame Control: 00:03:00 •Module 01: Conditions and Decisions Course Outline: 00:01:00 •Module 02: IF-THEN-ELSE Condition: 00:02:00 •Module 03: IF-THEN-ELSEIF Condition: 00:04:00 •Module 04: Conditional Operators in VBA: 00:04:00 •Module 05: Logical Operators in VBA: 00:07:00 •Module 06: SELECT CASE Statement in VBA: 00:05:00 •Module 01: Looping and Iterations Overview: 00:02:00 •Module 02: Using DO-WHILE Loop in VBA: 00:04:00 •Module 03: Using DO-UNTIL Loop in VBA: 00:02:00 •Module 04: Using FORNEXT Loop in VBA: 00:02:00 •Module 05: Using FOREACHNEXT Loop in VBA: 00:03:00 •Module 01: Drawing Objects Overview: 00:01:00 •Module 02: Draw a Line Object using Utility Function: 00:03:00 •Module 03: Draw a Line Object using Points from User's Input: 00:07:00 •Module 04: Draw a Circle Object Using Utility Functions: 00:03:00 •Module 05: Draw a Text Object using Utility Functions: 00:05:00 •Module 06: Draw a LWPolyline and Polyline Objects: 00:06:00 •Module 01: Code Debugging Overview: 00:01:00 •Module 02: Code Debugging in VBA Demo: 00:12:00 •Module 03: Code Debugging in VBA Demo Continued: 00:02:00 •Module 01: Error Handling Course Outline: 00:02:00 •Module 02: Error Handling in VBA Demo: 00:13:00 •Module 01: Conclusion and Thank you!: 00:01:00