Navigating Access with the Alt Key

If you like to use the keyboard as much as possible when you’re working with software, Access makes it somewhat easy to do that. I say somewhat because you need to use a special key in order to make the rest of the keyboard work as a commander.

When you want to switch tabs and issue commands with the keyboard (rather than with the mouse), press the Alt key. As shown in Figure 2-20, pressing Alt causes numbers and letters to appear in small squares on the Quick Access toolbar and the Ribbon’s tabs. When the numbers and letters are visible, you can press one of those characters on your keyboard to issue a command (such as pressing 1 to Save) or to switch to a tab (such as pressing C to get to the Create tab).

Figure 2-20: Rather press a letter or number than click a tab or button with your mouse? The Alt key shows you how.

When you’re on a tab (but only if you press its letter key to activate it), the individual buttons on that tab have their own keyboard shortcuts displayed. Instead of single numbers or letters, however, now you’re looking at pressing key combinations, such as F + Z (displayed as FZ onscreen) to activate the Form Wizard. Figure 2-21 shows the keyboard shortcuts for the Create tab.

Figure 2-21: Each button on a tab has its own keyboard shortcut.

The goal is not to try to press the two keys at the exact same time. Instead, press the first one listed — and with that key still pressed, tap the second key. Voilà!

Comments

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 ...

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...

Handy Access 2013 Keyboard Shortcuts

Access, like all Windows applications, is meant to be used with the mouse. The mouse is assumed to be your main way of communicating with the software — clicking Ribbon tabs, buttons, and drop-down lists, and making choices in dialog boxes to use things like the Report Wizard and the Access Options dialog box discussed in the previous sections of this chapter. You can left-click to make standard choices from onscreen tools and rightclick to access pop-up menus — also known as context-sensitive menus because the menu choices vary depending on what was right-clicked. If you right-click a Ribbon tab or button, you get choices for customizing toolbars and buttons. If you right-click a database component tab (say, the Table tab while that table is open), you get choices related to the table. Not a big fan of the mouse? Check out the Cheat Sheet for this blog. It’s full of powerful keyboard shortcuts. Keystroke Function F1 Opens the Help window. Alt+f Opens the File tab. ...

MS Access Guide

Search This Blog