27 Educators providing Courses in Cardiff delivered On Demand

Name: Microsoft Access
Price: 25 GBP
Availability: InStock

access On Demand Cardiff

lifelong learning, university of southampton

1BF,

Welcome to Lifelong Learning at the University of Southampton. We deliver the University's community learning programme, which offers a range of opportunities for adult learners to enhance their skills and broaden their knowledge in a range of subject areas. From languages to creative writing and from archaeology to quantum computing you can choose from a diverse range of courses which run throughout our academic year (October to July). Our courses normally run on a weekly basis during the evenings and can be from 6 to 30 weeks in length. In addition to our evening courses we also run a series of themed Study Days. These events generally take place on Saturdays or Sundays and consist of a half or full day of academic lectures delivered by staff or postgraduate students. Examples of past topics are: Jane Austen, 1066, Lawrence of Arabia, the Archaeology of Southampton, Castles, Women and British Film, Stonehenge and Old Sarum. Lifelong Learning is based at our Avenue Campus and most of our courses and events take place at this campus where there is plenty of parking and it is on the U2 bus route and Avenue cycle route. When you study with us you will have access to a full range of learning resources through the University libraries and online. You will receive a student card and email address which will enable you to benefit from a wide variety of discounts and student offers. So whether you are looking to study for personal enjoyment, develop your career or wish to take the next step towards higher education take a look at our Lifelong Learning programme and join our vibrant lifelong learning community.

Message

direct 2u training & consultancy

Caerphilly

Our approach is a simple one – to operate in the best interests of our clients with no jargon, no confusion, no nonsense, just peace of mind. Established in 2014, Direct 2U Training & Consultancy Ltd was founded by its three Directors, Paul Chappell, Gary James and Jeff Berriman, later being joined by Paul Jenkins as a Co-Director. We provide a range of professional health and safety related training and consultancy services, through a team of Directors, employees and carefully selected associates. We’re based in Caerphilly, South Wales and offer services nationally to a variety of organisations and groups. WE TAKE PRIDE IN OFFERING EXCELLENT VALUE FOR MONEY SERVICES WHILE PUTTING CLIENTS NEEDS FIRST Health and Safety related Training services Are an enjoyable experience where delegates are involved. Accredited courses run by trainers with a wealth of practical knowledge and experience at a day and time that best suits client needs e.g. daytime, early mornings, evenings or weekends. We offer a range of open as well as bespoke courses customised for the Client. Health and Safety Consultancy services Are professional, practical and proportionate. Providing a clear focus for Clients in management of health and safety risks relevant to their area of business. Our team understands that health and safety is challenging for many businesses, with often confusing legislation and varying requirements amongst insurers, regulators and purchasers. Our aims are to provide businesses, small and large, with all they need to ensure a position of compliance as a minimum, whilst saving time, money and hassle. We will provide you with easy-to-access support, from our in house qualified health & safety consultants.

champneys house (ffec)

1AT,

Aspris Education provides expert specialist education services for children and young people aged 5 to 25 with a range of conditions and special education needs, including autism and social, emotional and mental health (SEMH) difficulties, through our extensive network of schools, further education colleges and partnerships with NHS child and adolescent mental health (CAMHS) units. Why choose Aspris Education? With absolute focus upon achieving the very best outcomes, our schools and colleges support young people with special educational needs to fulfil their own unique potential through: Safe and nurturing education environments that meet the full range of young people’s needs Tailored curriculums geared around a deep understanding of young people’s challenges Bespoke access to social skills programmes Well-equipped education and therapeutic facilities Pathways that tackle the difficult transitional journeys from childhood to adulthood A reputation for excellence Aspris Education's schools and colleges have a reputation for excellence in dealing with autism, social, emotional and mental health (SEMH) difficulties and additional needs, as reflected by our Ofsted, Estyn, Care Inspectorate, Education Scotland & CQC judgements. Our regulatory outcomes significantly outperform national sector performance data with many of our services achieving the very highest accolade from regulators of ‘Outstanding’. A national network for local placements The wide geographic spread of our schools and colleges allows us to provide local placements that meet young people’s unique education needs. Students are able to maintain relationships and links within their local community, in turn maximising their chance of a smooth and successful placement. A broad and varied curriculum Whether a student wants to progress to university or move into employment, we will support them in pursuing their ambition. Our schools and colleges offer a broad curriculum, with the choice of both academic and vocational courses in a variety of subjects, including:

