Hi Richard, here is a quiz of my own that demonstrates some key concepts in database.  Has any student asked you about this before, or has a TechHelp video been made?  This is a somewhat tricky problem that we may come across once in a while, or perhaps quite often.  

In the list of names below, sorted by last name and then first name, how do you create a query that only displays names from "Mitchell, Sophia" onwards?  In other words, the query should find the proper "cut off point" and return only the last 10 names in this list below, starting from "Mitchell, Sophia".

ID     LastName     FirstName
972    Anderson     Alexander
956    Bennett      James
341    Bennett      Henry
36     Brooks       Noah
576    Carter       Olivia
108    Coleman      Mia
166    Cooper       Benjamin
571    Edwards      Samuel
576    Edwards      Liam
729    Hayes        Isabella
740    Mitchell     Sophia
806    Mitchell     Ava
179    Parker       Daniel
459    Peterson     Grace
627    Phillips     Chloe
159    Reynolds     Ethan
239    Richardson   Charlotte
379    Sullivan     Emma
507    Turner       Lucas
33     Wallace      Amelia

You can't use the condition:

   LastName >= "Mitchell" And FirstName >= "Sophia"

because that will miss "Mitchell, Ava".  The FirstName field is *not* necessarily sorted ascendingly from record to record, so you can't use the ">=" operator, nor any operator -- because there is no discernible order in the FirstName field, since it is a secondary sort field.  

The ID field doesn't help us either.  It is an autonumber field that increments by one every time a new record is entered.  The names were not entered alphabetically -- think of them as employees of a company, whose names were entered in the order of when they were hired.

Anyone interested in solving this, please post your answer below.  There may be more than one answer.  Ideally, the solution should cause no change to the table's structure.  But any solution is fine if the problem can be solved, which is the bottom line.