Search Tips
Advanced Search
Sams Teach Yourself Microsoft Access 2000 in 24 Hours
by Timm Buchanan; Craig Eddy
Sams, Macmillan Computer Publishing
ISBN: 0672312891 Pub Date: 04/29/99
Search this book:
Previous
Table of Contents
Next
Closing Queries
When you finish working with a query, click the box with the X in the top-right corner. If you made any
changes to the query’s fields or properties, you are prompted to save those changes. Because, for now, you’re
only looking at queries and how they are defined, click No to avoid changing the Northwind database. You
also can close a query window by pressing Ctrl+F4.
Summary
This hour showed you how an existing query is structured and how to view, sort, and filter the data returned
by the query. In the next hour, you’ll learn all about finding and editing data by using Access 2000 forms.
You’ll learn more about queries in Hours 11 and 18.
Workshop
The Workshop is designed to help you anticipate possible questions, review what you’ve learned and begin
thinking ahead to putting your knowledge into practice. The answers to the Quiz are in Appendix A.
Q&A
Q When I open the Customers and Suppliers By City query in Datasheet View, I cannot type in any
of the cells. Why is this.
A This query is a union query. Union queries are not updatable. You should update the tables that make
up the query instead. Also, union queries cannot be opened in Grid Design View.
Q When I attempt to open the Employee Sales By Country query, I am prompted to enter a
Beginning Date and an Ending Date. What causes this to happen.
A This query uses two parameters in its query definition:
[Beginning Date]
and
[Ending
Date]
. Access requires values for these parameters before the query’s datasheet can be constructed.
See Hour 18, “Creating Queries," for more information on parameters in queries.
Quiz
Title
-----------
|
|