1745 Courses in Liverpool

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

Microsoft Project Orange Belt® 2016: In-House Training This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2016, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2016, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop provides the eBook Dynamic Scheduling with Microsoft® Project 2013, and is kept up to date with the framework of knowledge outlined by the Project Management Institute's PMBOK® Guide and the Practice Standard for Scheduling. What you Will Learn You'll learn how to: Understand what's new in Project 2016 Explain where Project 2016 fits in the Microsoft® EPM solution Initialize Project 2016 to start project planning Create a well-formed project schedule Understand task types and the schedule formula Assign resources and costs to tasks Analyze resource utilization and optimize the schedule Set a baseline and track progress Create and manage project reports Customize views and fields Apply Earned Value Management Understand the basics of managing multiple projects Getting Started Introductions Course structure Course goals and objectives Concepts of Project Management Getting Started with Project 2016 Project 2016: What's New and General Overview Setting Up a New Project Schedule (templates, options, save, etc.) Setting the Project Calendar Entering Tasks The planning processes Importing tasks (Word, Excel, SharePoint) Synchronizing with SharePoint Tasks List Creating and managing the WBS (include tasks, manually scheduled tasks, summary tasks, milestones, and custom WBS coding) Entering Estimates Tendencies in estimating The rolling wave approach Entering duration and work estimates Types of tasks Entering Dependencies The principle of dynamic scheduling Choosing the right Type of dependency Entering dependencies in Project 2016 Different applications of dependencies Entering Deadlines, Constraints, and Task Calendars Use of deadlines and constraints Entering deadlines and constraints in Project 2016 Entering Resources and Costs Types of resources Entering resources in Project 2016 Calendars and resources Entering costs in Project 2016 Entering Assignments Assignments in a schedule Assignments and task types Entering assignments in Project 2016 Assignments, budgets, and costs Optimizing the Schedule The critical path method (CPM) and the resource critical path (RCP) Resource leveling Optimizing time, cost, and resources in Project 2016 Updating the Schedule The baseline Updating strategies and situations Prepare the status and forecast report in Project 2016 Reporting Using reports Using Visual Reports Formatting and printing in Project 2016 Customizing fields in Project 2016 Earned Value Management (EVM) Overview of EVM Applying EVM with Project 2016 Evaluating the Project Evaluating the project performance Project benefits and results Templates for future projects Summary and Next steps Tools and checklist Best practices checklist Certification options

Affinity Publisher Training Course for Beginners. Online Affinity Training with live instructors or face to face onsite. Learn to create and design layouts for flyers, brochures, newsletters, marketing documents and business stationery.

PfMP® Exam Prep: In-House Training This is an intensive PfMP® Exam preparation course. This learning experience guides you through the multi-faceted discipline of portfolio management by focusing on the related technical, leadership, and business skills required to navigate it in the real world. First and foremost, this is an intensive PfMP® exam preparation course. Over the course, we go beyond exam prep to provide selected practice in applying key portfolio management skills, tools, and techniques. This learning experience guides you through the multi-faceted discipline of portfolio management by focusing on the related technical, leadership, and business skills required to navigate it in the real world. The journey zooms in and out between governance context and specific operational activities. The ultimate goal is practical application, with the bonus of certification along the way. What You Will Learn By the end of this program, you will be able to: Align and manage the portfolio, strategically, to satisfy organizational objectives and priorities, through benefit realization Articulate and emulate the role of a portfolio manager Apply the principles and skills of a portfolio manager to your real-world environment Study and prepare for the PfMP® Examination Apply for the certification, per the PMI PfMP Handbook and pass the initial panel review on your application Getting Started Course Overview Details of the PfMP® Certification process Foundation Concepts Projects, program, and portfolios A portfolio management process Strategy and value The role of the portfolio manager The role of key stakeholders Life cycle management The Portfolio Life Cycle Overview of Life Cycle Portfolio Management Information System (PMIS) Governance within the Portfolio Life Cycle Strategic Management Strategy concepts Supporting documentation and the strategic plan Planning and optimization Organizational risk appetite Managing strategic change Governance Management Overview and Guiding Principles The Concept of Governance Effective Design Factors Governance Roles Capacity and Capability Management Overview and Guiding Principles Capacity Management and Planning Supply and Demand (Management and Optimization) Organization Capabilities (Assessment and Development) Performance Management (Reporting, Analytics, and Balance) Stakeholder Engagement The Importance of Stakeholders Overview and Guiding Principles Definition and Identification Analysis and Planning Communications Approaches and Management Value Management Overview (Guiding Principles, Definition, and Components) Negotiating Expected Value Maximizing Value Assuring Value Realizing Value Measuring and Reporting Value A Look at Tools Risk Management Overview and Guiding Principles Portfolio Risk Planning Portfolio Risk Identification Portfolio Risk Assessment Portfolio Risk Response Examination Content Outline (ECO) Overview Structure Strategic Tasks Mapping Governance Tasks Mapping Performance Tasks Mapping Risk Tasks Mapping Communication Tasks Mapping List of Knowledge and Skills Exam Prep and Practice Overview Documenting experience Submitting the application Preparing to sit for the exam

Microsoft Project Blue Belt® 2013: In-House Training This course introduces Project Server 2013 features that expedite scheduling projects and simplify managing tasks within an enterprise environment. Learn different aspects of Project Server and their benefits to varying roles in the enterprise, and gain hands-on experience and insights on best practices from SMEs around the world. This course introduces Project Server 2013 features that expedite scheduling projects and simplify managing tasks within an enterprise environment. Learn different aspects of Project Server and their benefits to varying roles in the enterprise, and gain hands-on experience and insights on best practices from SMEs around the world. What you Will Learn You'll learn how to: Identify the project's life cycle Understand the Enterprise Project Management (EPM) environment Apply the basic project management principles to selecting, initiating, planning, executing, monitoring and controlling, and closing your Project 2013 schedules Take advantage of new features Explain Project Server 2013 views and project sites Meet deadlines and budget restrictions Keep the workloads of your resources within their available limits Efficiently update your schedule Take advantage of the standard reports, custom views, and visual reports for your projects Take a brief look at the Business Intelligence potential Efficiently and effectively manage your project(s) and programs Work comfortably within Project Server 2013 or Project Online Getting Started with Microsoft® Project Server 2013 Describing the EPM context Discovering Project Server 2013 and Project Online Differentiating the users of Project Server 2013 Working with Project Professional 2013 and Project Server 2013 Recognizing the Life Cycle within EPM Projects and Portfolio Management Portfolio management and governance Originating new initiatives within EPTs and workflows Prioritizing initiatives, analyzing scenarios, optimizing, and selecting the portfolio Initiating Projects Initiating processes with Project Professional, SharePoint lists, Enterprise Projects, and Resource Plans Importing projects and managing project owner and permissions Planning Projects - Scope and Schedule Management Planning context and framework Scheduling in PWA Using the Deliverables feature Planning Projects - Staffing Management Plan Building a project team Managing resource availability Reviewing the assignment cycle Resolving resource overallocation Planning Projects - Cost Components, Baseline, and Consolidated Schedules Developing components of the Cost Management Planning processes Working with the baseline in projects and programs or master schedules Improving the Collaboration in the Project Sites Creating the Project Sites Developing components of the Risk Management Plan and Issues Tracking Linking planning documents Additional apps and customization Executing Projects Understanding executing processes Managing resources using Build Team and other features Working with timesheets Reporting administrative time Configuring personal settings Monitoring and Controlling Projects - Tracking Task and Project Progress Understanding the Monitoring and Controlling processes Task progress and updates in PWA including considerations for different tracking methods Task progress and updates in Project Professional 2013 Monitor and Control Projects - Measuring Performance and Reporting Progress Understanding status reports Reviewing performance metrics and progress reports Taking advantage of preloaded reports at the Business Intelligence Center Considerations for defining custom reports Closing Projects Reviewing the closing processes and closing tasks to updates Supporting the closing process

