379 Courses in Edinburgh

Microsoft Access training course description A hands on course providing a solid grounding in Microsoft Access. What will you learn Use and customise the Microsoft Access environment. Select, use and customise queries. Define tables. Design forms and reports. Recognise the use of macros. Microsoft Access training course details Who will benefit: Anyone wishing to work with Microsoft Access. Prerequisites: Database fundamentals Duration 3 days Microsoft Access training course contents Introducing databases Flat file databases, Relational databases, the objects defined in an Access database, planning a simple relational database. Open Access and create a database The database wizards, tables, creating and amending tables, using field properties to improve the quality of data entry and system performance, the primary key. Working in datasheet view View, add, modify and delete records, find records. Advantages and disadvantages of entering data directly into a table. Queries Sort and select records form a single table, advantages and disadvantages of entering data via a query, define simple calculated expressions, use 'Totals' queries. Forms Use the form wizards, basic editing of objects created using the form wizards, Data-entry in form view. Reports Use the report wizard, basic editing of objects created using the report wizard, print reports. The multi table environment Plan and create a related table, define a one-to-many relationship, write multi-table queries and use the 'AutoLookup' feature, use the form wizard to create a subform and carry out data-entry in a main/subform, print and amend reports, use the report wizard to create reports based on multi-table. Relationships Working with one-to-one and one-to-many relationships, recognising and handling many-to-many relationships, referential integrity. Select queries Select queries based on related tables, parameter queries, Crosstab, find unmatched queries and Find Duplicate, the implications of the Join properties in a relational query, conditional expressions, and working with the expression builder. Action queries Make table queries, append queries, update queries, delete queries. Customising forms. Using the Toolbox, calculated controls, Combo and List boxes, query by form, working with form and control properties, domain aggregate functions. Reports Report and control properties, customising sorting and grouping, calculated controls on reports, Sub-reports, editing and altering a report's source. Macros Introduction to macros.

Broadband access training course description ADSL is a broadband technology providing fast Internet access (amongst other applications) over existing telephone lines. This course covers an overview of the DSL family, what ADSL is through to how ADSL works. What will you learn Describe what ADSL is. Describe how ADSL works. Describe the ADSL architecture. Recognise the limitations of ADSL. List the elements required for an ADSL installation. Broadband access training course details Who will benefit: Network engineers and anyone who will be working with ADSL. Prerequisites: Intro to data communications & networking Duration 2 days Broadband access training course contents What is ADSL? Broadband definitions, OSI layer 1, ADSL services, WANS. ADSL features: always on, point to point, Asymmetric, speeds. ADSL benefits, xDSL family, standards, history, example DSL forum documents. ADSL architecture The big picture, The PSTN and telephones, Digital and analogue, PSTN and modems, ADSL vs. modem speeds, Block 1: Customer premises, Block 2: The last mile, Block 3: The exchange, Block 4: the core network. Customer premises Splitters, micro filters, splitter architectures, Splitterless ADSL, ADSL modems, USB, ADSL routers. The local loop ADSL PHY, Some basics, ADSL margins, speed implications, distances, RADSL, Line testing, whoosh tests, line coding, multiple channels, FDM, echo cancellation, Modulation: AM, FM, PM, QAM, QAM constellations, DMT, CAP, Framing, Superframes, fast data mode, interleaved mode, RADSL revisited. The exchange Local exchange ADSL items, DSLAMs, ADSL racks, Contention. The core network The role of the core network, ATM, ATM VPI/VCI, ATM cells, ATM layers, AAL5, RAS, Home gateways. ADSL and the higher layers Layer 2 choices, PPPoA, PPP, CHAP, Layer 4 and above, ADSL and ATM. Installing and configuring ADSL Choosing providers, line activation, hardware requirements, Configuring layer 1 and layer 2, Configuring IP. Summary ITU ADSL standards

