Audiobook Collection

[sam02]

Can anyone point me in the correct direction for a ready made template to record my audiobook collection. i have tried to make my own but its not gone well i had one a few years ago but i have changed computers and i dont remember what it was called please

[Welshgasman]

Look at the templates in your access version

[sam02]

Look at the templates in your access version

I have and not found anything suitable but thank you

[Welshgasman]

Have you tried to Google?

https://www.google.com/search?q=micr...hrome&ie=UTF-8

TBH I would have thought the basics would be
tblAuthor
tblBook

Perhaps tblCategory as well?

WHat more do you think you need?

And from the above link
https://download.cnet.com/access-tem...-76472069.html

[Micron]

WHat more do you think you need?

Some books are a collaboration with 2 or more authors, so maybe a junction table for that. Since it's about audio books, maybe a table for narrators but that might be a bit of a stretch.

[orange]

sam02,

Here is a link to a data model for a book collection. It should give you the basics. You may need to add/adjust to accommodate audio vs traditional, and perhaps narrator as micron suggested.

[Welshgasman]

Nice find Jack.
Audio could just be another format?

[orange]

Paul,

Very true. Usefulness depends on OP's requirement and ability. If you abstract book to audio book, video book....it should be helpful.

[sam02]

sam02,

Here is a link to a data model for a book collection. It should give you the basics. You may need to add/adjust to accommodate audio vs traditional, and perhaps narrator as micron suggested.

Wow thank you orange that looks like its what i have been looking for i have had a quick look but as you can expect i am busy today i just need to see if there is a sample file download. Thank you again
I have had another look and it just what i want but the website is down at the moment just need to get a sample of it

[Welshgasman]

Wow thank you orange that looks like its what i have been looking for i have had a quick look but as you can expect i am busy today i just need to see if there is a sample file download. Thank you again
I have had another look and it just what i want but the website is down at the moment just need to get a sample of it

Website is up for me?
However all you get is the Data Model, not a template.
YOU have to build your DB from that.

[orange]

See this for more info --not exactly book collection --but close enough for learning.

[Welshgasman]

I am sure there must be a template from MS. I have one in 2007 for online, but I cannot access any template online anymore, presumably due to the age of my Access version?

[sam02]

Website is up for me?
However all you get is the Data Model, not a template.
YOU have to build your DB from that.

Oh thank you I downloaded the relationship into word and with a few alteration it would be perfect but to build it all it’s above my skill set. But thanks for the I fo

[Welshgasman]

Look on YouTube.
Plenty of videos on how to construct tables, queries etc.

[sam02]

Look on YouTube.
Plenty of videos on how to construct tables, queries etc.

Hi i have looked and i can construct tables, queries, forms to a basic level but its the relationships that are above me