3820 Design 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.

Elevate your expertise in LNG terminal operations safety through our classroom training course. Energyedge provides industry-leading expertise and guidance.

This course is ideal for all, from beginners to confident makers. You will learn the basics of leather craft for accessories and be introduced to techniques including machine stitching on leather, hand finishing and hand cutting. You will also be working with the full spectrum of leather types from soft leathers and suedes to a hard sturdy veg tanned leather. This is a perfect introductory course to start your journey into leatherwork and bag making as you will experience the wide variety of tasks involved in the work. In order to complete your bag in a day we will use part pre-prepared components and the bag will be made from a ‘Hands of Tym’ pattern but do not fear there is still plenty of work for you to do. During the day you will be directed by your tutor Leathersmith and London College of Fashion Lecturer Georgie Tym to make a 'Turned seam' Leather backpack with drawstring and flap closure. It will have raw edge straps with buckles to adjust and one flat pocket. The dimensions of the bag are 250mm x 310mm x 200mm. The bag is fully lined and it will be the same construction as the bag in the photos - please contact for more info or view online Parking available on the drive with easy access via the M40. Banbury train station is a 30 min walk. Trains run from both London Marylebone and Birmingham to Banbury in 50mins. Also well connected to Reading, Oxford, Leamington Spa to name a few. Maximum class size is 3-4 What's included in the price? There are no additional costs. All leather, hardware and other materials will be included. There will be a selection of leather and hardware colours for you to choose from.There will be lunch served at midday and tea/ coffee breaks throughout. Cancellation policy Easy - Cancellation and a full refund can be obtained up to 2 weeks before the course starts About Georgie at Hands of Tym During training at Cordwainers, London College of Fashion in 2010 I learnt how to design, make and manufacture bags professionally. Following a varied career in Accessories design and development across many roles and international brands I set up Hands of Tym in 2016. The courses I offer are suitable for all, from experienced to total novice. Come along to learn something new, and design and make your own leather bag in a day.

DNS training course description This three-day hands on DNS training course studies both the UNIX BIND and the Microsoft (MS DNS) implementations. The course starts with the big picture of how DNS works, then client configuration. Primary and secondary servers are then configured, progressing to DDNS, subdomains and security issues. Hands on sessions follow all sections ensuring that troubleshooting techniques are used throughout the course. Students choose whether to use Windows or UNIX for the hands on sessions. What will you learn Describe the architecture of DNS. Explain how DNS works. Install, configure, maintain and troubleshoot DNS DNS training course details Who will benefit: Technical staff wanting to learn DNS including: Network personnel System administrators. Prerequisites: UNIX Fundamentals (or Windows knowledge). TCP/IP foundation for engineers. Duration 3 days DNS training course contents What is DNS? Hostnames, Name resolution, host files, host file problems, What is DNS? The DNS namespace, TLDs, gTLDs, registering domains, Nameservers, how DNS works. Hands on Testing DNS servers on the Internet. DNS clients Ways to use DNS, dynamic and static configuration, multiple nameservers, domain name, searchlist, resolution issues, testing the configuration. Hands on Client configuration. DNS server software Implementations, Microsoft, BIND, daemons and services, installation, starting and stopping servers. Hands on Setting up a DNS server. DNS zone files What is a zone, Zone file overview, Forward zones, Reverse zones, Resource records, A records, PTR, CNAME, Root hints, local zone file. BIND and Microsoft configuration. Hands on Server configuration files. NS and applications MX records, Mail server load balancing, SPF, SRV records, VoIP and SRV, Microsoft and SRV, NAPTR. Hands on Testing records with dig and nslookup. DNS slaves and other servers DNS server types, Server resilience, Slaves, Zone transfers, SOA records, Serial numbers, recommendations, polling based zone transfers, NOTIFY, AD integration, DNS caching, Negative caching, TTL, Caching only servers. Hands on Masters, slaves and zone transfers. The DNS protocol The DNS stack, DNS port numbers, DNS queries, The DNS header, header section format, question format, other section format. Hands on Troubleshooting DNS with Wireshark. Dynamic DNS DHCP, DDNS, IXFR, WINS integration. Hands on Dynamic DNS. Subdomains Root servers, root server selection, Authority, delegation, NS records, subdomain with and without delegation, reverse delegation. Hands on Delegation, setting up a subdomain server. DNS security Restricting queries, DNS and firewalls, Split DNS, forwarders, internal root servers, the use of proxy servers, DNSSEC, TSIG. Hands on Hardening a DNS server. DNS and IPv6 What is IPv6, IPv6 addressing, IPv6 DNS issues, AAAA, IPv6 reverse delegation. Troubleshooting DNS Problem solving, DNS troubleshooting, Zone file checking, Some common errors, Log files, tools, nslookup, dig, host, DNS design, performance, load balancing. Hands on Putting it all together. Summary Useful books, Internet sites, RFCs. Appendix: ENUM What is ENUM, How ENUM works, NAPTR.

Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. Certificates Certificates Certificate of completion Digital certificate - Included