Message

high grange school

0DR,

High Grange School’s multi-disciplinary approach incorporates best practices and autism-friendly strategies and supports in order to meet the educational needs of students who have ASD. Our students learn how to develop and use effective compensatory strategies to overcome difficulties in social and emotional processing, communication and flexibility in thinking and behaviour, all of which can combine to have a negative impact on their learning. The design of the school; its environment and facilities; and the structure and delivery of our educational programmes are created to reduce the stress and anxieties often associated with an autism spectrum condition. Our enabling teaching approach provides multiple physical and practical opportunities as well as visual supports for learning. This helps students to achieve their full potential by understanding and dealing with personal challenges while making the most of their abilities and strengths. Managing expectations realistically is a core part of our educational programme. Individualised Learning Plans are created for all students with input from the school’s specialist therapists. These plans include strategies to enable students to manage their anxieties; to regulate their emotional responses; and to reduce or eliminate negative and inappropriate behaviours which are preventing effective learning and positive social interactions. During the school day students have access to a varied and stimulating curriculum. The Classes are grouped by Key Stage and students are taught in small groups of up to 6. Teachers use detailed planning to ensure each individual is enabled to achieve in all areas. Classrooms are well-equipped and include specialist facilities for Music, Art & Design, D&T, Science, Computer Science and ICT, Food Technology and Performing Arts. High Grange has excellent PE facilities, including a swimming pool, large gymnasium, hard court areas and extensive grassed areas.

Message

oakwood specialist college - torpoint campus

2BJ,

Our Dawlish campus is situated in the coastal town of Dawlish near Exeter. It is a short walk from the town centre and the golden beach, with excellent transport links via bus or the Great western train line to Exeter, Plymouth and beyond. At Dawlish we provide learning programmes for around 80 learners, a small number of whom enjoy the residential experience in our onsite shared property, and in single and shared flats and houses in the nearby area. Our Torpoint campus is situated just a short walk from the ferryport and enjoys beautiful views of the River Tamar and beyond. We attract learners from both Plymouth and Cornwall to study here. Students benefit from accessing our local Torpoint community, but also take part in the huge range of trips and activities that Plymouth has to offer. At Oakwood Torpoint we provide learning for up to 25 learners. Torpoint is a day student only campus. Our newest campus, Oakwood Yate, is located in Yate, South Glos. with excellent transport links to Bristol and beyond. The campus benefits from being centrally located in the bustling town centre of Yate with a wide range of shops and leisure facilities providing excellent work experience and community access for our learners. At Oakwood Yate we provide learning for up to 15 learners. Yate is a day student only campus. The College’s focus is to develop the knowledge and skills of every learner to prepare them for independent life, living and work. We provide individualised and bespoke learning programmes that follow the pathways to adulthood, and include employment related qualifications and work experience. The College was inspected by OFSTED in September 2018, and judged to be good in all areas and Outstanding for Personal Development, Behaviour and Welfare (PDBW), with inspectors describing the learners as…” making excellent progress in their personal development and behaviour. They gain skills that can help them to be more independent in their daily lives”.

Message

adderley nursery school

1HN,

