|
Queries
ask questions. Queries can look up information as well as manipulate
the data in the Tables. For example, a query can search for and
modify the rental price for all the old movies. Query
Views: Design and Datasheet The
Design View helps you select the tables and work with the
data. For example, the query on this page looks at the Movies table
and counts the movies by the Genre. The Datasheet View
displays the records in the Movie Table. Query
Options: Query Types Select
Queries look for records that match your criteria. Say you
wanted to find the movies released before 1999. Action
Queries change or update the data. The Action queries include: Make Table Append
(Add new records) Update
(Modify the records) Crosstab
(Analyze the records) Delete Keep
going...
Microsoft Access: Sample Database Query
|
|
| |
