37 Courses in London

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

This one-day workshop is intended for participants who have a basic understanding of Outlook but who want to know how to use its advanced features to manage their email communications, calendar events, contact information and other communication tasks. This course will help participants: Gain confidence using Outlook and its advanced features Organise and prioritise email messages Archive messages for safe-keeping Use rules to process received or sent messages automatically Manage scheduled meetings with others Give others permission to view and manage their folders and items Use contacts and commands to find out more about a person or company Prioritise work-flow using tasks and assigning tasks to others 1 Email messages Combining multiple clicks with quick steps Following up flag options Saving multiple attachments Attaching a folder of files Recalling and replacing a message Categorising messages with conditional formatting 2 Message options Adding options to messages Marking a message as private Receiving quick responses with voting buttons Directing replies to specific users Delaying sent messages Inserting links in messages 3 Stay organised with rules Using rules to automate message flow Moving messages with rules Using the rules wizard Setting up rules with conditions Using rules that work whilst you are away 4 Message clean-up Using conversation clean-up Using mailbox clean-up Moving messages to the archive folder Archiving folder properties Auto-archiving properties 5 Managing calendars Creating calendar groups Sharing calendars with permissions Setting up working days and times Managing time zones Categorise appointments with conditional formatting Publishing a calendar 6 Schedule meetings Scheduling a meeting Managing meeting responses Proposing new meeting times Adding attendees to a meeting Viewing multiple appointments 7 Using contacts Merging contacts to letters Merging contacts to labels Mail merging contacts in Word Exporting contacts to Excel 8 Managing tasks Organising your workload with tasks Categorising tasks Assigning tasks to others Sending a task status report Allocating time for tasks Regenerating a new task Viewing your tasks in the calendar 9 Adding message items Adding calendars to messages Adding business cards to messages 10 Email accounts Adding multiple user accounts Adding account permissions

LEATHER CRAFT AND LEATHER SEWING TECHNIQUES: WHAT IS THIS COURSE ABOUT? This is a theoretical and practical introductory group tuition during which you will be taught common, essential leather crafting and sewing techniques and understand how working with leather differs from working with vegan leather or fabric.You will be taught how to correctly use hand tools, how to sew leather by hand and understand the most common finishing and construction techniques used in bag and accessory making. You will learn about different types of leather and understand how to select the correct type of material(s) for your project. You will receive an overview of the technical aspects of working with leather and constructing bags and accessories such as inking, burninshing, marking, cutting, gluing, reinforcing, skiving, debossing and more.You will learn how to saddle stitch, select the appropriate tools for this sewing technique, and produce your own samples of work to take home with you.You will receive relevant, useful and informative handouts as well as lists of leather and tool suppliers. At the end of the lesson, you will have the choice to create a simple hand-sewn leather item, such as a simple purse or card holder, to take home with you, or to practice more techniques.This is a professional course delivered by a prototype maker and manufacturer, with the aim of providing an overview and hands-on experience on more common leather working practices. At the end of the tuition you will have: – Gained an understanding of leather types, tanning methods, leather characteristics and the best uses for specific projects. – Gained confidence in using specific tools for preparing, marking, finishing, cutting leather and fastening fittings. – Understood and practiced leather craft techniques such as inking, beveling and burnishing techniques – Understood what it means to work with different leather types and thicknesses and have the ability to source and select the correct tools and materials for your projects. – Understood how to manipulate leather using tools, reinforcement, stabilisers and stiffeners in crucial areas of bags and accessories. – Gained confidence in sewing by hand and obtained the skills to realise some simple leather items independently. WHAT WILL BE TAUGHT?Below is a list of topics covered during the classes: LEATHER, VEGAN LEATHER AND HAND TOOLS: – Understanding leather: overviews on types of leather, tanning, finishings and best use– Vegan leathers: an overview on different types and features – Understanding how to choose the right materials for your project and the appropriate tools for those materials – Leather preparing, pattern placement and marking on leather – Cutting complex shapes using a variety of tools – Using leather punches – Understanding the use of skiving, beveling and creasing – Finishing leather edges: painting vs burnishing – Using various leather glues and tapes – Understand the use of reinforcements, fusings and stabilisers to back leather – Prototyping and manufacturing leather goods: mentions of different working methods, machines and tools HAND SEWING: – To understand the different options, characteristics, and proper application of the tools used in saddle stitching – To learn the basics of saddle stitching leather and understood the different the tools and materials used in the technique CONSTRUCTION TECHNIQUES: – To create a small, simple hand stitched leather item to take home with you INCLUDED IN THE COURSE: You will be provided with useful digital and paper handouts which contain:– A list of tools and materials used during the lesson(s), including a description of what they are and how they are used– A list of recommended suppliers for both leather and fittings (physically in London and online)– A glossary containing essential key words related to the topic of the lesson– A glossary containing information about leather types and characteristics WHAT ARE THE ENTRY REQUIREMENTS?This course is suitable for total beginners, beginners with some experience and intermediate.You should be able to use measurements and understand verbal and written English instructions.   ARE THERE ANY OTHER COSTS? IS THERE ANYTHING I NEED TO BRING?Materials are included.Feel free to bring a notepad, if you would like to take some notes, we will provide the rest. HOW LONG IS THIS TUITION?:This tuition will require up to 12 hours to complete. We aim to provide customised and high quality tuition services and by only allowing up to 6 students at a time, we are able to focus on each person needs and interests.As every student has a different level of ability and previous experience, this course might lead some students to complete the core aspects of the lesson in a shorter time frame than others.Students who complete the course early will be welcome to stay and use the studio facilities to exercise on the topics of the lesson.