Adderley is a very child-centred nursery, which means that children spend much of their day engaged in self-directed learning. The majority of the day is free-flow, meaning children choose to engage in a range of different activities, indoors and outdoors. Children engage in activities independently and with their friends, as well as taking part in adult facilitated activities that are planned from children's interests and developmental needs. We believe that at this young age children learn best through a play-based curriculum, with support from our experienced staff team who engage with children in their play to support social interaction, language development and further learning opportunities. Some key attributes we seek to develop in children include self-confidence, problem solving and independence. 2-4s Unlike many other settings, at Adderley our two to four year olds are all part of the same unit. They share the same space and access the same activities. The Nursery is led by qualified early years' teachers and experienced qualified Nursery Practitioners. Key Person Each child & family has a named key practitioner. This offers the opportunity for a special relationship to develop. The key practitioner builds a close relationship by acting as a companion for the child & being mindful to the needs of the child during each day. The key practitioner acts as a champion for child & parent. Sharing information and creating opportunities to talk with parents builds trust & partnership. Settling-in is a crucial time. Transitions Each child and family is unique. Before starting Nursery, we offer all children and families a pre-entry induction meeting at Nursery and sometimes a home visit. We have new children starting every term. We have a range of base areas that offer a place of security for children to explore the Nursery. The Loft Room and Green Room provision support our youngest children to make smooth transitions from home to Nursery. There are seamless internal transitions to Studio 1 and Studio 2 for older children. Studio 1 and Studio 2 offer continuity and progression. We work together to support the settling process. When parents feel comfortable in the setting it helps their children to settle. During the Summer Term we work closely with neighbouring primary schools to offer smooth transitions to Reception. Children leave with excellent primary school readiness. Rhythm of the Day Adderley feels like home. We create Rhythm in the Nursery through our daily routine. Some children arrive early for breakfast and stay for tea. These are nurturing, social times. For most children in Nursery the day begins with meeting & greeting by the key person. A group time with the key person takes place on entry to meet & plan learning (breathing in) (15 minutes). This is followed by a period of child-initiated play indoors & outdoors (breathing out & exploring the world) (90 minutes). A group time at end of the session to share food, reflect, share stories and singing (breathing in) (15 minutes). About the Nursery Rhythm also comes through personal care routines. Nappy changing, changing clothes, washing, eating, quiet/resting/sleeping times are learning and development times for key person and child. Children experience the seasons and feel connected to nature and its lifecycle. There is a planned yearly timetable for looking after the garden and visits to parks. There are unplanned spontaneous experiences connected to weather. Children participate in real experiences like shopping, gardening, cooking and caring for living creatures and plants Food and Nutrition We are passionate about fresh, healthy food that tastes great. The right nutrients can affect everyone's mood, behaviour, health, growth and even their ability to concentrate. Encouraging a well-balanced diet establishes healthy eating now and for the future. We offer hot meals that are brought onto site by specialist caterers in education establishments. The children also have access to a morning snack of fruit with water available throughout the day. We offer breakfast and tea to children who are with us for longer days. The children grow some of our food in the garden. Governing Body The Governing body plays a key role in overseeing the practice and ethos of the school. They provide challenge and support to the Executive Head teacher and leadership team. If you would like to be involved please ask at Reception. Annual Data At Adderley we track children's learning and development termly, seeking to ensure that children make good or better progress and continue to be stimulated and challenged by their nursery experiences. This information is shared with families at termly reviews. We also use this data to identify curriculum development priorities. Working with Parents We value parental input very highly. We are always looking for parents to join our Governing Body which s a way to be involved in the direction that Adderley takes moving forwards. Each term parents meet with their child's Key person and contribute to identifying 'next steps' for their child's learning and development. We encourage families to share children's learning experiences from home through the Tapestry documentation tool.

Message

the bonny academy

Caerphilly

The Bonny Academy is a Training Provider. No matter if you’re an individual looking for personal growth or a company looking to train your employees, I can probably offer you something to train in. Who works at The Bonny Academy? At the moment, the only person working here is the founder, Lee-Ann Bonny. Lee-Ann is an experienced & fully qualified teacher. Look on the bio page for more info. In the future, I will be employing qualified & trusted individuals that have been pre-selected to run sessions and workshops in their main field of study. I am already building a small team of very talented individuals who will be fully trained to deliver courses to you & your teams. What do we do here? The Bonny Academy offers courses based around vocal coaching, performance & music theory and is aiming towards a future of training for roles in the events industry. Musicians Techs Crew Medics SIA & Stewards The company is just starting out & I am building a steady foundation of training that will catapult The Bonny Academy to the top of the events industry. There are vocal coaching subscriptions available, as well as online vocal courses. Vocal coaching & music tutoring is available via video call & face to face. The Bonny Academy has recently become a registered centre with awarding body Qualsafe. You can now access a wider range of courses including: Health & Safety at Work, Risk Assessments, Safeguarding, Fire Safety, Education & Training Level 3 and much more. Keep an eye on information about future courses such as First Aid at Work & SIA. Some of these courses have e-learning available in the shop on this website and, in the training section, you’ll find a full list of courses I currently offer. You’ll also find links to sign up to courses that I’ll be holding. All Qualsafe courses are certified qualifications & are regulated by Ofqual. Any Qualsafe qualfication that you do with me can be added to your digital learning record. Your learning record holds all of your qualifications from 2012 and can be accessed by educational institutions and employers, so you can make sure your credentials are proven. I am working hard on offering live/online workshops linked with live events services: volunteering, awareness of vulnerable groups, disability recognition, ALN/SEND & much more! The Bonny Academy courses & workshops will be accredited so you can add the hours to your Continued Professional Development files. The quarterly online vocal workshop already has accreditation & is worth 2 CPD hours, so make sure you sign up with your email to find out dates for those! Keep checking back to see if there’s something you’d like to attend. Courses & workshops will be available via Video Call, E-Learning & Face to Face.

