598 Courses in London

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

This MS Access Advanced Course mostly covers creating advanced MS Access reports, forms, and macros. Create and amend Advanced Forms and Advanced Reports. Macro buttons. This assists you to build user-friendly forms to facilitate effective navigation, effective data capture and effective viewing and querying data This course will help you to structure MS Access tables, import, and manage your data effectively.

This Access Course concentrates on using creative queries, to extract data from large data sets to get insight from your data and report it. Learn and explore various query techniques from where clauses, to aggregation, joins and more. This private style tuition helps to maximise the value you get from the day.

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

This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports. This course will help participants: Plan and create a database Sort and filter records Use field data types Work with tables Create and manage a query Create and work with forms, and use the form wizard View, create and print reports 1 Access introduced Planning a database Creating a blank database Opening an existing database Security warnings The navigation pane Previewing database components Closing an Access database 2 Tables introduced Viewing and navigating table data Navigating using keyboard shortcuts Editing table data Adding records to tables Selecting and deleting records Finding and replacing data Filtering tables Summing table data 3 Queries introduced Opening a query in datasheet view Opening a query in design view Adding fields to a query Sorting query results Modifying datasheet view Saving and closing queries 4 Forms introduced Working with form data Sorting records Filtering records Working in design and layout views Changing object attributes 5 Reports introduced Opening and viewing reports Viewing a report in design view Previewing and printing report data Creating reports with auto report Creating reports with the report wizard Changing field attributes 6 Creating a new database Creating database tables Creating table fields Selecting field data types 7 Table relationships Introducing relationships Establishing table relationships The one-to-many relationship type Establishing referential integrity 8 Creating queries Streamline query criteria using wildcards Creating summary queries Creating queries based on criteria Running date queries Formatting field properties Building queries from multiple tables Summing in queries 9 Creating forms Creating a new form Inserting form fields Working with the property sheet The command button wizard The command button wizard Programming without typing Creating forms with embedded sub forms Creating forms with the sub form wizard Creating forms with the form wizard 10 Creating reports What are report bands? Managing report controls Basing reports on multiple tables Basing reports on queries Sorting and grouping records

Microsoft Access training course description A hands on course providing a solid grounding in Microsoft Access. What will you learn Use and customise the Microsoft Access environment. Select, use and customise queries. Define tables. Design forms and reports. Recognise the use of macros. Microsoft Access training course details Who will benefit: Anyone wishing to work with Microsoft Access. Prerequisites: Database fundamentals Duration 3 days Microsoft Access training course contents Introducing databases Flat file databases, Relational databases, the objects defined in an Access database, planning a simple relational database. Open Access and create a database The database wizards, tables, creating and amending tables, using field properties to improve the quality of data entry and system performance, the primary key. Working in datasheet view View, add, modify and delete records, find records. Advantages and disadvantages of entering data directly into a table. Queries Sort and select records form a single table, advantages and disadvantages of entering data via a query, define simple calculated expressions, use 'Totals' queries. Forms Use the form wizards, basic editing of objects created using the form wizards, Data-entry in form view. Reports Use the report wizard, basic editing of objects created using the report wizard, print reports. The multi table environment Plan and create a related table, define a one-to-many relationship, write multi-table queries and use the 'AutoLookup' feature, use the form wizard to create a subform and carry out data-entry in a main/subform, print and amend reports, use the report wizard to create reports based on multi-table. Relationships Working with one-to-one and one-to-many relationships, recognising and handling many-to-many relationships, referential integrity. Select queries Select queries based on related tables, parameter queries, Crosstab, find unmatched queries and Find Duplicate, the implications of the Join properties in a relational query, conditional expressions, and working with the expression builder. Action queries Make table queries, append queries, update queries, delete queries. Customising forms. Using the Toolbox, calculated controls, Combo and List boxes, query by form, working with form and control properties, domain aggregate functions. Reports Report and control properties, customising sorting and grouping, calculated controls on reports, Sub-reports, editing and altering a report's source. Macros Introduction to macros.

