When i create a table from scratch there is always a record and also when i run a query on the table there is always an empty record at the last line. Is there anyway to i cant get rid of it or hide it. it can be confusing and the user might add line that not suppose to be there.

thanks in advance

There is no empty record. What you are seeing is a visual clue that the recordset allows additions. If you want to enter a new record, you type in the empty row which is there for that purpose.

You can't avoid seeing the empty row when you open a table in datasheet view but then users should NEVER open tables directly. All user interaction should be through forms. You can control the way the form works with properties. You can set the AllowAdditions and AllowDeletions to No if you don't want users to add or delete records via that form.

when i use a query its shows an empty records aswell which is confusing for user. its okey if the list contain many records but when it only contain a few record it can look confusing

That may be a time to do it through a form like Pat suggested. That way, you have complete control over how it is displayed. You never want your users accessing the tables directly as they may or may not (usually the latter) know what changing a specific field will do in other parts of the DB.

However, Access has been using a very similar interface since Access 2.0 (around 1994), so if you're users are still this unexperienced after 17 years (unless they are under 17), that's a little strange. Even the biggest of the bigwigs where I work (a huge company) know how to use Outlook, Word, and some Excel and Powerpoint. The Access applications we provide all have very specific forms designed to look not like a database, as many people still don't see the difference between say Access and Excel (much less RAM and a hard drive).