220 Form F courses

Description: Master the latest techniques of UX design with the Level 2 Certificate in UX Design course. User experience design or UX helps you to enhance the user satisfaction by improving the usability, accessibility, and pleasure of the users while experiencing or using your product. Throughout the course, you will learn the common UX mistakes people do while designing websites. You will be able to understand the human behaviour and psychology when they use your site. Based on this human behaviour and psychology, you will be able to apply the Usability Principles for improving your digital product that will satisfy the customers and meet their needs. Screenshots of UX problems faced by many designers, developers, and product managers will be presented to you so that you can understand the concepts easily. Instead of these, the course discusses the role of a role of UX developers for making any Website's or Apps Usability better. Who is the course for? Designers Developers Coders SEO Experts UI Designers Entrepreneur Design Directors Web Designers Mobile App Developes Startup CEO Anyone who wants to learn User Experiene Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction to User Expericne, UX Roles and how to be a UX Designer What Is UI FREE 00:05:00 Can I be a Ux Designer-updated 00:03:00 Different Role of Ux Designer 00:06:00 Major Parts of Ux Design 00:05:00 Human Centered Design, Double Diamond Model of Design and Root Cause analysis Human Centered Design 00:03:00 Double Diamond 00:05:00 Root Cause Analysis 00:02:00 Seven Stages of Actions 00:05:00 Five second usability test 00:02:00 06. Assignment 00:03:00 What is Agile UX 00:06:00 Principles & Concepts of User Experience, Usability and Interaction Design Affordance And Signfiers 00:06:00 Affordance And Signifiers-examples-fix-video 00:06:00 Afforadances explained headshot 00:05:00 Natural Mapping with examples 00:09:00 Mental models and conceptual models 00:06:00 Working Memory 00:06:00 Working Memory Example 00:07:00 06. Recognition And Recall 00:04:00 Recognition examples 00:07:00 User Expectations 00:04:00 User Expectations examples 00:08:00 User expectation headshot 00:02:00 Peripheral Vision 00:05:00 Peripheral Vision examples 00:07:00 Context of Use 00:05:00 Context of use headshot 00:02:00 Why-stakeholders are important 00:04:00 Information Architecture 00:05:00 Information Architecture Examples 00:11:00 Human Behavior Patterns, Decision making, scanning patterns and Change Blindness Humans Lazy Behavior decision Paralysis And Scanning 00:05:00 Human Decisions-Old And New Brain 00:03:00 Humans Hate Change 00:03:00 Our Goals And Change Blindness 00:03:00 Human behavior decision Paralysis hate change Examples 00:08:00 F-z Patterns Cart Abondomnment, Form Field Conversions 00:07:00 Designing for Humans - How to design better products for humans Discoverability 00:06:00 Discover assignment 00:01:00 Learnability 00:04:00 Feedback 00:03:00 Feedback Within Context Walmart 00:03:00 Feedback examples 00:08:00 Constraints With Examples 00:06:00 Consistancy With Examples 00:06:00 Slips And Mistakes With Examples 00:04:00 Designing For Errors With Examples 00:04:00 User In Control with Examples 00:05:00 Grouping And chunking with Examples 00:04:00 Humans Have Limits 00:07:00 How Developers can improve User Experience? Using design patterns: don't reinvent the wheel 00:05:00 Dont let users think do heavy calculation yourself 00:08:00 Speed and Delays 00:06:00 Smart Defaults 00:06:00 Guiding And Training Users 00:04:00 Barriers To Entry 00:05:00 Natural Language with Examples 00:08:00 Natural Language Forms 00:03:00 Google Analytics 00:05:00 Notification 00:07:00 Anticipatory Desgin 00:04:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

This course will guide you on how to design a responsive website from scratch without any previous experience in Adobe XD. You will also learn the principles of UI and UX and get your design ready for coding.

