How to Keep Track of Your CD Collection Using Microsoft Access

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

Steps

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
Determine what data you would like access to contain about the CD, ie Album Name, Album Artist... etc.

Advertisement
3
Open Microsoft Access.
4
Go to File -> New.
5
Select Blank Database.
6
Save the Database using a name like "CD Collection" or something else descriptive.
7
Select Create Table in Design View, on the Project Window.
- Next you will see a window with Field Name and Data Type.
8
Enter the first of the fields you chose to sort the data by in the Field Name, ie Album Artist, Album Name.
9
Use Text as the Data type for all categories.
10
Enter a description for each category next to the data type, if you wish.
11
Set a primary key, that is one Field designated as the main field of the table.
12
Save the table as CD Collection or something else descriptive when finished.
13
Open the Table in the Projects Window.
14
Enter the CD data from your CD collection.
15
Save the table when you are finished entering the data.