Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

changes you make database

Forum home » Delegate support and help forum » Microsoft Access Training and help » Changes you make in a database

Changes you make in a database

ResolvedVersion 2003

Luigi has attended:
Access Introduction course
Access Intermediate course

Changes you make in a database

Is there a way to audit a database in the same way that you can with Excel?

RE: Changes you make in a database

Dear Luigi

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.


I would request you to clarify what you mean by audit in Excel. If you are talking about audit trail in Access then you need to have knowledge of VBA. The following link provides you some information:

http://www.everythingaccess.com/tutorials.asp?ID=Creating-an-Audit-Trail

If you are interested in knowing out Access VBA courses then please refer to the following link:

https://www.stl-training.co.uk/ms-access-training-courses-in-london-2003-vba.php



I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.