4402 Courses in Cardiff delivered On Demand

>> Deal Price is Active Now; Offer Ends Soon, Hurry Up!! << Are you looking to improve your current abilities or make a career move? Our unique Office Administration & Skills Course might help you get there! Expand your expertise with high-quality training - study the course and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the course. This Advanced Diploma in Office Administration & Skills at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 180 CPD points) to make your skill development & career progression more accessible than ever! Why Prefer This Office Administration & Skills Course? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS after completing the Office Administration & Skills course Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. The course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enroling on this course. With this comprehensive course, you can achieve your dreams and train for your ideal career. The course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enroling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enroling on the course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the program. Experts created the course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! *** Course Curriculum *** Here are the topics you will cover on the course: Module 01: Personal Assistant Module 02: Admin Support Module 03: Administrative Management Module 04: Organisational Skills Module 05: Telephone Etiquette Module 06: Business Writing Module 07: Time Management Module 08: Body Language and Effective Communication Module 09: Meeting Management Module 10: Excel Basics Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Module 11: PowerPoint Basic Customise the User Interface Set PowerPoint 2016 Options Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Create SmartArt Modify SmartArt Write Math Equations Add Audio to a Presentation Add Video to a Presentation Customise Animations and Transitions Review a Presentation Store and Share Presentations on the Web Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks and Action Buttons Record a Presentation Secure a Presentation Broadcast a Slide Show Create a Video or a CD Assessment Process After completing an online course module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the Advanced Diploma in Office Administration & Skills at QLS Level 7 exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Office Administration & Skills Course Right for You? Anyone interested in learning more about this subject should take this course. This Office Administration & Skills will help you grasp the basic concepts as well as develop a thorough understanding of the subject. All are welcome to take this course. There are no prerequisites for enrolment, and you can access the course materials from any location in the world. Requirements The Office Administration & Skills program does not require any prior knowledge; everyone may participate! This Office Administration & Skills course is open to anyone who is interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This Office Administration & Skills course allows you to study at your own speed and grow a quality skillset. Career path After completing this Office Administration & Skills Course, you are to start your career or begin the next phase of your career in this field. Our entire Office Administration & Skills course will help you to gain a position of respect and dignity over your competitors. The certificate enhances your CV and helps you find work in the field concerned. Certificates Certificate of completion Digital certificate - £10 Advanced Diploma in Office Administration & Skills at QLS Level 7 Hard copy certificate - £139 Show off Your New Skills with a Certificate of Completion After successfully completing the Advanced Diploma in Office Administration & Skills at QLS Level 7, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 139 GBP inside the UK 149 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)

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: Microsoft Access is a database management system (DBMS) from Microsoft. This software combines the relational Jet Database Engine with a graphical user interface and software-development tools. Microsoft Access is one of the Microsoft Office suites of applications. In this application, users can create tables, queries, forms and reports, and connect them together with macros. Through this course, you will learn the necessary skills, knowledge, and information about Microsoft Access 2013 needed for any users and for any professionals. Who is the course for? Professionals who want to learn about the Access. People who have an interest in the more functions and features of Access. 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 hardcopy 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 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: The Microsoft Access Intermediate Level course is a useful qualification to possess and would be beneficial for following careers: Software Engineer Technical Support Technical Sales Business Analyst Web Developer Software Tester. Microsoft Access Intermediate Level Module One - Getting Started 00:30:00 Module Two - Creating a Custom App 01:00:00 Module Three - Customizing App Actions 01:00:00 Module Four - Customizing Your App Views with Macros 01:00:00 Module Five - Working with Validation Rules and Messages 01:00:00 Module Six - Working with Macros 01:00:00 Module Seven - Advanced Query Tasks 01:00:00 Module Eight - Designing Forms 01:00:00 Module Nine - Advanced Reporting Tasks 01:00:00 Module Ten - Advanced Database Tools 01:00:00 Module Eleven - Working with the Access Environment 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Microsoft Access Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Access Intermediate Level 00:20:00 Final Exam Final Exam- Microsoft Access Intermediate Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: The Microsoft Access application is used by professionals who manage the database in their organisation. The advanced users of Access can write rich solutions with advanced data manipulation and user control. Access also has report creation features that can work with any data source that Microsoft Access can access. Through this course, you will learn the advanced skills, knowledge, and information about Microsoft Access. You will learn things related to shareable apps, action bar, customising the records in your desktop database, and much more. Who is the course for? Professionals who want to learn about the Microsoft Access. People who have an interest in the advanced features of the Access. 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 hardcopy 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 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: The Microsoft Access Advanced Level course is a useful qualification to possess and would be beneficial for following careers: Software Engineer Technical Support Technical Sales Business Analyst Web Developer Software Tester. Microsoft Access Advanced Level Module One - Getting Started 00:30:00 Module Two - Using App Views 01:00:00 Module Three - Customizing Apps, Part One 01:00:00 Module Four - Customizing Apps, Part Two 01:00:00 Module Five - Working with More Record Tasks 01:00:00 Module Six - Using Advanced Field Tasks 01:00:00 Module Seven - Working in Table Design View 01:00:00 Module Eight - Working with the Expression Builder 01:00:00 Module Nine - Working with External Data 01:00:00 Module Ten - Creating Queries 01:00:00 Module Eleven - Creating Forms and Reports 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Microsoft Access Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Access Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Access Advanced Level 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Access is the most popular database for Windows. It enables you to collect, organize, and report on data via a graphical interface. Templates provide pre-defined forms, reports and database designs - and Macros enable you to automate regular tasks. By this Microsoft Access 2016 Advanced explore the advanced Access features. Whether you are using Access for the first time, , or have been using it for years, this course will help you make the most of Access 2016's features and tools. So, if you are thinking to improve your knowledge in Microsoft Access 2016, you can join this course now. Learning Outcomes: Designing forms through adding and setting controls, creating subforms, using tab pages to organize information, improve navigation, formatting and applying conditional formatting Data, field, form and record validation Creating macros, restricting records using conditions, validate data, automate data entry and convert a macro to VBA in order to enhance user interface design Link tables to external data sources, manage database, determine object dependency, document database, and analyze database performance Allow multiple user access to database by splitting it, implement security, set passwords, convert Access database to ACCDE file, and add digital signatures Create and modify switchboards and startup options 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 Access 2016 Advanced 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 Access 2016 Advanced 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. Implementing Advanced Form Design Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Using Data Validation Field Validation 00:30:00 Form and Record Validation 00:30:00 Using Macros to Improve User Interface Design Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Using Advanced Database Management Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Distributing and Securing a Database Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Managing Switchboards Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Activities Activities - Microsoft Access 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft Access 2016 Advanced 00:20:00 Final Exam Final Exam- Microsoft Access 2016 Advanced 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Microsoft Access is the most powerful and well-known software for creating databases. This course is the advanced version of Microsoft Access 2007 beginner's level, as it will drive you to the advanced level of Microsoft Access 2007. Learn about the advanced features and functions of access 2007. Explore the advanced database tool and how can they be used. At the end of this course, you will be able to create databases as professionals. In this course you will learn the necessary skills, knowledge and information of Microsoft Access.  Who is this course for? For individuals who are working in IT firms. For people who are looking forward to learning about the advanced features of Microsoft Access 2007. 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 Access 2007 Advanced Level will be very beneficial and helpful, especially to the following professionals: Software Tester. Software Engineer. Technical Support. Technical Sales. Business Analyst. Web Developer. Microsoft Access 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Advanced Table Tasks 01:00:00 Module Three - Advanced Form Tasks 01:00:00 Module Four - Advanced Reporting Tasks 01:00:00 Module Five - Understanding Relationships 01:00:00 Module Six - Advanced Query Tasks 01:00:00 Module Seven - Working with SQL 01:00:00 Module Eight - Linking Data 01:00:00 Module Nine - Importing Data 01:00:00 Module Ten - Exporting Data 01:00:00 Module Eleven - Advanced Database Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Microsoft Access 2007 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Access 2007 Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Access 2007 Advanced Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Nowadays data management is absolutely crucial, and there's not much room for error. If you've already taken the basic Microsoft Access 2013 course, or know your way around the program already, then you're ready for this advanced level of Microsoft Access 2013. This Microsoft Office 2013 Access Advanced - Complete Video Course covers advanced functions and features of Access 2013. You will learn about implementing advanced form design, using data validation and using macros to improve user interfacer design. You will also learn how to use advanced database management, distribute and secure a database and manage switchboards. If you want to take your Microsoft Access 2013 skills to the next level, you'll learn how to use this program's advanced features to build a fully functional database from scratch. 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 2013 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 2013 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. Implementing Advanced Form Design Add Controls to Forms FREE 00:22:00 Create Subforms 00:03:00 Organize Information with Tabs Pages 00:05:00 Enhance Navigation of Forms 00:06:00 Apply Conditional Formatting 00:05:00 Using Data Validation Field and Record Validation 00:23:00 Form Validation 00:08:00 Using Macros to Improve User Interface Design Create a Macro 00:17:00 Restrict Records Using a Condition 00:05:00 Validate Data Using a Macro 00:06:00 Automate Data Entry Using a Macro 00:06:00 Convert a Macro to VBA 00:05:00 Using Advanced Database Management Link Tables to External Data Sources 00:05:00 Manage a Database 00:07:00 Determine Object Dependency 00:05:00 Document a Database 00:05:00 Analyze the Performance of a Database 00:05:00 Distributing and Securing a Database Splitting a Database for Multiple User Access 00:05:00 Implement Security 00:09:00 Set Passwords 00:07:00 Convert an Access Database to an ACCDE File999 00:07:00 Analyze the Performance of a Database 00:04:00 Managing Switchboards Create a Database Switchboard 00:07:00 Modify a Database Switchboard 00:04:00 Set Startup Options 00:06:00 Mock Exam Mock Exam- Microsoft Office 2013 Access Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Access Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Access is a database management system (DBMS) from Microsoft. This software combines the relational Jet Database Engine with a graphical user interface and software-development tools. It stores data in its format based on the Access Jet Database Engine. Through this course, you will learn from beginner, intermediate, and advanced level skills, knowledge, and information about Microsoft Access 2013. You will then know the different components of the database so that you understand the structure underlying your data to know data manipulation and user control. Who is the course for? New staff or workers who want to learn about the Microsoft Access 2013 People who have an interest in the basics and features of the Access 2013 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 hardcopy at a cost of £39 or in PDF format at a 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 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: The Level 3 Diploma in Microsoft Access course is a useful qualification to possess and would be beneficial for following careers: Software Engineer Technical Support Technical Sales Business Analyst Web Developer Software Tester. Microsoft Access Essentials Module One - Getting Started 00:30:00 Module Two - Opening and Closing Access 01:00:00 Module Three - An Introduction to Databases 01:00:00 Module Four - Sharing Data Using Apps 01:00:00 Module Five - Working in Your App 01:00:00 Module Six - An Introduction to Desktop Databases 01:00:00 Module Seven - Performing Basic Table Tasks 01:00:00 Module Eight - Working with Fields 01:00:00 Module Nine - Working with Table Relationships 01:00:00 Module Ten - An Introduction to Queries, Forms, and Reports 01:00:00 Module Eleven - Protecting Your Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access for Beginners 00:00:00 Microsoft Access Expert Module One - Getting Started 00:30:00 Module Two - Creating a Custom App 01:00:00 Module Three - Customizing App Actions 01:00:00 Module Four - Customizing Your App Views with Macros 01:00:00 Module Five - Working with Validation Rules and Messages 01:00:00 Module Six - Working with Macros 01:00:00 Module Seven - Advanced Query Tasks 01:00:00 Module Eight - Designing Forms 01:00:00 Module Nine - Advanced Reporting Tasks 01:00:00 Module Ten - Advanced Database Tools 01:00:00 Module Eleven - Working with the Access Environment 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access Intermediate Level 00:00:00 Microsoft Access Advanced Module One - Getting Started 00:30:00 Module Two - Using App Views 01:00:00 Module Three - Customizing Apps, Part One 01:00:00 Module Four - Customizing Apps, Part Two 01:00:00 Module Five - Working with More Record Tasks 01:00:00 Module Six - Using Advanced Field Tasks 01:00:00 Module Seven - Working in Table Design View 01:00:00 Module Eight - Working with the Expression Builder 01:00:00 Module Nine - Working with External Data 01:00:00 Module Ten - Creating Queries 01:00:00 Module Eleven - Creating Forms and Reports 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access Advanced Level 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Access 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Access 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

