2354 Microsoft courses in Ince-in-Makerfield delivered On Demand

Power BI - Business Data Analysis and Visualization Training Course Overview Are you looking to begin your Microsoft Power BI career or want to develop more advanced skills in Microsoft Power BI? Then this power BI - business data analysis and visualisation training course will set you up with a solid foundation to become a confident Power BI user and help you to develop your expertise in Microsoft Power BI. This power BI - business data analysis and visualisation training course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this power BI - business data analysis and visualisation training course will set you up with a solid foundation to become a confident Power BI user and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a Power BI user. The power BI - business data analysis and visualisation training course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a Power BI user. This comprehensive power BI - business data analysis and visualisation training course is the perfect way to kickstart your career in the field of Microsoft Power BI. This power BI - analyze and interactively visualize business data course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as a Power BI user or want to learn more skills on Microsoft Power BI but unsure of where to start, then this power BI - business data analysis and visualisation training course will set you up with a solid foundation to become a confident Power BI user and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This power BI - business data analysis and visualisation training course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who should take this course? This comprehensive power BI - business data analysis and visualisation training course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Power BI. Entry Requirement There are no academic entry requirements for this power BI - business data analysis and visualisation training course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Method of Assessment On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately. Career path This power BI - business data analysis and visualisation training course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Course Curriculum Introduction - What is Power BI. Introduction - What is Power BI. Getting Started with Power BI Pro Getting Started with Power BI Pro Working With Various Data Sources in Power BI Using Data from Excel Tables in Power BI Using Data from Normalized Excel Spreadsheets in Power BI Update Data in Power BI Import Data from Websites into Power BI Import Data from a PDF File into Power BI Import Data from a CSV File into Power BI Import Data from Access Databases into Power BI Elaborate a Power BI Report to Enable Decision Making Elaborate a Power BI Report to Enable Decision Making Improve a Power BI Report to Increase Informative Value Optimize Power BI Reports to Improve Readability Edit Field Properties in Power BI to Improve Readability Format Axes to Make Data Comparable Visualize Benchmarks with Reference Lines Add Annotations Using Text Boxes Create YoY Comparisons Conveniently Visualize Data on Maps to Valorize Reports Enrich Visualisations with Radial Gauges - Speedometer and Thermometer Enrich Visualisations with Conditional Formatting Perform Advanced Data Analysis by Using Filters and Slicers If Default Visualizations are not Enough: Add Custom Visuals Customize the Design of a Report Save Key Findings in Easy-to-Access Bookmarks Optimize Reports for Mobile Devices Access from Anywhere with Power BI Working With Data - Advanced Techniques Improve Datasets by Extracting Data from Fields and Adding Fields Create Calculated Columns if the Data Source is Insufficient Take Advantage of Predefined Calculations Using Quick Measures Create Virtual Columns Using Measures Power BI Service - The Online Version of Power BI Power BI Service - First Steps Share Power BI Reports for Collaboration Provide Power BI Reports in Microsoft Teams Publish Power BI Reports Manage Roles and Assign Users From Complex Reports to Clear Dashboards Set Up Alerts for Target Values Commenting on Reports and Dashboards Use Data Gateways to Access Local Data Safely Optimizing Power BI with Advanced Settings Appendix: The Various Power BI Components and How to Install Power BI Installing Power BI Pro Activate the Power BI Service Final Remarks Final Remarks Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Overview This Management Level 5 course meticulously delves into understanding the complexities and nuances of modern leadership, catering to those keen on mastering the art of effective management. This course has been curated meticulously to offer insights into various facets of management and leadership. From understanding the fundamental theories that govern administration to honing skills like negotiation and communication, the curriculum is a comprehensive voyage through the disciplines that develop a proficient manager. One would also find a detailed exploration of contemporary issues like corporate responsibility and the nuances of navigating office politics, promising a well-rounded educational experience.In addition to managerial theories and practices, the Management Level 5 course is robustly equipped to impart essential technological skills. With extensive modules on Microsoft Word, Excel, and PowerPoint, learners are primed to excel in the modern digital workspace, harnessing the power of these tools to augment their managerial prowess. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Management Level 5. It is available to all students, of all academic backgrounds. Requirements Our Management Level 5 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 22 sections • 23 lectures • 04:37:00 total length •Understanding Management and Leadership: 00:40:00 •Leadership Theories: 00:25:00 •Improving Management and Leadership Performance: 00:15:00 •High Performance Teams: 00:32:00 •Motivating Employees: 00:26:00 •Organisational Skills: 00:26:00 •Talent Management: 00:37:00 •Succession Planning: 00:24:00 •Business Process Management: 00:28:00 •Communication Skills: 00:27:00 •Negotiation Techniques: 00:15:00 •Managing Meetings and Giving Feedback: 00:21:00 •Managing Change: 00:22:00 •Time Management: 00:06:00 •Stress Management: 00:15:00 •Emotional Intelligence in Leadership: 00:32:00 •Managing Conflict: 00:14:00 •Dealing with Office Politics: 00:34:00 •Risk Management: 00:35:00 •Corporate Responsibility and Ethics: 00:14:00 •Microsoft Word: 08:06:00 •Microsoft Excel: 03:59:00 •Microsoft PowerPoint: 08:24:00

