Suppose you have a table named Cars with fields that store the name - year - price - and condition of used cars that you are considering for purchase. Also suppose that the table has become large and that you frequently include the Year field in queries. You can create an index on the Year field so that your queries return results more quickly. Which syntax will you use to achieve this?

🎲 Try a Random Question  |  Total Questions in Quiz: 45  |  🧠 Study this quiz with Flashcards
This question is part of a full practice quiz:
Microsoft Access 2010 Test — practice the complete quiz, review flashcards, or try a random question.

Practice this Upwork Skill Test. Freelancers take skill tests on Upwork to show their skills to potential clients and to make themselves more marketable. Upwork suggests you take as many tests as you want -  your skills are shown on your Upwork profile page.


Suppose you have a table named Cars with fields that store the name - year - price - and condition of used cars that you are considering for purchase. Also suppose that the table has become large and that you frequently include the Year field in queries. You can create an index on the Year field so that your queries return results more quickly. Which syntax will you use to achieve this?