Broadband access training course description ADSL is a broadband technology providing fast Internet access (amongst other applications) over existing telephone lines. This course covers an overview of the DSL family, what ADSL is through to how ADSL works. What will you learn Describe what ADSL is. Describe how ADSL works. Describe the ADSL architecture. Recognise the limitations of ADSL. List the elements required for an ADSL installation. Broadband access training course details Who will benefit: Network engineers and anyone who will be working with ADSL. Prerequisites: Intro to data communications & networking Duration 2 days Broadband access training course contents What is ADSL? Broadband definitions, OSI layer 1, ADSL services, WANS. ADSL features: always on, point to point, Asymmetric, speeds. ADSL benefits, xDSL family, standards, history, example DSL forum documents. ADSL architecture The big picture, The PSTN and telephones, Digital and analogue, PSTN and modems, ADSL vs. modem speeds, Block 1: Customer premises, Block 2: The last mile, Block 3: The exchange, Block 4: the core network. Customer premises Splitters, micro filters, splitter architectures, Splitterless ADSL, ADSL modems, USB, ADSL routers. The local loop ADSL PHY, Some basics, ADSL margins, speed implications, distances, RADSL, Line testing, whoosh tests, line coding, multiple channels, FDM, echo cancellation, Modulation: AM, FM, PM, QAM, QAM constellations, DMT, CAP, Framing, Superframes, fast data mode, interleaved mode, RADSL revisited. The exchange Local exchange ADSL items, DSLAMs, ADSL racks, Contention. The core network The role of the core network, ATM, ATM VPI/VCI, ATM cells, ATM layers, AAL5, RAS, Home gateways. ADSL and the higher layers Layer 2 choices, PPPoA, PPP, CHAP, Layer 4 and above, ADSL and ATM. Installing and configuring ADSL Choosing providers, line activation, hardware requirements, Configuring layer 1 and layer 2, Configuring IP. Summary ITU ADSL standards

City & Guilds 18th edition course with 2382-22 final exam only £234.00. Exams available every week across the UK, same day results, quick certificate, best prices..

Osteopathic palpation of the involuntary mechanism and paediatric/developmental anatomy of the cranium, membranous/fascial & fluid systems Course Title: OCC Access Course Dates: 14, 15 and 22 September 2024 (minimum 6 contact hours per day) Location: OCC, Canopi Building 7 - 14 Great Dover Street, London, SE1 4YR Osteopaths studying on our postgraduate courses need to have acquired hands-on skills beyond their undergraduate training. Our Access Course provides tailored training to introduce & nurture palpation of the involuntary mechanism and paediatric/developmental anatomy of the cranium, membranous/fascial & fluid systems to prepare less experienced osteopaths for further paediatric training. Our experienced faculty will deliver this 3-day course, which enables osteopaths to reach the required standard for entry onto the OCC courses and does not limit our osteopaths to any one technical style. These days can also be useful to osteopaths who want to refresh or enhance previously acquired skills & can be attended as individual days if space permits. Course Content: Day 1 - Saturday 14th September – Vault & base osteology, applied anatomy & motion – RTM & venous sinuses – Sacral /pelvic anatomy & motion Day 2 - Sunday 15th September – SBS patterns, theory & palpation – Fascia – Fluid – CNS Day 3 - Sunday 22nd September – Viscerocranium anatomy, osteology & motion – Principles of treatment – Intra oral techniques – Condylar parts osteology, applied anatomy & treatment All 3 days will be delivered in small groups to facilitate individual learning and needs. Most of the teaching will take place at the tables with very little lecture material & will include demonstrations interwoven with appropriate practical sessions. This is designed to deliver theory but in a very practical hands-on way. In order to provide this level of supervision numbers will be limited, and places are allocated on a ‘first come first served’ basis. For more info call 0208 875 5291 or email educationregistrar@occ.uk.com Cancellation Policy The OCC/FPO reserves the right to postpone this course if circumstances change. Eventbrite’s processing fee is non-refundable, so in the event that the course is cancelled by the OCC/FPO, all fees (excluding Eventbrite’s fee) will be refunded. Should circumstances mean that you have to cancel your place on this course, the OCC/FPO regrets to inform that no refunds can be given unless we are able to re-sell your place. Please note, the OCC/FPO does not accept responsibility for any expense you incur (such as travel and accommodation costs), so please do consider this before registration. occ.uk.com/continuing-professional-development The Osteopathic Centre for Children is the clinical arm of the Foundation for Paediatric Osteopathy. Registered Charity: 1003934

