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

Chapter 7. Creating and Working with Sim... > Working in Query Datasheet View

Working in Query Datasheet View

When you’re developing an application, you might need to work in table or query Datasheet view to help you load sample data or to solve problems in the queries, forms, and reports you’re creating. You might also decide to create certain forms in your application that display information in Datasheet view. Also, the techniques for updating and manipulating data in forms are very similar to doing so in datasheets—so you need to understand how datasheets work to be able to explain to your users how to use your application. If you’re using Access as a personal database to analyze information, you might frequently work with information in Datasheet view. In either case, you should understand how to work with data editing, and the best way to learn how is to understand viewing and editing data in Datasheet view.

Before you get started with the remaining examples in this chapter, open ContactsDataCopy.mdb from your sample files folder. In that database, you’ll find a query named qryContactsDatasheet that we’ll use in the remainder of this chapter. I defined this query to select key fields from tblContacts and display a subdatasheet from tblContactEvents.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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