1243 Courses in Birmingham

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 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. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

A whole day of workshops for groups of pupils throughout your school, delivered by a dedicated ally of disabled people. Engaging and thought-provoking, these workshops are a must for schools that want to challenge prejudice and promote disability equality. Workshops will help pupils to: learn more about disability and human rights hear disabled people’s perspectives identify common stereotypes and some of the prejudices disabled people face consider what disability is and how it arises understand the difference between impairment and disability review terminology and its effect on disabled people’s identities learn about disabled people who have made a difference ask sensitive questions anonymously become advocates for disability equality 95-100% of participants say that they found our workshop helpful Some of the reasons pupils have given for finding the workshop helpful are: “Until today I had always been scared of disabled people but today I have learnt that disabled people have a heart and emotions too.” “I now understand more about disabilities. My sister and brother has disabilities.” “It shows that although disabled people have limits they can do many things.” “Because presenter told in very simply way about complicated things and used interesting examples.” “Now I know that disabled people do things differently.” FAQs: How long is each workshop? 40-45 minutes; this can be adjusted to fit in with your school day. How many workshops will you deliver? We can deliver up to six workshops in a day. How many pupils should there be in each group? The workshops are interactive, so they are more effective with groups of around 20 pupils. We are often asked to work with larger groups and this still generates excellent feedback from pupils and staff. What year groups are these workshops for? The workshops are suitable for all year groups in primary and secondary schools; we adapt the content and presentation according to the age of pupils. Does a member of staff need to stay with the group? Yes, we ask that a member of staff is present at each workshop. Will you need any equipment? We ask for a computer, projector and access to the internet. Pupils will need a pen to write with. How are the workshops evaluated? At the end of each workshop we ask all (except the youngest) pupils to write down if they have found it helpful or not and why; we may also offer them an opportunity to ask a question anonymously.If schools have opted for this (please see optional extras below) we will send the school written responses to questions and a transcript of pupils’ feedback as evidence of impact. Cost: CSIE price: £800+vat plus expenses Optional extras: a) written responses to pupils’ anonymous questions (£50+vat) b) transcript of pupils’ feedback, as evidence of impact (£50+vat)

Project Communication Skills: In-House Training Communication is the single most critical project success factor. When effective, projects get executed on time, within budget, and with objectives being met. But that isn't all. Strong communication also nurtures healthy team relationships. And in today's highly diverse world, where projects are often fast-paced, complex, and virtual, that is more important than ever. Strong communication skills foster cultural awareness, trust, and empathy. Together, they contribute greatly to project success-and ultimately, to future project success. In this course, participants will actively explore best communication practices from a variety of perspectives: in-person, virtual, electronic, and via formal project documentation. In order to be transformative, however, those perspectives will be filtered further through the lens of their formal, personalized assessment. It is a powerful tool which identifies individuals' internal needs and priorities. It translates those into descriptive profiles and reports, gifting users with valuable information about themselves and others. Paired with the course's real-world activities, it will provide uniquely strategic opportunities for communicating effectively and meaningfully-and with less conflict, both personally and professionally. What You Will Learn At the end of this program, you will be able to: Identify basic elements of communication and explain how they affect teams Explore how your assessment style impacts you and how you communicate with people of other styles Infer how your style impacts the way(s) you send and interpret emails and instant messages Analyze real world email and instant messaging practices to determine how they affect communication and relationships Explore best practices for formal project communications and presentations Analyze how your assessment style and global diversity can contribute to both strong team communication and conflict Identify solutions for virtual team work communication challenges Getting Started Foundation Concepts Communication as a foundation skill Elements of communication Communicating across media Targeting your audience How communication impacts team performance The Assessment Framework Overview of the assessment's approach Exploring assessment report Increasing your effectiveness with other assessment styles Email and Instant Messages Preferred communications and assessment styles The email brands we create Assessment styles and email Emotion and email Email guidelines and best practices Anatomy of an email The seven deadly email sins Instant messages and other interfaces Project Communications and Presentations Communicating across the project lifecycle Project templates Structuring a presentation Delivering a presentation Interpersonal and Team Communication Skills Communication styles and techniques Managing conflict in a project environment Styles and conflict Communication and global team leadership Virtual Communication Leading global virtual teams Virtual processes and technology Virtual team leadership

Microsoft Project White Belt® 2013: In-House Training This workshop serves as an introduction to the interface and features of Microsoft® Project 2013. This course will be led by an IIL-certified instructor who will outline the benefits of Microsoft Project, provide tips on using various features and common shortcuts, recommend guidelines, and discuss the application of scheduling concepts to manage project work This workshop serves as an introduction to the interface and features of Microsoft® Project 2013. This course will be led by an IIL-certified instructor who will outline the benefits of Microsoft Project, provide tips on using various features and common shortcuts, recommend guidelines, and discuss the application of scheduling concepts to manage project work. What you Will Learn You'll learn how to: Define key scheduling concepts and terms Effectively navigate the user interface and interpret common views Configure essential elements of a new schedule Enter and modify a task list Set dependencies between tasks Create a basic resource list and generate assignments Format targeted areas of the Gantt Chart view Prepare the schedule for printing Getting Started Introductions Course objectives Course outline Navigating the User Interface and Views Navigate and use the Ribbon Use and customize the Quick Access Toolbar Modify general and display options Become familiar with major elements on the Project screen Navigate Gantt Chart, calendar, and network diagram views Search for a help topic Setting up a New Schedule Create new schedules Create a new schedule using existing information Enter and modify the schedule start date Enter and modify exception days in the calendar Entering, Modifying, and Outlining Task Data Enter, edit, correct, and clear information Enter unscheduled tasks Enter duration estimates for a single task or multiple tasks Organize tasks Set up a multi-level outline Add notes to tasks Creating Dependencies by Setting Links Identify a critical path in a simple schedule Understand how scheduling software calculates a critical path Describe dynamic schedules and dependencies Create links using various methods Display the critical path Entering and Assigning Resources Plan for resources Create a list of available resources Assign resources Formatting Gantt Chart View Format text and Gantt Chart bars Format a collection of items Configure print options

The ability to effectively manage conflict is a core competency in the 21st-century workplace.

If you run a small, tight-knit team, this course is tailored to help you get the most from the group.

Recognising the value of, and practising, clear and open communication at all levels is the first step to improving performance, whether at an individual, team, management, leadership or organisational level. We all know this, but why is it so difficult? This unique programme will make it much, much easier for you by giving you a robust framework to use - and the opportunity to practise your skills in a safe, supportive environment. It will help you have conversation that deliver tangible results. The programme will help you: Overcome the barriers to effective performance conversations Handle feedback conversations effectively Improve working relationships with your staff Set realistic expectations and targets (and get 'buy-in' for them) Improve your communication style Plan and prepare for honest conversations in the workplace 1 What is an honest conversation? Why don't we have them more often? What stops us? The cost of not having them 2 The feedback conversation Dealing with the impact of feedback conversations 3 Preparing for conflict 4 Effective working relationships 5 The expectations conversation 6 The targets conversation 7 Your communication styles 8 Planning and preparing for an honest conversation 9 Giving and receiving feedback skills

Introducing the “How to Keep a Relationship Strong and Happy” Package: Your Blueprint for Long-lasting Love, Respect, and Happiness Are you looking to build a solid foundation and keep your relationship thriving with love, respect, and happiness? Miss Date Doctor is delighted to present our exclusive “How to Keep a Relationship Strong and Happy” package. Designed to provide you with the essential tools and guidance, this comprehensive relationship coaching program will empower you to create a lasting and fulfilling bond with your partner. With our package, you’ll learn invaluable strategies to foster respect, effectively manage conflicts, maintain physical and emotional intimacy, cultivate empathy, and nurture love. We understand that every relationship is unique, which is why our experienced relationship coaches will tailor their expertise to address your specific needs and goals. Why should you invest in the “How to Keep a Relationship Strong and Happy” package? Because a strong and happy relationship requires effort, commitment, and the right knowledge. Here’s how our package can help: Cultivating Respect: Respect forms the foundation of any healthy relationship. Our package will guide you on how to establish mutual respect, communicate effectively, and create a safe and supportive environment where both partners feel valued and appreciated. By learning the principles of respect, you’ll build a strong bond that withstands the test of time. Conflict Management Strategies: Conflicts are inevitable in any relationship, but how you handle them can make all the difference. Our expert coaches will teach you effective conflict resolution techniques, helping you navigate disagreements with grace and understanding. By learning healthy communication styles and negotiation skills, you’ll resolve conflicts while strengthening your connection. Maintaining Physical and Emotional Intimacy: Physical and emotional intimacy are essential for a thriving relationship. Our package will provide you with practical tips and guidance to keep the spark alive, reignite passion, and deepen your emotional connection. You’ll explore techniques to enhance intimacy, explore each other’s needs and desires, and create a satisfying and fulfilling bond. Cultivating Empathy and Understanding: Empathy is the key to fostering understanding and compassion in your relationship. Our coaches will guide you through exercises and techniques to enhance empathy, helping you better understand your partner’s perspective, needs, and emotions. By cultivating empathy, you’ll foster a deeper connection and create a harmonious and supportive partnership. Nurturing Love and Connection: Love is a journey that requires nurturing and continuous effort. Our package will provide you with the tools and strategies to keep the love alive. You’ll explore ways to express love and appreciation, create shared experiences, and maintain a sense of adventure and excitement. Together, we’ll ensure that your relationship remains vibrant and filled with joy. Continuous Support and Guidance: Throughout your journey, our dedicated relationship coaches will provide ongoing support and guidance. You’ll have access to personalized advice, resources, and strategies to address any challenges that may arise. With our support, you’ll feel confident in navigating the ups and downs of your relationship and maintaining a strong and happy partnership. Invest in the “How to Keep a Relationship Strong and Happy” package from Miss Date Doctor today and embark on a transformative journey towards building a lasting and fulfilling relationship. Discover the secrets to love, respect, happiness, and connection that will enrich your lives for years to come. Contact Miss Date Doctor now to book your package and create a relationship that stands the test of time. Happiness and fulfillment await you and your partner. Don’t wait—start building the love you deserve today! 4 x 1 hour session https://relationshipsmdd.com/product/how-to-keep-a-relationship-strong-and-happy-package/

Managing Stress in Challenging Times: In-House Training This course looks at the symptoms and causes of stress and how these affect us emotionally, behaviorally, and physically. You will learn some simple stress-busting techniques that will have a positive influence on your beliefs and behaviors around stress. You will also have the opportunity to develop a personal action plan which will serve as an ongoing reference point for dealing with pressure in its many forms - home, family, social, and work. What You Will Learn At the end of this program, you will be able to: Recognize the symptoms and causes of stress Manage and reduce the effects of stress in your life with simple stress-busting techniques Create a simple personalized plan to manage stress and promote a healthier, happier, and more productive lifestyle Getting Started Foundation Concepts What is stress? Why stress matters Flight or fight response and role of hormones Work-Life Balance How to create balance and set boundaries Learning how to say 'no' Stress-Reduction Techniques Visualization and relaxation techniques Behaviors and beliefs Putting things in perspective Circle of influence (vs. circle of control) Slowing down Be Responsible and Kind to Yourself Basic human needs Honest communication Your responsibility to yourself and others Calming thoughts

Resilience is the ability to take the challenges and changes of life in your stride and say yes to the opportunities that excite you.