Why use select queries for a form?

[syntaktik]

While looking up examples of databases, i have come across a pattern that people are making a table, and an "extended table" with a query, and then make a form. Is there a benefit of doing that over directly using the table

 

[boblarson]

While looking up examples of databases, i have come across a pattern that people are making a table, and an "extended table" with a query, and then make a form. Is there a benefit of doing that over directly using the table

Tables are not stored in any specific order. Many people actually believe that a table stores data in the order in which it was entered. But that is simply not the case. Each time you run compact and repair, Access will attempt to present table data using the primary key, if possible, but it is not guaranteed and it will also get quickly out of order if data is added and deleted. Queries allow you to set a sort order which will be consistent.

And, by the way, an Order By set on a table will not propagate to the form.

 

[syntaktik]

does that mean I should be using queries also? Or only for large databases?

 

[boblarson]

does that mean I should be using queries also? Or only for large databases?

I suggest using queries instead of the table.