Wednesday, November 7, 2018

You have Messages!

I have posted a video for how to make navigation form in Access a couple of posts ago.  I use Access for much of my shared data entry type procedures.  There are some basic and easy ways to use this program, but to really use a lot of the great features, there is almost an endless amount of options you can use with both Macros and VBD coding to customize your Access database.

Often times you will create a database, but you will be handing off the reins to different users for data entry. Good database design involves helping users that you may not be training yourself, on how to enter data into your system.  To make sure users get the information when they need it, you can create message box pop ups to help users understand more about what they need to do. 

On the last database I created, I made a message box that appears when a user selected a certain type of error in the system for receiving.  The message lets the user know the next steps.  Learning how to do this process involved some trial and error.  Since then, I have found the wonder of Youtube videos to help me learn how to do the process.  I can't stress enough how great of a tool Youtube videos are for finding ways to use more of Access great features. 

I have linked the video below that will help you learn how to put in message box.  Please watch it, but also use this as a jumping off part to use more of what Access can do.


1 comment:

  1. Great post! I think this is a very helpful video on how to use and navigate Access. I think that it is something that is very helpful and will be very helpful to others to be able to view. I think that being able to go online and find a video like this that is helpful is huge important, just because you know that there are tools out there that can help you learn about what you are wanting to learn about.

    ReplyDelete