37 Courses in London

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

Trade barriers are going up across the globe. And cybercrime is on the increase. The link between the two? The value of trade secrets. As countries become increasingly protectionist as regards international trade, so their IP law has been changing, with the result that companies that previously would have sought protection through patents are opting to go down the trade secret route instead. But is this a high-risk strategy? Technology is changing and this is having an impact on forms of commercial co-operation. Collaborative or open forms of innovation by their very nature involve the sharing of intellectual property (IP), and in many instances this IP is in the form of valuable confidential business information (ie, trade secrets). Little surprise, then, that trade secrets disputes have increased accordingly. At the same time, the changes in technology make trade secrets more vulnerable to attack, misappropriation, theft. So just how effective are the legal protections for trade secrets? How can organisations safeguard the value in their IP (increasingly, the single biggest line in their balance sheets)? This programme is designed to help you address these issues. Note: this is an indicative agenda, to be used as a starting point for a conversation between client and consultant, depending on the organisation's specific situation and requirements. This session is designed to give you a deeper understanding of: Emerging trends in trade secrets protection and exploitation The current situation in key jurisdictions Recent case law How leading companies are responding The importance of trade secret metadata Different external stakeholders and their interests Key steps for effective protection of trade secrets Note: this is an indicative agenda, to be used as a starting point for a conversation between client and consultant, depending on the organisation's specific situation and requirements. 1 What are trade secrets? Definitions Examples Comparison with other forms of IP (patents, confidential information, know-how, copyright) 2 Current trends The various changes taking place affecting trade secrets - legal changes, trade wars, cybercrime, technology, commercial practice The current position in the UK, Europe, USA, China, Japan, Russia Corporate best practice 3 Trade secret disputes - how to avoid them Trade secret policies, processes and systems Administrative, legal and technical protection mechanisms The role of employees The sharing of trade secrets with others 4 Trade secret disputes - how to manage them Causes Anatomy of a trade secret court case 'Reasonable particularity' 5 Related issues Insurance Tax authorities and investigations Investor relations 6 Trade secret asset management roadmap Maturity ladder First steps Pilot projects

It is essential that those charged with responsibility for credit control and debt recovery have a full appreciation of the relevant law: no-one can negotiate effectively to recover a debt if they don't understand the ultimate sanctions they can apply. This programme is designed to give them a practical, up-to-date understanding of the law as it applies to your particular organisation. This course will help ensure that participants: Understand the relevant laws Know how and when to invoke legal processes Avoid legal pitfalls in debt collection negotiations Specific, practical learning points include: Definition of 'harassment' How to set up an in-house collection identity Whether cheques in 'full and final settlement' are binding The best steps to trace a 'gone away'... and many, many more. 1 Data protection and debt recovery There are a whole range of things which can be checked on members of the public and which are not affected by the restraints of the Data Protection Act. These will be explained in simple, clear terms so that staff can use this information immediately. 2 County Court suing The expert trainer will show how to sue for money owed, obtain judgment and commence enforcement action without leaving your desk. This module is aimed at showing how to make the Courts work for you instead of the other way around! 3 Enforcement of judgments There are many people who have a County Court Judgment (CCJ) against their debtor but who still remain unpaid. This session explains each of the enforcement methods and how to use them to best effect. Enforcement methods covered include: Warrant of Execution Using the sheriff (now known as High Court Enforcement Officers) Attachment of earnings Third Party Debt Orders Charging Orders (over property and goods) Winding-up companies and making individuals bankrupt 4 Office of Fair Trading rules on debt recovery Surprisingly few people are aware of the Office of Fair Trading rules on debt recovery and many of those that do know think they don't apply to them - but they do. Make sure you know what you need to! 5 New methods to trace elusive, absentee and 'gone away' debtors Why write the money off when you can trace the debtor and collect the money you are owed? 6 Credit checking of new and existing customers It makes sense to credit check would-be, new and existing customers to evaluate the likelihood of payment delays or perhaps not being paid at all. This session shows a range of credit checking steps, many of which can be done completely free of charge, including a sample credit application/ account opening form. 7 Late Payment of Commercial Debts Regulations Do your staff understand this legislation and how to use it to make people pay quicker than ever before? The trainer shows how. 8 The Enterprise Act The Enterprise Act made some startling changes to corporate and personal insolvency. What are the implications for credit control and debt recovery within your organisation?

