This article will help describe how to create a unique collection of your music using Microsoft Access.

Steps

  1. 1
    Collect all of the music CDs that you own into a large pile. (There is no need to alphabetize as this can be done later inside Microsoft Access.)
  2. 2
    Determine what data you would like access to contain about the CD, ie Album Name, Album Artist... etc.
    Advertisement
  3. 3
    Open Microsoft Access.
  4. 4
    Go to File -> New.
  5. 5
    Select Blank Database.
  6. 6
    Save the Database using a name like "CD Collection" or something else descriptive.
  7. 7
  8. 8
    Enter the first of the fields you chose to sort the data by in the Field Name, ie Album Artist, Album Name.
  9. 9
    Use Text as the Data type for all categories.
  10. 10
    Enter a description for each category next to the data type, if you wish.
  11. 11
    Set a primary key, that is one Field designated as the main field of the table.
  12. 12
    Save the table as CD Collection or something else descriptive when finished.
  13. 13
    Open the Table in the Projects Window.
  14. 14
    Enter the CD data from your CD collection.
  15. 15
    Save the table when you are finished entering the data.
  16. Advertisement

Warnings

Advertisement

Things You'll Need

  • Your CD Collection
  • Microsoft Access

About This Article

Tested by:
wikiHow Technology Team
wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, 11 people, some anonymous, worked to edit and improve it over time. This article has been viewed 60,108 times.
How helpful is this?
Co-authors: 11
Updated: January 31, 2023
Views: 60,108
Categories: Databases
Advertisement