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
The Ultimate Guide to Using Microsoft Access
How to
Hack Into a Windows User Account Using the Net User Command
How to
Learn Data Entry
How to
Reset SA Password in SQL Server
How to
Import Web Data Into Excel on PC or Mac
How to Order Alphabetically in SQL
How to
Delete Duplicate Records in Oracle
How to
Hack a Database
How to
Add Data to a Pivot Table
How to Make an Inventory Database in Access: Complete Guide
How to
Create a Database from an Excel Spreadsheet
How to
Make a Database Using MS Access
How to
Download Microsoft Access
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