Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access
The next Access Europe meeting will be onWednesday 1 Nov 2023starting at18:00 UK time (6PM UTC)and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on Sunday 29 Oct, whilst the USA remains on Daylight Savings until mid November. The start time for this meeting is equivalent to19:00 (7PM)inCentral Europeand (for this month only)11AMinSeattle / PST Due to the clock changes, please carefully checkWorld Time Buddythis month for all local times This session will be led byJohn Heaserwho is an experienced Access developer based in the U.K. Topic outline: SQL Serverhas aGeography data typethat can represent points, lines and polygons on the Earth’s surface. This data can be used to: • Find which polygons contain a point: e.g. find the Local Government Region for a location where you know the Latitude/Longitude (Lat/Long can be found from the PostCode) • Find the points that lie within a radius of a starting point and order them by distance: e.g. find the Stores that lie within 50 miles of a customer and show them in ascending order of distance This can be very useful for many purposes andSQL Servercalculates the results very fast - provided that suitableSpatial Indexesare defined. Unfortunately Access can’t work directly withGeography data types! However, you can make use ofGeography datainAccessby using: • Persisted Computed Columns • Scalar Functions • Stored Procedures • Triggers We will look at how these SQL skills can be used to bring the benefits of Geography data types to Access. The same skills can also be used to leverage the power of SQL Server to do other tasks that would be slow to perform or difficult to code, if done directly in Access. For more details about this month's presenter and session content, see:https://accessusergroups.org/europe/event/access-europe-2023-11-01/orhttps://isladogs.co.uk/aeu-21/ The meeting will again be held onZoom. When the time comes, you can connect using:Join Zoom Meeting. If you are asked, use:Meeting ID: 924 3129 5683 ; Passcode: 661210 For more connection options, please see theAccessUserGroups.orgweb page for this event As always, the session will be recorded and the video uploaded toYouTubeafter the event
