Scales and Modes XML and ADO Recordset Example

I originally created a spreadsheet of all of the Major and Minor Keys and different Modes used in Guitar music. You can view a copy of this find_scales.xls.

While learning some theory concepts specifically related to Guitar music, I decided to create a web application that could quickly tell me what would be the Major and Minor Keys(that I was playing), as well as all of the different Modes that apply to the Guitar. The animated *.gif below shows how the lookups work by placing the proper note character in the field.

I am still expanding this database and application(as well as my musical knowledge) and will eventually port it over to the Pocket PC. I just need to figure out a way to consolidate the content presentation. As always, I can provide copies of the source code, xml files or even database upon request.

Web Application which SQL queries HIG Find Scales Modes.MDB and displays XML and ADO recordset contents.

Step 1: Created a Microsoft Access Database and Table to store all Major and Minor Keys with Modes.

Notice below, that I created a HIG Find Scales Modes Database and a HIG Find Scales Table. I actually imported the find_scales.xls data into the new table.

Created HIG Find Scales Modes.MDB and HIG Find Scales Table to store all Major and Minor Keys and Modes.

HIG Find Scales Table settings from find_scales.xls.

HIG Find Scales Table contents from find_scales.xls.

Step 2: Created HIG Find Scales Modes Query.

Created HIG Find Scales Modes Query.

HIG Find Scales Modes Query SQL Statement.

HIG Find Scales Modes Query SQL Parameter.

Step 3: Run HIG Find Scales Modes Query.

HIG Find Scales Modes Query Results.

Step 4: Created HIG Find Scales Modes Data Access Page.

Created HIG Find Scales Modes Data Access Page.

Created HIG Find Scales Modes RecordSource Recordset.

Steven C. Howes and Howes-IT-Going are NOT Responsible for Usage or Reproduction.
This Web Application, Microsoft Access Database and Microsoft Excel Spreadsheet were for Educational and Discussion Purposes ONLY. Terms of use.