- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
Microsoft Access Advanced - In-company / Bespoke
By Microsoft Office Training
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
Designed to promote deep relaxation and mindfulness through a thoughtfully slower-paced practice, this nurturing class offers a sanctuary from the demands of daily life. Led by experienced instructor Kirstine Henderson, each session focuses on gentle stretching and accessible exercises that honor your body's natural rhythm and capabilities, making it welcoming for practitioners of all ages, fitness levels, and experience. Throughout the class, you'll be guided through a carefully curated sequence of calming poses that work harmoniously to enhance flexibility, improve balance, and cultivate overall well-being. The emphasis is on moving with intention rather than intensity, allowing you to truly listen to your body and respond to its needs. Each posture is offered with modifications and variations, ensuring that everyone can participate comfortably and safely. Whether you are completely new to yoga and taking your first steps onto the mat, or you're a seasoned practitioner seeking a soothing way to unwind and reconnect with yourself, this class provides a supportive and non-judgmental environment. You'll discover how gentle movement can be profoundly transformative, helping you release physical tension while quieting mental chatter. Meeting in the studio 11.15 to leave to the park if the weather allowed. Mats provided This class sponsored by Awards for All, Community Fund We prioritize the area of Gorgie-Dalry-Saughton where our studio is based. By attending this class you release the teacher, Giada Gaslini and Art and Spirituality Cic, from any liability arising out of any personal injuries, emotional or physical release, death, expectations of results, theft in the venue or damages that may happen to people and objects while attending.
Microsoft Access Introduction - In-company (now with live online classes)
By Microsoft Office Training
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
Ever ever wished someone would just swoop right on in, sprinkle some magic on your photos or maybe just tell you exactly what to do and how to do it? On this half day, exclusive, in-person workshop, personal brand photographer Susan Heaton Photography will do just that! And it comes complete with an invaluable aftercare support package. Susan has been photographing small businesses in and around Edinburgh for 20 years! I love what I do! I have a wonderful network of business owners and I love sharing my tips and tricks to help them take their own photos - either to tide them over between brand shoots or to help them until they have the budget to get a professional in!” On the Stand Out Shots workshop you’ll learn how to use your phone using very little else (except perhaps a tripod) to take stand-out, professional-looking photos for your business, for social media, blog posts, profile images, website, marketing material and more. Susan will share tips, tricks and secrets she has gathered from 20 years of photographing small businesses in Edinburgh, to help you to take photos that stand out, and you will have invaluable post workshop access to a WhatsApp group for support with implementing what you have learnt. You will: learn how to make the most of the settings on your phone and what they all mean develop skills that will last a lifetime find out how to find the best light available get tips on how to arrange and style your photos practice top posing tips and find the ones that work best for you gain confidence and get rid of the awkward! network and connect with fellow workshoppers If you're self-employed and need some shots of you in action, or run a product-based business, this is the perfect workshop for you and will help you attract customers. But this workshop is not just for business owners, it's for anyone wanting to improve the way they take photos with their phone. What's included: half day workshop fuelled by light refreshments from local suppliers full after-care package so that you can always go back to Susan with questions in-person workshop is only available at The Arienas Collective Earth conscious credentials We are mindful of the effect we have on the environment, and do our best to minimise our impact. Your workshop correspondence and notes are sent to you electronically. Favourite feedback We love to hear what you think about our workshops. Here's a favourite review for Stand Out Shots: If you are wondering whether this course is for you, then it definitely is! I knew I had a great phone but absolutely zero knowledge of its capability or even how to use it! Susan's delivery is friendly, calm, patient and insightful and her experience is invaluable. Just learning the basics of my phone, and more about photo composition, lighting and editing tips has already paid dividends for my marketing posts. More information The Arienas Collective workshops, courses and events are run from a welcoming and supportive environment within a Georgian mews home in Edinburgh’s City Centre New Town. We invite you to join us, leave any day-to-day worries behind and immerse yourself in being creative. Spaces on our workshops and courses are limited so that our creative team of artists and makers can offer you the hands-on help and support you need to make the most of your time with us. Our taster and introductory workshops focus on teaching creative skills and methods you can continue practising at home, using affordable materials and equipment. Where more expensive equipment is required we will mention this in the workshop description. All the equipment and materials you need are included in the price, unless stated otherwise. Light refreshments from local suppliers are provided. On full day workshops you are welcome to bring your own lunch to eat inside or out. There is also a wide range of independent sit-in or takeaway delis, cafés, and restaurants, plus a range of supermarkets all within a 5-10 minute walk. Accessibility The workshop space is on the first-floor of our Georgian mews home and unfortunately we do not have lift access. Blue badge holders can park outside our front door on the single yellow line by arrangement. Allergies The workshop space is in our open plan living space and is not nut free. Please let us know about any skin or food allergies before booking. We offer a dairy-free milk and gluten free snack alternative. Minimum number no refund policy To ensure we can always pay our creatives a fair fee, we require a minimum number of bookings for each workshop and for this reason bookings are non-refundable. Should we have to cancel due to low numbers, we will offer you the option to swap to an alternative date or workshop, or to request a refund. We do our very best to avoid cancellations. Since we often get late bookings, we keep our workshops on sale for as long as possible. We realise that some of you travel from afar, so if you book a space and have not yet received an email confirming your workshop is going ahead and need to make plans for your trip, please get in touch before booking any travel or accommodation so we can update you on booking numbers. Or check in before booking. Private workshop bookings Most of our workshops are also available to book for: private get-togethers with family and friends; themed wedding and birthday celebrations; corporate team building and well-being purposes; and in-store retail events for your customers. If you’d like to know more please Email Lynn. Age restrictions Our workshops are planned with adults in mind. Many are suitable for teenagers, but some may require under 16s to be accompanied for insurance purposes. Please check with us before booking.
Access - intermediate (In-House)
By The In House Training Company
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