Course Overview Use Microsoft's benchmark business application to its full potential by taking this Advanced Excel Analytics by Real World Projects course. Using expert guidance, the contents will familiarise you with the broad range of functionalities on Excel, empowering you to deliver enhanced information analysis and accurate conclusions more effectively across an organisation. This progressive Excel learning experience will teach you how to download and manipulate complex data patterns and any collection of figures or statistics. You will become intuitively aware of how to arrange this for visual and investigative purposes. The coaching delivers a masterclass for core competencies that will take you from being a regular analyst to a sought-after Excel expert in all forms of data presentations. Make your mark in Microsoft skills and take your office abilities to the next level. This best selling Advanced Excel Analytics by Real World Projects has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Advanced Excel Analytics by Real World Projects is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Advanced Excel Analytics by Real World Projects 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 Advanced Excel Analytics by Real World Projects 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 Advanced Excel Analytics by Real World Projects, 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 Advanced Excel Analytics by Real World Projects 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 Advanced Excel Analytics by Real World Projects 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.

Do you want to prepare for your dream job but strive hard to find the right Data Scientist and Cybersecurity Engineer courses? Then, stop worrying, for our strategically modified Data Scientist and Cybersecurity Engineer bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 33 course mega Data Scientist and Cybersecurity Engineer bundle that will exceed your expectations within your budget. The Data Scientist and Cybersecurity Engineer related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Data Scientist and Cybersecurity Engineer bundle will help you build a solid foundation to become a proficient worker in the sector. This Data Scientist and Cybersecurity Engineer Bundle consists of the following 30 CPD Accredited Premium courses - Course 01:Basic Data Analysis Course 02:Excel Data Analysis Course 03:2021 Python Programming From A-Z: Beginner To Expert Course 04:Python Data Science with Numpy, Pandas and Matplotlib Course 05:2021 Data Science & Machine Learning with R from A-Z Course 06:Mastering SQL Programming Course 07:Research Methods in Business Course 08:Cyber Security Incident Handling and Incident Response Course 09:Microsoft Azure 2017 Course 10:AZ-104: Microsoft Azure Administrator Course 11:Microsoft Azure Cloud Concepts Course 12:Advanced Excel Analytics Course 13:Statistics & Probability for Data Science & Machine Learning Course 14:Quick Data Science Approach from Scratch Course 15:R Programming for Data Science Course 16:Learn Python, JavaScript, and Microsoft SQL for Data science Course 17:Google Data Studio: Data Analytics Course 18:Introduction to Excel Data Tools and Data Management Course 19:Microsoft Access Tables and Queries Course 20:Microsoft Access Databases Forms and Reports Course 21:Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 22:VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes! Course 23:Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 24:GDPR Course 25:Data Center Training Essentials: General Introduction Course 26:Web Scraping and Mapping Dam Levels in Python and Leaflet Course 27:Microsoft Power BI - Master Power BI in 90 Minutes! Course 28:PowerBI Formulas Course 29:Business Intelligence and Data Mining Course 30:Financial Ratio Analysis for Business Decisions 3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Learning Outcomes of Data Scientist and Cybersecurity Engineer This tailor-made Data Scientist and Cybersecurity Engineer bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Data Scientist and Cybersecurity Engineer Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete Data Scientist and Cybersecurity Engineer training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Data Scientist and Cybersecurity Engineer bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this Data Scientist and Cybersecurity Engineer course, all you need is - A smart device A secure internet connection And a keen interest in Data Analysis and Cyber Security Career path Upon completing this essential Data Scientist and Cybersecurity Engineer Bundle, you will discover a new world of endless possibilities. These Data Scientist and Cybersecurity Engineer courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

