192 Import/Export courses in Nottingham delivered On Demand

The Microsoft Access 2016 Beginner to Advanced course is a comprehensive training program covering all levels of proficiency. From creating simple databases to advanced querying, form creation, report generation, and database management, this course provides a deep understanding of Microsoft Access's features and functions. Learning Outcomes: Build and modify Access databases, tables, and fields. Create effective queries to sort, filter, and summarize data. Develop professional-looking reports with controls, charts, and calculations. Design forms with controls, tab pages, and conditional formatting. Automate tasks using macros and understand the basics of VBA. Manage database performance, security, and object dependencies. Create a database switchboard and modify startup options. Understand data normalization, table relationships, and import/export processes. Why buy this Microsoft Access 2016 Beginner to Advanced? Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Microsoft Access 2016 Beginner to Advanced 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 the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Beginners with no previous experience in Microsoft Access. Professionals seeking to enhance their database management and reporting skills. Individuals aiming to become proficient in creating and maintaining databases. Students pursuing careers in data analysis, administration, or database management. Prerequisites This Microsoft Access 2016 Beginner to Advanced was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: Analyze, interpret, and present data insights using Access. Database Administrator: Design, implement, and maintain databases for organizations. Administrative Assistant: Manage data, generate reports, and streamline processes. Project Manager: Organize project-related data and create performance reports. Business Owner: Build and manage databases to support business operations. Course Curriculum Module - 1 Orientation to Microsoft Access 01:00:00 Create a Simple Access Database 01:00:00 Get Help in Microsoft Access 00:30:00 Modify Table Data 00:30:00 Work with Records 01:00:00 Sort and Filter Records 00:30:00 Create Lookups 01:00:00 Join Data from Different Tables in a Query 01:00:00 Sort and Filter Data in a Query 01:00:00 Perform Calculations in a Query 00:30:00 Create Parameter Queries 00:30:00 Create Action Queries 00:30:00 Create Find Duplicate and Find Unmatched Queries 00:30:00 Summarize Data 00:30:00 Create a Report 01:00:00 Add Controls to a Report 00:30:00 Enhance the Appearance of a Report 00:30:00 Prepare a Report for Print 00:30:00 The Access Options Dialog Box 01:00:00 Relational Database Design 00:30:00 Create a Table 01:00:00 Modify a Table and Fields 00:30:00 Create Table Relationships 00:30:00 Create Query Joins 00:30:00 Join Tables That Have No Common Fields 00:30:00 Relate Data within a Table 00:30:00 Work with Subdatasheets 00:30:00 Create Subqueries 00:30:00 Data Normalization 01:00:00 Create a Junction Table 00:30:00 Import Data into Access 00:30:00 Export Data to Text File Formats 00:30:00 Export Access Data to Excel 00:30:00 Create a Mail Merge 00:30:00 Organize Report Information 00:30:00 Format Reports 00:30:00 Include Charts in a Report 00:30:00 Add a Calculated Field to a Report 00:30:00 Add a Subreport to an Existing Report 00:30:00 Create a Mailing Label Report 00:30:00 Publish a Report as PDF 00:30:00 Activities - Microsoft Access 2016 for Beginners 00:00:00 Module - 2 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 Field Validation 00:30:00 Form and Record Validation 00:30:00 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 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 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 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Activities - Microsoft Access 2016 Advanced 00:00:00