About Course Master the fundamentals of administrative support and Personal assistant with this online course Welcome to the Administrative and Office Assistant/Personal Assistant (PA) online course by Xpert Learning. Through this course from Xpert Learning, you will gain the fundamental skills required to be a successful Administrative and Office Assistant/Personal Assistant (PA) or an HR Assistant. Taught through a variety of virtual and interactive exercises, the course will empower you to develop your career as an Administrative or Personal Assistant.With the Online course, you'll learn how to stay one step ahead, anticipating needs and meeting the demands of this challenging, yet rewarding role. Our Course will give you the confidence to know that you're one step closer to your dream job, promotion, or new career. Administrative Office Assistant/Personal Assistant is a career that requires a lot of collaboration and communication. Primarily, you will be responsible for creating the workflow of the company where you are working. The more experience in this field and knowledge of administrative procedures, the more success you will have. The course is designed so that the student comes out with skills that are applicable to any industry. The course is entry-level for anyone interested and it is designed to equip students with the skills necessary to face any situation that could arise in an administrative or office assistant role. This course contains 9 modules covering various topics like Roles and responsibilities, Necessary skills, gathering the right tools, identifying procedures, business writing, and organising meetings and events. You will also receive PDF reading materials for further study.The Administrative Office Assistant/Personal Assistant course is aimed at providing students with the most up-to-date knowledge of the latest trends and developments in the workplace. This course will educate you on how to design a workflow for routine administrative tasks that are essential for a company to run smoothly. You will learn how to conduct your job effectively by using communication skills and taking the necessary steps for the successful completion of duties. Learn how to become a successful office assistant, with organization and problem-solving skills. The Admin and office assistant/Personal Assistant course is a perfect fit for students who are looking to grow their careers in this field. You will gain industry-specific knowledge through in-depth coverage of the topics required of an administrator, as well as a thorough understanding of administrative office procedures. What Will You Learn? Understand the roles and responsibilities of an excellent personal assistant Familiarise yourself with the skills of an effective administrator Gain an extensive understanding of business etiquette Organisational Meeting and Conference Skills Professional time management and prioritisation skills Course Content Introduction to Administrative and Office Assistant Introduction to Administrative and Office Assistant Administrative Assistant: Roles and Responsibilities Administrative Assistant Roles and Responsibilities Necessary Skills for Administrative Assistant Necessary Skills for Administrative Assistant Gathering the Right Tools Gathering the Right Tools Day to Day Tasks of an Administrative Assistant/PA/Secretary Day to Day Tasks of an Administrative Assistant/PA/Secretary Writing for The Business Environment Writing for The Business Environment Organising Meetings and Events Organising Meetings and Events Conclusion Conclusion Health and Safety, your wellbeing: Workstation Ergonomics A course by Xpert Learning RequirementsThere is no entry requirement. Audience Aspiring Personal Assistant, Administrative Assistant, HR Assistant, Secretary Personal Assistant, Executive Personal Assistant, Administrative Assistant, HR Assistant who want to enhance their skills Audience Aspiring Personal Assistant, Administrative Assistant, HR Assistant, Secretary Personal Assistant, Executive Personal Assistant, Administrative Assistant, HR Assistant who want to enhance their skills