Message

1 2 3

Courses matching "access"

Show all 34194

MO-500 Microsoft Access Expert Certification

By Packt

Welcome to the course. This course is designed for beginners who want to prepare for the MO-500 Microsoft Access Expert Certification Exam. This course will help you become an expert in all the core concepts and techniques specified for the Microsoft Access Expert MO-500 Certification Exam.

Delivered Online On Demand8 hours 35 minutes

£82.99

Access 2019 Beginner

By SkillWise

Delivered Online On Demand

£29

Access 2016 Advanced

By iStudy UK

If you have already done with the basic functions of Microsoft Office Access 2016, then now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Access is Microsoft's flagship database application that allows you to create and manage databases for all sorts of different purposes. This new version of Access incorporates a few new features and connectivity options in order to make databases more accessible to the everyday user. This Access 2016 Advanced is intended to help all users get up to speed on the different features of Access and to become familiar with its more advanced features. The course covers how to complete advanced form design tasks, add field and record validation, create and manage macros, conduct advanced database management, distribute and secure a database, and manage switchboards. What Will I Learn? Improve the Structure of a Database Maintain a Database Work with Access Switchboards Configure Access for Multiple Users Automate Processed with VBA Use Table Events Requirements Access Introduction and Intermediate courses or equivalent experience. Who is the target audience? Students who wish to learn the more advanced capabilities of Access. Introduction Introduction FREE 00:01:00 Improving the Structure of a Database Using the Table Analyzer Wizard 00:05:00 Append Querying to Normalize a Table 00:09:00 Creating a Junction Table 00:06:00 Maintaining a Database Backing Up a Database 00:02:00 Using the Compact and Repair Database Tool 00:03:00 Using the Object Dependencies Tool 00:02:00 Using the Database Documenter Too 00:02:00 Using the Performance Analyzer Tool 00:02:00 Working with Access Switchboards Understanding the Access Switchboard 00:03:00 Using The Switchboard Manager 00:09:00 Modifying a Switchboard 00:05:00 Setting the Startup Options 00:04:00 Configuring Access for Multiple Users Using the database Splitter 00:04:00 Configuring Trusted Locations 00:02:00 Password Protecting a Database 00:03:00 Password Protecting Modules 00:01:00 Converting a Database to an ACCDE file 00:02:00 Automating Processes with VBA Understanding VBA Basics 00:06:00 Exploring Variables and Control Flow Statements 00:10:00 Exporting a Table or Query with VBA 00:06:00 Converting a Macro to VBA 00:02:00 Using Table Events Understanding Table Events 00:02:00 Using the Before Change Event Command 00:04:00 Using the After Change Event Command 00:04:00 Conclusion Course Recap 00:01:00 Resources Resources - Access 2016 Advanced 00:00:00 Course Certification

Delivered Online On Demand1 hour 40 minutes

£25

Access 365 Advanced

By iStudy UK

Learning Objectives Introduction , Improving the Structure of a Database , Maintaining a Database , Working with Navigation Forms and Startup Options , Configuring Access for Multiple Users , Automating Processes , Using Table Events , Conclusion Pre-Requisites Access Beginner and Intermediate courses or equivalent experience. Description Access 365 Advanced will further build upon the topics covered in the Access 365 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create backups, create and modify Navigation Forms, set startup options, split a database, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), convert macros to VBA, and use Table Events. Module 1: Improving the Structure of a Database Using the Table Analyzer Wizard 00:09:00 Append Querying to Normalize a Table 00:10:00 Creating a Junction Table 00:06:00 Module 2: Maintaining a Database Backup Up a Database 00:03:00 Using the Compact and Repair Database Tool 00:03:00 Using the Object Dependencies Tool 00:03:00 Using the Database Documenter Tool 00:02:00 Using the Analyze Performance Tool 00:02:00 Module 3: Working with Navigation Forms and Startup Options Creating a Navigation Form 00:03:00 Modifying a Navigation Form 00:05:00 Setting the Startup Options 00:03:00 Module 4: Configuring Access for Multiple Users Using the Database Splitter 00:04:00 Configuring Trusted Locations 00:03:00 Password Protecting a Database 00:04:00 Password Protecting Modules 00:02:00 Converting a Database to an ACCDE File 00:02:00 Module 5: Automating Processes with VBA Understanding VBA Basics 00:03:00 Exploring Variables and Control Flow Statements 00:10:00 Exporting a Table or Query with VBA 00:09:00 Converting a Macro to VBA 00:02:00 Module 6: Using Table Events Understanding Table Events 00:02:00 Using the Before Change Event Command 00:07:00 Using the After Update Event Command 00:04:00 Resource Resource - Access 365 Advanced 00:00:00 Final Exam Final Exam - Access 365 Advanced 00:20:00

