Ask Your Question

Database creation

asked 2020-12-11 13:44:07 +0200

KAC352 gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-12-11 18:30:29 +0200

Ratslinger gravatar image


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.

edit flag offensive delete link more


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.

KAC352 gravatar imageKAC352 ( 2020-12-11 18:38:38 +0200 )edit

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.

Ratslinger gravatar imageRatslinger ( 2020-12-11 18:44:24 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-12-11 13:44:07 +0200

Seen: 36 times

Last updated: Dec 11 '20