After you have created and saved a query, you can open the query. Opening an existing query will cause the query to run and display the results. You do not need to create a new query each time data in the corresponding table is modified. Each time the query is run, any changes made to the data in the table will be reflected in the query results.
Be sure Queries is selected on the Objects bar, and then double-click your 2A Query1 saved in Activity 2.6.
On the Query Datasheet toolbar, click the View button to switch to the Design view.
Another Way: To Open a Query in Design View
Use the Design Button on the Database Window
You can also open a query directly in the Design view. In the Database window, select the query, and then on the Database window toolbar, click Design.
In the design grid, point to the selection bar above the Donor Last Name field until the pointer displays as shown in Figure 2.14.
Click to select the Donor Last Name column, and then press .
Using the technique you just practiced, in the design grid, select the Club Affiliation column. Then, point to the selection bar at the top of the selected column to display the white selection pointer , drag to the left to position Club Affiliation in the first column, and then compare your screen with Figure 2.15.
On the Query Design toolbar, click the Run button .
On the Query Datasheet toolbar, click the View button to return to Design view. Leave your query open in Design view for the next activity.
Chapter One. Creating Documents with Microsoft Word 2003
Chapter Two. Formatting and Organizing Text
Chapter Three. Using Graphics and Tables
Chapter Four. Using Special Document Formats, Columns, and Mail Merge
Chapter One. Creating a Worksheet and Charting Data
Chapter Two. Designing Effective Worksheets
Chapter Three. Using Functions and Data Tables
Chapter One. Getting Started with Access Databases and Tables
Chapter Two. Sort, Filter, and Query a Database
Chapter Three. Forms and Reports
Chapter One. Getting Started with PowerPoint 2003
Chapter Two. Creating a Presentation
Chapter Three. Formatting a Presentation
Chapter One. Using Access Data with Other Office Applications
Chapter Two. Using Tables in Word and Excel
Chapter Three. Using Excel as a Data Source in a Mail Merge
Chapter Four. Linking Data in Office Documents
Chapter Five. Creating Presentation Content from Office Documents
GO! with Microsoft Office 2003 Brief (2nd Edition)
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)