This very practical two-day workshop analyses the content and implications of key MoD terms and conditions of contract. The programme explains the principles and terminology of the contractual aspects of defence procurement as well as considering a number of relevant policies and initiatives. The course covers key components, constructs and methodologies associated with any commercial venture entered into with the UK MoD. Starting at the MoD organisational level the workshop sets the scene by looking at the acquisition process and organisation, detailing the various roles and responsibilities of MoD personnel. The workshop provides an in-depth examination of MoD DEFCONs and many narrative terms, setting them in the context of the organisation and its structures. The workshop helps participants to gain an understanding of the content and purpose of the range of MoD DEFCONs and narrative conditions commonly used throughout the acquisition lifecycle. It includes a review of Part 2 of the Defence Reform Act 2014 regarding Single Source Pricing, which comes into effect in 2015 and is already starting to be applied to significant contracts. On completion of this programme the participants will understand the terminology associated with the MoD terms and conditions of contract and will have an accurate view of their relevance, usage and their legal basis and how they can affect contractual and commercial decision-making. They will have gained an insight into defence acquisition contracting and they will be more commercially aware. DAY ONE 1 The commercial environment Key roles and responsibilities of the MoD organisations at the heart of the acquisition process 2 Tendering to MoD An appraisal of some of the obligations placed upon contractors when they are submitting a proposal to the MoD pre-contract 3 Standardised contracting MoD have introduced non-negotiable standardised contracts for certain levels of procurement. This section considers their use and relevance to defence contracting 4 Pricing, profit, post-costing and payment The parameters specific to a costing structure and the differences between competitive and non-competitive bidding The role of the QMAC, the profit formula, the requirements for equality of information and post-costing Different types of pricing and issues surrounding payment 5 Defence Reform Act - Single Source Pricing Single Source Pricing under Part 2 of the new Defence Reform Act Changes from the existing position, how contractors are affected and the compliance regime that accompanies the new requirements 6 Delivery and acceptance Specific requirements and the significance and impact of failing to meet them Acceptance plans Non-performance and the remedies that may be applied by the Customer - breach of contract, liquidated damages and force majeure DAY TWO 7 Protection of information and IPR Contractor's and MoD's rights to own and use information How to identify background and foreground intellectual property Technical information and copyright in documentation and software How to protect IPR at the various stages of the bidding and contracting process 8 Defence Transformation and Defence Commercial Directorate Widening and increasing roles and functions of the Defence Commercial Directorate Background to the Defence Reform Act 2014 9 Legal requirements Terms used in MoD contracts to reflect basic legal requirements Records and materials required for MOD contracts and therefore the obligations, responsibilities and liabilities that a company undertakes when it accepts these conditions Overseas activities 10 Subcontracting and flowdown Understanding the constructs required by the MoD for subcontracting Which terms must be flowed down to the subcontractor and which are discretionary 11 Termination Termination of a contract for default Termination for convenience How to optimise the company's position on termination 12 Warranties and liabilities Obligations and liabilities a company might incur and how they might be mitigated MoD policy on indemnities and limits of liability 13 Electronic contracting environment Electronic forms of contracting Progress toward a fully electronic contracting environment

