305 Microsoft AZ-900 courses

Learning Objectives Introduction , Getting Started with Access , Working with Data , Creating Databases and Objects , Working with Queries , Working with Reports , Working with Forms , Conclusion   Pre-Requisites Basic computer skills. Knowledge of basic database concepts is helpful but not required.   Description This course is an introduction to Microsoft Access 2019. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2019 Intermediate course. Access 2019 Beginner Module 1: Introduction to the course 00:01:00 Module 2: What is Database 00:03:00 Module 3: Understanding Database terminology 00:04:00 Module 4: Navigating the Access Interface 00:09:00 Module 5: What is Flat file Database 00:03:00 Module 6: What is Relational Database 00:10:00 Module 7: Relating Tables 00:08:00 Module 8: Reviewing the Access Ribbon 00:02:00 Module 9: Working with Tables 00:07:00 Module 10: Navigating Tables 00:03:00 Module 11: Editing Data 00:03:00 Module 12: Adding New Records 00:03:00 Module 13: Using Subdatasheets 00:04:00 Module 14: Understanding Database and Table Design Principles 00:09:00 Module 15: Using Table Data Sheet View 00:04:00 Module 16: Working with Field Data Types 00:07:00 Module 17: Using Table Design View 00:04:00 Module 18: Using Calculated Fields 00:08:00 Module 19: Calculating Dates 00:04:00 Module 20: Calculating Strings 00:04:00 Module 21: Using the Lookup Wizard 00:11:00 Module 22: Lookup Wizard Linking Tables 00:06:00 Module 23: Using Indexes 00:05:00 Module 24: What are Queries 00:06:00 Module 25: Creating Simple Queries 00:05:00 Module 27: Entering Criteria-Exact Match and Ranger Operators 00:06:00 Module 28: Understanding And VS Or 00:06:00 Module 29: Using Wild Cards 00:04:00 Module 30: Using Key Words 00:04:00 Module 31: Sorting and Hiding Fields 00:03:00 Module 32: Creating Multi-Table Queries 00:03:00 Module 33: Creating a Calculated Field in Query 00:05:00 Module 34: Additional Tips 00:05:00 Module 35: What are Reports 00:04:00 Module 36: Understanding Report Types 00:03:00 Module 37: Building Good Reports 00:02:00 Module 38: Using Autoreport 00:06:00 Module 39: The Report Wizard 00:12:00 Module 40: Using the Report Design View 00:07:00 Module 41: Printing Reports 00:04:00 Module 42: Creating Labels 00:05:00 Module 43: Additional Tips 00:09:00 Module 44: What are Forms 00:03:00 Module 45: Understanding Form Types 00:03:00 Module 46: Creating Forms 00:02:00 Module 47: Navigating Forms 00:02:00 Module 48: Editing Data in Forms 00:05:00 Module 49: Understanding the Form Wizard 00:05:00 Module 50: Using the Form Design View 00:04:00 Module 51: Working with Controls 00:07:00 Module 52: Using the Form Layout View 00:03:00 Module 53: Additional Tips 00:07:00 Downloadable Resources Resources - Access 2019 Beginner 00:00:00 Final Exam Final Exam - Access 2019 Beginner 00:20:00

Microsoft Outlook is available as a part of the Microsoft Office suite. Microsoft Outlook 2010 is a reliable application for emails. Outlook can assist you to manage every aspect of your life. Learn from scratch the basic information about Microsoft Outlook 2010. You will learn how to work with Microsoft Outlook 2010. You will be taught how to work with emails, creating emails and managing the email. You will also go through the Outlook's organization tools. In this course you will learn the necessary skills, knowledge and information of Microsoft Outlook.  Course Highlights Certified Microsoft Outlook 2010 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 Certified Microsoft Outlook 2010 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 Certified Microsoft Outlook 2010 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? Certified Microsoft Outlook 2010 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 Certified Microsoft Outlook 2010 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 Outlook 01:00:00 Module Three - Working with E-mail 01:00:00 Module Four - Creating a New E-mail 01:00:00 Module Five - Managing E-mail 01:00:00 Module Six - Managing Junk Mail 01:00:00 Module Seven - Outlook's Organization Tools 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contacts 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities Activities-Certified Microsoft Outlook 2010 for Beginners 00:00:00 Mock Exam Final Exam

