Objective 4. Open and Edit an Existing Query

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.

Activity 2.7. Opening and Modifying an Existing Query

1.

Be sure Queries is selected on the Objects bar, and then double-click your 2A Query1 saved in Activity 2.6.

The query opens in the Datasheet view, which you can use to view the records in a query result.

2.

On the Query Datasheet toolbar, click the View button to switch to the Design view.

Your query displays in Design view. Recall that the View button is used to change the display between viewing the records and viewing the design of an object.


[Page 984]

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.

3.

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.

Figure 2.14.


4.

Click to select the Donor Last Name column, and then press .

The Donor Last Name field is removed from the design grid and the Pledge Amount field moves to the third column in the design grid.

5.

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.

Figure 2.15.
(This item is displayed on page 985 in the print version)


To rearrange fields in the query, first select the field you want to move, and then drag it to a new position in the design grid.


[Page 985]

6.

On the Query Design toolbar, click the Run button .

The results of the query display three fields in the new arrangement.

7.

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.



[Page 985 (continued)]

Windows XP

Outlook 2003

Internet Explorer

Computer Concepts

Word 2003

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

Excel 2003

Chapter One. Creating a Worksheet and Charting Data

Chapter Two. Designing Effective Worksheets

Chapter Three. Using Functions and Data Tables

Access 2003

Chapter One. Getting Started with Access Databases and Tables

Chapter Two. Sort, Filter, and Query a Database

Chapter Three. Forms and Reports

Powerpoint 2003

Chapter One. Getting Started with PowerPoint 2003

Chapter Two. Creating a Presentation

Chapter Three. Formatting a Presentation

Integrated Projects

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
GO! with Microsoft Office 2003 Brief (2nd Edition)
ISBN: 0131878646
EAN: 2147483647
Year: 2004
Pages: 448

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net