Hello,
I wish to replace excel with access but the following question holding me back from doing it. If all the below question can be done,i will definitely do it.
Possible/ How to?
1) Insert comment to table field for a specific record( This is similar like Excel's Insert Comment).
2) Highlight field color (like excel highlight cell background color)
3) Track who add new record/ edit what in a table/(database)?
4) When I made changes in access table, it means it's saved. Access never ask for confirmation wheter I really want to save, It really bothers me.


Please help

---

Answer from Richard Rost:

1. You can create a MEMO field as part of your table so each record can have comments associated with it. It's not PER-CELL (field) like Excel, but you can have comments.

2. You can use Conditional Formatting in Access just like Excel. If you want to manually change the field color you can do it with a little bit of VBA code.

3. This isn't easy to do in either Excel or Access, but it can be done. You would need to either use Access 2003 (or earlier) and set up User Logons or create your own User Logon form like I cover in my Access Security Seminar:

http://www.599cd.com/site/courselist/seminars/access-security/?key=BlFAlEx

4. That's just how Access works. As soon as you move off of a record, it automatically saves the data to the table. This is usually a GOOD thing. If you want to get around it, you could create your own button with a prompt "Are You Sure?" but again that would involve a little tiny bit of programming.

Access is MUCH more powerful and flexible than Excel, but it's different, and there will be a little bit of a learning curve. If you have a LOT of data (more than a few hundred records) or you need to automate anything (calculations, reports, etc.) then you're much MUCH better off with Access.