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
This one-day workshop focuses on building a professional presentation from scratch, giving you essential hints and tips on how to utilise the key features of PowerPoint, including speaker notes, inserting charts, diagrams and pictures, and utilising slide transitions and animation. You will also learn about PowerPoint templates and themes to ensure your presentations have the best impact. This course will help participants: Using Slide Master Create a presentation using a template Insert slides and change the layout Manage slides and control formats Enhance slides using animation, pictures, charts and graphics Work with tables, rows, cells and columns Create and control paragraph lists Insert titles and labels Effectively use slide show controls and presenter view Print slides, handouts and notes 1 Introduction to PowerPoint Navigating the features Creating a simple presentation Inserting new slides and changing layouts Creating speaker notes 2 Using Layouts in Slide Master Editing templates in slide master Adding a design theme Adding transitions, pictures and logos Using Slide Show View 3 Drawing shapes and SmartArt Using Drawing Tool Formats Creating shapes Aligning shapes and stacking order Creating a cycle graphic Creating an organisation chart 4 Animation Visually enhancing slides with animation Using text and object animation Adding animation to lists Making animation work for you 5 Presenting Confidently running a presentation Using presenter view Using the slide show controls
This one-day workshop is designed to enhance your PowerPoint skills to achieve dynamic presentations that work with you, making it easier to deliver a polished, professional presentation. You will learn advanced PowerPoint skills that will save you time and elevate your presentations. This course will help participants: Create custom shows to personalise presentations for individual clients Make the Slide Master work collectively with slide layouts and themes Seamlessly interact with external content using links Work with advanced animations and transitions, and video/audio tools 1 Themes and Masters Add a Design theme to a presentation Make changes to the Slide Master Delete layouts from the slide master Saving a slide master with themes as a template 2 Advanced graphics and diagrams Drawing, duplicating and resizing shapes Grouping, aligning and stacking shapes and graphics Using SmartArt for diagrams and organisation charts 3 Graphs and charts Inserting and formatting a chart Linking an Excel chart to a slide Linking Excel tables to a slide Animating charts 4 Video, Custom animation and Hyperlinks Adding and editing video Animating pictures and drawings Hyperlink to another Slide or Website Compressing and optimising media 5 Presenting Reuse slides Hide slides Rehearsing timings Enabling a presentation to run continuously
Upskill your knowledge with Time Training Center’s Python Classes in Abu Dhabi.In this course you will master Python’s fundamental skills and web frameworks.Learn the core concepts of python such as data structures, algorithms and its implementation. Enroll now! Call us: 97126713828 Mail : info@timetraining.ae Learn more:https://www.timetraining.ae/course/python-training-course Address: Office 203, ADCP Tower - B,Behind City Seasons, Electra Street, Abu Dhabi United Arab Emirates
Improove your excel skills with Time Training Center’s advanced excel course in Abdu Dhabi. Our advanced Training can help you master the latest functions and tools in MS Excel.Acquire multiple skills, such as calculating, evaluating, organising, and coordinating data through spreadsheets. Enroll now! Call us: 97126713828 Mail : info@timetraining.ae Learn more:https://www.timetraining.ae/course/advanced-excel-course-in-abu-dhabi Address: Office 203, ADCP Tower - B,Behind City Seasons, Electra Street, Abu Dhabi United Arab Emirates
Nurture your child’ s skills with Time Master Skills Development Centre’s Skill Development Courses For Kids in Abu Dhabi.We provide a wide range of skill development courses such as personality development,chess,robotics coding and many more.With our child development courses improve your child’s life skills to make he/her a better person in the future. Call us:02 6739171 Mail : info@timemaster.ae Learn more:https://timemaster.ae/skill-development-courses Address:112576, ADCP Tower B,Office 404, Behind City Seasons, Electra Street,Abu Dhabi - United Arab Emirates
Upgrade your cyber security skills with Time Training Center’s Cyber Security courses in Abu Dhabi. Learn how to safeguard networks and data from cyber threats. With our cyber security courses you will Learn the latest penetration testing techniques,various types of cyber threats,ways to tackle cyber threats and many more. Enroll now! Call us: 97126713828 Mail : info@timetraining.ae Learn more:https://www.timetraining.ae/course_category/cyber-security-courses-in-abu-dhabi Address: Office 203, ADCP Tower - B,Behind City Seasons, Electra Street, Abu Dhabi United Arab Emirates
Improove your child’s arithmetic and problem solving skills with Time Master skill development center’s Maths coaching courses in Abu Dhabi .Our courses are designed in a way to improve your child’s academic,creativity and problem solving skills.Our team of well trained teachers make sure that your child have a deep understanding of mathematical concept with both curricular and co-curricular activities. Call us:02 6739171 Mail us, at info@timemaster.ae Learn more:https://timemaster.ae/maths-coaching Address:112576, ADCP Tower B,Office 404, Behind City Seasons, Electra Street,Abu Dhabi - United Arab Emirates
Provide your child with best of education with Time Master skill development center’s academic coaching courses in Abu Dhabi.Our courses include e learning assistance,science and maths.With our courses your child will have best of learning experience with in a stress free atmosphere .Our highly qualified teachers make sure that your child have the basic foundation for a better future. Call us:02 6739171 Mail us, at info@timemaster.ae Learn more:https://timemaster.ae/coaching-classes Address:112576, ADCP Tower B,Office 404, Behind City Seasons, Electra Street,Abu Dhabi - United Arab Emirates
Up skill your autocad skills with Edoxi’s AutoCAD courses in Dubai.Learn how to create 2D and 3D drawings, plans, and models for product design, building design, structural engineering, electrical design etc.With Edoxi’s AutoCAD courses you will master tools and techniques to improve your productivity and adapt to a variety of design requirements. Enroll now! Call us: +971 4380 1666 Mail us, at info@edoxi.com Learn more:https://www.edoxi.com/autocad-courses Address: Office 504, Bank Street Building, Next to Burjuman Metro Station Exit 3, Khalid Bin Al Waleed Rd, Dubai, United Arab Emirates