BAG AND ACCESSORY DESIGN COURSE: WHAT IS THIS COURSE ABOUT?This fashion design course for beginners and intermediates is a group class aimed to support aspiring designers or designers in need of guidance in designing viable and realistic bags and/or accessories.This course enables you to understand essential skills required to become a fashion bag designer ans well as guiding you through the steps necessary for designing, developing, prototyping and manufacturing your collection. WHY THIS IS NOT THE USUAL ‘ACCESSORY DESIGN’ COURSEThis course is designed by a team of designers, prototype makers and handbag manufacturers.It is both a theoretical and practical introductory course which will teach you what the industry requires from designers in order to be able to understand and correctly translate their ideas into finished products.This course is focused on giving you an overview on the complexity and extensiveness of the process that designing handbags requires.The course will assist you in understanding the prerequisites before and during the design of your styles. This knowledge will enable you to circumvent a lengthy, costly, and occasionally frustrating process when it comes time to prototype and manufacture your collection. WHY WE CREATED A FASHION DESIGN COURSEAfter years of experience in designing and developing collections for our customers, we realised that there was a substantial lack of clear information available about what designing a collection of handbags and fashion accessories truly requires and how it is achieved.We created this course with the aim of helping the new generation of designers, as well as designers which are still struggling, in developing their ideas and empower them to clearly and correctly communicate them to whoever is going to prototype their collection.We essentially have created this tuition based on the needs and problems of our customers, hoping to promote and facilitate creatives in the realisation of their projects. WHO IS THIS COURSE FOR?This course is designed for aspiring designers and professionals seeking expert advice from the industry. It caters to those in need of guidance to optimise their design process or understand the nuances of working as a fashion accessory designer.No previous experience is required. WHAT WILL BE TAUGHT?The designing classes cover various topics, including:Preliminary considerations before designing on the role and skills of a designerUnderstanding the concept and use of a moodboardAnatomy of a handbag, including lining and hardwearImportance of construction and finishing optionsDifferences and purposes of illustrations vs technical drawingsSketching techniques, including drawing in perspective and technical drawingsProduct development for a specific designUnderstanding what technical information the prototype maker requiresOverview of the prototyping process HOW WILL THE ABOVE BE TAUGHT:The class will take place in person at our London studio and the lesson will alternate between theoretical lessons and practical exercises. INCLUDED IN THE COURSE:You will also receive access to a collection of handouts providing relevant information, useful resources and support in continuing your designing process independently.The handouts will contain:– A glossary containing essential key words related to the topic of the lesson– An illustrated glossary containing information about type of bags and bags’ features– Documents about leather types, finishings, tanning processes– Information about perspective and guides to be used as reference to develop your drawings– A list of recommended suppliers for both leather and fittings (physically in London and online)– A glossary containing information about leather types and characteristicsWHAT ARE THE ENTRY REQUIREMENTS?You should be able to use measurements and understand verbal and written English instructions. ARE THERE ANY OTHER COSTS? IS THERE ANYTHING I NEED TO BRING?Materials to exercise with are included.Feel free to bring a notepad, if you would like to take some notes, we will provide the rest.HOW LONG IS THIS TUITION?:This tuition will require up to 7.5 hours to complete but depending on the number of attendees, the ability of participants and the group’s pace, the syllabus may be covered in a shorter time frame.We aim to provide customised and high-quality tuition services and by only allowing max 6 students at a time, we are able to focus on each person needs and interests.As every student has a different level of ability and previous experience, this course might lead some students to complete the core aspects of the lesson in a shorter time frame than others.Students who complete the course early will be welcome to stay and use the studio facilities to exercise on the topics of the lesson.