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
Course Objectives At the end of this course you will be able to: Understand the Outlook interface Send and receive email messages Organise email messages Manage their calendar Manage their contacts Work with tasks and notes Customise Outlook ' 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. Getting Started With Outlook Navigate the Outlook Interface Perform Basic Email Functions Use Outlook Help Composing Messages Create an Email Message Check Spelling and Grammar Format Message Content Attach Files and Items Enhance an Email Message Manage Automatic Message Content Reading and Responding to Messages Customise Reading Options Work with Attachments Manage Your Message Responses Managing Your Messages Manage Messages Using Tags, Flags, and Commands Organise Messages Using Folders Managing Your Calendar View the Calendar Manage Appointments Manage Meetings Print Your Calendar Managing Your Contacts Create and Update Contacts View and Organise Contacts Working With Tasks and Notes Create and manage Tasks Create and manage Notes Customising the Outlook Environment Customise the Outlook Interface Create and Manage Quick Steps Who is this course for? Who is this course for? This course is intended for the user who needs to learn how to use Microsoft Outlook to compose and send email, schedule appointments and manage contact information. Requirements Requirements General knowledge of the Windows OS
Game design training face to face training customised and bespoke.
Management of Portfolios (MoP®) Practitioner: Virtual In-House Training In this MoP® Practitioner course, participants will have sufficient knowledge and understanding of how to apply and tailor the MoP guidance and to analyze portfolio data, documentation, and roles in relation to a given situation. MoP helps organizations ensure if the investments are done in the right, change initiatives, and implementing them correctly. This is achieved by: Prioritizing the programs and projects in terms of their contribution to the organization's strategic objectives and overall level of risk Managing the programs and projects consistently to ensure efficient and effective delivery Maximizing the benefit by providing the greatest return from the investment made What you will Learn Define the business case to get senior management approval for portfolio management Plan the implementation of portfolio management Select and adapt MoP principles, practices, and techniques to suit different organizational environments Evaluate examples of MoP information including documents and role descriptions Analyze the solutions adopted in relation to a given scenario Introduction Overview MoP Portfolio Definition Portfolio Management Roles Portfolio Management Documents MoP Practitioner Assignments Portfolio Management Documents Portfolio Delivery How to Implement Practice Exam MoP Practitioner Exam (taken online, after the class has ended)
Network+ training course description This network+ course covers the TCP/IP side of the exam. For delegates to pass the exam it is important that they meet the prerequisites, self study is also required. An intensive hands on IP foundation. The course focuses on all parts of TCP/IP including layers 4 to 7 on end stations as well as layer 3 on routers. The TCP/IP protocols are also studied to enable delegates to be able to troubleshoot TCP/IP using Wireshark. Hands on sessions are used to reinforce the theory rather than teach specific manufacturer equipment. What will you learn Use ping, traceroute and other tools to diagnose faults on a network. Configure IP on PCs and routers. Plan IP addresses and subnets. Analyse IP and TCP packets using an analyser. Troubleshoot TCP/IP. Network+ training course details Who will benefit: Those wishing to pass the Network+ exam. Prerequisites: Introduction to data communications & networking Duration 5 days Network+ training course contents What is TCP/IP? TCP and IP are protocols, 7 layer model, network layers, hardware/software layers, internetworking, protocols, What is IP? What is TCP? The internet, The IAB, RFCs. Ping and Wireshark Host configuration, IP addresses, subnet masks, default gateways, ping. Hands on Base configuration. Testing with ping. Analysing packets with Wireshark. Switches and Wireshark Switches versus hubs, layer 2 forwarding table, flooding, broadcasts. Hands on Building a switched based network. Configuring network devices Configuration options, console port, putty, telnet. Hands on Configuring switches, telnet. IP IP packet format, protocol field, TTL, DiffServ, fragments, ICMP. Hands on IP packet analysis. IP addressing 32 bits, dotted decimal, rules, networks, role of subnet masks, simple subnetting, prefix notation. Broadcasts, special use addresses. Hands on Planning and implementing addressing. IP and the lower layers ARP, media not supporting ARP. Hands on ARP. Routing What are routers? What routers do, default gateways, routing and addressing, routing tables, ways to update routing tables. Hands on Building a routed network, traceroute. Routing protocols IGPs and EGPs, RIP, RIPv2, Why not to use RIP, OSPF, OSPF metrics, convergence, distance vector protocols, link state protocols. Hands on OSPF, analysing routing tables, loopbacks. Network simulators Network simulators, EVE-NG, GNS3, CML. Hands on Using EVE-NG. Subnetting Subnetting to the bit level, ranges, how prefixes are used. Hands on Subnetting. VLANS and IP addressing What are VLANs, tagging, 802.1Q, Inter VLAN routing. Hands on Inter VLAN routing. TCP and UDP Layer 4, port numbers, client ports, broadcasts multicasts and layer 4, UDP header, TCP header, connections, ACK, sliding windows, options, connection states. Sockets. Hands on Analysing TCP packets. IPv4 address configuration Private addresses, NAT, NAPT, dynamic addressing, DHCP, link local addresses. Hands on DHCP, NAT. IPv6 What is IPv6, 128 bit addresses, address formats, IPv6 address allocation, header format, migration, dual stack, tunnelling, NAT64, DNS64. Hands on IPv6 setup troubleshooting. IPv6 address configuration Static addressing, EUI-64 addresses, IPv6 address order, SLAAC, DHCPv6. Hands on SLAAC. Applications Clients, servers, HTTP, Email, resource sharing, VoIP, video, terminal emulation, remote desktop. Network management and SNMP. Hands on Servers, TFTP, VoIP packet analysis. DNS Names and addresses, hosts file, how DNS works. FQDNs, DNS client configuration. Hands on Troubleshooting DNS. Security Firewalls, firewall architectures, DMZ, how firewalls work, proxy servers, filtering, ACLs, IDS, VPNs, authentication, encryption, tunnels, secure protocols. Hands on Firewalls, SSH Troubleshooting Methods, tools. Using the 7 layer model. Troubleshooting toolkits. Hands on Fixing the network.
Duration 3 Days 18 CPD hours This course is intended for Participants must possess a valid data centre training certificate such as CDCP or any other approved equivalent. Please submit a copy of your certificate for verification upon registration for the CTDC course. Overview After completion of the course the participant will be able to:1. Learn to properly comprehend and apply the ANSI/TIA-942 Standard requirements and guidelines2. Understand the proper intent of the ANSI/TIA-942 Standard to avoid both over- and/or under-investment3. Align the selection of redundancy levels and infrastructure investments to the business requirements.4. Understand the criteria and requirements for a high-availability data centre design and how to effectively establish the data centre from the perspective of the ANSI/TIA-942 Standard5. Understand how the ANSI/TIA-942 Standard relates to various worldwide standards This course, the participant will learn how to design an ANSI/TIA-942 compliant data centre. It will provide a clear understanding of the requirements of the ANSI/TIA-942 Standard and possible implementation variations. Introduction to Data Centre Facilities About the ANSI/TIA-942 Life of the ANSI/TIA-942 Standard Relation to other standards Architectural Electrical Mechanical Telecommunication Areas under scope High level redundancy definitions Redundancy options (N, N+1 etc.) Fault tolerant Concurrent maintainability Compartmentalisation Examples of redundancy levels Data Centre Space PlanningData Centre TopologiesRecommendations for Energy EfficiencyArchitectural Site selection Parking Multi-tenant building Building construction Vapor barrier Roofing Floor loading Raised flooring Suspended/drop ceiling Hanging load Seismic Building Security & Safety Security CCTV Staffing Bullet/ballistic proofing Lighting Safety - Signage Building and Room Access Security checkpoints Entry lobby Doors and windows Exit corridors Shipping and receiving areas Room/Area Design Requirements Administrative offices Security offce Operations centre Restroom and break room UPS/Battery rooms Generator and fuel storage area Computer room Electrical Utility power - Substation - Feed requirements - Self-generation HT/HV switch gear Generator and fuel supply LT/LV switch gear - ATS - Alternatives to ATS UPS and batteries PDU STS Grounding Surge protection EPO Central power monitoring Load banks Testing Equipment maintenance - Preventive maintenance - Facility training programs Mechanical Environmental design - Temperature and humidity requirements - Contamination - Sources - Clean air - Pressurisation - Radio sources - Vibration - Water ingress Water cooled systems - Heat rejection - Chilled water system - Condenser water? - Make up water Air cooled systems HVAC control systems Plumbing - Pipe routing Fire suppression Water leak detection Telecommunications Network topology Redundancy level design Media and connectors Cabling pathways Detailed cabling design considerations Administration and labeling Cable testing Data centre fabrics Exam: Certified TIA-942 Design Consultant Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Take your knowledge to the next level with EnergyEdge course on Layer of Protection Analysis (LOPA). Enroll now to advance your career.
Advanced Kibana training course description This training course is aimed at users who already have some experience with Kibana, who are looking to further their knowledge. What will you learn Lens Timelion Maps Custom Visualisations with Vega Canvas Filters and Controls Drilldown and Dashboards KQSL and ElasticQueries Scripted and RunTime Fields Alerts and Alarms Advanced Kibana training course details Who will benefit: Users who already have some experience with Kibana, who are looking to further their knowledge. Prerequisites: None Duration 1 day Advanced Kibana training course contents Topics Lens Visualisation types (tables,bars,charts) Category breakdown Adding multiple metrics Using formulas in metrics Labels Adding reference layer Limitations Visualise Library Timeseries, Metrics Different types of aggregations Maps GeoMapping Heat Maps Using ES index as data source Visualisation, tool tips Custom Visualisations with Vega Introduction to vega scripting Canvas Widgets and Texts Elasticsearch SQL Canvas Expressions Filters and Controls Dropdown filters Ad-hoc filters Searchbar filters Drilldown Dashboards Linking one dashboard to another KQSL and ElasticQueries Bool Query AND/OR Phrase Part match vs keyword search Wildcard search Scripted and RunTime Fields Creating ad-hoc calculated fields using scripts Performance issues Alerts and Alarms Query Based Formatting output Connector types(email,index,teams etc)
The Jamf 200 course offers a core understanding of Jamf Pro. It also provides enterprise-level knowledge of macOS and iOS platforms. Rely on our expert trainers to help you pass the Jamf 200 certification first time. Topics: Introduction to the Jamf Pro server. Building and managing content (.pkg, .mpkg, and .dmg packages) for deployment to macOS devices. Enrolling macOS and iOS devices using automated MDM enrollment. Setup and configuration of macOS and iOS devices. Configuring the user environment (Configuration Profiles, .plist). Security for macOS and iOS devices. Purchasing and distributing App Store apps using Apple Business Manager or Apple School Manager. Scripting overview (Bash). Initial setup and refreshing/reimaging macOS and iOS devices. Ownership and permissions (POSIX, ACE/ACL) on macOS devices. Prerequisites: Abundant hands-on experience with macOS and iOS. What’s Included: Four days (9am-5pm each day) of lab-style interaction. Proctored certification exam during the afternoon of the fourth day. All hardware and software required for the course. Printed course materials. Jamf Certified Tech badge on your Jamf Nation profile (upon successfully completing the exam with a passing score). Free £100 Apple technical training credit
Arbitration and Dispute Resolution Why Attend Effective dispute resolution helps minimize the costs and adverse effects to relationships that often arise from commercial disputes. If informal negotiation fails to resolve a dispute, mediation or arbitration can often be the next best option in order to avoid litigation in court. This course will give participants an insight into dispute resolution from the perspective of a lawyer. Participants will gain an in-depth understanding of the main differences between the various dispute resolution techniques with a particular focus on arbitration, in order to reduce the likelihood of disputes leading to court cases. Course Methodology In this interactive training course participants will frequently work in pairs as well as in larger groups to complete exercises as well as regional and international case studies. Course Objectives By the end of the course, participants will be able to: Identify the right course of action to resolve a legal dispute Reduce the possibility of disputes leading to legal action Apply national and international legal requirements for dispute resolution Employ arbitration knowledge to negotiate terms Use case law to achieve a favorable outcome for their organization Target Audience This course is suitable for professionals within all industries who are involved in contract management and resolving disputes including, but not limited to, project managers, contract managers, procurement managers, supply chain managers, contractors, architects, developers and engineers. This course would also highly benefit in-house council and legal advisors new to the region who require the fundamentals of dispute resolution in the GCC. Target Competencies Litigation Arbitration Mediation Negotiation GCC Dispute Resolution Frameworks Note The Dubai Government Legal Affairs Department has introduced a Continuing Legal Professional Development (CLPD) programme to legal consultants authorised to practise through a licensed firm in the Emirate of Dubai. We are proud to announce that the Dubai Government Legal Affairs Department has accredited EMG Associates as a CLPD provider. In addition, all our legal programmes have been approved. This PLUS Specialty Training Legal course qualifies for 4 elective CLPD points. Fundamentals of dispute resolution Overview of the dispute resolution process Adjudicative process Consensual process Introduction to the English High Court litigation processes Why do international businesses take their dispute to the English High Court? English civil courts Legal practitioners who are involved in resolving disputes Importance of jurisdiction clause How do you decide? Exclusive or non-exclusive? Differences between the Civil law system and the Common law system Principles of the common law system Principles of the civil law system The importance of these systems in dispute resolution Importance of Alternative Dispute Resolution ( ADR) Types of ADR Arbitration Mediations Conciliation Negotiation Arbitration - the best form of ADR The object of Arbitration The role of an Arbitrator Advantages and disadvantages of Arbitration Requirement of an Arbitration agreement The importance of the New York convention The role of UNCITRAL in dispute resolution Preparing for an arbitration hearing Types of Arbitration Institutional arbitration v Ad hoc arbitration Advantages and disadvantages of Institutional arbitration Advantages and disadvantages of Ad hoc arbitration Drafting international Arbitration agreement Checklist for drafting an Arbitration agreement Practical consideration with 'Seat' of Arbitration Model Arbitration clauses ICC LCIA Arbitral awards Enforcement of an Arbitral awards Grounds for challenging Arbitral awards Recent international case law Arbitration terms and terminology Other ADR methods: Advantages and disadvantages of each method: Mediation Conciliation Negotiation Ambiguity in an Arbitration clause What to avoid Importance of the language used in an Arbitration clause Dubai International Arbitration Centre (DIAC) Examining the rules of DIAC