***Small Businesses FEAR This Simple Financial Secret!** (Learn it with the Xero Accounting & Bookkeeping + Tax, Finance & Financial Management Course!)*** Did you know that according to a recent Federation of Small Businesses report, 72% of small business owners in the UK believe strong financial management is crucial for success? The Xero Accounting & Bookkeeping + Tax, Finance & Financial Management course equips you with the theoretical knowledge and understanding to excel in this critical area. This Xero Accounting & Bookkeeping + Tax, Finance & Financial Management comprehensive course is designed to provide a solid foundation in Xero accounting software, tax accounting principles, and financial management strategies. Throughout the course, you'll gain the theoretical knowledge needed to navigate the financial world with confidence, helping you make informed decisions for your business or future career. 3 CPD Accredited Courses Are: Course 01: Advanced Diploma in Xero Accounting and Bookkeeping at QLS Level 7 Course 02: Tax Accounting Course 03: Financial Management Learning Outcome: Going through our interactive modules of Xero Accounting & Bookkeeping + Tax, Finance & Financial Management course , you will be able to - Gain a working knowledge of Xero Accounting & Bookkeeping software. Master essential tasks like creating invoices, managing bills, and reconciling bank accounts in Xero. Understand core accounting principles like double-entry accounting and VAT returns. Develop strong financial management skills, including budgeting, analyzing financial statements, and interpreting financial data. Gain a theoretical grounding in tax accounting, including capital gains tax and import/export considerations. Confidently navigate the Xero Accounting & Bookkeeping + Tax, Finance & Financial Management landscape. Key Highlights of Xero Accounting & Bookkeeping + Tax, Finance & Financial Management: CPD Accredited Xero Accounting & Bookkeeping + Tax, Finance & Financial Management Course Unlimited Retake Exam & 24/7 Tutor Support Easy Accessibility to the Xero Accounting & Bookkeeping + Tax, Finance & Financial Management Course Materials 100% Learning Satisfaction Guarantee Lifetime Access Self-paced online Xero Accounting & Bookkeeping + Tax, Finance & Financial Management course Modules Covers to Explore Multiple Job Positions Curriculum Topics: Advanced Diploma in Xero Accounting and Bookkeeping at QLS Level 7e Xero Accounting & Bookkeeping + Tax, Finance & Financial Management begins with a deep dive into Xero accounting software. This course equips you with the theoretical knowledge to navigate Xero's functionalities for various bookkeeping tasks. You'll learn how to set up your Xero account, manage contacts, create invoices and bills, reconcile bank statements, and track inventory. Xero Accounting & Bookkeeping + Tax, Finance & Financial Management also covers essential bookkeeping principles like double-entry accounting and chart of accounts. Section 01: Introduction Introduction Section 02: Getting Started Introduction - Getting Started Signing up Quick Tour Initial Settings Chart of Accounts Adding a Bank Account Demo Company Tracking Categories Contacts Section 03: Invoices and Sales Introduction - Invoices and Sales Sales Screens Invoice Settings Creating an Invoice Repeating Invoices Credit Notes-03 Quotes Settings Creating Quotes Other Invoicing Tasks Sending Statements Sales Reporting Section 04: Bills and Purchases Introduction - Bills and Purchases Purchases Screens Bill Settings Creating a Bill Repeating Bills Credit Notes-04 Purchase Order Settings Purchase Orders Batch Payments Other Billing Tasks Sending Remittances Purchases Reporting Section 05: Bank Accounts Introduction - Bank Accounts Bank Accounts Screens Automatic Matching Reconciling Invoices Reconciling Bills Reconciling Spend Money Reconciling Receive Money Find and Match Bank Rules Cash Coding Remove and Redo vs Unreconcile Uploading Bank Transactions Automatic Bank Feeds Section 06: Products and Services Introduction - Products and Services Products and Services Screen Adding Services Adding Untracked Products Adding Tracked Products Section 07: Fixed Assets Introduction - Fixed Assets Fixed Assets Settings Adding Assets from Bank Transactions Adding Assets from Spend Money Adding Assets from Bills Depreciation Section 08: Payroll Introduction - Payroll Payroll Settings Adding Employees Paying Employees Payroll Filing Section 09: VAT Returns Introduction - VAT Returns VAT Settings VAT Returns - Manual Filing VAT Returns - Digital Filing Free Course 01: Tax Accounting Xero Accounting & Bookkeeping + Tax, Finance & Financial Management delves into the world of tax accounting. This course provides a theoretical understanding of tax principles, regulations, and calculations relevant to businesses. You'll explore topics like income tax, corporation tax, value added tax (VAT), and payroll taxes. Xero Accounting & Bookkeeping+ Tax, Finance & Financial Management equips you with the knowledge to identify tax implications for business transactions and ensure compliance with tax authorities. Module 01: Capital Gain Tax Module 02: Import and Export Module 03: Double Entry Accounting Module 04: Management Accounting and Financial Analysis Module 05: Career as a Tax Accountant in the UK Free Course 02: Financial Management Xero Accounting & Bookkeeping + Tax, Finance & Financial Management concludes with a focus on financial management. This course explores the theoretical underpinnings of financial decision-making. You'll learn how to create financial statements, analyze financial data, develop budgets and forecasts, and manage cash flow effectively. Xero Accounting & Bookkeeping+ Tax, Finance & Financial Management empowers you to make informed financial decisions that contribute to the overall success of a business. Module 01: Introduction to Financial Management Module 02: Fundamentals of Budgeting Module 03: The Balance Sheet Module 04: The Income Statement Module 05: The Cash Flow Statement Module 06: Statement of Stockholders' Equity Module 07: Analysing and Interpreting Financial Statements Module 08: Inter-Relationship Between all the Financial Statements Module 09: International Aspects of Financial Management Each topic has been designed to deliver more information in a shorter amount of time. This makes it simple for the learners to understand the fundamental idea and apply it to diverse situations through Xero Accounting & Bookkeeping + Tax, Finance & Financial Management course. Certification Free CPD Accredited (CPD QS) Certificate. Quality Licence Scheme Endorsed Certificate of Achievement: Upon successful completion of the course, you will be eligible to order an original hardcopy certificate of achievement. This prestigious certificate, endorsed by the Quality Licence Scheme, will be titled 'Advanced Diploma in Xero Accounting and Bookkeeping at QLS Level 7'. Your certificate will be delivered directly to your home. The pricing scheme for the certificate is as follows: £129 GBP for addresses within the UK. Please note that delivery within the UK is free of charge. Disclaimer This Xero Accounting & Bookkeeping + Tax, Finance & Financial Management course will teach you about Xero accounting software and help you improve your skills using it. It's created by an independent company, & not affiliated with Xero Limited. Upon completion, you will earn a CPD accredited certificate, it's not an official Xero certification. CPD 30 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Xero Accounting & Bookkeeping + Tax, Finance & Financial Management course. Besides, this Xero Accounting & Bookkeeping + Tax, Finance & Financial Management course particularly recommended for- Anyone interested in learning Xero can progress from a beginner to a knowledgeable user in just one day. Small business owners that want to handle their own accounting in Xero Xero Practice Manager Bookkeepers who wish to learn Xero rapidly Requirements Students seeking to enrol for Xero Accounting & Bookkeeping + Tax, Finance & Financial Management course should meet the following requirements; Basic knowledge of English Language is needed for Xero Accounting & Bookkeeping + Tax, Finance & Financial Management course, which already you have. Basic Knowledge of Information & Communication Technologies for studying Xero Accounting & Bookkeeping + Tax, Finance & Financial Management course in online or digital platform. Stable Internet or Data connection in your learning devices to complete the Xero Accounting & Bookkeeping + Tax, Finance & Financial Management course easily. Career path The Xero Accounting & Bookkeeping + Tax, Finance & Financial Management course will enable you to explore in Xero related trendy and demanding jobs, such as: Bookkeeping Specialist Client Experience Specialist Accounting Advisory Apprentice Cloud Accountant Education Specialist Management Accountant Finance Manager Tax Implementation Specialist Xero Practice Manager Certificates CPD QS Certificate of completion Digital certificate - Included After successfully completing this course, you can get CPD accredited digital PDF certificate for free.

