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. Tailored in company 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. 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
Why choose Vectorworks Landmark Training Course? Course info Explore the Vectorworks Landmark Training Course! 1-on-1 Live Online sessions led by certified tutors and industry experts. Master Vectorworks Landmark for landscape and site design, creating captivating outdoor spaces. Enroll now to unleash your design skills. Duration: 16 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. This course focuses on Vectorworks Landmark fundamentals, providing essential tools and techniques for landscape architecture, design, and related disciplines. Participants should have a basic understanding of Vectorworks software. The course covers 2D and 3D drawing, file organization, landscape plan/model creation, and more. Learning Objectives: Organize drawing files using industry standards and best practices for effective collaboration. Utilize imported files and field-collected data for base plans and site inventories. Integrate 2D and 3D elements for plan documentation and model analysis. Utilize worksheet features for material quantification and project efficiency. Course Prerequisites: Participants should be familiar with basic drafting concepts, computer operations, and keyboard shortcuts. This training demonstrates sustainable design principles and the use of CAD tools for erosion control, runoff calculations, plant tracking, and sun/shade analysis. Participants will learn to create a 3D site digital terrain model and assess proposed plantings' effects on solar heat gain and water usage. Vectorworks Landmark Basic to Intermediate Training Course Duration: 16 hours Join our comprehensive Vectorworks Landmark Basic to Intermediate Training, designed for landscape architects and designers. Master 2D and 3D landscape design with essential techniques, covering site analysis, plans, irrigation, and 3D visualization. Unleash your creativity with custom plant symbols and detailed planting plans using the plant database. Course Outline: I. Introduction to Vectorworks Landmark (1 hour) An overview of Vectorworks Landmark for landscape design Interface orientation and basic tool usage Navigation and viewport controls Landscape design project creation and management II. Site Analysis and Site Plans (3 hours) Collecting site information and producing site analysis drawings Crafting site plans and hardscape design Working with contours, elevations, and terrain models Incorporating site amenities like paths, fences, and walls III. Planting Plans (5 hours) Utilizing the plant database to select suitable plants for specific regions Creating personalized plant symbols Developing comprehensive planting plans and plant lists Understanding plant compatibility and growth patterns IV. Irrigation Design (2 hours) Designing and editing irrigation systems and zones Integrating irrigation components into the site plan Generating irrigation reports for efficient planning V. 3D Visualization (3 hours) Creating captivating 3D models of landscape designs Applying textures and materials to hardscape elements and plants Utilizing the Renderworks engine for high-quality rendering Enhancing designs with lighting and special effects VI. Customization (1 hour) Tailoring the interface for landscape design efficiency Creating custom object styles and resource libraries VII. Collaboration and Sharing (1 hour) Importing and exporting data from other software platforms Sharing landscape design drawings with colleagues and collaborators VIII. Conclusion and Next Steps (1 hour) Comprehensive review of course content Guidance on further learning resources Q&A session and feedback gathering Enroll in our Vectorworks Landmark Basic to Intermediate Training to enhance your landscape design expertise and unleash your creative prowess. Download Vectorworks Landmark https://www.vectorworks.net/en-GB/landmark By the end of the Vectorworks Landmark Training Course, participants will: Understand the key features and functionalities of Vectorworks Landmark for landscape design. Demonstrate proficiency in using essential tools for site analysis, site plans, and hardscape design. Create detailed planting plans, selecting appropriate plants, and understanding their compatibility and growth patterns. Design efficient and effective irrigation systems, including generating irrigation reports. Create 3D visualizations of landscape designs, applying textures, materials, lighting, and special effects. Customize the interface and create personalized object styles and resources. Collaborate and share landscape design drawings with other software users. Have the foundation to pursue further learning and exploration in landscape design using Vectorworks Landmark.
In today's fast-changing competitive environment, people in all roles need to have more commercial awareness and responsibility.
The ability to effectively manage conflict is a core competency in the 21st-century workplace.
Public Speaking Courses That Work Our public speaking courses are refreshingly different and transformative. Mindful presenting is the key to the future of high impact public speaking training. In fact, we are changing organisations one presentation at a time. We do that by providing training that empowers and equips professionals to present with greater confidence, clarity and impact.
Public Speaking Courses That Work Our public speaking courses are refreshingly different and transformative. Mindful presenting is the key to the future of high impact public speaking training. In fact, we are changing organisations one presentation at a time. We do that by providing training that empowers and equips professionals to present with greater confidence, clarity and impact.
Public Speaking Courses That Work Our public speaking courses are refreshingly different and transformative. Mindful presenting is the key to the future of high impact public speaking training. In fact, we are changing organisations one presentation at a time. We do that by providing training that empowers and equips professionals to present with greater confidence, clarity and impact.
Vray for 3ds max face to face training customised and bespoke.
Our Team Building Programmes are 'simply excellent' (quote from Unilever). They always deliver much greater energy' motivation and efficiently accelerates to a galvanised, integrated team for their Manager/Team Leader. They're great fun and very commercially orientated - the best of both key elements to a successful and long-lasting high performance team. A successful company is always made up of successful teams. Teams that can work autonomously with a clearly defined set of goals, roles, vision, responsibility and culture will always reach for and achieve far greater success than a team that works just as a group of individuals. Our team building solutions are individually built and geared towards teams at any level within an organisation, providing an independent and objective perspective to promote a common purpose such as the creation of a 'high performance team'. Out With The Old Traditionally, team building events have been restricted to certain levels of management where they head off site for a bit of archery, quad biking and paintballing or something along those lines. Then over some coffee and cocktails, business plans and more efficient ways to work are casually discussed. Whilst being out having fun instead of being at work may improve an individual person's mood, the effect will only be short-term, and will not go far in creating permanent and cohesive teams who are able to overcome challenges together and drive the business forward when back in the workplace. In With The New Today's business thinking is more strategic and certainly has to look for returns on the investment. That is why Dickson Training Ltd's team building programmes are bespoke and built to your requirements through research, understanding your business and, most importantly, what results and achievements you are looking to get out of the programme. Once "what success looks like" has been established, we create tasks and activities that will test your leadership, problem solving, communication and team work skills. When the tasks have been completed, the learning - both practical and theory - is debriefed to the group as well as how it will translate back in your business. Not only are our events great fun, but they provide participants with learning points they can act upon to improve or enhance the working practices/environment. Team Building That Gets Results We have a highly innovative team who design team builds to suit all budgets and time or space restrictions. Large or small, we will develop the perfect event to meet your commercial objectives, keeping in line with your values and company culture. More recently we have combined team galvanising events with ways to engage the participants with and support their local communities. This solution has proved extremely popular with our clients and we are continuing to develop more and more programmes doing exactly this. " Phil did everything in a very professional and focused manner, without losing sight of the overall aims or having 'fun'. When I moved to Airbus UK and subsequently European Aeronautic Defense and Space Company (EADS), I had no hesitation in recommending Phil and the team to deliver the required training and team events. Without doubt Phil and his team are excellent providers of training, to suit even bespoke requirements, and I would not hesitate in recommending the team to any business in the future. " Glenn Brown, Systems & Expertise Manager, Airbus Personnel Service Augmented Skills – an Essay by Phil Dickson All of you, who are reading this, and all the people you meet and work with will have – ‘Augmented Skills’. So – if you are an IT Engineer or a Pharmacist; perhaps you are, or know, a Departmental Leader and you work with a Logistics Project Manager; these roles will demand core skills, whether they be technical know-how or qualifications in the discipline. But to be that bit better; more reliable; more effective & productive and therefore more valuable and, frankly, marketable – capitalizing on ‘Augment Skills’ comes into play. The I T Engineer who was a Chess Champion at Uni, which would indicate that they possess some key ‘Augmented skills’ including how they plan 3 steps ahead and are always prepared for the unexpected. The Pharmacist, who is a keen sportsperson in their private life, will likely be tenacious, team-orientated and disciplined – again these are superb qualities to have in this – or any – role. Your colleagues, as well as yourself, will have ‘Augmented Skills’ that will be an asset if only they are explored and applied to their role and indeed, career. Everyone has their own 'Super-power' If they love gardening, they are probably strategic, patient and inclined to research; if they cook or bake, they are usually well organized and comfortable with multi-tasking. A big reader will tend to be considered and possess good critical thinking faculties, and an amateur mechanic or keen DIY person will often be practical, resourceful and very determined. I have observed that many new Parents discover they have ‘Augmented Skills’ they didn’t know they had... such as getting order out of chaos and displaying industrial amounts of patience and good grace when they really do not feel like it. They very often become far more compassionate and empathetic. Most people have their very own ‘Superpower’. Invite your team members to offer their ‘Augmented Skills’ to your work-place – and just watch as it elevates the motivation levels and improves results. It’ll be very rewarding for all concerned – and for meeting the Team’s objectives, to encourage the person who is a talented artist to be a sounding board on some of the marketing imagery and layouts; for the team member who is great at Maths or resolving crosswords to be asked for their input to solving a problem that is causing logistical or operational headaches. Never exploit a Team member’s unique special skills at their expense I would like to stress, however, that it must never be an area where a team member gets exploited by harvesting their unique special skills to coerce them into taking on greater responsibilities and tasks without providing them with the commensurate salary and status. To do so would be immoral and, ultimately, counter-productive as it would lead to resentment and disenfranchisement. This is about encouraging people’s capability and inviting their input to boost confidence and enhance the team’s capability. Often, we need to be more than what our Job Description says It is also important to highlight that whatever a person’s role or function is – they will definitely need to have additional capabilities to be effective. The best example of this is when we designed and delivered a range of ‘Advanced Customer Care skills’ training sessions for the Met Office a few years ago…we met so many remarkably super-bright Meteorologists, many of whom were having to make significant adjustments to answering questions from Customers that seemed to be illogical and often, obtuse. It wasn’t enough for these Meteorologists to be highly skilled at interpreting data and identifying patterns – they needed ‘Augmented skills’ to make that information accessible to members of the public (and Council workers and Air Traffic controllers and Shipping agents) and many other people, as to what that particular weather system was going to be like in their area and at what time. They have to know how to ‘de-jargonise’ the material and provide succinct, clear, and yet temperate, descriptions without ever appearing exasperated, impatient or judgmental in response to sometimes quite silly questions. For a highly trained scientist – that can be counter-intuitive. Being Philosophical... and a wee bit pretentious At the risk of being a little Philosophical (and probably a wee bit pretentious) – in my own role of Trainer – my core skills have to include – being a very good communicator, an active listener and have innovative and engaging ways to convert an idea, or a model, into practical application that my Delegates and Clients gain tangible benefits from. This is how it applies to me... I really enjoy composing short, light classical-style piano pieces. Now, to do this well, you need to be able to find a transition from one chord or melody to a different theme or key. It has to be worked out very carefully to have incremental transitions and pleasant-sounding developments as the piece unfolds. I think I have become better at this as I have honed my skills as a composer. But I have realized that these very same skills have ‘Augmented’ my ability to help a Manager, or a Team, move from a state of conflict; tension; disfunction; disenfranchisement; lack of confidence to a place that is more harmonious with far greater productivity. The very same process of careful listening, considering options, taking well-considered steps, having a creative, sometimes brave, move towards a resolution are at play in both Training and Piano Compositions! Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. Please contact us for more information.