Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
20 Cards in this Set
- Front
- Back
|
Queries |
it allows you to pull information from one it more tables |
|
|
Pinpoint, identify, locate, and determine |
What are the four steps when planning a query? |
|
|
Pinpoint |
Exactly what you want to know |
|
|
Identify |
Every type of information you want included in your query results |
|
|
Locate |
The fields you want to include in your query |
|
|
Determine |
The criteria the information in each field needs to meet |
|
|
Datasheet view and Design view |
What are the 2 main views? |
|
|
Run Query |
To view the result of the query in a table |
|
|
Run |
Perform the actions specified in a query |
|
|
The Object Relationship Pane |
All of the tables you choose to include in your query will appear as small window in? |
|
|
The Design Grid |
Bottom part of Query Design view |
|
|
Field |
It is the first row of the design grid contains the names of it |
|
|
Table |
Each field name is the name of the field belongs to |
|
|
Sorting |
Ascending or Descending sort |
|
|
Query Criteria |
It let's you specify exactly what type of information you want to your query to retrieve |
|
|
1st step |
select the create tab on the ribbon, and locate the queries group |
|
|
2nd step |
select the query design command |
|
|
3rd step |
Access will switch to query design view in the show table dialog box that appears, select the table you want to rub a query on, click add, then click close |
|
|
Last step |
the selected table will appear as a small window in the object relationship pane. in the table window, double click the field names you want to include in your query. They will be added to the design grid in the bottom part of the screen |
|
|
Datasheet view |
Let's you view your query results in the form of a table |
