Explore this Article
X
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.
The wikiHow Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 60,108 times.
Learn more...
This article will help describe how to create a unique collection of your music using Microsoft Access.
Steps
-
1Collect 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.)
-
2Determine what data you would like access to contain about the CD, ie Album Name, Album Artist... etc.Advertisement
-
3Open Microsoft Access.
-
4Go to File -> New.
-
5Select Blank Database.
-
6Save the Database using a name like "CD Collection" or something else descriptive.
-
7Select Create Table in Design View, on the Project Window.
- Next you will see a window with Field Name and Data Type.
-
8Enter the first of the fields you chose to sort the data by in the Field Name, ie Album Artist, Album Name.
-
9Use Text as the Data type for all categories.
-
10Enter a description for each category next to the data type, if you wish.
-
11Set a primary key, that is one Field designated as the main field of the table.
-
12Save the table as CD Collection or something else descriptive when finished.
-
13Open the Table in the Projects Window.
-
14Enter the CD data from your CD collection.
-
15Save the table when you are finished entering the data.
Advertisement
Warnings
- This might take a long time if you have a large collection of CDs.⧼thumbs_response⧽
Advertisement
Things You'll Need
- Your CD Collection
- Microsoft Access
You Might Also Like
![Use Microsoft Access](./images/3753325126--crop-342-184-245px-Use-Microsoft-Access-Step-46-Version-3.webp)
![Hack Into a Windows User Account Using the Net User Command](./images/543508281--crop-342-184-245px-Hack-Into-a-Windows-User-Account-Using-the-Net-User-Command-Step-22.webp)
How to
Hack Into a Windows User Account Using the Net User Command
![Learn Data Entry](./images/1683761030--crop-342-184-245px-Learn-Data-Entry-Step-9.webp)
How to
Learn Data Entry
![Reset SA Password in SQL Server](./images/2195732902--crop-342-184-245px-Reset-SA-Password-in-Sql-Server-Step-42-Version-3.webp)
How to
Reset SA Password in SQL Server
![Import Web Data Into Excel on PC or Mac](./images/1145255628--crop-342-184-245px-Import-Web-Data-Into-Excel-on-PC-or-Mac-Step-20.webp)
How to
Import Web Data Into Excel on PC or Mac
![Order Alphabetically in SQL](./images/1281046089--crop-342-184-246px-Order-Alphabetically-in-SQL-Step-4-Version-2.webp)
![Delete Duplicate Records in Oracle](./images/2240230709--crop-342-184-243px-Delete-Duplicate-Records-in-Oracle-Step-13.webp)
How to
Delete Duplicate Records in Oracle
![Hack a Database](./images/1392191199--crop-342-184-243px-Hack-a-Database-Step-10.webp)
How to
Hack a Database
![Add Data to a Pivot Table](./images/2990026137--crop-342-184-245px-Add-Data-to-a-Pivot-Table-Step-11.webp)
How to
Add Data to a Pivot Table
![Make an Inventory Database in Access](./images/584006467--crop-342-184-245px-Make-an-Inventory-Database-in-Access-Step-6Bullet1.webp)
![Create a Database from an Excel Spreadsheet](./images/2184526732--crop-342-184-245px-Create-a-Database-from-an-Excel-Spreadsheet-Step-34.webp)
How to
Create a Database from an Excel Spreadsheet
![Make a Database Using MS Access](./images/1438398688--crop-342-184-245px-Make-a-Database-Using-MS-Access-Step-16-Version-3.webp)
How to
Make a Database Using MS Access
![Download Microsoft Access](./images/3039573467--crop-342-184-244px-Download-Microsoft-Access-Step-5-Version-2.webp)
How to
Download Microsoft Access
![Link Tables in Access](./images/1224420137--crop-342-184-245px-Link-Tables-in-Access-Step-13.webp)
How to
Link Tables in Access
Advertisement
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