Finding, Filtering, Sorting  «Prev  Next»
Lesson 1

Introduction to Finding, Sorting and Filtering Data in Access Tables

Chances are that you are putting data in a database because you want to do something with it, that is analyze it, sort it, or use it to answer questions on how to run your organization more efficiently.
It may be that some of what you want to do with your data can only be done with queries and reports, however, even tables give you some analytic tools.
This module covers the different ways you can manipulate data within tables. You will learn how to:
  1. Use the Find and Replace dialog box
  2. Sort records using one or more fields
  3. Filter records to display a subset of records in a table
  4. Filter records using multiple criteria
  5. Filter records using complex criteria

The Synapse Process of learning in the Brain

A spike of activity traveling along the axon causes a charge to be injected into the post synaptic neuron at a synapse. A neuron generates spikes when it has received enough charge in its dendritic tree to depolarize a part of the cell body called the axon hillock. When the axon hillock gets depolarized, the neuron sends a spike out along its axon. And the spike is just a wave of depolarization that travels along the axon.
Synapses themselves have interesting structure and contain little vesicles of transmitter chemical and when a spike arrives in the axon it causes these vesicles to migrate to the surface and be released into the synaptic cleft. There are several different kinds of transmitter chemicals. There are transmitter chemicals that implement positive weights and ones that implement negative weights. The transmitter molecules diffuse across the synaptic clef and bind to receptor molecules in the membrane of the post-synaptic neuron, and by binding to these big molecules in the membrane they change their shape, and that creates holes in the membrane. These holes are like specific ions to flow in or out of the post-synaptic neuron and that changes their state of depolarization. In biology, depolarization is a sudden change within a cell, during which the cell undergoes a dramatic electrical change. Synapses adapt, and that is what most of learning is, changing the effectiveness of a synapse. They can adapt by varying the number of vesicles that get released when a spike arrives or by varying the number of receptor molecules that are sensitive to the released transmitter molecules.
Synapses are very slow compared with computer memory nd have a lot of advantages over the random access memory on a computer because they are very small and low power.
The most important property of synapses is that they can adapt. They use locally available signals to change their strengths, and that is how we learn to perform complicated computations. Questions:
  1. How do they decide (make decisions) and how do synapses change their strength?
  2. What are the rules for how the synapses should adapt?