Photoshop pay per hr training flexible time weekend evening

Photography is a way of feeling, of touching, of loving. ... it remembers little things, long after you have forgotten everything. - Aaron Sisking For the kind of photos that are worthy of the memories  Because we just don't get do-overs with kids. There is no such thing as second-first steps. Because all their little quirks, all the big and little moments that shape their lives and their childhoods are something that only YOU as parents see and appreciate fully. And they are the thing that make them who they are. There is simply no outside photographer who can come in and capture those unique things because nobody knows your children like you do. Photography For Parents Fundamentals Our flagship 6 week Photography course designed to help you learn all the key photography skills that you will need to drastically improve your children's photos.  KEY COURSE INFO: Course type: Instructor-led or self paced Course duration: 6 weeks Course format: Online course with Interactive weekly live classes, personal photo feedback and support group WHAT YOU LEARN: Our hands-on online instructor-led approach helps guarantee that you will quickly learn the key camera and photographic storytelling skills while keeping the focus on photographing children.  From camera know-how, light and composition, specific recipes to help you capture typical situations and getting it all right on the fly - yeah, our kids don't sit still either LEARN WHAT'S INCLUDED IN EACH MODULE Key Camera skills Working with natural light Capturing kids on the move Photo composition Portraits and details Photo storytelling HERE IS HOW YOU LEARN WITH US:  If you have bought an online course before, then gave up half way through because ... life.. - well, we are a bit different. This is A LOT more than a bunch of random tutorials. This is a proper, well designed, supported and paced course that genuinely delivers. HERE ARE THE INGREDIENTS THAT MAKE OUR COURSE DELIVER The one with all the materials: 5 core course modules, introduced on a weekly basis, plus a bonus wraparound module ( more on that below) - courses accessible online and in pdf version The one with all the people: You're not going through the course on your own - as part of the course you join an online peer support group, moderated daily by the instructor, where you connect, get help and go through this journey together with other parents like you. The one with all the answers: Every week we run an live online class which is where your instructor goes through the key parts of your course, answers live questions and demonstrates techniques and additional illustration photos. The Live classes are run in the evening ( after the kids are in bed) and are always recorded in case you couldn't join in live The one that's all about you: Every week comes with homework to help you practice the elements we introduce in the modules. You submit those images to your instructor on a weekly basis and receive thorough, photo-by-photo, video feedback from your instructor - so it's all about you and your progress, nobody else's The one with the bonuses: A PDF workbook to help you go through the materials and practice the skills, handy cheat sheets formatted for your phone so you can whip them out on the go plus a Bonus wrap-up module with swipe files of photo ideas for children at different ages, handy checklists and more!  The one after it's over: We don't just leave you on your lonesome after the course is over - you get access to a=our Alumni group - a Photography for Parents Clique if you will - which is where we continue supporting you, answering your questions, encouraging you to take photos through weekly and monthly challenges and peer support Next Fundamentals course starts on 15th January 2024 5 core course modules Support Facebook group Weekly online Live class Personal Feedback on your images BONUS: extra module with ideas bank for photographing children of all ages BONUS: PDF course workbook BONUS: Printable and mobile friendly Pocket Guides HERE IS WHAT YOU WILL LEARN WITH US:  How to finally, actually, properly use your camera - no more cryptic buttons and the 'oh no! what have I pressed now?!' panic. Life's too short to be intimidated by your camerant The precise steps and 'recipes' to help you capture all sorts of different situations - whether your kids are indoors on a dark and dreary day or tearing through the park in the sun How to see the world and your children through a photographers eyes and learn to compose your photographs on the fly so they truly reflect the beauty you see How to get great photos CONSISTENTLY - I mean the spray and pray method is fine, but wouldn't it be nice to have confidence your images will turn out the way you want them? How to learn to notice and capture the little details, the big picture, the whole story of your children growing up. BEAUTIFULLY. "Absolutely, without a doubt, the best money I have ever spent on anything kid related. I so wish i had done these courses 6 years ago, just before my 1st was born. My photography has improved significantly and I'm just sad the course are over, I have loved everything about them!" Hannah Slater "The most enjoyable online course I ever done" I cannot recommend this course highly enough, and I am so grateful for Ania for creating this amazing course and community, teaching busy parents how to document their family storied beautifully! DALIA SEABORNE "I'm amazed at how much my photography has improved " I have learned so much and am amazed at how much my photography has improved - they are brilliant value for money considering the level of personal attention you receive! I've come away with a whole lot more technical knowledge as well as a heap of inspiration and ideas. LUCY GRIFFITH "The most wonderful entry into the incredible photography world" I am seeing things that I have never noticed before, I am using the DSLR to capture precious moments with my family and am signed up to two further courses because the instructors, modules and supportive community are amazing and I think I might be addicted KIRSTY FINNIE Photography for Parents FUNDAMENTALS Next course starts on 15th Jan 2024 All the learning resources, all the community, all the support, all the personal help. Virtually failproof 5 core course modules Bonus Idea Bank module PDF course workbook Pocket reference guide Support group Weekly online live class Personal Feedback on your images Access to Photography For Parents Alumni community But will it work for me? - our guarantee: GUARANTEE We know our course works. We have seen a few thousands of students go through our courses and really improve. BUT, if you find that after the first couple of modules that it just doesn't work for you, you haven't learnt anything new, it's the wrong level for you, you haven't improved, or you simply don't get on or engage with it - we will simply refund you in full. Simple as that! INSIDE THE MODULES - aka WHAT DO YOU LEARN? Module 1: See what your camera sees Our first module is dedicated to breaking you our of the snapping habit and giving you a fresh perspective. We show you how your camera sees the world differently than what you might expect in three major ways - the optics. the focus and the light. Major Takeaways: At the end of the module you will have gained full control of your focus - no more guessing game and kids turning out all blurry, you will also gain an insight of how to use your lens ( there is a skill to it) and how to let the light help make your subjects stand out. What's included: The importance of focus and what it does to our brain Taking control of your focus - the Where and HOW your camera focuses Mastering focus formula - a process to help you determine what settings to use for each occasion To zoom or not to zoom and how it changes what and how your camera sees Learning how your camera sees the light and how to make it better, especially with tricky light Learning how to shoot against the light - like a bright window and NOT end up with the person looking all dark Module 2: On exposure and all things sharp and blurry In our second module we take you off the auto setting and dive deep into learning about exposure - i.e. making sure that your images are not too dark or bright or blurry. But not only that, we pay special attention to how to make some of the things in your image sharp and others blurry through the use of specific combinations of settings  Major Takeaways: How to work your camera in priority ( semi-manual) modes, how to capture detail or portraits with a great separation of sharp and blurry to make these elements stand out.  What's included: Understanding the mechanics of your camera - how does a photo actually happen inside Taking your camera firmly OFF the Auto settings - learning the key factors ( aperture, shutter speed and ISO) and how they interact with one another How to capture portraits and those precious detail shots beautifully Switching to Aperture priority and controlling your aperture - the how and the why Taking control of what in your image will be sharp and what will be blurry - hello full control over blurry backgrounds, blurry foregrounds and pin sharp subjects in between. Module 3: Capturing movement  One of my favourite modules, dedicated to helping you capture your kids in motion - whether they're wriggling babies, speedy crawlers, wobbly toddlers or perpetual-motion-machines that most children are. We learn how to match your focus settings, your shutter settings and your composition to capture great movement photos.  Major Takeaways: Learn how to capture your children on the move, SHARP but also how to use blur and speed to really showcase and highlight movement. Big AH-HA moments here!  What's included: Switching your camera to shutter priority and mastering MOVEMENT Learning how to capture moving things SHARP - yes, that includes those fast movingbaby arms and legs Learning how to capture moving things BLURRY - and why would you want to do it? Learning how to highlight action and energy and speed in your images and how to help yourself with composition Creative techniques like night time light trails or panning or creative blur How to use your focus settings on top of your shutter settings to help capture things sharp Module 4: See what your camera sees Although we introduce elements of photographic composition throughout the course, this is the module entirely dedicated to it. We look at composition not just as a set of arbitrary rules, but more as something that helps you express what you really see and feel. We look at photographic storytelling and helping your images get look more impactful and stronger Major Takeaways: Good photographic composition principles to help you really show the magic you are seeing. At the end of this module you will say goodbye to boring flat photos and will instead start taking rich images with lots of depth and eye catching composition.  What's included: understanding how we 'read' photographs and how to compose so that the magic YOU see translates into what the others see when they pick up that photo fundamental rules of photo composition - we started you off with the rule of thirds but there is MORE Good crops, bad crops, crazy crops and everything in between storytelling through your photographs - how to make your images mean something and show something real, beyond 'my child looks cute here' getting creative and expressing yourself through photographs learning to go beyond your usual compositions and discovering different styles Module 5: Photographic composition and storytelling Although we introduce elements of photographic composition throughout the course, this is the module entirely dedicated to it. We look at composition not just as a set of arbitrary rules, but more as something that helps you express what you really see and feel. We look at photographic storytelling and helping your images get look more impactful and stronger Major Takeaways: Good photographic composition principles to help you really show the magic you are seeing. At the end of this module you will say goodbye to boring flat photos and will instead start taking rich images with lots of depth and eye catching composition.  What's included: Understanding how we 'read' photographs and how to compose so that the magic YOU see translates into what the others see when they pick up that photo Fundamental rules of photo composition - we started you off with the rule of thirds but there is MORE Good crops, bad crops, crazy crops and everything in between Storytelling through your photographs - how to make your images mean something and show something real, beyond 'my child looks cute here' Getting creative and expressing yourself through photographs Learning to go beyond your usual compositions and discovering different styles BONUS Module 6: Idea Bank : Photographing children at different ages This last module is a bit different. We us it to give you lots of ideas for photos with children of different ages - from photographing milestones to capturing what's unique about them at a particular stage and really getting into their world to capture where they're at. The module is packed with ready to take ideas and will let you take all that you have learned in the first 5 modules and apply it in real life sitautions. We also help you think ahead to the next steps in your photography education - should you want to continue. 

Duration: 1 Day Who would find this course useful? C++ coders. This course covers C++ programming principals and the syntax of all generally used C++ statements. Level: From beginners. For classroom courses: Bring your own device.

Mending garments extends their life. Learn how to properly sew buttons, restore stitching, fix hems, and employ undetectable repairing techniques. You'll also appreciate the social and artistic sides of mending with others, as well as lowering your carbon footprint by avoiding fast fashion. Book your place today and revamp your wardrobe with some basic but efficient clothing mending techniques!