The Windows Microsoft Word for Beginners Accredited Course is created so that you can create, and edit your documents. Other than creating documents, you can also do various tasks with this program. In this course, you will learn the necessary skills, knowledge and information about Word. You will learn how to create professional quality documents and learn the features this program has. Through this course, you will also learn how to use styles to ensure consistent formatting in all of your documents. Course Highlights Microsoft Word for Beginners Accredited Course 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 Word for Beginners Accredited Course 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, 40 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 Word for Beginners Accredited Course 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 Word for Beginners Accredited Course 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 Word for Beginners Accredited Course 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. Microsoft Word for Beginners Module One - Getting Started FREE 00:30:00 Module Two - Opening Word FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities- Microsoft Word for Beginners Accredited Course 00:00:00 Mock Exam Mock Exam- Microsoft Word for Beginners Accredited Course 00:20:00 Final Exam Final Exam- Microsoft Word for Beginners Accredited Course 00:20:00

Description:  This Microsoft Office 2010 Excel Beginners - Complete Video Course will teach you the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel's window components, you will learn how to use the Help system and navigate worksheets and workbooks. Then you will enter and edit text, values, formulas, and pictures, and you will save workbooks in various formats. You will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course is designed to introduce you to using Microsoft Excel if you're unfamiliar with any major aspect of it. The series will lead you through the fundamentals of creating and working with Excel spreadsheets. Today's Excel spreadsheet isn't just for financial professionals. Microsoft Excel offers intuitive tools that make it easy to access, connect, and analyze critical data-regardless of your profession. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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. Who is this Course for? Microsoft Office 2010 Excel Beginners - Complete Video Course is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Microsoft Office 2010 Excel Beginners - Complete Video Course 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 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. Getting Started Spreadsheet Terminology FREE 00:02:00 The Excel Environment 00:05:00 Getting Help 00:03:00 Navigating a Worksheet 00:06:00 Entering and Editing Data Entering and Editing Text and Values 00:09:00 Entering and Editing Formulas 00:09:00 Working with Pictures 00:03:00 Saving and Updating Workbooks 00:07:00 Modifying a Worksheet Moving and Copying Data 00:13:00 Moving and Copying Formulas 00:07:00 Absolute and Relative References 00:06:00 Inserting and Deleting Ranges, Rows, and Columns 00:07:00 Functions Entering Functions 00:15:00 AutoSum 00:04:00 Other Common Functions 00:11:00 Formatting Text Formatting 00:06:00 Column Formatting 00:12:00 Number Formatting 00:06:00 Conditional Formatting 00:10:00 Additional Formatting Options 00:12:00 Printing Preparing to Print 00:09:00 Page Setup Options 00:14:00 Printing Worksheets 00:04:00 Charts Chart Basics 00:11:00 Formatting Charts 00:05:00 Managing Large Workbooks Viewing Large Worksheets 00:14:00 Working with Multiple Worksheets 00:12:00 Printing Large Worksheets 00:08:00 Graphics and Screenshots Conditional Formatting with Graphics 00:09:00 SmartArt Graphics 00:05:00 Screenshots 00:05:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Beginners - Complete Video Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Project 2010 is the latest version of Project, a companion project management application for Microsoft Office. This Microsoft Project 2010 Beginners - Complete Video Course teaches the basic commands and features of Microsoft Project 2010. Here, you will learn how to create and modify task lists, establish a project schedule, create calendars, assign resources to tasks, track costs, and work with different views and tables. You will also learn how to apply filters and groups, and sort task and resource data. This version includes a wide range of changes, including the new ribbon interface. Microsoft Project integrates with all the other Office application you regularly use. You will finish up the course with learning how to resolve resource conflicts. If you want to know more detail about Microsoft Project you have to be a part of this course. You will get all the basic knowledge from here, which will help you to pull up ahead. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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. Who is this Course for? Microsoft Project 2010 Beginners - Complete Video Course is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Microsoft Project 2010 Beginners - Complete Video Course 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 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. Getting Started Project Management Concepts FREE 00:12:00 The Project Window 00:15:00 Project Files 00:10:00 The Help Window 00:02:00 Tasks Creating a Task List 00:10:00 Modifying a Task List 00:07:00 The Work Breakdown Structure 00:13:00 Tasks Scheduling Task Links 00:16:00 Task Relationships 00:09:00 Task Options 00:05:00 Resource Management The Base Calendar 00:07:00 Resources and Calendars 00:14:00 Project Costs 00:08:00 Views and Tables Working with Views 00:12:00 Working with Tables 00:04:00 Filters, Groups, and Sorting Filters 00:10:00 Groups 00:05:00 Sorting Tasks and Resources 00:05:00 Finalizing the Task Plan Finalizing Schedules 00:09:00 Handling Resource Conflicts 00:11:00 Mock Exam Mock Exam- Microsoft Project 2010 Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Project 2010 Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This course follows up from the Beginners Excel 2010 course by delving even deeper into features and functions of this powerful spreadsheet software. This Microsoft Office 2010 Excel Advanced - Complete Video Course builds on the skills and concepts taught in Excel 2010: intermediate. In this series you will learn to work with advanced formulas, as well lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation and database functions such as DSUM. You will learn how to work with Pivot Tables and PivotCharts, how to import and export data, and how to query external databases. Finally, you will learn about the analytical features of Excel, running and recording macros, SmartArt graphics and conditional formatting with graphics, and more. Before you taking this course you should have a firm grasp of the basics. This course will pull up your basic knowledge. So join this course to be an expert. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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. Who is this Course for? Microsoft Office 2010 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Microsoft Office 2010 Excel Advanced - Complete Video Course 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 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. Logical and Statistical Functions Logical Functions FREE 00:17:00 Math and Statistical Functions 00:19:00 Financial and Date Functions Financial Functions 00:04:00 Date and Time Functions 00:10:00 Array Formulas 00:09:00 Displaying and Printing Formulas 00:08:00 Lookups and Data Tables Using Lookup Functions 00:14:00 Using MATCH and INDEX 00:06:00 Array Formulas 00:07:00 Advanced Data Management Validating Cell Entries 00:08:00 Exploring Database Functions 00:06:00 Exporting and Importing Exporting and Importing Text Files 00:11:00 Exporting and Importing XML Data 00:03:00 Querying External Databases 2 hours agoMore 00:09:00 Analytical Tools Goal Seek and Solver 00:15:00 The Analysis ToolPak 00:05:00 Scenarios 1 hour agoMore 00:06:00 Macros and Custom Functions Running and Recording a Macro 00:19:00 Working with VBA Code 00:07:00 Creating Functions 00:05:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2010 Access Advanced - Complete Video Course builds on the skills and concepts taught in Access 2010: Intermediate. You will learn about querying with SQL, Advanced Queries, Macros, Advanced Macros, Importing, Exporting, And Linking, Database Management, Access, OneNote, PowerPoint, Windows, Excel, Outlook, Publisher, Word, and much more. The earliest lessons focus on advanced table design with indexing and input masks. The course shows how to create advanced queries using joins, unions, and sub queries, going step by step where things get complex. Lessons on advanced form design and reporting will allow you to better manage and display your data. This course will empower you with the knowledge and skills necessary to be a proficient user. If you already have a good grounding in Microsoft Word, this course will provide you with the knowledge and skills to use Microsoft Access 2010 at an expert level. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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. Who is this Course for? Microsoft Office 2010 Access Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Microsoft Office 2010 Access Advanced - Complete Video Course 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 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. Querying with SQL SQL and Access FREE 00:06:00 Writing SQL Statements 00:18:00 Attaching SQL Queries to Controls 00:06:00 Advanced Queries Creating Crosstab Queries 00:05:00 Creating Parameter Queries 00:11:00 Using Action Queries 00:17:00 Macros Creating, Running, and Modifying Macros 00:08:00 Attaching Macros to the Events of Database Objects 00:05:00 Advanced Macros Creating Macros to Provide User Interaction 00:20:00 Creating Macros that Require User Input 00:04:00 Creating AutoKeys and AutoExec Macros 00:07:00 Creating Macros for Data Transfer 00:07:00 Importing, Exporting, and Linking Importing Objects 00:14:00 Exporting Objects 00:06:00 Working with XML Documents 00:13:00 Linking Access Objects 00:13:00 Using Hyperlink Fields 00:06:00 Database Management Optimizing Resources 00:16:00 Protecting Databases 00:05:00 Setting Options and Properties 00:06:00 Mock Exam Mock Exam- Microsoft Office 2010 Access Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Access Advanced - Complete Video Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Outlook is the most valuable communication tools. It helps you to communicate faster. In this Microsoft Office 2007 Outlook Advanced - Complete Video Course you will build on the email and calendaring skills you have already obtained and will provide you with the skills needed to personalize email, organize Outlook items, manage Outlook data files, share and link contacts, save and archive email, create forms, and work offline and remotely, and much more. Before getting this course you must have the basic and intermediate skills of Microsoft Outlook 2007. This level will give you an advanced knowledge you need to know about Microsoft Outlook 2007. It will provide you with sufficient 2007 Outlook Advanced skills to create sophisticated analytical spreadsheet and master interface advanced formulae. So, take this advanced course to get a complete understanding of the higher functions of Outlook. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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. Who is this Course for? Microsoft Office 2007 Outlook Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Microsoft Office 2007 Outlook Advanced - Complete Video Course 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 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. Mailbox Managing Data Files FREE 00:08:00 Managing Your Mailbox 00:15:00 Notes and Journal Folders The Notes Folder 00:12:00 The Journal Folder 00:21:00 Calendar and Contacts The Calendar 00:09:00 Group Schedules 00:07:00 The Contacts Folder 00:18:00 Collaboration Features Sharing your Folders 00:25:00 Sharing Calendars 00:23:00 SharePoint Integration 00:02:00 RSS Feeds 00:08:00 Templates and Forms Working with Templates 00:08:00 Working with Forms 00:17:00 Mock Exam Mock Exam- Microsoft Office 2007 Outlook Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Outlook Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2007 Access Advanced - Complete Video Course builds on knowledge gained in the introduction and intermediate levels. This advanced series will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database. You will also learn to automate functions by creating simple and then very advanced macros, advance your querying ability and then to use SQL statements in your queries. You will discover how to work with objects and the fundamentals of database management. Finally, you will be taught how to protect your valuable data sources. Before getting this course you must have the basic and intermediate skills of Microsoft Office 2007. This level will give you an advanced knowledge you need to know about Microsoft Office 2007. By taking this course you will have a complete understanding of the higher functions of Access. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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. Who is this Course for? Microsoft Office 2007 Access Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Microsoft Office 2007 Access Advanced - Complete Video Course 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 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. Querying with SQL SQL and Access FREE 00:02:00 Examining an SQL Statement in Access 00:02:00 Writing SQL Statements 00:03:00 Writing an SQL SELECT Statement 00:04:00 Using the WHERE Clause 00:02:00 Creating Aliases 00:04:00 Displaying Matching Records from Related Tabs 00:03:00 Finding Unmatched Records 00:03:00 Getting Context-Sensitive Help in SQL 00:01:00 Attaching SQL Queries to Controls 00:02:00 Assigning a SQL-Specific Query to Controls 00:04:00 Advanced Queries Creating Crosstab Queries 00:01:00 Viewing a Crosstab Query 00:02:00 Using the Crosstab Query Wizard 00:02:00 Creating Parameter Queries 00:01:00 Creating a Query with Multiple Parameters 00:03:00 Creating a Single Criterion Parameter Query 00:03:00 Using a Wildcard in a Parameter Query 00:02:00 Using Action Queries 00:02:00 Adding Records to a Table with an Append Query 00:03:00 Deleting Records with a Delete Query 00:04:00 Modifying Records with an Update Query 00:04:00 Creating a Make Table Query 00:01:00 Macros Running, and Modifying Macros 00:02:00 Creating and Running a Macro 00:02:00 Modifying a Macro 00:02:00 Attaching Macros to the Events of Database Objects 00:01:00 Attaching a Macro to the Open Event Form 00:02:00 Attaching a Macro to a Command 00:00:00 Advanced Macros Creating Macros to Provide User Interaction 00:02:00 Creating a Data Validation Macro 00:05:00 Creating a Data-Entry Macro 00:06:00 Creating Macros that Require User Input 00:03:00 Creating a Macro that Runs a Para 00:02:00 Creating the AutoKeys and AutoExec Macros 00:01:00 Creating an AutoKeys Macro 00:02:00 Creating an AutoExec Macro 00:01:00 Creating Macros for Data Transfer 00:01:00 Importing a Database Object 00:02:00 Importing, Exporting, and Linking Importing Objects 00:04:00 Importing Multiple Objects 2 days ago 00:02:00 Importing an Object from Excel 00:04:00 Using a Saved Import Specification 00:02:00 Importing a CSV File 00:03:00 Exporting Objects 00:01:00 Exporting an Object 00:03:00 Using a Saved Export Specification 00:01:00 Interacting with the XML Documents 00:02:00 Exporting and Import 00:04:00 Exporting to an XML 00:04:00 Linking Access Objects 00:02:00 Linking to an Access Table 00:03:00 Updating the Links 00:02:00 Linking to an Excel Workbook 00:02:00 Working with Windows SharePoint Services 00:02:00 Database Management Optimizing Resources 00:04:00 Converting a Database to a Prior Version 00:01:00 Analyzing Performance 00:03:00 Splitting a Database 00:04:00 Using the Compact and Repair Database Utility 00:01:00 Backing Up a Database 00:01:00 Protecting Databases 00:01:00 Encrypting a Database with a Password 00:01:00 Removing a Password and Encryption 00:01:00 Setting Options and Properties 00:02:00 Internet Integration Topic A Hyperlink Fields 00:02:00 Creating a Hyperlink Field 00:02:00 Inserting Data in a Hyperlink Field 00:01:00 Modifying Data in a Hyperlink Field 00:01:00 Working with Outlook 2007 00:01:00 Mock Mock Exam- Microsoft Office 2007 Access Advanced - Complete Video Course 00:20:00 Final Final Exam- Microsoft Office 2007 Access Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Created by Microsoft, InfoPath Designer 2010 is one of their applications. It was created for designing, distributing, filling and submitting electronic forms containing structured data. In this course, you will learn the necessary skills, knowledge, and information about InfoPath Designer 2010 and learn how to customize the InfoPath environment to make it work for you. Find out how to utilize the features of this program such as digital signatures, all control features, using commands and switches, formulas and functions, and rules, queries, and data submission. Who is the course for? Professionals who want to learn more about the Microsoft InfoPath Designer 2010 People who want to become an expert in using Microsoft InfoPath Designer 2010 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. 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 recognized 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: The Microsoft InfoPath Intermediate Level is a useful qualification to possess and would be beneficial for any type of professions or career such as: Administrative Officer Project Management Officer Project Assistant Project Support Secretary. Microsoft InfoPath Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with the InfoPath Environment 01:00:00 Module Three - Working with Digital Signatures 01:00:00 Module Four - Doing More with Controls 01:00:00 Module Five - Working with Control Properties, Part 1 01:00:00 Module Six - Working with Control Properties, Part 2 01:00:00 Module Seven - Using Commands and Switches 01:00:00 Module Eight - Using Formulas and Functions 01:00:00 Module Nine - Using Action Rules 01:00:00 Module Ten - Using More Action Rules 01:00:00 Module Eleven - Using Queries and Data Submission 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft InfoPath Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft InfoPath Intermediate Level 00:20:00 Final Exam Final Exam- Microsoft InfoPath Intermediate Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00