Running a Query


graphics/06inf24.jpg

graphics/one_icon.jpg

After you've opened the database that contains the query, click the Queries option in the Objects bar.

graphics/two_icon.jpg

Any queries you have created and saved are listed. Click the query you want to open .

graphics/three_icon.jpg

Click the Open button in the database window's toolbar.

graphics/four_icon.jpg

Access runs the query and displays the results.

INTRODUCTION

When you want to view the results of a query, you run or open the query from the database window.

TIP

Opening and Closing Queries

If you prefer, you can double-click a query in the database window to open it. To close a query, click its Close button.

TIP

Editing and Adding Data

If you change or add data to a query, the associated database table is updated to reflect those changes. In this way, you can use a query to edit and add data.



Easy Microsoft Office Access 2003
Easy Microsoft Office Access 2003
ISBN: 789729598
EAN: N/A
Year: 2003
Pages: 174

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