what are range queries? pg 435
A select query with criteria that matches a range of values.
what are AND and OR logical operators? pg437
they create a complex query
what is a Wildcard? pg440
is a charactor that matches any one or more charctors.
what are the rational operators? pg436
are used to specify critica in a range query.
what is anexsample of when you would use a Mail Merge Wizard? pg445
can be used to integrate data stored in an access database with a document.
why is it important to properly query a database? pg431
because a selected query retrieves or selects data that matches specified criteria.
why are two tabels related?
they are related when a field in one table corresponds to a feild in another table.
What needs to be defined in oreder to view and analyze data from multiple tabels?
table relationships must be defined.
what is a selective query?
a selective query retrieves or selects data that matches specified criteria.
what happens after defining a select query, and clicking on the run button on the tool bar.
the selected query is defined.
what dose the criteria <J mean?
this means to query the customers with last names that come before the letter J.
what do subdatasheets contain?
they contain the records from another table that are related to the current record.
what dose the asterick (*) mean?
this means it is a wild card, it matches any number of charactors or no charactors at all.
what dose a form letter mean?
it is a word document with merge feilds which are placesholders for data from an access table or query.