access lesson 12 Flashcards
why do we store information in databases?
we expect to use that information in the future
why is the data needed?
to answer a question or support a decision
database queries
used to automate the process of extracting the information that we need
the Query Wizard
walks you through the process of creating a query by asking you a series of questions about what you want the query to include
the Query Design/Query by Example (QBE)
provides a graphical way to “drag and drop” the elements of your query until it is exactly how you want it
what is the first stem of a query design?
add tables we want to be part of the query
query is just another ____ of the data in the table
“view”
what is the best way to to sort query?
sort your query in the query design view
there are times that you may need a field to be part of a query, but you don’t want that field to be displayed as part of a query result. how do you overcome this problem?
add the city field to the query twice.
sort the query first by province and then by city.
then hide the second city field.
how do you prevent duplicate records from appearing in the query?
properties
unique values->YES
>
Returns all records larger than the specified value
> =
Returns all records that are at least as large as the specified value (including the value)
Returns all records that are smaller than the specified value
<=
Returns all records that are at least as small as the specified value (including the value)
=
Returns all records that are exactly equal to the value specified
