Can I add a wireless LAN card to my Ethernet-connected computer and have it act like an access…?

Can I add a wireless LAN card to my Ethernet-connected computer and have it act like an access point for other wireless computers?

Yes! It won't act exactly like an access point, but will work essentially the same. See this How To.