How to Create a Music Database Using Microsoft Access

Updated April 17, 2017

Among the many tools Microsoft Access offers for managing your data is an online library of database templates. You can customise these templates to make a database for storing information about your music collection. An essential step in this project is configuring Access to allow templates from prior versions of Access to load. Making a music database with Access allows you to manage your music collection, and introduces you to the procedures needed to make other types of databases from templates.

Download the Access "Music Collection" database template from the Microsoft Access template gallery.

Make a copy of the downloaded database template by clicking it in Windows Explorer, pressing "Control-C," then pressing "Control-V."

Rename the duplicated database "MyMusicDatabase," or another title that describes your music interests.

Open Access, then click the Microsoft Office button at the top left of the introductory Access screen.

Click the "Trust Center" link in the left pane. The "Trust Center" is a configuration window you use to tell Access you want to load databases from older versions of Access. The music database is one from a previous version of Access.

Click the "Trust Center" button at the bottom of the current window, then click the "Locations" link in the left pane.

Click the "Add location" button at the bottom of the current screen, then enter the name of the folder you downloaded the music database template to. This step tells Access to allow macros from all databases in the folder you indicated to run.

Close all open windows by clicking their "OK" buttons.

Double-click, in Windows Explorer, the "MyMusicDatabase" file you made in Step 2. Access will open the file.

Click the "Enter Recordings" link that appears in the introductory screen, then click the right-most icon with the right arrow, at the bottom of the data entry pane. This creates a blank record for you to enter a song's information into.

Type, in each field of the form, the information that describes a song whose details you want to store in the database. For example, in the "Title" field type "Hey Jude" or another song title. Repeat this step for each song you want to enter in the database.

Close the "Recordings" entry window by clicking its "X" icon in the window's upper right corner.

Display the reports menu by clicking the "Reports" link in the main screen.

Click any of the links that appears in the current form to display a report providing information on your music data. For example, click "Artist Report" to display a report with information about singers and musicians.

Click the "Exit" button at the bottom of the "Report" form when you're done managing your music data.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Darrin Koltow wrote about computer software until graphics programs reawakened his lifelong passion of becoming a master designer and draftsman. He has now committed to acquiring the training for a position designing characters, creatures and environments for video games, movies and other entertainment media.