Course Overview Capoeira is a Brazillian form of martial art that incorporates dance, acrobatics and music. Dating back to the 16th century, it is known for its complex footwork and energetic kicks.  The Basics of Capoeira Martial Art course is an introduction to this special martial art form, for complete beginners. Through this course, you will learn the history and foundations of capoeira, as well as its many health benefits. It will teach you the basic beginner's defense moves, footwork and kicks, step-by-step, as well as how to warm up your body before you begin. This instructor-guided course will also teach you how to condition your body to improve your balance and build strength, stamina and flexibility, to get in the best physical shape of your life. This best selling Basics of Capoeira Martial Art has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Basics of Capoeira Martial Art is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Basics of Capoeira Martial Art is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Basics of Capoeira Martial Art is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Basics of Capoeira Martial Art, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Basics of Capoeira Martial Art will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Basics of Capoeira Martial Art to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Learn to communicate with your audience regularly with appropriate email marketing. Enrol the Aweber Training Course and explore the strategies of finding massive subscribers and sales. Aweber is an email marketing and autoresponder tool. Email marketing is one of the best ways of gaining profit. The course shows you some of the surefire methods of email marketing with Aweber. The techniques of using the service and the ways of setting up an auto-responder will be discussed in the course. The course shows you the ways of making money through email. You will learn to create a double and a single opt-in subscriber process. Throughout the course, you will also know how to develop an opt-in form for your website. Additionally, the course shows you the systems of importing an existing list from an offline source. business cards, LinkedIn contacts, etc. Next, the course teaches you how to add people to your email list and how to send a broadcast email. Shortly, the course will focus on the various potential ways of using email marketing for gaining profit by using Aweber. What you'll learn You will know how to use Aweber You will know how to send a broadcast email You will know how to set up an autoresponder You will know how to add people to your email list You will know how to make money from your email list You will know how to communicate with your audience and increase conversions You will know how to 2X your business with the power of the SOAP + SEINFELD Email Sequence Requirements You should have a subscription for Aweber or will get one Introduction 1. Promo FREE 00:01:00 2. Introduction 00:01:00 4. The Blueprint Overview 00:11:00 5. Signup for Aweber 00:01:00 6. Sign Into Aweber 00:01:00 7. Create a New Email List 00:06:00 8. Create Your First Signup Form 00:04:00 9. Customizing Your Signup Form 00:03:00 10. Signup Form Widget & Footer 00:01:00 11. ClickFunnels Autoresponder Integration 00:01:00 12. Importing Your List 00:05:00 13. Sending Broadcast Messages & Autoresponders 00:13:00 14. Segmentation & Why We Do It 00:10:00 15. List Options 00:05:00 16. Reports 00:02:00 17. Apps 00:02:00 18. Getting Help in Aweber 00:01:00 19. Copy My ClickFunnels Sales Funnel 00:03:00 Email Marketing 20. Why Email Everyday 00:03:00 21. The Value Ladder Explained 00:12:00 22. Soap Opera Sequence 00:13:00 23. Walkthrough of My SOAP Sequence 00:29:00 24. Client SOAP Sequence Example 00:11:00 25. Seinfeld Email Sequence 00:11:00 26. The Attractive Character Overview 00:10:00 27. Attractive Character II 00:18:00 Assessment

Course for Newbies to Microsoft InfoPath Don't know anything about one of the most useful software in microsoft office? Don't worry this course will teach you what you need to know. Designing your own customized form has never been easier using Microsoft Infopath. Use infopath to write your own expense report with offline support, increased accuracy and higher efficiency. Fill out your own insurance claim, permit application and other forms at your own convenience. Other benefits include inventory management and market research. Use this software to design, distribute, and to fill and submit electronic forms containing structured data. This course consists of units designed to teach you to use infopath. This course can teach people want to learn how to design their own forms for professional purposes. At the end of the course you will be tested on your knowledge on infopath. All the important features will taught to you so that you can operate infopath smoothly. Course Highlights Microsoft InfoPath for Beginners is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft InfoPath for Beginners into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 30 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft InfoPath for Beginners Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft InfoPath for Beginners is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Microsoft InfoPath for Beginners is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 00:30:00 Module Two - Opening and Closing InfoPath 01:00:00 Module Three - Using the InfoPath Filler 2010 01:00:00 Module Four - Designing a Form Framework 01:00:00 Module Five - Adding Labels 01:00:00 Module Six - Adding Controls 01:00:00 Module Seven - Formatting Controls 01:00:00 Module Eight - Working with Data Sources 01:00:00 Module Nine - Creating a View 01:00:00 Module Ten - Finishing the Form 01:00:00 Module Eleven - Distributing Your Form 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities - Microsoft InfoPath for Beginners 00:00:00 Mock Exam Final Exam