Our team of Construction industry experts provide business management training for leaders and business owners across England and Scotland CONSTRUCTION INDUSTRY SPECIFIC Construction Business Growth Academy The Power Within Training is dedicated to helping construction-based business owners and construction management throughout England, Scotland, and Wales achieve more than they believed possible. Our construction business training is designed to develop owner-managers and help them create the future they want. To ensure business growth, we have a dedicated team of industry professionals to give unique support specific to the skills, traits, and challenges found within Construction. This programme was created to help you push and elevate your business to the next level. Contact us to register for our construction business training. Explore Our Construction Business Growth Course We created the Business Growth Academy for business owners like you to grow and develop their businesses in a more controlled and sustainable way. To ensure growth, our construction business training is a series of six training modules focused on business growth, leadership, and financial management. Most of our participants are business owners looking to get the tools needed to spend more time working on their business while generating more profitability to ensure consistent business growth. The Power Within Training uses the latest business growth strategies, which allow you to identify, modify and quickly implement our easy-to-follow business-building tools and techniques designed around the construction and property development industry. Whether you are a business owner or an aspiring construction and property development entrepreneur, our Construction Management Course will provide the tools and techniques to drive your business forward and achieve sustainable growth. Join us at the Business Growth Academy and unlock your full potential. The Goal of Our Construction Management Training Our goal with this training is to provide you with the tools you need to take control of your business. This allows you to use the latest strategies and ensure the smooth growth of your construction business. The construction management training we offer is a three-month course with new modules available twice monthly, delivered via Zoom or in person. These modules are designed to work around your schedule. After, you’ll have a 39-hour CPD certification thanks to our CITB skills & training courses. Overall, our fully funded construction management training will help you place the proper foundation, allowing you to build a more substantial and focused business that’s centred around constant growth and profits while future-proofing your business. BUSINESS GROWTH ACADEMY The Benefit of Our Business Growth Academy As you go through our training, you’ll delve into each module and the critical steps and tools. These include how to plan, organize, and control construction operations, all designed to provide you with a well-rounded view of your business. Not only will you get the tools you need to ensure your construction business growth, but you’ll also get access to benefits such as lifetime access to your online interactive training portal, entrance into a private social and professional networking group, pro bono coaching, and mentoring from industry experts and leaders. Here are some additional benefits of our construction management training: Register your interest today You’ll build a personalised 12-month business development plan that keeps you focused on high-value activities, ensuring you remain on track to grow. Tools and techniques to not only measure but also increase your profitability within your business. These tools help you ensure that you’re never leaving money on the table again. Learn, develop, and nurture self-management and leadership strategies that you can work on and in your business to help you from chasing your tail or burning out. You’ll develop unshakeable confidence in your business’s ability to grow and become the kind of entrepreneur that chooses the customers they want to work with, meaning customers who are driven by value, not by price. Gain valuable leadership and self-development skills, which encourage learning for life. Lastly, you’ll no longer wonder, “what if?” You’ll have the knowledge and understanding to keep unlocking and growing your business’s true potential. WHAT'S INCLUDED IN THE PROGRAMME Course Overview As we’ve mentioned, our business management course is designed to be completed over three months, with two courses being released monthly. These are designed to be done on Zoom or in person and are flexible around your busy schedule. Our modules were created to be easy to understand while providing the resources needed to elevate your construction business. Here is a more in-depth look at what to expect from our modules: Module 1: The C.O.D.E Breaker: The Business FundamentalsThis module will encourage you to deep dive into your why and break the business C.O.D.E. You’ll be shown the importance of knowing why you started the business, how you can build a business while remaining authentic, and what needs to be done to ensure you create and support a solid foundation moving forward. During this module, you’ll discover how to successfully build a business in the construction industry, from the fundamentals and foundations to the growth. Lastly, we’ll review your vision, values, and purpose, show why these are critical areas, and allow you to establish a real business for you and your customers. Module 2: Your M.E.N.T.A.L Agility: The Entrepreneurial Mindset With this module, we’ll focus on self-leadership and how you should constantly be developing the ‘inner game’ or minder and the ‘outer game’ or action. The inner game consists of intention, self-awareness, self-confidence, and self-efficacy. These must be used to achieve personal mastery, while the outer game consists of influence and impact. M.E.N.T.A.L. agility is your key to all success and failure, meaning that without leading yourself, you’ll never find business success. For us, your M.E.N.T.A.L. agility is made of five key components that enable you to transition from owning a business to thinking and planning like an entrepreneurial business owner. Module 3: The T.I.M.E Multiple: Working ON or Working IN The point of this module is to help you understand that you can’t manage your time; you can only manage your use of time or your self-management skills. It’s vital to have strong self-management skills to be more successful at work. We’ll explore ways to help maximise your time and identify your High Payoff Activities. The T.I.M.E. multiplier is about accepting that you cannot do everything yourself. Instead, it would be best if you focused on your high-payoff activities. Our goal is to teach you to say it’s okay to say no. We’ll show you the importance of recognising the significance of all your decisions. Along with that, we focus on unique planning and defining processes to bring the future into the present. Module 4: The Business P.R.O.B.E: The Numbers Game Understanding your finances is essential as it allows you to make informed decisions that have the potential to make significant impacts on your business, growth, and even your bottom line. We want you never to leave money on the table again. When you know the difference between markup and margin, fixed and variable costs can make the difference between owning a business and the business owning you. Understanding your business numbers will increase your revenue and profitability and even grow your business. Module 5: High-Performance T.E.A.M.S: The Well-Oiled High-performing teams are more than a group that works together. A high-performing team has clear priorities and purposes and shares an understanding of how each team member or subcontractor prefers to approach work. The foundation of a high-performing team or business starts with trust. The development starts with creating an environment where leaders and team members can openly disclose which strengths they feel they bring to a team and what support they need to be their best selves. Truth is that all people’s problems directly reflect the business owner’s leadership and management. When a team doesn’t do things your way, they probably have no idea what your way is. Module 6: G.O.A.L.S: Setting & Defining the Accountability System Everyone works best with clearly defined goals, from completing a refurb on a budget or growing your construction business to over 10M annual profit. Remember the old saying, through a goal with a plan, is just a wish! We’ll teach you our tried and tested process for setting and achieving your objectives by focusing on what matters most. Reviewing your daily, weekly, and monthly goals, we can help you make high performance a habit. Best of all, you’ll create a detailed 12-month business development plan to get your personal and professional goals moving in the right direction. Meet the Construction Business Training Presenters Derrick Matheson: Training and Development Director and Trainer of Business Growth Academy A seasoned business owner, Derrick understands the challenges UK construction and property development professionals face. We have crafted a targeted program that simplifies growth, empowering entrepreneurs with easy-to-implement strategies.  Derrick’s mission is simple: to empower and equip ambitious entrepreneurs and professionals with the tools and knowledge necessary to thrive in today’s competitive market. The Business Growth Academy is a testament to his dedication, offering an innovative, step-by-step business-building process that demystifies the complexities of growth and unlocks the full potential of your enterprise. Stuart Mason: BGA’s Bold Training Manager, Lead Trainer, and Author of “How To Wreck Your Business Stuart, the fearless BGA Training Manager and Lead Trainer has turned his business failures into powerful lessons for others. As the author of “How To Wreck Your Business,” Stuart shares his hard-earned wisdom to help business owners avert the same pitfalls that led to the demise of his own company on its 20th anniversary. Stuart’s approach is refreshingly direct and unapologetically abrupt, cutting through the noise to deliver real-world insights that make a difference. Don’t expect a dry lecture on business theory from a dusty textbook; instead, Stuart offers a ‘streetwise’ perspective that is both practical and actionable, pushing you to uncover the answers that will make your business shine in a competitive market.