Portfolio Management Skills: In-House Training The main purpose of this workshop is to equip and enable people in a portfolio management office and PMO to effectively and efficiently support the Executive Leadership and Operational Management to plan, implement, manage, and evolve portfolio management in their organization. There is a deliberate focus on preparing you to become a strong and effective change advocate for meaningful portfolio management that delivers objective measurements of benefit contribution towards the strategic objectives to lead, manage, and continuously improve portfolio management governance, processes, and frameworks with and through the direction of a portfolio practice, principles, and delivery boards. What you Will Learn At the end of this program, you will be able to: Articulate the benefits of portfolio management Link the initiatives in an organization with its strategic objectives Participate in the introduction of portfolio management in an organization Create or improve the portfolio governance structure Lead the inventory of ongoing and new initiatives Assist the executives in the prioritization of initiatives through the use of Multi-criteria Analysis and other selection tools Support the executives in balancing the portfolio based on the optimal use of resources and priorities Create a portfolio delivery plan Define thresholds and variance reporting criteria Assist the executives and the financial team in the definition of Stage Gate Funding Lead the Stage Gate reviews Analyze the benefits that are being realized by the initiatives Foundation Concepts Definitions Benefits of Portfolio Management Objectives of Portfolio Management Portfolio Life Cycles Governing the Portfolio Portfolio Governance structure Roles and responsibilities Initial activities when starting portfolio management Prioritizing Initiatives Prioritize purpose Multi-Criteria Analysis Analytical Hierarchy Process (AHP) Strategic alignment Balancing the Portfolio Allocating resources and budgets Communicating decisions of initiatives status Planning the Portfolio Planning review cycles Using Stage Gate Funding Setting thresholds and variance reporting Tool examples Managing the Portfolio Delivery Project and Program Life Cycles Stage Gate Reviews Loop back to Prioritize, Balance and Plan Interaction with the Portfolio Delivery Board Project, Program and Functional Managers' roles and responsibilities

Introducing In-Person Couples Therapy Package: Strengthening Relationships Through Personalized Guidance and Connection Are you and your partner facing challenges in your relationship, longing for effective communication, intimacy, and mutual understanding? Miss Date Doctor’s In-Person Couples Therapy Package offers you and your partner the opportunity to engage in face-to-face therapy sessions, fostering a deeper connection and personalized guidance to enhance your relationship. Relationships can experience ups and downs, and sometimes external guidance is needed to navigate through difficult times. Our experienced couples therapists are committed to providing you and your partner with a safe and supportive space to address concerns, improve communication, and strengthen your bond. Here’s how the In-Person Couples Therapy Package can support you: Personalized Couples Assessment: Our therapists will conduct a thorough assessment to understand your relationship dynamics, strengths, and areas that need improvement. Tailored Therapy Sessions: In-person couples therapy offers personalized sessions that cater to your unique needs and relationship goals. Communication Enhancement: We’ll provide effective communication tools and techniques to promote healthy and open dialogues between you and your partner. Conflict Resolution Skills: Our therapists will guide you in developing constructive conflict resolution strategies to navigate disagreements. Reigniting Intimacy: In-person therapy can help you and your partner reconnect emotionally and physically, fostering a deeper sense of intimacy. Emotional Connection: We’ll focus on building emotional connection and understanding between you and your partner. Navigating Transitions: Whether it’s a life change or milestone, therapy can help you navigate transitions while maintaining a strong relationship. Shared Growth: The In-Person Couples Therapy Package promotes shared growth, allowing you and your partner to evolve together as a couple. The In-Person Couples Therapy Package at Miss Date Doctor is designed to strengthen your relationship through face-to-face interaction and expert guidance. Our experienced couples therapists provide a secure environment for open conversation and collaborative problem-solving. Invest in the growth and well-being of your relationship and take the first step towards enhanced connection with the In-Person Couples Therapy Package. Embrace the opportunity to improve communication, address challenges, and build a resilient and loving partnership. Let our skilled therapists guide you and your partner towards a stronger and more fulfilling relationship journey. 1 hour session x3 https://relationshipsmdd.com/product/in-person-couples-therapy/

This interactive programme will use the topic of equity, diversity, and inclusion to illustrate the problem of unconscious bias and the practical solutions to overcome it. The programme will provide the opportunity for self-reflection, open discussion, and training on some of the softer skills to maximise objectivity in the workplace.

In today's fast-changing competitive environment, people in all roles need to have more commercial awareness and responsibility.

Ensuring that you provide the level of service that your customers want to be delivered through your people. This programme develops the skills and behaviours that enhance the experience that your customers receive.