In this practical, hands-on course, you'll learn how to use R for effective data analysis and visualization and how to make use of that data in a practical manner. You will learn how to install and configure software necessary for a statistical programming environment and describe generic programming language concepts as they are implemented in a high-level statistical language.

Master the art of project planning, scheduling, and resource management with Oracle Primavera P6 PPM Professional. The course offers a streamlined approach to efficiently manage projects and includes workshops for intermediate-level users to apply their knowledge in practice.

The Customs Compliance & Regulations Mini Bundle is built for those dealing with policies, paperwork, and fine details—minus the legalese headache. From understanding UK customs rules to refining written communication and data accuracy, this bundle keeps things sharp and relevant. You’ll cover British Law, written clarity, regulatory awareness, and the kind of proofreading that saves you from embarrassing typos in official documents. Whether you’re assisting in admin, handling client forms, or working on legal documentation, this is a bundle that helps you avoid crossed wires and crossed lines. It’s ideal for people who appreciate order and a well-formatted spreadsheet. Learning Outcomes: Understand the basics of UK customs and regulatory processes. Apply British legal knowledge to workplace-related responsibilities. Communicate clearly and effectively within professional environments. Enter data correctly using structured and standard procedures. Identify and correct written errors through proper proofreading. Follow business regulations and documentation expectations carefully. Who Is This Course For: Admin staff dealing with official paperwork and documentation. Legal support staff working with reports and formal letters. Professionals needing better written and verbal accuracy. Data entry clerks in regulated or legal-based offices. Business teams managing trade and customs procedures. Staff supporting import/export or goods processing roles. Office managers streamlining document accuracy and record-keeping. Anyone who works under rules and likes avoiding mistakes. Career Path: Customs Documentation Officer – £30,000/year Regulatory Admin Assistant – £28,000/year Legal Proofreader – £32,000/year Data Entry Clerk – £23,000/year Communication Support Officer – £27,000/year Business Regulations Assistant – £29,000/year

