Tips of linking the database to form for better the performance in Visual Studio 2010

[Candace]

I am working on the software project of Visual Studio 2010. I am new user to this Visual Studio 2010 environment. I have connected the database to the forms created in Visual Studio 2010. But these forms are not working well according to the performance. I am not getting the performance I want to get through this form. So I need to know the tips for enhancing the performance of the forms.

[ChrisUlrich]

I will like to mention some of the tips for linking the database to form for better performance.
1. It will be better if you avoid the record navigation on the linked tables. The better option will be to use PageUp and PageDown movements.
2. If the form consists of only adding records then it will better if you use “DataEntry” commands for the “Records” menu.
3. Use less number of data returned queries mean try to use minimum number or fields and records that require filter on returned queries.
4. If you are linking more than one table in your query then avoid using aggregate functions.