1535 Courses delivered Live Online

Access Introduction generally navigate through Access Database, get data fast, update data records by entering, update data and delete data. Run available report, use available forms, create simple forms and reports via wizards. This style tuition helps to maximise the value that you get from the day.

LOOKING FOR: ADULT FICTION, SCIENCE FICTION / FANTASY After several years spent within publishing houses Bookouture, Canelo, Avon, One More Chapter and Head of Zeus, Hannah Todd became a Literary Agent at the Madeleine Milburn Literary, TV & Film Agency, before joining Janklow & Nesbit in January 2025. Her clients include Kirsty Greenwood, Charlie Gallagher and Leah Mercer. Hannah is keen to see commercial fiction across the board, but with a particular focus on romance, Science Fiction/Fantasy & mystery novels. She is drawn to books with exemplary characterisation, voice and strength of feeling. But don't let your characterisation overshadow the need for impeccable plot and if you can make her laugh or cry then you're onto a winner! Across the full light-dark spectrum Hannah especially loves SFF that features an unlikely band of heroes, like the Six of Crows series by Leigh Bardugo, Scott Lynch's Gentleman Bastard series, Becky Chambers' The Long Way to a Small Angry Planet, T. Kingfisher's Nettle and Bone,and the cosy themes/settings offered by Heather Fawcett and TJ Klune. Hannah's advice is make sure you have a clear USP and hook: If you are sending your reader to a magical academy, or if we're riding dragons or waving wands, that's great! But what makes your book feel different and fresh? An excellent voice is key, but what else makes your take on these tropes stand out? An example of a phenomenal book that has turned the magical academy trope on its head, with layers of excellent world building, a unique magic system and plot twists galore is The Will of the Many by James Islington. If you have something crafted this beautifully then Hannah wants to see it! Romantasy of varying spice levels, accessible to both romance and fantasy readers, is on Hannah's wishlist. And you can whisk her away with contemporary romance novels, romcoms, sweeping love stories that redefine the genre. Romcoms with great disability rep and LGBTQIA+ stories that focus on the joy of falling in love are high on Hannah's agenda. She particularly loves Emily Henry, Laura Wood and Abby Jiminez. Think more Nicholas Sparks than Sally Rooney, and Bonnie Garmus rather than Gabrielle Zevin. In this space, she is a big fan of Emma Donoghue, Bonnie Garmus and Jojo Moyes. Meet with Hannah to discuss your crime and high-concept thrillers with an unsettling ‘it-could-happen-to-me’ feeling, coupled with a twist that's unseen until its delivery. The book she most wants to find in this space is something like Three Hours by Rosamund Lupton in both its themes (real-world emotional suspense) and its execution. A mystery series that feels like a real 'romp' is something she loves to escape with too. With regards to all genres, Hannah is particularly interested in voices from underrepresented backgrounds: such as writers of colour, indigenous communities, the LGBTQIA+ community, and those with disabilities. Hannah does not the right agent to give advice on: Re-imaginings of the classics Books that feature characters putting on Shakespeare plays! Historical fiction Children's, middle-grade and YA Hannah would like you to submit a covering letter, one page synopsis and the first 5,000 words of your completed manuscript in a single word document. (In addition to the paid sessions, Hannah is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Tuesday 8th July 2025

LOOKING FOR: PICTURE BOOKS, CHAPTER BOOKS, MG, YA, CHILDREN'S NON-FICTION After a childhood buried in library books and Beanos, Lydia started her career in the editorial team at Egmont, where she commissioned books such as the Carnegie Medal-winning The Poet X. She joined the Darley Anderson team in 2018, and as well as building an engaging and diverse list of authors and illustrators, she was promoted to Director in March 2024. With experience on both sides of the commissioning desk, Lydia loves working editorially with her clients and developing ideas from an initial spark into a full manuscript. She represents clients across all age groups, including picture book, chapter book, middle grade and YA, and has a particular focus on non-fiction. Lydia reads and considers widely, and among other things she is looking for snort-inducing stories for younger readers, clever and contemporary teenage and YA fiction, and non-fiction projects that take big ideas and make them easily navigable, accessible and fun. No matter the story, Lydia is drawn to voice above anything else and will always be sucked in by a strong hook. Lydia represents clients including Soofiya, Gina Blaxill, Mark Bradley, Ryan Hammond, Alice Harman, Joyce Efia Harmer, Catherine Jacob, Hannah Moffatt, Rachel Morrisroe, Nick Sheridan, Rashmi Sirdeshpande and Eva Wong Nava. If you could sum up her tastes in three words, they would be curious, characterful and heartfelt, and in three books, they would be One of Us is Lying, Nevermoor and You Are Awesome. Lydia would like you to submit a covering letter, a 1 page synopsis and the first 3 chapters or 20 pages of your completed manuscript in a single word document. For Picture Books please submit a covering letter and texts for two completed stories. (In addition to the paid sessions, Lydia is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Monday 7th July by 12noon UK BST

Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored in company training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. Requirements Requirements Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

This one hour evening workshop will help you to start the process of thinking about what you want to do (e.g: major repairs, improved access, reordering to create flexible space, installing toilets or a kitchenette) and the initial steps to take towards developing it into a viable project. We'll also look at the different types of funders you might want to consider applying to for a grant. Please note numbers are limited to allow everyone a chance to tak and share their ideas.

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored in company training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. Certificates Certificates Certificate of completion Digital certificate - Included

Hosted by Let's Do Business Finance Date: 16th July Time: 12pm – 12.45 pm Location: Online (Zoom link provided upon registration) Cost: Free Is your business finding it hard to access finance through traditional lenders? You’re not alone — and there is another way. Join us for this free lunchtime webinar to discover how the Community Enable Fund from British Business Bank can help you access the funding you need to grow, even if you’ve previously struggled to secure finance. We’ll be joined by a panel of industry experts: Lisa Young – Let’s Do Business Finance (the first accredited lender on the scheme) Susan Elliott – British Business Bank Matt Woodcock – Responsible Finance What You’ll Learn: What the Community Enable Fund is and how it works Why it was created and how it can help your business Real examples of how the fund can help SMEs How to apply and what to expect during the process Support available alongside the funding Whether you're a growing business, or simply exploring new finance options, this session is for you. 💬 There will be a live Q&A with our panel, so bring your questions! Who should attend? SME business owners and directors Community-focused and purpose-led businesses Anyone who has previously struggled to secure business finance Reserve your place today and take the next step towards unlocking funding for your business.

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access