DBWebApplications 





Finding, Filtering, Sorting  «Prev  Next»
Lesson 5 Filter records using multiple criteria
Objective Use Filter by Form to filter one table using multiple criteria.
While Filter by Selection is simple to use it may not meet your needs. You may have criteria for more than one field, or you may have more than one criterion for one field. Filter by Selection does not provide the flexibility for multiple criteria, but Filter by Form offers you more options if you need to filter using more than one field in a datasheet.
Use this Simulation to learn how to use Filter by Form.
Filtering by Form
Remember that criteria selected on the same tab must both be met in order for the record to “pass” the filter. When criteria are selected on different tabs, only the criteria on one tab must be met for the record to be displayed.
Click the link below to learn more about how to filter records using multiple criteria.
FilterRecords using Multiple Criteria
Learn how to filter using more complex criteria using the Advanced Filter Sort feature.


Cerebral Cortex is modular

One final point about the brain is that the cortex is modular, at least it learns to be modular. Different elements of the cortex end up performing different functions. Genetically, the inputs from the senses go to different areas of the cortex. This determines a lot about what the input will ultimately end up doing. If you damage the brain of an adult, local damage to the brain causes specific effects. Damage to one place might cause you to lose your ability to understand language. Damage to another place might cause you to lose your ability to recognize objects. We know a lot about how functions are located in the brain because when you use a part of the brain for doing something it requires energy, and so it demands more blood flow, and you can see the blood flow in a brain scanner. This monitoring allows you to see which parts of the brain you are using for particular tasks. But the remarkable thing about cortex is it looks pretty much the same all over, and that strongly suggests that it has a fairly flexible universal learning algorithm in it. This is backed up by the observation that if you damage the brain early on, functions will relocate to other parts of the brain. So it is not genetically predetermined, at least not directly, which part of the brain will perform which function. There are convincing experiments on baby ferrets that show that if you cut off the input to the auditory cortex that comes from the ears, and instead reroute the visual input to the auditory cortex, then the auditory cortex that was destined to deal with sounds will actually learn to deal with visual input, and create neurons that look very like the neurons in the visual system.
This suggests that the cortex is made of general purpose material that has the ability to turn into special purpose hardware for particular tasks in response to experience. This gives you a nice combination of rapid parallel computation once you have learned. In addition, you the cortex has the flexibility to learn new functions and the brain is learning to perform parallel computation.