Change Location × London, UK

    Recent Locations

      MS Access Database Advanced 2-Day Course Private 1-to-1, London in Charing Cross


      • MS Access Database Advanced 2-Day Course Private 1-to-1, London Photo #1
      1 of 1
      February 14, 2019

      Thursday  11:00 AM (on various days)

      8 Northumberland Avenue
      Charing Cross, Greater London WC2N 5BY

      Performers:
      • No Performers Listed
      EVENT DETAILS
      MS Access Database Advanced 2-Day Course Private 1-to-1, London

      MS Access Database Advanced Course, Private 1-to-1 Course summary Course Aims (Access 2003, 2007, 2010, 2013, 2016 and Mac) This course is offered one-to-one, for individual attention to your requirements. This private style tuition helps to maximise the value that each delegate gets from the day. This course will help you to structure, import, manage and query your data effectively. Advanced forms. Macro buttons linking forms and Menu systems. Power Queries. Course Outline Advanced Data Management Database design: planning the database and its purpose Referential Integrity Creating tables, datatypes, primary keys Table Relationships Importing data, and the planning of data migration An Introduction to SQL Queries Brief Query revision Forms Tasks Using Subforms Creating a Navigation Form Restricting Form Entries - controlling input Exporting a Form Other Form Tasks Creating reports Access Macros SQL and Microsoft Access Understanding SQL Using the SELECT Statement Using Subqueries Using SQL Joins

      Categories: Science

      This event repeats on various days: Apr 25, May 2, May 9

      Event details may change at any time, always check with the event organizer when planning to attend this event or purchase tickets.