Term
| To view only records that satisfy a specific set of conditions you would use a _______, which isolates records meeting a certains set of conditions |
|
Definition
|
|
Term
| You can perform calculations in a _______, ask it to find data or use it to sort or total fields. |
|
Definition
|
|
Term
| The Simple Query Wizard creates a _____ query, which askes a question about the data stored in one or more tabels. |
|
Definition
|
|
Term
| A _____ query will sum, count, average, or calculate minimum or maximum values. |
|
Definition
|
|
Term
| This query can be used to find records from one segment of your database that you may wish to solicit for additional services, or to check why they are not on the other table |
|
Definition
|
|
Term
| It is convenient to create a query using a wizard and then modify or tailor it in _____ view. |
|
Definition
|
|
Term
| The Total row is used to perform calculations on the values in a _____. |
|
Definition
|
|
Term
| You can sort data in tables, but you can also make sort settings in _____ Design view. |
|
Definition
|
|
Term
| A multi-table select query, ios a query based on more than one _____. |
|
Definition
|
|
Term
| You need to know how many customers who live in a specific area of the state purchased a particular item. Which Access feature would assist with this task? |
|
Definition
|
|
Term
| The area code for an area of your state has changed. What would be the quickest way to update all the records in your database? |
|
Definition
|
|
Term
| You want to calculate the sales for a particular area. What is the best query to use? |
|
Definition
|
|
Term
| True or false? You can speed up a search in a data sheet by selecting a field and just searching that data. |
|
Definition
|
|
Term
| True or False? You can select values in only one field as the filtering criteria. |
|
Definition
|
|
Term
True or False?
A saved query can be run any time and will include any new data added to the database |
|
Definition
|
|
Term
True or False?
Queries can be printed just like datasheets, using the Office Button and Print tools |
|
Definition
|
|
Term
| True or False? The multiples query is a select query that can be used to detect duplicate entries in a field, when duplication presents an error. |
|
Definition
|
|
Term
| True or False? The query design grid is the area in Design view where you can set criteria, indicate if a field is to be shown or not, and add the totals |
|
Definition
|
|
Term
| True or False? A calculated field is a field defined in a query that displays the result of an expression |
|
Definition
|
|
Term
| True or False? You can sort data in tables, but you cannot make sort settings in Query Design view |
|
Definition
|
|
Term
|
Definition
|
|
Term
| An organized collection of facts about a particular subject. |
|
Definition
|
|
Term
| Access is a ________________________ where your data is divided into separate, subject-based tables that you can bring together in reports as needed |
|
Definition
| Relational Database Management System |
|
|
Term
| What are model databases in categories that you may be able to adapt to your needs? |
|
Definition
|
|
Term
| Specific data in a field is called the ______ |
|
Definition
|
|
Term
| What is used to display one record at a time and can contain fields from several different tables? |
|
Definition
|
|
Term
| What is a structured way to tell Access to search the records and retrieve data that meets certain criteria? |
|
Definition
|
|
Term
| What view can you Add, Edit, Delete, And View Data? |
|
Definition
|
|
Term
| What view can you interactively summarize and analyze data fro tables? |
|
Definition
|
|
Term
| What view can you Graphically reptesent the information in a PivotChart? |
|
Definition
|
|
Term
| What view can you modify table structures? |
|
Definition
|
|