This is not a single course but a set of menu options from which you can 'pick and mix' to create a draft programme yourself, as a discussion document which we can then fine-tune with you. For a day's training course, simply consider your objectives, select six hours' worth of modules and let us do the fine-tuning so that you get the best possible training result. Consider your objectives carefully for maximum benefit from the course. Is the training for new or experienced credit control staff? Are there specific issues to be addressed within your particular sector (eg, housing, education, utilities, etc)? Do your staff need to know more about the legal issues? Or would a practical demonstration of effective telephone tactics be more useful to them? Menu Rather than a generic course outline, the expert trainer has prepared a training 'menu' from which you can select those topics of most relevance to your organisation. We can then work with you to tailor a programme that will meet your specific objectives. Advanced credit control skills for supervisors - 1⁄2 day Basic legal overview: do's and don'ts of debt recovery - 2 hours Body language in the credit and debt sphere - 1⁄2 day County Court suing and enforcement - 1⁄2 day Credit checking and assessment - 1 hour Customer visits and 'face to face' debt recovery skills - 1⁄2 day Data Protection Act explained - 1⁄2 day Dealing with 'Caring Agencies' and third parties - 1 hour Debt counselling skills - 2 hours Elementary credit control skills for new staff - 1⁄2 day Granting credit and collecting debt in Europe - 1⁄2 day Identifying debtors by 'type' to handle them accurately - 1 hour Insolvency: Understanding bankruptcy / receivership / administration / winding-up / liquidation / CVAs and IVAs - 2 hours Late Payment of Commercial Debts Interest Act explained - 2 hours Liaison with sales and other departments for maximum credit effectiveness - 1 hour Suing in Scottish Courts (Small Claims and Summary Cause) - 1⁄2 day Telephone techniques for successful debt collection - 11⁄2 hours Terms and conditions of business with regard to credit and debt - 2 hours Tracing 'gone away' debtors (both corporate and individual) - 11⁄2 hours What to do if you/your organisation are sued - 1⁄2 day Other topics you might wish to consider could include: Assessment of new customers as debtor risks Attachment of Earnings Orders Bailiffs and how to make them work for you Benefit overpayments and how to recover them Cash flow problems (business) Charging Orders over property/assets Credit policy: how to write one Council and Local Authority debt recovery Consumer Credit Act debt issues Using debt collection agencies Director's or personal guarantees Domestic debt collection by telephone Exports (world-wide) and payment for Emergency debt recovery measures Education Sector debt recovery Forms used in credit control Factoring of sales invoices Finance Sector debt recovery needs Third Party Debt Orders (Enforcement) Government departments (collection from) Harassment (what it is - and what it is not) Health sector debt recovery skills Hardship (members of the public) Insolvency and the Insolvency Act In-house collection agency (how to set up) Instalments: getting offers which are kept Judgment (explanation of types) Keeping customers while collecting the debt Late payment penalties and sanctions Letter writing for debt recovery Major companies as debtors Members of the public as debtors Monitoring of major debtors and risks Negotiation skills for debt recovery Old debts and how to collect them Out of hours telephone calls and visits Office of Fair Trading and collections Oral Examination (Enforcement) Pro-active telephone collection Parents of young debtors Partnerships as debtors Positive language in debt recovery Pre-litigation checking skills Power listening skills Questions to solicit information Retention of title and 'Romalpa' clauses Sale of Goods Act explained Salesmen and debt recovery Sheriffs to enforce your judgment Students as debtors Statutory demands for payment Small companies (collection from) Sundry debts (collection of) Terms and Conditions of Contract Tracing 'gone away' debtors The telephone bureau and credit control Taking away reasons not to pay Train the trainer skills Utility collection needs Visits for collection and recovery Warrant of execution (enforcement)

Overview Understand the structure and mechanics of Target Redemption Notes (TARNs), autocallables, accumulators, and faders. Who the course is for CEOs, CFOs, COOs with responsibility for Strategic Management Investment bankers Real estate consultants Management consultants Private Equity investors Financial analysts Institutional Funds and Portfolio Managers Retail investors Course Content To learn more about the day by day course content please request a brochure. To learn more about schedule, pricing & delivery options speak to a course specialist now