Designing your own customized form has never been easier using Microsoft Infopath. Using this useful software to its full potential however is something very few can do. But don't worry, this course will allow you to use microsoft infopath to its full extent. Use infopath to write your own expense report with offline support, increased accuracy and higher efficiency. Fill out your own insurance claim, permit application and other forms at your own convenience. Other benefits include inventory management and market research. Use this software to design, distribute, and to fill and submit electronic forms containing structured data. This course consists of units designed to teach you to use infopath at its highest capacity. This course can teach people want to learn how to design their own forms for professional purposes. At the end of the course you will be tested on your knowledge on infopath. All the important features will taught to you so that you can operate infopath smoothly. Course Highlights Certificate in Microsoft InfoPath 2007 is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certificate in Microsoft InfoPath 2007 into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certificate in Microsoft InfoPath 2007 Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certificate in Microsoft InfoPath 2007 is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certificate in Microsoft InfoPath 2007 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 00:30:00 Module Two - Opening and Closing InfoPath 01:00:00 Module Three - Filling Out a Form 01:00:00 Module Four - Designing a Form Framework 01:00:00 Module Five - Adding Labels 01:00:00 Module Six - Adding Controls 01:00:00 Module Seven - Formatting Controls 01:00:00 Module Eight - Working with Data Sources 01:00:00 Module Nine - Creating a View 01:00:00 Module Ten - Finishing the Form 01:00:00 Module Eleven - Distributing Your Form 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Certificate in Microsoft InfoPath 2007 00:00:00 Mock Exam Final Exam

Learning Objectives Introduction , Designing Tables for Better Data Entry , Sharing Data with Other Applications , Working with Action Queries , Advanced Query Techniques , Automating Processes with Macros , Advanced Form Techniques , Advanced Report Techniques , Conclusion   Pre-Requisites Access 365 Beginner or equivalent experience.   Description This course is designed to teach students intermediate level skills in Microsoft Access 365. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 365 Advanced course.   Module 1: Design Tables for Better Data Entry Reviewing Table Design Principles 00:11:00 Setting Field Size, Formats, and Captions 00:11:00 Setting Default Values and Required Fields 00:05:00 Restricting Data Entry-Validation Rules 00:07:00 Restricting Data Entry-Input Masks 00:09:00 Module 2: Share Data with Other Apps Exporting Tables and Queries to Excel 00:05:00 Exporting Data to a SharePoint List 00:02:00 Importing Data from Excel 00:06:00 Importing Data from a SharePoint List 00:02:00 Linking External Data Sources 00:05:00 Using Word Merge 00:06:00 Module 3: Work with Action Queries What are Action Queries 00:04:00 Creating an Update Query 00:06:00 Creating an Append Query 00:04:00 Creating a Delete Query 00:04:00 Creating a Make Table Query 00:04:00 Changing Start Number of an Auto Number Field 00:04:00 Module 4: Advanced Query Techniques Modifying Query Joins 00:06:00 Using Self Joins to Combine Data 00:06:00 Creating Find Unmatched and Find Duplicate Queries 00:09:00 Creating Parameter Queries 00:05:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:06:00 Summarizing Query Data with Totals 00:04:00 Creating Crosstab Queries 00:06:00 Module 5: Automate Processes with Macros Understanding Macro Basics 00:14:00 Creating Macros to Open Forms by Record 00:09:00 Validating Data Entry with Macros 00:10:00 Creating a Macro to Automate Data Entry 00:08:00 Advanced Data Entry Using Macros and DLOOKUP 00:11:00 Module 6: Advanced Form Techniques Using Conditional Formatting 00:04:00 Working with the New Label Name Property 00:03:00 Organizing Form Fields with Tab Controls 00:09:00 Creating an Option Group Control 00:06:00 Creating a Combo Box Control 00:04:00 Configuring a Combo Box Control to Show Search Results 00:04:00 Using a Subform to Show Data From a Related Table 00:06:00 Module 7: Advanced Report Techniques Inserting a Chart on a Report 00:07:00 Showing Data in Columns 00:07:00 Inserting a Subreport 00:05:00 Configuring Reports with Parameter Queries 00:03:00 Sending Reports 00:03:00 Resource Resource - Access 365 Intermediate 00:00:00 Final Exam Final Exam - Access 365 Intermediate 00:20:00

