Skip to main content

Working with ScreenTips In Access 2013

ScreenTips are the little names and brief descriptions of onscreen tools that appear when you put your mouse pointer over buttons, commands, menus, and many of the other pieces of the Access workspace.

make something happen — as when a dialog box opens, Access performs some task for you, or something is created — these things typically have associated ScreenTips that you can choose to view or not view. If you choose to view them, you can choose to see very brief or more elaborate tips.

To tinker with Access’s ScreenTips settings, follow these steps:

1. Click the File tab.

The File menu (the red panel on the far left) and the Info view appear on the workspace, as shown in Figure 2-17.

The File tab’s panel of commands gives you an Options command, which you can use to adjust how Access looks and works.
Figure 2-17: The File tab’s panel of commands gives you an Options command, which you can use to adjust how Access looks and works.

2. Click the Options command, near the bottom of the menu.

The Access Options dialog box appears onscreen.

3. From the list on the left side of the Access Options dialog box, select General.

The options in the dialog box change to show other options related to ScreenTips, file formats and folders, and how your name and initials are stored, as shown in Figure 2-18.

4. In the first section of the dialog box, click the ScreenTip Style dropdown list.

5. Choose from the following options:

Show Feature Descriptions in ScreenTips: This option displays ScreenTips with extra information, as shown in Figure 2-19. Here you see that in addition to the name of the button, a brief description of how it works (or its effect) is displayed for your benefit. It even points to more assistance and information — in this case, the ScreenTip references the use of the F1 key to open Access’s Help files.

The settings for just about everything you can see and use in Access are available through the Access Options dialog box.
Figure 2-18: The settings for just about everything you can see and use in Access are available through the Access Options dialog box.

View the helpful button and tab names and information. Access 2013
Figure 2-19: View the helpful button and tab names and information.

Don’t Show Feature Descriptions in ScreenTips: If you want just the facts, ma’am, this is for you. ScreenTips will show just the button name with no further explanation.

Don’t Show ScreenTips: Want to go it alone? Turn off ScreenTips.

6. Click OK to close the Access Options dialog box.

Establishing the level of detail included in ScreenTips isn’t the end of your options. You can also choose whether to include keyboard shortcuts in ScreenTips. This is on by default, and it’s pretty useful.

Comments

Popular posts from this blog

Access Field Types and Uses

A field, you remember, is where your data lives. Each field holds one piece of data, such as Last Name or Batting Average. Because there are so many different kinds of information in the world, Access offers a variety of field types for storing it. In fact, Access puts the following field types at your disposal: Short Text Long Text Number Currency Date & Time Yes/No Lookup & Relationship Rich Text Attachment Hyperlink OLE Object Calculated There’s also an Autonumber field type, which is applied automatically to the first field in a new, blank database. The types just listed are those available for fields you create in addition to that first field — the ones that will contain your data. For now, suffice it to say that the Autonumber field is a field that contains an automatically-generated number so that each record is unique in that it has a unique autonumber, or ID. You get the word about the need for (and ways to create) unique fields later on, in Chapter

Building a Database in Access

So you’ve read a few posts here at the beginning of the blog, maybe you’ve leafed ahead where I’ve referred to other chapters, and now you feel ready. You want to dive in and start building a database. Keeping in mind my previous advice to take it slowly, you can take a whack at it here. In the following procedure, you set up a new database and then use the Table Wizard to build the first table in the database. Ready? Here we go . . . 1. If Access is not already running, take a moment to start it. Chapter 1 shows you how to do this. In the Access workspace, a series of large template icons appears, below a Search for Online Templates box, accompanied by links to likely searches for templates that store Assets, Business, Contacts, Employee, and so on. 2. Click the Blank Desktop Database icon. A Blank Desktop Database dialog box appears, as shown in Figure 3-1. Figure 3-1: New blank databases need names. Give yours one here. 3. Type a name to replace the generic Databa

Choosing Between Flat and Relational Databases

Unlike ice cream, databases come in just two flavors: flat-file and relational. Also unlike ice cream, it’s not really a matter of preference as to which one you choose. Some databases require a relational approach; others would be overwhelmed by it. Read on to figure out how to tell the difference. Isolationist tables In a flat system (also known as a flat-file system), all the data is lumped into a single table. A phone directory is a good example of a flat-file database: Names, addresses, and phone numbers (the data) are crammed into a single place (the database). Some duplication occurs — if one person has three phone lines at home, his or her name and address are listed three times in the directory — but that’s not a big problem. Overall, the database works just fine. Tables that mix and mingle The relational system (or relational database) uses as little storage space as possible by cutting down on the duplicated (also known as redundant) data in the database. To a