Im far from an expert but I know enough to answer your questions in lamens terms. I used to have the same worries. I only know about current hardware so I hope that's what you're looking for.
First of all you want to buy an ATX Form Factor motherboard (sometimes just called ATX). Any new motherboard coming out for a long time will be ATX Form Factor. This specification determines the physical layout of some of the devices on the motherboard, namely the PCI, ISA, and AGP slots. Also it determines where your PS/2, serial, parallel, and USB ports will be. Any ATX motherboard will fit properly inside an ATX case. However there are different I/O shields (input/output). This is a thin piece of metal or plastic that has holes cut out to accomodate PS/2, serial ports, parallel ports and your USB ports. This small shield attaches to your case on the back. The motherboard will fit nicely into it. It's all standardized and it all fits like Legos.
Next are the differences between Slot A, Socket A, Socket 370 and Slot 1.
Slot A is for classic AMD Athlons and the first set of Thunderbirds. The "Slot A" determines the actual physical interface your CPU will use. It's a long thin interface on the motherboard itself.
Socket A is also for AMD Athlons. It's used by the newest Thunderbirds and the Durons. It's a square shaped interface as opposed to a slot. It has many holes in it to accomodate socketed Thunderbirds and Durons which have many pins sticking out the bottom of them.
Slot 1 is for Intel processors. It's shaped just like a Slot A except that they are not compaitable. The CPUs that use a Slot 1 interface are Pentium 2, some Pentium 3s, and some Celerons (I'm not sure about Celeron 2s).
The last type of socket you'll come across is called Socket 370. The newest Intel Pentium 3s use this interface as well as some older Celerons. It's similiar to a Socket A (as I described above) but again they are not compaitable. You may come across the term "FC-PGA" or "PGA". PGA stands for "pin grid array". The "FC" stands for "flip chip". Flip chip refers to the fact that internally the processor in a Pentium 3 is flipped over to dissipate heat more effciently. "Pin grid array" refers to the fact that underneath the CPU there are many pins laid out in even rows. The latest Pentium 3s are FC-PGA and they fit inside a Socket 370 interface.
An ATX Form Factor motherboard can have ANY one of the above CPU interfaces (Slot A, Socket A, Slot 1, Socket 370.) All the latest hardware is ATX Form Factor. You won't have any problems finding an ATX Form Factor case to put everything into. Again it's all standardized. You shouldn't worry about wether or not an ATX mother board will fit inside an ATX case.
Their is one exception though. There is a specification called Micro-ATX. Basically ( I believe) it's just like regular ATX but smaller. Sometimes called "Baby ATX". Micro ATX motherboards should fit into standard ATX cases. I don't see why it wouldn't. However non Micro ATX motherboards will have problems fitting into a Micro ATX case. For simplicity's sake and to avoid headaches and costly returns to online vendors. Get a standard ATX motherboard and any standard ATX case. It'll all fit together nicely, like Legos.
I hope this helped you some and calmed down some of your worries. Got any other questions?
dave
[edit] by the way, I think this is the longest message I've ever posted on these forums
