• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. What Every Developer Needs to... > Basing Forms on Queries: The Why and...

Basing Forms on Queries: The Why and How

Chapter 2, “A Strategy for Developing Access Applications,” covered strategies for developing Access applications. One strategy is basing forms on queries; by doing this, you generally get optimal performance and flexibility. Rather than bring all fields and all records over the network, you bring only the fields and records you need. The benefits are even more pronounced in a client/server environment where the query is run on the server. Even in an environment where data is stored in the proprietary Access file format (.MDB) on a file server, a form based on a stored query can better take advantage of Access's indexing and paging features. By basing a form on a query, you also have more control over which records are included in the form and in what order they appear. Finally, you can base a form on a query containing a one-to-many join, viewing parent and child information as if it were one record. Notice in Figure 6.39 that the client and project information appear on one form as if they were one record.

Figure 6.39. A form based on a one-to-many query.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint