Click the Run button or the Datasheet View button on the Design tab to view the query’s results (see Figure 36-10).

Working with records in Datasheet view is covered in detail in Chapter 36. As you can see in that chapter, filtering, sorting, rearranging, and searching within a datasheet is quite easy. Our simple select query did not transform the data in any way, so the data shown in Figure 36-10 is completely editable. We can modify existing data, delete rows, and even add new records to this data set, if we want.

When you’re working with data in the datasheet, all the table and field properties defined at the table level are in effect. Therefore, validation rules, default values, and other properties assert themselves even though the datasheet is the result of a query.

FIGURE 36-10
The datasheet view of the query.

Earlier versions of Access referred to an updatable datasheet as a Dynaset. This expression emphasized the fact that the datasheet was dynamically linked to its underlying data sources. However, this expression has fallen by the wayside because very often the data in a query’s datasheet is not updatable. For instance, transforming the data in any way, such as combining first and last names as a single field, makes the datasheet non-updatable. You’ll see data transformations later in this chapter.

At any time, clicking the Design View button on the Home tab of the Ribbon returns you to Query Design mode.

• Discover The Magic Of Running Your Own Internet Business Running a successful Internet business is one of those magical things some people can only dream about. However the reality...
• DSLR Canon Camera EOS 550D (Rebel T2i / X4 Digital) Preview [/caption] Preview based on a pre-production DSLR Canon Camera EOS 550D Less than a year after the launch of the...
• UK financial picture continues to look bleak. Rumours have it that Bank of England governor Mervyn King may have had some serious explaining to do Chancellor Alasdair...
• Linkin Park Promise 'Catalyst' Video Will Be 'Very Different' LP's DJ 'likes to go for something big,' bassist Phoenix Farrell tells MTV News of Joe Hahn-directed clip.By James Montgomery...
• OnPar Golf Touchscreen GPS User Reviews Send this to a friend OnPar Golf Touchscreen GPS Manufacturer: OnPar Customer Rating: List Price: $479.95 Sale Price:...