17836 Courses delivered Online

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. Requirements Requirements 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 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

Historical Association webinar series: History and literacy: better together Presenter: Andrew Wrenn There are many fine core texts that can enhance primary history and magnify its curricular impact. This practical webinar will show how to plan carefully when using these texts, exploring some of the advantages this can bring while avoiding corresponding pitfalls. Careful consideration will be given to the setting of subject-specific and general literacy objectives and tasks. To use your corporate recording offer for this webinar please complete this form: https://forms.office.com/e/HYhgpvBBuG

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special ADHD Coaches: Create Your Rock Solid 4 Week Discovery Series Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The ADHD Coaches: Create Your Rock Solid 4 Week Discovery Series Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This ADHD Coaches: Create Your Rock Solid 4 Week Discovery Series Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This ADHD Coaches: Create Your Rock Solid 4 Week Discovery Series Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this ADHD Coaches: Create Your Rock Solid 4 Week Discovery Series ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing. Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the ADHD Coaches: Create Your Rock Solid 4 Week Discovery Series there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the PDF certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This ADHD Coaches: Create Your Rock Solid 4 Week Discovery Series course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This ADHD Coaches: Create Your Rock Solid 4 Week Discovery Series does not require you to have any prior qualifications or experience. You can just enrol and start learning. This ADHD Coaches: Create Your Rock Solid 4 Week Discovery Series was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This ADHD Coaches: Create Your Rock Solid 4 Week Discovery Series is a great way for you to gain multiple skills from the comfort of your home. Week 01 Welcome 00:08:00 How to Share Document with Your Client 00:04:00 The Life Wheel Overview 00:04:00 The Life Wheel Overview (PDF) The Life Wheel in More Depth 00:06:00 Repeat this Exercise Every 3 Months 00:01:00 Keep Your Focus on the Time 00:01:00 Week 2 Do These Exercises on Yourself First 00:02:00 The Strengths Form Overview 00:04:00 The Strengths Form Overview (PDF) The Top 5 Strengths Section 00:01:00 The Challenges Form Overview 00:01:00 The Challenges Form Overview (PDF) How to Turn the ADHD Challenges into Strength 00:05:00 Week 3 Learning Styles Overview 00:09:00 Learning Styles Overview (PDF) Focus, Understand, Remember 00:03:00 The 8 Most Common Learning Styles 00:11:00 How to Use This Idea to Create Rapport with Your Client 00:01:00 Week 4 Plan for Your Life Overview 00:02:00 Plan for Your Life Overview (PDF) The Plan for Your Life in More Detail 00:04:00 How to Create Your 5 Year Plan 00:04:00 How to Keep Your Focus on Your Life Plan 00:02:00 How to Write a Letter to Yourself One Year from Now 00:04:00 How to Write a Letter to Yourself Five Years from Now 00:03:00

Writing Clear Business Communication: In-House Training This program is about learning about the writing process and covers the full spectrum of documents used when corresponding in the workplace. The ability to write effectively comes naturally to some people, but for the vast majority, it is a task often approached with a mixture of trepidation and dread. Effective writing seldom, if ever, 'magically materializes' on the spot. In reality, it is most often the product of planning, writing, and rewriting. This is why writing is called a process; it must go through a series of steps before it is clear and complete. This program is about learning about the writing process and covers the full spectrum of documents used when corresponding in the workplace. The ability to write effectively comes naturally to some people, but for the vast majority, it is a task often approached with a mixture of trepidation and dread. However, the ability to communicate in the written word, for whatever purpose, is an important part of our working and personal lives and can have a direct impact on our ability to persuade, gain commitment or agreement and enhance understanding. Good writing sounds like talking on paper, which is why this program is focused on getting the message across and achieving the desired results using the 'keep it simple and direct' approach. What you Will Learn At the end of this program, you will be able to: Write effective e-mails, letters, memos, and reports Clearly articulate the message Achieve desired results from correspondence Organize content for maximum impact Format for enhanced understanding Choose the appropriate communication medium for each document Revise documents to increase clarity and impact Foundations Concepts Business writing as a form of professional communication How business writing compares to other forms of writing Characteristics of good business writing Challenges with business writing The Project Environment Business writing in the project environment The concept of art, science, and optics of business writing Art Economy Precision Action Music Personality Science Purpose, simple, compound, and complex sentence structures Techniques to engage the reader Point of view: tone, attitude, and humor Organization: opening, body, and closing Support and coherence Optics Visual optics Sound optics Feel optics Effective optics Efficient optics Email Formal vs. informal emails Suggestions for improving email communication Instant and text messaging Reports Common types of reports created Formatting of reports Guidelines for meeting minutes Contracts Types of contracts Common agreements Procurement documents Templates, Forms, and Checklists Templates Forms Checklists Other Formatting Good Documentation Practices Good documentation practices Data integrity in business communication

