What Is Database Auditing – Microsoft Access Tools

What Is Database Auditing Using Microsoft Access Tools?

The question I’m often asked is What is database auditing and how do I create an audit trail in Microsoft Access?

The second part to that question means the inquisitor has realised there are no standard MS Access tools available (out-of-the-box) for you to utilise and developers are therefore left to their own skills and time to creating a tool instead.

what is database auditing

In this quick article, I want to highlight the key components to designing your own auditing tool and  Continue reading “What Is Database Auditing – Microsoft Access Tools”

Working With Hyperlinks In Access – Create A Button Link

Working With Hyperlinks In Access – Create A Button Link

With an Access database, there are many ways to perform similar functions like creating a clickable button using the standard CommandButton or using hyperlinks in Access instead – that’s a URL link and having some quick automated way to fire up an email for example.

This blog expands on this feature and in particular how you can use a hyperlink to act as an alternative button for your datasheet or form objects in your database without even using a single line of programming code albeit a macro or some Access VBA code.

Working With Hyperlinks In Access – Create A Button Link

Rather than a conventional CommandButton (a grey dull looking control) to click and run a procedure, we can adopt the hyperlink action instead and Continue reading “Working With Hyperlinks In Access – Create A Button Link”

How To Create A Splash Screen In Access

How To Create A Splash Screen In Access

Have you ever noticed the standard splash screens that pop-up in many applications and wondered how you could create a splash screen to replace the original and customize your database file to your own brand?

This method that I’m going to show and step you through requires no programming at all (i.e. Access VBA) just some effort in creating a nice looking graphics file you wish to replace using something like Photoshop or even the standard MS Paint utility.

create a splash screen

 

 

 

 

 

 

 

 

In this exercise, I’ going to use Continue reading “How To Create A Splash Screen In Access”

How To Open Microsoft Access Database Appear Outside Of Access

How To Open Microsoft Access Database Appear Outside Of Access

If you have ever browsed the Access options and design properties of your database then you will know some of the neat tricks that help to blend your database application into your Windows environment But how to open Microsoft Access database (file) and make it appear to be outside of the application is an illusion that maybe useful.

In this quick tutorial, I’m going to create a blank canvas form as the background and maximize it so it covers the whole application which will require some combined form property changes too.

how to open microsoft access database

On top of that, I will call another opening form (your starting form) to Continue reading “How To Open Microsoft Access Database Appear Outside Of Access”