Delivered Online On Demand2 hours 1 minutes

£25

Access 2019 Advanced

By iStudy UK

Learning Objectives Introduction , Improving the Structure of a Database , Maintaining a Database , Working with Navigation Forms and Startup , Configuring Access for Multiple Users , Automating Processes with VBA , Using Table Events , Conclusion Pre-Requisites Access Beginner and Intermediate courses or equivalent experience. Description Access 2019 Advanced will further build upon the topics covered in the Access 2019 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create backups, create and modify Navigation Forms, set startup options, split a database, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), convert macros to VBA, and use Table Events. Access 2019 Advanced Module 1: Introduction to the course 00:01:00 Module 2: Using the table Analyzer Wizard 00:07:00 Module 3: Append Querying to Normalize a Table 00:06:00 Module 4: Creating a Junction Table 00:05:00 Module 5: Backing up a Database 00:02:00 Module 6: Using the Compact and Repair Database Tool 00:03:00 Module 7: Using the Object Dependencies Tool 00:02:00 Module 8: Using the Database Documenter Tool 00:02:00 Module 9: Using the Analyze Performance Tool 00:02:00 Module 10: Creating a Navigation Form 00:03:00 Module 11: Modifying a Navigation Form 00:03:00 Module 12: Setting the Startup Options 00:02:00 Module 13: Using the Database Splitter 00:03:00 Module 14: Configuring Trusted Locations 00:03:00 Module 15: Password Protecting a Database 00:03:00 Module 16: Password Protecting Modules 00:02:00 Module 17: Converting a Database to an ACCDE File 00:02:00 Module 18: Understanding VBA Basics 00:03:00 Module 19: Exploring Variables and Control Flow Statements 00:07:00 Module 20: Exploring a Table or Query with VBA 00:10:00 Module 21: Converting a Macro to VBA 00:03:00 Module 22: Understanding Table Events 00:02:00 Module 23: Using the Before Change Event Command 00:05:00 Module 24: Using the After Update Event Command 00:03:00 Module 25: Recap 00:01:00 Resource Resource - Access 2019 Advanced 00:00:00 Final Exam Final Exam - Access 2019 Advanced 00:20:00

Delivered Online On Demand1 hour 45 minutes

£25

Access 365 Advanced

By SkillWise

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 Access 365 Advanced 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 Access 365 Advanced Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Access 365 Advanced 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 Access 365 Advanced 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 Access 365 Advanced ? 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 Access 365 Advanced 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 Access 365 Advanced 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 Access 365 Advanced does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Access 365 Advanced 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 Access 365 Advanced is a great way for you to gain multiple skills from the comfort of your home. Module 1: Improving the Structure of a Database Using the Table Analyzer Wizard 00:09:00 Append Querying to Normalize a Table 00:10:00 Creating a Junction Table 00:06:00 Module 2: Maintaining a Database Backup Up a Database 00:03:00 Using the Compact and Repair Database Tool 00:03:00 Using the Object Dependencies Tool 00:03:00 Using the Database Documenter Tool 00:02:00 Using the Analyze Performance Tool 00:02:00 Module 3: Working with Navigation Forms and Startup Options Creating a Navigation Form 00:03:00 Modifying a Navigation Form 00:05:00 Setting the Startup Options 00:03:00 Module 4: Configuring Access for Multiple Users Using the Database Splitter 00:04:00 Configuring Trusted Locations 00:03:00 Password Protecting a Database 00:04:00 Password Protecting Modules 00:02:00 Converting a Database to an ACCDE File 00:02:00 Module 5: Automating Processes with VBA Understanding VBA Basics 00:03:00 Exploring Variables and Control Flow Statements 00:10:00 Exporting a Table or Query with VBA 00:09:00 Converting a Macro to VBA 00:02:00 Module 6: Using Table Events Understanding Table Events 00:02:00 Using the Before Change Event Command 00:07:00 Using the After Update Event Command 00:04:00 Resource Resource - Access 365 Advanced Final Exam