Description: This Microsoft Office 2007 PowerPoint Beginners - Complete Video Course will provide you with an overview of the features and functions of Microsoft Office PowerPoint 2007. By taking this course you will learn to work with PowerPoint environment, open move around in, and close a presentation, display different views of a presentation, save a presentation, quickly create a presentation, create a presentation based on a ready-made design, convert an outline to a presentation, reuse existing slides, create a photo album, enter text, edit text, add and manipulate text boxes, correct and size text boxes, correct and size text while typing, check spelling and choose the best words, find and replace text while typing, change the size, alignment, spacing, apply a theme, rearrange slides in a presentation, switch to a different color scheme, and more.  So, if you are interested to learn all the basics of Microsoft Office PowrPoint 2007, then you should join this course now. 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 PowerPoint 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 2007 PowerPoint 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 The PowerPoint Window FREE 00:17:00 Getting Help 00:01:00 New Presentations Creating New Presentations 00:09:00 Saving Presentations 00:03:00 Rearranging and Deleting Slides 00:03:00 Using Slides from Other Presentations 00:02:00 Formatting Slides Text Formatting 00:18:00 Modifying Text 00:10:00 Paragraph Formatting 00:03:00 Drawing Objects Shapes 00:05:00 Modifying Objects 00:16:00 Text in Shapes 00:12:00 Graphics WordArt 00:07:00 Pictures 00:10:00 Clip Art 00:07:00 Tables and Charts Tables 00:10:00 Charts 00:06:00 Diagrams 00:06:00 Modifying Presentations Templates and Themes 00:06:00 Slide Masters 00:17:00 Transitions and Timings 00:07:00 Speaker Notes 00:04:00 Setting Up Slide Shows 00:05:00 Proofing and Delivering Presentations Proofing Presentations 00:07:00 Running Presentations 00:02:00 Printing Presentationsns 00:07:00 Mock Exam Mock Exam- Microsoft Office 2007 PowerPoint Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 PowerPoint Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00