From export headaches to import paperwork and everything in between, navigating EU customs and compliance can feel like solving a Rubik’s cube blindfolded. This 8-in-1 Premium Bundle is built to demystify it all. With topics covering GDPR, KYC, AML, and British Law—alongside logistics, MS Excel, and more—you’ll gain insight into the structured chaos of trade regulation without needing a decoder ring. Whether you're aiming to stay afloat in trade documentation or trying not to mix up your anti-money laundering obligations with your GDPR policies, this bundle offers a tidy stack of essentials. Learn the core of lawful operations, compliance protocols, and international logistics—all with a firm grip on what matters (and what’s legally required). Yes, there’s a bit of Excel too—because no one escapes spreadsheets. Learning Outcomes: Understand the key principles of import and export documentation. Learn AML procedures and financial reporting responsibilities clearly. Gain familiarity with GDPR and data protection essentials. Develop insight into logistics and supply chain frameworks. Understand British legal elements related to compliance roles. Improve documentation accuracy using core MS Excel functions. Who is this Course For: Professionals managing EU-based shipping or freight coordination. Staff responsible for KYC and anti-fraud documentation. Business owners handling cross-border product movement. Admins involved in regulatory paperwork and reporting. Office teams needing a refresher on GDPR basics. Individuals entering customs support or logistics roles. HR or finance roles tied to AML or compliance filing. Anyone curious about how trade regulations actually work. Career Path: Customs Compliance Officer – £30,000/year Import/Export Coordinator – £28,500/year Logistics Administrator – £26,000/year AML Analyst – £35,000/year Regulatory Compliance Assistant – £32,000/year KYC Officer – £33,000/year

This course teaches you to prepare for AZ-104 Certification. The course gives you the knowledge to make you Azure ready and become a better Azure administrator. All the changes that were made to AZ-103 by Microsoft to make it AZ-104 are incorporated in this course.

Embark on a transformative Python web development journey with this course and dive deep into creating a dynamic book rental system from scratch. Master Django's import-export capabilities, design elegant UI with Tailwind CSS, implement advanced features, and more. Elevate your skills and build real-world applications effortlessly!

If databases were kingdoms, SQL Server would be the crown jewel—and this bootcamp helps you understand why. Whether you're a curious beginner or someone who once dabbled in database queries, this course introduces you to Microsoft SQL Server in a way that feels both structured and digestible. From creating databases to querying data with finesse, you'll gain a clear understanding of how SQL Server works—without needing to download every technical manual Microsoft ever wrote. This course doesn't drown you in jargon or drag you into a tech fog. Instead, it’s paced with clarity, peppered with useful insights, and designed to help you genuinely grasp how to manage data efficiently. You'll learn key SQL concepts, explore table relationships, get to know stored procedures, and understand the logic that powers business intelligence—all while keeping your learning screen-based and refreshingly jargon-free. Let’s face it: data isn’t going anywhere, so you might as well learn to speak its language. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Microsoft SQL Server Bootcamp 2022 Section 01: Getting Started Section 02: SQL Server setting up Section 03: SQL Database basic Section 04: SQL DML (Data Manipulation Language) Section 05: SQL DDL (Data Definition Language) Section 06: SQL DCL (Data Control Language) Section 07: SQL Statement Basic Section 08: Filtering Data rows Section 09: Aggregate functions Section 10: SQL Query statements Section 11: SQL Group by statement Section 12: JOINS Section 13: SQL Constraints Section 14: Views Section 15: Advanced SQL commands Section 16: SQL Stored procedures Section 17: Import & Export data Section 18: Backup and Restore Database Course Assessment To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%. When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme. Certification Once you have finished the course, you will be eligible to apply for a CPD QS accredited certificate as proof of your new skills and your continued professional development. Certificates are available as PDF for £9, or you can request a hard copy to be sent in the post for £15. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Microsoft SQL Server Bootcamp 2022 course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Microsoft SQL Server Bootcamp 2022 course is open to all, with no formal entry requirements. Career path Upon successful completion of the Microsoft SQL Server Bootcamp 2022 Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

