Open or create the Access database you want to edit. Click the tab of the table you wish to open in design view. Click the "View" menu icon and click "Design View." ...

In "Design View", go to "View => Datasheet View" in the menu bar. Now, simply enter the name of a few artists in your music collection and choose their Genre of music from your drop-down menu. You'll ...