Design and sew your own full-length apron! All materials are provided.

Writing and Managing Requirements Documents: In-House Training This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals pass the IIBA™ Certification exam to become a Certified Business Analysis Professional (CBAP™). Learn more at www.iil.com/bacp. Once a business analyst has completed the information gathering and analysis to produce the solution to a business problem, the results must be documented for all stakeholders to see and understand. This course will enhance the skill set needed for writing and managing the complex readership that business analysts interact with on a day-to-day basis. What you will Learn Upon completion, participants will be able to: Write an understood requirements document that is approvable and acceptable Validate a requirements document Manage the changes to requirements documents through the SDLC Foundation Concepts The role of the business analyst An introduction to the BABOK® Guide The business analyst and the product/project life cycle The requirements documentation process Planning for Effective Requirements Documentation Overview of requirements planning Planning for validation Planning for verification: well-formed criteria Planning for verification: understood and usable criteria Writing Effective Requirements Documents Overview of writing requirements documents Using a standard structure / template Applying formatting techniques Meeting the challenge of writing non-functional requirements Baselining Requirements Documents Overview of the requirements baseline process Validation Verification Approval Managing Requirements Change through the Product Life Cycle Overview of requirements change management Establishing a formal change management process Tracing requirements through design and development (build, test, and implementation) Following through to post-implementation (transition and early production)

Stained Glass  4 DAYS ADVANCED PRACTICE 3 Days Painting + 1 Day Leading  Design, Painting Layers, Enameling, Leading 9.00am - 15.00pm (on chosen dates)

Are you a graduate or an industry professional ready to take your career to the next level, develop a new specialism, or see your film idea or project realised? Our MA in Screen and Film Production could enable you to advance your career, develop and enhance your skillset, and align yourself with top industry professionals. Through research-based practice this new MA puts you and your aspirations at the centre of your learning, whilst refining your chosen specialist pathway. 

Would you like to add a persona touch to your old coat? Change a look of your favourite cardigan? Wearing a customised, handmade brooch could completely change your look so why not to join us for a 2-hour brooch making workshop, where you will learn very basic stitching and working with various upcycled fabrics including felt, tweed and tartan scraps. If you prefer to use your own materials or have some pieces of sentimental value you would like to use, you are more than welcome to bring them along. During this workshop, we will also touch on the theory of colours and how they can affect and change our moods. This workshop is led by Anna Baran, a trauma informed designer, artist, and maker based in the north of Edinburgh. She has always drawn inspiration from the sea, with her walks to local beaches, particularly Wardie Bay during the lockdown, becoming not only a source of new ideas for her artistic practice but also a way to gather materials such as driftwood, pieces of plastic ropes, and seashells. Anna has consistently sought to incorporate upcycled materials into her art, using her work to raise environmental awareness and promote art as an accessible medium for self-expression, regardless of financial circumstances. In addition to participating in various art exhibitions and fashion-related events, she has delivered a wide range of art and craft workshops to diverse communities across Edinburgh. This FREE workshop is for Adults women only and is sponsored by CORRA and HENRY DUNCAN GRANTS By attending this class you release Anna Baran, Giada Gaslini and Art and Spirituality Cic, from any liability arising out of any personal injuries, emotional or physical release, death, physical reaction, expectations of results, theft in the venue or damages that may happen to people and objects while attending. Pictures will be taken during the workshop, if you prefer not to be in them, please inform the teacher.