Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you're designing your database for other people to use you'll find times when you'd like to provide them with instructions, one convenient tool utilizes Screen Tips and Status Bar info comments. Scroll down in your Navigation pane and open up the Customers Order Form. Notice when I hold my cursor over my Notes field it tells the user what to do, this is a screen tip, and if I click in the field and then look in the lower left-hand corner at the Status Bar, I can see instructions to follow. You can train your users to look in these two places when they have questions. Let's add a Screen Tip reminding the user that they don't have to type in the Parentheses and the Dashes when they enter in the phone numbers.
Click in the WorkPhone field, change the form to Layout View, this technique also works in Design View. Open up the Property Sheet by clicking on the button in the upper right-hand side of the ribbon, go to the Other tab. Here, where it says ControlTip Text, type in, Enter numbers only, then go down to the Status Bar Text field and key in, Access will automatically format phone numbers for you. Now, go back to the Form View, hold your cursor over the WorkPhone and it says, Enter numbers only.
When you click on it, look down below the Status Bar and it has your message, Access will automatically format phone numbers for you. Using Screen Tips and Status Bar Text can be an excellent training and help tool for you users, just make sure they know to look for these hints.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 98788 Viewers
80 Video lessons · 141646 Viewers
59 Video lessons · 59987 Viewers
52 Video lessons · 73159 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.