38 Builder courses

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.

Mastering the ability to apply all different versions of builder gel, acrylic gel, hard gel, and sculpting gel is an art worth mastering. Achieving the best application and retention process is by far the best part of doing nail's, it's not about speed it's about perfection. Please contact us for further information and course availability. Many thanks

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

Microsoft Lync training course description This course teaches IT staff how to plan, design, deploy, configure, and administer a Microsoft Lync Server solution. The course emphasizes Lync Server Enterprise Unified Communications features focussing particularly on coexisting with and migrating from legacy communication services. The labs in this course create a solution that includes IM and Presence, Conferencing, and Persistent Chat. This course helps prepare for Exam 70-336. What will you learn Describe the Lync Server architecture. Install and deploy Lync Server. Use Lync Server management interfaces. Deploy and manage clients. Manage and administer dial-in conferencing. Design audio and video for web conferencing. Plan for instant message and presence Federation. Deploy and configure persistent chat in Lync. Configure archiving and monitoring services. Troubleshoot Lync Server. Describe the required daily, weekly, and monthly maintenance tasks. Use SIP commands and analyze SIP logs. Configure high availability features in Lync. Design load balancing in Lync Server. Backup and restore Lync Server data. Microsoft Lync training course details Who will benefit: Technical staff working with Microsoft Lync. Prerequisites: Supporting Windows 2008 or 2012. Duration 5 days Microsoft Lync training course contents Microsoft Lync Server architecture Lync Server architecture, Lync core capabilities, Lync design process, assessing infrastructure requirements and updating the design, planning for all Microsoft solutions framework phases. Designing a Lync Server topology Infrastructure requirements for Lync Server, using the planning tool, using topology builder, server infrastructure, documentation. Hands on Environment preparation and Lync Server pools. Users and rights in Microsoft Lync Server Managing Lync Server, role based access control. Hands on Using the management shell, configuring role-based access control. Client/device deployment and management Deploy and manage clients, prepare for device deployment, IP phones. Hands on Clients. Conferencing in Lync Server Introduction to conferencing in Lync Server, designing for audio\video and web conferencing, dial-in conferencing in Lync Server, managing and administering conferencing. Hands on Conferencing in Microsoft Lync. Designing and deploying external access Conferencing and external capabilities of Lync Server, planning for IM and presence federation, designing edge services. Hands on Deploying Edge Server and Configuring Remote Access, Validating the Edge Server. Deploying Lync Server persistent chat Overview of persistent chat architecture in Lync Server, designing persistent chat, deploying and persistent chat. Hands on persistent chat server. Monitoring and archiving The archiving service, the monitoring service, configuring archiving and monitoring. Hands on Archiving and monitoring in Lync Server. Administration and maintenance of Lync Lync Server troubleshooting tools, Lync Server operational tasks, Lync Server troubleshooting techniques. Hands on Lync administration tools, centralized logging service, analysing Lync Server logs and traces. High Availability in Lync Server High availability in Lync Server, configuring high availability in Lync Server, planning for load balancing, designing load balancing. Hands on Configuring database mirroring, experiencing a scheduled SQL Server outage, experiencing an unscheduled SQL Server outage. Disaster recovery in Lync Server Disaster recovery in Lync Server, tools for backing up and restoring Lync Server, critical Lync Server data to back up and restore, critical data to export and import, designing branch site resiliency. Hands on Configure pool pairing, experiencing a pool failure or outage. Planning a migration to Lync Server Coexistence and migration, migration steps, planning for clients and devices. Designing a client migration and device migration strategy. Hands on Creating a migration plan, documenting the migration phases.

The 1-Day Foundations Course in Wheel Building with master wheel-builder Vince Warner Are You New to Wheel Building and Eager to Start Off Right? Imagine having the confidence to build motorcycle wheels that not only look good but are durable and reliable. With the right foundation, you can! I believe that a strong foundation is essential to becoming proficient in any skill, and wheel building is no different. That's why I created the 1-Day Foundations Course—to provide you with all the essentials you need to get started on the right foot. Here's What You'll Learn:Preparation and Measurements: How to ensure you have all the correct parts, materials and accurate measurements before you start building. Lacing: Understand the methodology behind lacing the most common type of motorcycle wheel. Truing: Essential techniques for achieving optimal alignment for your wheel. Tensioned Wire Wheel Principles: A deep dive into the underlying principles that make a tensioned wire wheel reliable and effective. BONUS: Full Access to Video Modules To complement your 1-day experience in my workshop, you'll also gain full access to Module 2 of my video training, which is essential viewing before you attend. This covers many of the topics you'll be learning in-person. SPECIAL BONUS: Introduction to Bicycle Wheels As an added bonus, I'm also going to give you Module 1, which focuses on bicycle wheels—expanding your understanding and adding another skill to your wheel building arsenal. Lunch Is on Me! Enjoy complimentary lunch, along with tea, coffee, cold drinks, and snacks throughout the day.

Acrylgel is a fusion between builder gel and acrylic powder tailored to create durable and extremely natural looking nail enchantments. Acrylgel is a revolutionary product for nail design. It convinces with an easy and quick application and its very long durability. Because of the extremely high viscosity you can model all nails on one hand and cure them at once without getting any gel in the nail edges. Our Acrylgel is very easy to file. - Stable as acrylic, flexible as a gel. - Quick and easy application, max. saving of time.This course will take you through the application procedure, ‘French Pink and White’ techniques, sculpting with forms and maintenance procedure, including aftercare advice. THE REQUIREMENTS Salon attire must be worn during the course. Student must have clean nail without enhancements and long hair tied back. To ensure maximum practice, students will be required to work on each other throughout the day or on own hands. THE CONTENT Health, safety & hygiene Consultation techniques Contraindications Nail preparation Introduction to tip application Extend nail bed using sculpting techniques French Pink and White techniques Maintenance procedure Removal procedure Aftercare advice DURATION This is one day course which runs from 10am to 5pm PRICE INCLUDES Acrylgel training kit . Upon successful completion an course certificate will be awarded

This course is great for those looking to enter the world of Barbering whilst fitting training around their existing work schedule. You’ll learn to cut & style utilising the 5 Alan d foundation haircuts before moving onto all the latest Barbering techniques using scissors, scissor-over-comb, beard and moustache trimming, clipper work, shampooing and much more.

This Beginners Barbering Course is aimed at those looking to be work-ready upon completion and working towards an internationally recognised Barbering qualification. After an initial induction, on day 2 you will learn to cut & style utilising the 5 Alan d Foundation haircuts before moving on to the practical elements of Barbering, incorporating all the latest techniques using scissors, scissor-over-comb, clippers & trimmers and learning beard and moustache trimming and wet shaving.

This is the Alan d signature course. Aimed at barbers returning to the industry or experience barbers feeling ‘bogged down’ with their everyday routine and looking for inspiration. It’s also ideal for those trained in Ladies Hairdressing who haven’t been formally trained in the latest barbering techniques. You will learn the 5 Alan d Foundation Barbering haircuts along with use of clippers, fading, and beard & moustache trimming.

Illustrator face to face training customised and bespoke Online or Face to Face