Category Archives: SQL MS Access

SQL Azure to MS Access – Using VBA to Dump Azure Tables into MS Access Tables

The first thing you need to get sorted when moving to SQL Azure is having the ability to get your information out and safe if needs be. When experimenting with MS Azure and for applications that don’t have sensitive information … Continue reading

Posted in All, MS Access, Productivity, Programming, SQL Azure, SQL MS Access, SQL Server, VBA Code MS Access | Comments Off on SQL Azure to MS Access – Using VBA to Dump Azure Tables into MS Access Tables

MS Access front end – SQL Azure back end Link to Configuration Set UP FMS Group

This is an excellent article on linking MS Access to SQL Azure – which is just great if you are wanting to use your VBA skills direct on your SQL Database. FMS Professional Solutions Group – Luke Chung MVP article … Continue reading

Posted in All, SQL Azure, SQL MS Access, SQL Server | Comments Off on MS Access front end – SQL Azure back end Link to Configuration Set UP FMS Group

Ranking of Child Records according to Groups

Imagine you have a school full of Students and they have done a variety of exams. All results are collected in a table and you would like to obtain rankings by subject. How can you automatically rank all the students … Continue reading

Posted in All, SQL MS Access, VBA Code MS Access | Comments Off on Ranking of Child Records according to Groups

Using SQL to parse, clean and format strings

Many datasets can be somewhet confused by the time you get them. Maybe you had no control of the export from the database or maybe you asked for the right information and it came back somewhat warped. SQL has powerful … Continue reading

Posted in All, Data Cleansing, SQL MS Access, VBA Code MS Access | Comments Off on Using SQL to parse, clean and format strings

Forcing or Limiting Columns Using Cross Tab Queries

MS Access has a version of SQL that can be edited to enforce specific columns being shown in queries. Within the query editor navigate to the SQL View Normally when a cross-tab query is selected MS Access will generate columns … Continue reading

Posted in All, Database Design, MS Access, SQL MS Access | Comments Off on Forcing or Limiting Columns Using Cross Tab Queries

A detailed explanation of the Algebraic modeling using SQL for a Race Timing System

I know I’ve given an overview of what I did to create the timing system but here is the kernel explanation of the algebra modeled in SQL that does the real heavy lifting in my system and probably most other … Continue reading

Posted in All, Applied Mathematics, MS Access, SQL MS Access | Comments Off on A detailed explanation of the Algebraic modeling using SQL for a Race Timing System

MS Access SQL for randomising the results from a query

I was wanting to randomize the source of a form so that I could test myself on some Russian within a table. Turns out its very simple. Basing a Query on the following SQL will achieve it. SELECT TableName.PKID, TableName.Field1, … Continue reading

Posted in All, Database Design, MS Access, Programming, SQL MS Access | Comments Off on MS Access SQL for randomising the results from a query