Ever ever wished someone would just swoop right on in, sprinkle some magic on your photos or maybe just tell you exactly what to do and how to do it? On this half day, exclusive, in-person workshop, personal brand photographer Susan Heaton Photography will do just that! And it comes complete with an invaluable aftercare support package. Susan has been photographing small businesses in and around Edinburgh for 20 years! I love what I do! I have a wonderful network of business owners and I love sharing my tips and tricks to help them take their own photos - either to tide them over between brand shoots or to help them until they have the budget to get a professional in!” On the Stand Out Shots workshop you’ll learn how to use your phone using very little else (except perhaps a tripod) to take stand-out, professional-looking photos for your business, for social media, blog posts, profile images, website, marketing material and more. Susan will share tips, tricks and secrets she has gathered from 20 years of photographing small businesses in Edinburgh, to help you to take photos that stand out, and you will have invaluable post workshop access to a WhatsApp group for support with implementing what you have learnt. You will: learn how to make the most of the settings on your phone and what they all mean develop skills that will last a lifetime find out how to find the best light available get tips on how to arrange and style your photos practice top posing tips and find the ones that work best for you gain confidence and get rid of the awkward! network and connect with fellow workshoppers If you're self-employed and need some shots of you in action, or run a product-based business, this is the perfect workshop for you and will help you attract customers. But this workshop is not just for business owners, it's for anyone wanting to improve the way they take photos with their phone. What's included: half day workshop fuelled by light refreshments from local suppliers full after-care package so that you can always go back to Susan with questions in-person workshop is only available at The Arienas Collective Earth conscious credentials We are mindful of the effect we have on the environment, and do our best to minimise our impact. Your workshop correspondence and notes are sent to you electronically. Favourite feedback We love to hear what you think about our workshops. Here's a favourite review for Stand Out Shots: If you are wondering whether this course is for you, then it definitely is! I knew I had a great phone but absolutely zero knowledge of its capability or even how to use it! Susan's delivery is friendly, calm, patient and insightful and her experience is invaluable. Just learning the basics of my phone, and more about photo composition, lighting and editing tips has already paid dividends for my marketing posts. More information The Arienas Collective workshops, courses and events are run from a welcoming and supportive environment within a Georgian mews home in Edinburgh’s City Centre New Town. We invite you to join us, leave any day-to-day worries behind and immerse yourself in being creative. Spaces on our workshops and courses are limited so that our creative team of artists and makers can offer you the hands-on help and support you need to make the most of your time with us. Our taster and introductory workshops focus on teaching creative skills and methods you can continue practising at home, using affordable materials and equipment. Where more expensive equipment is required we will mention this in the workshop description. All the equipment and materials you need are included in the price, unless stated otherwise. Light refreshments from local suppliers are provided. On full day workshops you are welcome to bring your own lunch to eat inside or out. There is also a wide range of independent sit-in or takeaway delis, cafés, and restaurants, plus a range of supermarkets all within a 5-10 minute walk. Accessibility The workshop space is on the first-floor of our Georgian mews home and unfortunately we do not have lift access. Blue badge holders can park outside our front door on the single yellow line by arrangement. Allergies The workshop space is in our open plan living space and is not nut free. Please let us know about any skin or food allergies before booking. We offer a dairy-free milk and gluten free snack alternative. Minimum number no refund policy To ensure we can always pay our creatives a fair fee, we require a minimum number of bookings for each workshop and for this reason bookings are non-refundable. Should we have to cancel due to low numbers, we will offer you the option to swap to an alternative date or workshop, or to request a refund. We do our very best to avoid cancellations. Since we often get late bookings, we keep our workshops on sale for as long as possible. We realise that some of you travel from afar, so if you book a space and have not yet received an email confirming your workshop is going ahead and need to make plans for your trip, please get in touch before booking any travel or accommodation so we can update you on booking numbers. Or check in before booking. Private workshop bookings Most of our workshops are also available to book for: private get-togethers with family and friends; themed wedding and birthday celebrations; corporate team building and well-being purposes; and in-store retail events for your customers. If you’d like to know more please Email Lynn. Age restrictions Our workshops are planned with adults in mind. Many are suitable for teenagers, but some may require under 16s to be accompanied for insurance purposes. Please check with us before booking.

Gain the knowledge and skills to safely insert and manage peripheral IV cannulas with our training course for healthcare professionals. Ideal for nurses, medical personnel, and other practitioners.

Learn how to make your own jewellery using silver clay in this half day beginner class in Edinburgh City Centre

Learners will be given a broad overview of hazardous areas with a particular emphasis on the requirements for intrinsically safe fire detection and alarm systems.

Cosmic Path-Weekly Ashtanga and Vinyasa Yoga Inspired flow suitable for beginners with Adriana. 1 hour yoga and meditation class on Wednesdays at Art and Spirituality CIC, Edinburgh.

Learn how to make a mosaic mirror with Mossy Mosaic hosted at The Arienas Collective in Edinburgh City Centre

Designed to promote deep relaxation and mindfulness through a thoughtfully slower-paced practice, this nurturing class offers a sanctuary from the demands of daily life. Led by experienced instructor Kirstine Henderson, each session focuses on gentle stretching and accessible exercises that honor your body's natural rhythm and capabilities, making it welcoming for practitioners of all ages, fitness levels, and experience. Throughout the class, you'll be guided through a carefully curated sequence of calming poses that work harmoniously to enhance flexibility, improve balance, and cultivate overall well-being. The emphasis is on moving with intention rather than intensity, allowing you to truly listen to your body and respond to its needs. Each posture is offered with modifications and variations, ensuring that everyone can participate comfortably and safely. Whether you are completely new to yoga and taking your first steps onto the mat, or you're a seasoned practitioner seeking a soothing way to unwind and reconnect with yourself, this class provides a supportive and non-judgmental environment. You'll discover how gentle movement can be profoundly transformative, helping you release physical tension while quieting mental chatter. Meeting in the studio 11.15 to leave to the park if the weather allowed. Mats provided This class sponsored by Awards for All, Community Fund We prioritize the area of Gorgie-Dalry-Saughton where our studio is based.  By attending this class you release the teacher, Giada Gaslini and Art and Spirituality Cic, from any liability arising out of any personal injuries, emotional or physical release, death, expectations of results, theft in the venue or damages that may happen to people and objects while attending.

Edinburgh city centre sketching tours with ink and watercolour artist Mark Kirkham, known locally as The Edinburgh Sketcher