Craft workshop using a variety of pre-cut glass materials including rods, frit and frit balls to transform into your choice of a bowl, hanging or free standing wave form. Fused Glass Workshop – Flower Garden Designs I want to share my 15+ years of experience with you. This fused glass workshop is held at my Derbyshire studio and gallery space in the middle of Wirksworth near Matlock. About this fused glass workshop Whether you create a design inspired by wild flower gardens, fields of Poppies, a layer of Bluebells or hills covered in Heather you’ll enjoy playing with glass shapes and textures to create your own abstract and colourful creation. Choose from 3 options of pre cut glass bases and create either a bowl, sculptural wave or hanging panel. Round Bowl – approx. 17cm. Wave – approx. 32cm across x 7 tall. Round Hanging – approx. 18cm Get making by snapping glass rods, sprinkling crushed glass frit and place frit balls for your colourful flower blooms. The main thing to remember is to have fun! You will play with different types of decorative glass elements and learn a little about how the kiln firing will change them. Simply complete your design during the session and leave it at the studio for me to fire, finish and clean up for you. We will make arrangements to pick up a few weeks later or I can post your finished piece at cost. I will talk through all the Health & Safety in the session but I want you to know now, you will be handling precut glass pieces, they have pointy ends but with the right handling, they won’t hurt you. Recommended for ages 13+, all under 16s to be accompanied by a paying adult. Please don’t hesitate to contact me to discuss any queries you may have, big or small and make sure to find me on Instagram and facebook to keep up to date with all the sparkles and to see images of previous students works. Photos shown here (and on my facebook page) are previous students makes. Book with friends or come on your own for a supportive and fun creative fused glass workshop experience. All fused glass workshop attendees receive a 10% discount on purchases from the gallery shop on the day, just a little way I can say thank you for joining me! Things to bring with you: A bottle of water or travel cup of coffee/tea An apron or old clothes so you don’t have to worry about getting glue or other materials on them Pictures or images that inspire you An open mind and willingness to experiment Booking When booking make sure your email address is correct at checkout as I will email you any further information needed for the workshop. Please also include a contact phone number in the unlikely event that I need to cancel a workshop at short notice. Venue: Create Space Studio & Gallery, 27 Market Place, Wirksworth, Matlock DE4 4ET Currently, the washroom facilities in the studio shop aren’t the best, they probably won’t ever be perfect but I do have a working w.c and sink now, just behind a curtain. I would still recommend considering supporting one of the independent cafés, restaurants and pubs who would welcome some extra business in return for a comfort break. Workshop T&Cs: Please read through the Terms & Conditions for Glass Fusing Workshops and Courses that are booked here online. When you book a place you are agreeing to the following terms and conditions. Bookings and cancellations Bookings – If you can not attend a workshop, for what ever reason, please contact Stevie as soon as possible. Firstly we will work together to transfer your place onto another day, suitable for your needs. Another option is for you to offer your place out to a friend or family member. If this is not possible and your cancellation has been more less than 21 days in advance of the event, a refund can be offered. If your cancellation has been made less than 21 days before the event and you can not transfer onto a future date, every effort will be made to fill your place, from further advertising and/or the reserves list. If your space can not be filled by another attendee and you are unable to arrange a replacement yourself unfortunately, no refund can be offered. In the unlikely event that Stevie has to cancel a class, you will be offered either a full refund or a transfer to another date. As much notice as possible will be given, however, Stevie cannot be held responsible for your travel or accommodation costs. Accessibility Accessibility – Workshops at Create Space, Wirksworth: Entrance to the Studio Gallery has 2 stone steps. The workshop table is fixed and also up one step, the main table is high, you will be stood or sat on a tall chair.  Please contact Stevie for information about the suitability of her courses for ages and abilities before booking. Health & Safety Stevie reserves the right to exclude any student we feel may be a danger to themselves or other students.