Delivered Online On Demand

£29

Access 2019 Advanced

By SkillWise

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 Access 2019 Advanced 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 Access 2019 Advanced Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Access 2019 Advanced 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 Access 2019 Advanced 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 Access 2019 Advanced ? 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 Access 2019 Advanced 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 Access 2019 Advanced 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 Access 2019 Advanced does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Access 2019 Advanced 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 Access 2019 Advanced is a great way for you to gain multiple skills from the comfort of your home. Access 2019 Advanced Module 1: Introduction to the course 00:01:00 Module 2: Using the table Analyzer Wizard 00:07:00 Module 3: Append Querying to Normalize a Table 00:06:00 Module 4: Creating a Junction Table 00:05:00 Module 5: Backing up a Database 00:02:00 Module 6: Using the Compact and Repair Database Tool 00:03:00 Module 7: Using the Object Dependencies Tool 00:02:00 Module 8: Using the Database Documenter Tool 00:02:00 Module 9: Using the Analyze Performance Tool 00:02:00 Module 10: Creating a Navigation Form 00:03:00 Module 11: Modifying a Navigation Form 00:03:00 Module 12: Setting the Startup Options 00:02:00 Module 13: Using the Database Splitter 00:03:00 Module 14: Configuring Trusted Locations 00:03:00 Module 15: Password Protecting a Database 00:03:00 Module 16: Password Protecting Modules 00:02:00 Module 17: Converting a Database to an ACCDE File 00:02:00 Module 18: Understanding VBA Basics 00:03:00 Module 19: Exploring Variables and Control Flow Statements 00:07:00 Module 20: Exploring a Table or Query with VBA 00:10:00 Module 21: Converting a Macro to VBA 00:03:00 Module 22: Understanding Table Events 00:02:00 Module 23: Using the Before Change Event Command 00:05:00 Module 24: Using the After Update Event Command 00:03:00 Module 25: Recap 00:01:00 Resource Resource - Access 2019 Advanced Final Exam

Delivered Online On Demand

£29

Access 2016 Introduction

By iStudy UK

Microsoft Access 2016 is an information management tool that allows you to store, report, and analyze information within a relational database. This Access 2016 Introduction is designed for beginners so that even if you've never so much as opened the program before, you can learn how to use it like a pro. This course covers all the important features of Access 2016 and demonstrates how to use them. Here you'll learn how to harness the power of Microsoft Access 2016 to organize, store, edit, manage, and report on hundreds of thousands of records. This course will help you master Access and put it to creative, confident use. You'll develop not only strong Access skills, but a solid understanding of good database design concepts. By the time you've finished the course, you'll know how to organize and assemble an effective database for any kind of information you need to store, document, and manage. What Will I Learn? Understand Databases and Database Terminology Work with Data Create Databases and Objects Work with Queries Work with Reports Work with Forms Requirements Basic computer skills. Knowledge of basic database concepts is helpful but not required. Who is the target audience? Students who want to learn database concepts and build basic databases. Introduction Intro FREE 00:01:00 Getting Started What is a database 00:02:00 Understanding Database terminology 00:05:00 Navigating the Access Interface 00:06:00 What is a flat file database 00:04:00 What is a relational database 00:09:00 Relating Tables 00:06:00 Reviewing the Access Ribbon 00:04:00 Working with Data Working with Tables 00:04:00 Navigating Tables 00:02:00 Editing Data 00:03:00 Adding New Records 00:02:00 Using Subdata Sheets 00:03:00 Creating Databases and Objects Understanding Database and Table Design Principles 00:10:00 Using Table Data Sheet View 00:04:00 Working with Field Data Types 00:04:00 Using Table Design View 00:03:00 Using Calculated Fields 00:04:00 Calculating Numbers 00:03:00 Calculating Dates 00:01:00 Calculating Strings 00:02:00 Using the Lookup Wizard 00:05:00 Editing Lookups 00:04:00 Using Indexes 00:02:00 Working with Queries What are Queries 00:03:00 Creating Simple Queries 00:04:00 Understanding the Dynaset 00:02:00 Entering Criteria- Exact Match and Range Operators 00:04:00 Understanding AND v. OR 00:03:00 Using Wild Cards 00:02:00 Using Key Words 00:03:00 Sorting and Hiding Fields 00:02:00 Creating Multi-Table Queries 00:03:00 Additional Tips 00:03:00 Working with Reports What are Reports 00:03:00 Understanding Report Types 00:03:00 Building Effective Reports 00:02:00 Using AutoReport 00:04:00 Understanding the Report Wizard 00:04:00 Using the Report Design View 00:08:00 Creating Labels 00:02:00 Working with Forms What are Forms 00:04:00 Understanding Form Types 00:02:00 Creating Forms 00:02:00 Navigating Forms 00:02:00 Editing Data in Forms 00:03:00 Understanding the Form Wizard 00:03:00 Using the Form Design View 00:04:00 Working with Controls 00:03:00 Using Form Layout View 00:02:00 Additional Tips (2) 00:02:00 Conclusion Course Recap 00:01:00 Resources Resources - Access 2016 Introduction 00:00:00 Course Certification

