This article will help describe how to create a unique collection of your music using Microsoft Access.
Steps
-
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.)
-
Determine what data you would like access to contain about the CD, ie Album Name, Album Artist... etc.Advertisement
-
Open Microsoft Access.
-
Go to File -> New.
-
Select Blank Database.
-
Save the Database using a name like "CD Collection" or something else descriptive.
-
Select Create Table in Design View, on the Project Window.
- Next you will see a window with Field Name and Data Type.
-
Enter the first of the fields you chose to sort the data by in the Field Name, ie Album Artist, Album Name.
-
Use Text as the Data type for all categories.
-
Enter a description for each category next to the data type, if you wish.
-
Set a primary key, that is one Field designated as the main field of the table.
-
Save the table as CD Collection or something else descriptive when finished.
-
Open the Table in the Projects Window.
-
Enter the CD data from your CD collection.
-
Save the table when you are finished entering the data.Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
- Save Regularly.Thanks
- It may be quicker to find a program that can automatically create an excel spreadsheet of your CD collection, and use that instead.Thanks
Advertisement
Warnings
- This might take a long time if you have a large collection of CDs.Thanks
Advertisement
Things You'll Need
- Your CD Collection
- Microsoft Access
About this article
Thanks to all authors for creating a page that has been read 64,598 times.
Advertisement
