| INTRODUCTION TO ACCESS | |||||||||
| FILTER BY FORM EXERCISES | |||||||||
| A. Filter by Selection | |||||||||
| 1. | Use the Survey Table | ||||||||
| 2. | Filter by selection to select records where Intensity = "Light" | ||||||||
| 3. | Go to the Filter by Form view | ||||||||
| 4. | Return to Table view | ||||||||
| B. Multiple Filter by Selection | |||||||||
| 1. | Keep the filter on | ||||||||
| 2. | Filter by selection to select records where Genre = "Childrens" | ||||||||
| 3. | Go to the Filter by Form view | ||||||||
| 4. | Question: can you explain what you see? | ||||||||
| 5. | Return to Table view | ||||||||
| C. Start a new Filter by Selection | |||||||||
| 1. | Turn the filter off | ||||||||
| 2. | Filter by selection to select records where Maturity Rating = "PG-13" | ||||||||
| 3. | Go to the Filter by Form view | ||||||||
| 4. | Question: can you explain what you see? | ||||||||
| 5. | Return to Table view | ||||||||
| D. Filter by Form - point-and-click | |||||||||
| 1. | Go to the Filter by Form view | ||||||||
| 2. | Select the following filter values: Maturity Rating = "G" AND Rating = 5 | ||||||||
| 3. | Return to Table view | ||||||||
| E. Clear the filter | |||||||||
| 1. | Turn the filter off | ||||||||
| 2. | Go to the Filter by Form view | ||||||||
| 3. | Clear the filter shown in Filter by Form | ||||||||
| 4. | Question: how did you do it? | ||||||||
| F. Construct a "null" filter | |||||||||
| 1. | Go to the Filter by Form view | ||||||||
| 2. | Select the following filter values: Maturity Rating = "PG-13" AND Rating = 5 | ||||||||
| 3. | Return to Table view | ||||||||
| 4. | Question: can you explain what you see? | ||||||||