Delivered Online On Demand2 hours 56 minutes

£25

Access 2019 Intermediate

By SkillWise

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 Access 2019 Intermediate 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 Access 2019 Intermediate Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Access 2019 Intermediate 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 Access 2019 Intermediate 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 Access 2019 Intermediate ? 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 Access 2019 Intermediate 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 Access 2019 Intermediate 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 Access 2019 Intermediate does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Access 2019 Intermediate 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 Access 2019 Intermediate is a great way for you to gain multiple skills from the comfort of your home. Access 2019 Intermediate Module 01: Introduction to the Course 00:02:00 Module 02: Reviewing Table Design Principles 00:11:00 Module 03: Setting Field Size, Formats and Captions 00:09:00 Module 04: Setting Default Values and Required Fields 00:06:00 Module 05: Restricting Data Entry-Validation Rules 00:06:00 Module 06: Restricting Data Entry-Input Masks 00:07:00 Module 07: Exploring Tables and Queries to Excel 00:04:00 Module 08: Exporting Data to a SharePoint List 00:02:00 Module 09: Importing Data from Excel 00:06:00 Module 10: Importing Data from a Sharepoint List 00:02:00 Module 11: Linking External Data Sources 00:06:00 Module 12: Using Word Merge 00:07:00 Module 13: What are Action Queries 00:03:00 Module 14: Creating an Update Query 00:06:00 Module 15: Creating an Append Query 00:04:00 Module 16: Creating a Delete Query 00:05:00 Module 17: Creating a Make Table Query 00:04:00 Module 18: Changing Start Number of an Auto Number Field 00:04:00 Module 19: Modifying Query Joins 00:09:00 Module 20: Using Self Joins to Combine Data 00:06:00 Module 21: Creating Find Unmatched and Find Duplicate Queries 00:09:00 Module 22: Creating Parameter Queries 00:07:00 Module 23: Creating a Top X Query 00:03:00 Module 24: Reviewing Calculated Query Fields 00:05:00 Module 25: Summarising Query Data with Totals 00:05:00 Module 26: Creating a Crosstab Query 00:07:00 Module 27: Understanding Macro Basics 00:14:00 Module 28: Creating Macros to Open Forms by Record 00:08:00 Module 29: Validating Data Entry with Macros 00:09:00 Module 30: Creating a Macro to Automate Data Entry 00:08:00 Module 31: Advanced Data Entry Using Macros and DLOOKUP Functions 00:09:00 Module 32: Using Conditional Formatting 00:04:00 Module 33: Working with the New Label Name Property 00:02:00 Module 34: Organising Form Fields with Tab Controls 00:05:00 Module 35: Creating an Option Group Control 00:06:00 Module 36: Creating a Combo Box Control 00:05:00 Module 37: Configuring a Combo Box Control to Show Search Results 00:04:00 Module 38: Using a Subform to Show Data from a Related Table 00:05:00 Module 39: Inserting a Chart on a Report 00:07:00 Module 40: Showing Data in Columns 00:08:00 Module 41: Inserting a Subreport 00:04:00 Module 42: Configuring Reports with Parameter Queries 00:05:00 Module 43: Sending Reports 00:02:00

Delivered Online On Demand

£29

Microsoft Access

4.8(9)

By Skill Up

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Delivered Online On Demand3 hours 23 minutes

£25

Show all 34194