Data speaks volumes—if you know how to listen. This course offers a clever route into the world of MySQL, showing you how structured data can turn into smart decisions. Whether you're sifting through figures, building dashboards, or deciphering patterns, understanding SQL isn’t just helpful—it’s essential. You’ll be guided through the foundations of MySQL with clarity and precision, making sense of tables, queries, joins, and more—all without the fluff or confusion. Designed with the analytical mind in focus, this course shines a light on how MySQL powers insights behind the scenes in data science and analytics. It's tailored for learners who prefer clarity over jargon and structure over noise. If you're curious about how databases work and how data fuels smart outcomes, this course is your ideal stepping stone—organised, engaging and purposefully built for those who appreciate logic and clean learning paths. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Section 01: Getting Started Introduction How to get course requirements Getting started on Windows, Linux or Mac How to ask great questions FAQ's What is Source Code? Section 02: SQL Server setting up Section Introduction MySQL Server Installation Connect MySQL Server Instance MySQL Workbench overview Download and Restore Sample Database Section 03: SQL Database basics Section Introduction Overview of Databases Creating Database SQL Data Types Column Data Types on Workbench Creating Table Overview of Primary and Foreign Key Primary Key Foreign Key Creating Temporary tables EER - Enhanced Entity Relationship Diagrams Section 04: SQL DML (Data Manipulation Language) Section Introduction Insert statement Update statement Delete statement Section 05: SQL DDL (Data Definition Language) Section Introduction CREATE table statement DROP statement ALTER statement TRUNCATE statement COMMENT in query RENAME table Section 06: SQL DCL (Data Control Language) Create Database user GRANT permissions REVOKE permissions Section 07: SQL Statement Basic Section Introduction SQL Statement basic SELECT Statement SELECT DISTINCT SELECT with column headings Column AS statement DASHBOARD Analytics Section 08: Filtering Data rows SELECT WHERE Clause - theory SELECT WHERE Clause - practical Section 09: Aggregate functions for Data Analysis Sum() Min()-Max() Section 10: SQL Data Analyticstatements Order By statement SELECT TOP 3 records BETWEEN command IN operator Search Data usingLIKE cards Section 11: SQL Group by statement Section Introduction Group by - theory Data Analytics with Group By HAVING statement Section 12: JOINS Overview of Joins What are Joins Inner join Left outer join Right outer join Union CERTESIAN Product or Cross Join Query Exercise Solution for Query Exercise Section 13: SQL Constraints Section introduction Check constraint NOT NULL constraint UNIQUE constraint Section 14: Views Creating Views Data Analytic Viewsfrom multiple tables Section 15: Advanced SQL Functions Section Introduction Timestamp Extract from timestamp Mathematical scalar functions String functions Advanced functions Sub Queries SELECT with calculations Section 16: SQL Stored procedures Create stored procedure Stored procedure with parameter Drop Procedure Section 17: Import & Export data Section Introduction Import .csv file Export Data to .csv file Section 18: Backup and Restore Database Section Introduction Creating Database backup Restoring Database backup Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Learn MySQL from Scratch for Data Science and Analytics course is open to all, with no formal entry requirements. Career path Upon successful completion of The Learn MySQL from Scratch for Data Science and Analytics Course, learners will be equipped with many indispensable skills and have the opportunity to grab.