Learning Objectives Introduction , Designing Tables for Better Data Entry , Sharing Data with Other Applications , Working with Action Queries , Advanced Query Techniques , Automating Processes with Macros , Advanced Form Techniques , Advanced Report Techniques , Conclusion   Pre-Requisites Access 2019 Beginner or equivalent experience.   Description This course is designed to teach students intermediate level skills in Microsoft Access 2019. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 2019 Advanced course. 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

This Access 2016 Intermediate is specially designed for you if you are thinking to take your Microsoft Access skills to the next level. Through the course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.  From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. You will learn to design tables for improved accuracy in data entry by setting default values and restricting data entry, review the various options to share data with other applications, including Word and Excel, learn about Action Queries to automate updating, appending and deleting table data, and review various advanced query techniques such as using Query Joins, Parameter queries, working with totals and Crosstab queries. Finally, you'll build a navigation form to make it easy for your users to find their way around your database.  What Will I Learn? Design Tables for Better Data Entry Share Data with Other Applications Work with Action Queries Advanced Query Techniques Automate Processes with Macros Advanced Forms Advanced Report Techniques Requirements Access 2016 Introduction or equivalent experience. Who is the target audience? Students who want to take Access to the next level and improve their database design skills. Introduction Introduction FREE 00:01:00 Designing Tables for Better Data Entry Reviewing Table Design Principles 00:04:00 Setting Field Size, Formats and Captions 00:06:00 Setting Default Value and Required Fields 00:03:00 Restricting Data Entry Using Data Validation 00:02:00 Restricting Data Entry Using Input Masks 00:06:00 Sharing Data with Other Applications Exporting Tables and Queries to Excel 00:03:00 Importing Data from a TXT File 00:03:00 Importing Data from Excel 00:02:00 Exporting Data to a TXT File 00:02:00 Linking External Data Sources 00:03:00 Using Word Merge 00:02:00 Working with Action Queries What are Action Queries 00:02:00 Creating an Update Query 00:02:00 Creating an Append Query 00:03:00 Creating a Delete Query 00:02:00 Creating a Make Table Query 00:02:00 Changing the Start Number of an Auto Number Field 00:03:00 Advanced Query Techniques Creating Query Joins 00:05:00 Creating Find Unmatached and Find Duplicate Queries 00:03:00 Creating Parameter Queries 00:04:00 Using -Like- Keyword in Parameter Queries 00:02:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:03:00 Summarizing Query Data with Totals 00:03:00 Inserting Where Statements in Summary Queries 00:01:00 Creating a Crosstab Query 00:03:00 Automating Processes with Macros Understanding Macro Basics 00:06:00 Creating Macros to Open Forms by Record 00:04:00 Validating Data Entry with Macros 00:04:00 Creating a Macro to Automate Data Entry 00:03:00 Advanced Data Entry Using Macros and DLOOKUP Function 00:06:00 Advanced Form Using Conditional Formatting 00:02:00 Organizing Form Fields with Tab Controls 00:03:00 Creating a Combo Box Control 00:02:00 Creating an Option Group Control 00:03:00 Using a Subform to Show Data from a Related Table 00:03:00 Advanced Report Techniques Inserting a Chart on a Report 00:03:00 Showing Data in Columns 00:02:00 Inserting a Subreport 00:02:00 Configuring Reports with Parameter Queries 00:04:00 Sending Reports 00:02:00 Conclusion Course Recap 00:01:00 Resources Resources - Access 2016 Intermediate 00:00:00 Course Certification