In this course, we look at a number of advanced Excel techniques all aimed at helping you make sense of the numbers in your business. Each section in the course contains an exercise for practice and quiz. The course is created using Excel 2019/365 for Windows.

Course Overview Master the new functions and features of Microsoft Excel 2021 and learn how to use these new functions in your data reports, with this complete step-by-step video training course.  The New Functions in Excel 2021 course has been expertly designed to guide you through Excel 2021's new functions in the simplest way. Broken down into 10 key modules, you will learn how the UNIQUE, RANDARRAY and SEQUENCE functions work, how to filter data in a range or table, and much more. This practical training course will also walk you through how to use these new functions in data reports. This course is ideal for those who are already familiar with Excel and have experience using this software, who wish to familiarise with the latest functions of the 2021 version. Enrol today and add valuable spreadsheet management skills to your CV. This best selling New Functions in Excel 2021 has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth New Functions in Excel 2021 is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The New Functions in Excel 2021 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 New Functions in Excel 2021 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 New Functions in Excel 2021, 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 New Functions in Excel 2021 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 New Functions in Excel 2021 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.

A course by Xpert Learning RequirementsA computer or mobile device with an internet connectionA basic understanding of Microsoft Office applicationsA willingness to learn and grow Audience Business Professionals Administrative assistants Project managers Team leaders Office managers Business owners Anyone who wants to advance their career in the workplace Audience Business Professionals Administrative assistants Project managers Team leaders Office managers Business owners Anyone who wants to advance their career in the workplace

New Excel Functions   Course Description   Ross Maynard     Description In the second half of 2020 Microsoft released a significant upgrade to the most used spreadsheet programme in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this course, we discuss the power of dynamic arrays and introduce the new functions. The functions I am going to cover are: RANDARRAY- creating a table of random numbers or random dates UNIQUE – identifying the distinct items in a list SEQUENCE – listing numbers with a set interval SORT and SORTBY – new ways of dynamically sorting data FILTER – building the ability to filter data into formulae XLOOKUP – replacing VLOOKUP with greater flexibility IFS and SWITCH making it easier to construct IF statements The new CONCAT, and TEXTJOIN text functions   If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this course extremely useful.         Learning Outcomes Participants in this course will learn: What the new dynamic arrays feature in Microsoft Excel means How the new RANDARRAY function works How the new UNIQUE function works How the new SEQUENCE function works How the new SORT and SORTBY functions work How the new FILTER function works How the new XLOOKUP function can replace VLOOKUP How to build IF statements with the new IFS function How the new SWITCH function works How the new TEXTJOIN function can replace CONCATENATE and CONCAT How the new functions can be used in management reporting     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.       About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Office 365 Administration Basics bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The Office 365 Administration Basics related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Office 365 Administration Basics bundle will help you build a solid foundation to become a proficient worker in the sector. This Office 365 Administration Basics Bundle consists of the following 25 CPD Accredited Premium courses - Course 01 :Office Skills Training Course 02 :Admin, Secretarial & PA Course 03 :Corporate Paralegal Course 04 :Performance Management Course 05 :Team Management Course 06 :Microsoft Word, PowerPoint & Outlook Course 07 :Health and Safety in the Workplace Level 2 Course 08 :Business Etiquette and Professionalism Training Course 09 :Workplace First Aid Training Course 10 :Information Management Course 11 :Facilities Management and Workplace Services Course 12 :UK Employment Law Course 13 :Communication and Organisational Skills Course 14 :Meeting Management Online Course 15 :Minute Taking Certificate Course 16 :Document Control Course 17 :Touch Typing Course 18 :Email Writing Course 19 :Public Speaking Course 20 :Leadership Skills Course 21 :Corporate Risk And Crisis Management Course 22 :Cross-Cultural Awareness Training Course 23 :Equality, Diversity and Discrimination Course 24 :Level 3 Coaching & Mentoring Course Course 25 :Presentation Skills 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Learning Outcome This tailor-made Office 365 Administration Basics bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Office 365 Administration Basics Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course for free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Office 365 Administration Basics bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Office 365 Administration Basics Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

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