read some books/online articles on database normalization

sorry, we don't do homework for you. Give it a shot and ask specific questions if you need help

so, what is your question?

tblAsset
AssetID int indentity
other info (type, modelnumber, asset tag number, etc)

tblMAC
MACAddress int unique
AssetID int (Foreign Key)

tblIP
IPAddress int unique

um, have you never been in school?

on the surface, three hundred fields sounds like a lot, but it depends on the data involved, Does every product have one and only one entry in every column? if so, then your table is fine. if not...

If you are using outlook, you can simply use the import wizard in outlook to extract the information from the database into a contacts folder

what are you using for email?

for the first sp_tables. For the second, I have no idea