Learning Objectives Introduction , Getting Started with Access , Working with Data , Creating Databases and Objects , Working with Queries , Working with Reports , Working with Forms , Conclusion   Pre-Requisites Basic computer skills. Knowledge of basic database concepts is helpful but not required.   Description This course is an introduction to Microsoft Access 365. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 365 Intermediate course. Module 1: Getting Started with Access What is a Database 00:03:00 Database Terminology 00:05:00 The Access Interface 00:08:00 What is a Flat File Database 00:03:00 What is a Relational Database 00:10:00 Relating Tables 00:10:00 Reviewing The Access Ribbon 00:02:00 Module 2: Working with Data Working with Tables 00:07:00 Navigating Tables 00:04:00 Editing Data 00:03:00 Adding New Records 00:05:00 Using Subdatasheets 00:04:00 Module 3: Creating Databases and Objects Understanding Database and Table Design Principles 00:08:00 Using Table Data Sheet View 00:03:00 Working with Field Data Types 00:07:00 Using Table Design View 00:04:00 Calculating Numbers 00:05:00 Calculating Dates 00:02:00 Calculating Strings 00:03:00 Using The Lookup Wizard 00:12:00 Lookup Wizard Linking Tables 00:09:00 Using Indexes 00:04:00 Module 4: Working with Queries What are Queries? 00:08:00 Creating Simple Queries 00:05:00 Entering Criteria-Exact Match and Range Operators 00:05:00 Understanding And Versus Or 00:06:00 Using Wildcards 00:05:00 Using Key Words 00:04:00 Sorting and Hiding Fields 00:03:00 Creating Multi-Table Queries 00:03:00 Additional Tips C4 00:06:00 Module 5: Working with Reports What are Reports 00:05:00 Understanding Report Types 00:03:00 Building Good Reports 00:02:00 Using AutoReport 00:08:00 Understanding The Report Wizard 00:11:00 Using the Report Design View 00:08:00 Printing Reports 00:04:00 Creating labels 00:08:00 Additional Tips C5 00:10:00 Module 6: Working with Forms What are Forms 00:04:00 Understanding Form Types 00:03:00 Creating Forms 00:03:00 Navigating Forms 00:03:00 Editing Data in Forms 00:05:00 Understanding the Form Wizard 00:05:00 Using Form Design View 00:04:00 Working with Controls 00:10:00 Using Form Layout View 00:04:00 Additional Tips C6 00:07:00 Resource Resource - Access 365 Beginner 00:00:00 Final Exam Final Exam - Access 365 Beginner 00:20:00

A beginner-level course that will help you learn all you need to know about building applications using Python 3, FAST API, MongoDB, and NoSQL as well as front-end technologies such as HTML, CSS, JSX, and REACT JS with live demonstrations. You need to know the basics of HTML, CSS, and JavaScript to get started

Our CPD accredited online induction programme covers all aspects of the exam officer role and is specially designed for those new to the role.

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com