I am no programer but I played with and used MS Access. When I created tables, form etc I read that the suggested way to name was to include either tbl, frm etc so your able to know what you are using when you start building queries etc.
IE: book tbl, library rpt, etc.
Is this a good practice to continue to use in LO Base too.
Hello,
Have used Access years ago and Base for a few years now. Personally have not and do not prefix these items. I see no benefit in doing this. For example, you have a table of books. Now your naming would be (and please don’t use spaces in naming as it will only give you headaches) tbl_books. Now you mention to know for queries. Well if I have a query on the books table it will most likely not be the same result as the table. It is possibly a selection by authors. So why not just name it books_authors based upon the books table? Or is it logical that you are going to use the books table in a form called videos? Not certain it really matters. Now field names in a table/query may be an entirely different story.
If the use of these indicators helps you, there is no reason not to use them. Just please avoid using spaces in naming conventions - anywhere! Seen too many issues when this is not followed.
Thanks for the explaining, I will eliminate spaces as you suggested too. Like I said I’m a rookie to db but love playing with it and trying to make things work. I believe when I was trying to build queries it really helped me.
You are welcome.
As with all questions, if this has answered your question please tick the 
(upper left area of answer). It helps others to know there was an accepted answer.