Skip to main content

Adding buttons to the Quick Access toolbar

Speaking of the Quick Access toolbar and all the ways you can access commands for customizing it, try this to add commands:

1. With any database open (so that the Ribbon tabs are displayed), rightclick any of the buttons on any of the tabs.

You can also right-click the Quick Access toolbar or any Ribbon tab.

2. Choose Customize Quick Access Toolbar.

The Access Options dialog box opens (shown in Figure 2-13), with its Customization options displayed.

Figure 2-13: Pick a command category and a command to add to the Quick Access toolbar.
Figure 2-13: Pick a command category and a command to add to the Quick Access toolbar.

3. Click the Choose Commands From drop-down list and choose a command category.

A list of Popular Commands appears by default.

4. From any (or each) category, choose the commands you want to see at all times in the Quick Access toolbar by clicking them one at a time and then clicking the Add button.

As you click the Add button, the command you chose is added to the list on the right. Note that you have up- and down-pointing triangles on the right side of the list of commands you’ve added — with one of the commands you’ve chosen to add selected, use them to reorder the list, which rearranges the left-to-right order in which they’ll appear on the toolbar.

5. Continue selecting categories and commands on the left and using the Add button to add them to the list on the right.

Not all commands will be usable at all the times that the Quick Access toolbar is displayed. For example, if you choose to place the Filter button from the Home tab on the Quick Access toolbar, the button won’t be available until and unless a table or set of query results were open.

6. When you’ve added all the commands you want to add, click OK to add them and close the dialog box.

When you click OK, the changes to the Quick Access toolbar are applied. The toolbar’s space on the top of the workspace grows to accommodate all the new buttons, as shown in Figure 2-14.

Figure 2-14: Add as many buttons as you want — the toolbar will expand horizontally to accommodate them.
Figure 2-14: Add as many buttons as you want — the toolbar will expand horizontally to accommodate them.

If you’re in a hurry to add a specific button to the Quick Access toolbar, and you’re looking right at the button you want to add, just right-click the button and choose Add to Quick Access Toolbar from the menu that appears. The button you right-clicked instantly appears on the toolbar and remains in the tab where it was living when you right-clicked it.

Why, then, would you use the Access Options dialog box if a simple rightclick takes care of business? Because it gives you the ability to select buttons from all the various tabs in one place — no need to go hunting on the tabs for the buttons you want to add. But when there’s just one you want and you can see it at the time, the right-click method can’t be beat.
Labels:

Comments

Post a Comment

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 ...
Post a Comment
Read more

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...
1 comment
Read more

Databases with user forms

When you’re planning your database, consider how the data will be entered: If you’ll be doing the data entry yourself, perhaps you’re comfortable working in a spreadsheet-like environment (known in Access as Datasheet view), where the table is a big grid. You fill it in row by row, and each row is a record. Figure 1-1 shows a table of customers in progress in Datasheet view. You decide: Is it easy to use, or can you picture yourself forgetting to move down a row and entering the wrong stuff in the wrong columns as you enter each record? As you can see, there are more fields than show in the window, so you’d be doing a lot of scrolling to the left and right to use this view. You may want to use a form (shown in Figure 1-2) instead. A form is a specialized interface for data entry, editing, and for viewing your database one record at a time, if Someone else will be handling data entry Typing row after row of data into a big grid seems mind-numbing Figure 1-1: Datasheet view ...
1 comment
Read more