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.

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.

Step 2: Created HIG Find Scales Modes Query.

Step 3: Run HIG Find Scales Modes Query.

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