Question

1. Create an example of what a form in a database could look like. The form should have 5 fields to get the following information (Music ID, Album Name, Medium Type, Artist Name, and Release Year.) (You can sketch it using Paint, draw it on paper and scan it, use shapes in Word, use wireframe.cc and take a screenshot of the result and turn that in...sky's the limit)
2. Create an example report (same method used as the example form). This report display the information Music ID, Album Name, Medium Type, Artist Name, and Release Year in an organized manner with titles.
3. Create a table named tblMusic.
4. In the table, add fields called MusicID, AlbumName, MediumType, ArtistName, ReleaseYear.
5. Make MusicID the primary key. The MusicID should be simply a number (you can have it auto-generate, if you wish).
6. Create a form named frmMusic. This form should have 5 required fields.
7. Use the form to input five CDs, records, or other types of musical media. You can make up names or use real albums.
8. Create a report that displays the information from the tblMusic in an attractive and clear manner. Make sure all items are labeled and are visible. Name it rptMusic.

Answer 1

HI,

AS i understand your question, you wanted a database form, table and report..you didnt recommended any tool or language so i created all in MS Access.

1. In first image, i created a table tblMusic with 5 fields..refere below image.

2. In second image, i created a form to do a data entry by given database form.i design this form in MS Access.

3. In third image, i crated a report where all the tblMusic data is showing with header and date information.

Now i would like to know if you need MS access form and table with report as pdf or as other import method then let me know or comment in comment box , i will submit you those details.

Thanks