Command user interface for displaying selectable functionality controls in a database application

• US 8,689,137 B2
• Filed: 04/10/2006
• Issued: 04/01/2014
• Est. Priority Date: 09/07/2005
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: McCormack, Michael J., Bryant, Christopher W., Covington, Clinton Dee, Dickinson, Richard L., Coggins, Robert E., Krout, Kelly Michael, Selca, Vitore, Woodall, Zachary P., Kenney, Adam Russell, Hough, Dan Jacob
• Primary Examiner(s): TILLERY, RASHAWN N
• Application Number:
  US11/401,470
• Publication Number:
  US 20070055943A1
• Time in Patent Office: 2,913 Days
• Field of Search: 715/810, 715/821, 715/708, 715/777, 715/841, 715/843, 715/845, 715/842
• US Class Current: 715/810
• CPC Class Codes: G06F 3/0481 based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance

Abstract

An improved user interface is provided for displaying selectable software functionality controls of a database application. When a task-based functionality tab is selected from the user interface, selectable functionality controls provided by the associated database application for performing aspects of a task related to the selected tab are presented in a ribbon-shaped user interface above a workspace in which a user is entering or editing data. Upon selection of a different task-based functionality tab, the presentation of functionality controls associated with the first task is removed, and selectable functionality controls associated with the second selected task-based functionality tab are presented in the user interface. The selectable functionality controls presented in the user interface are grouped into logical groupings for more efficient utilization. An extensibility model is provided for allowing users to develop and use customized user interfaces and to allow utilization of legacy user interfaces.

Claims

1. A computer readable storage medium containing computer executable instructions which when executed by a computer perform a method for providing functionality from a database application via an improved user interface, the method executed by the computer executable instructions comprising:

providing a plurality of functionalities available from the database application;

organizing the plurality of functionalities according to a plurality of tasks;

providing user interface tabs for each of the plurality of tasks, each of the user interface tabs being operative to deploy, upon selection, layouts of logically grouped functionality controls;

receiving an indication of a selection of a database object within the database application; and

deploying, in response to the received indication, a database user interface tab comprising a layout of logically grouped functionality controls having a plurality of selectable controls associated with editing a selected data object, wherein deploying the database user interface comprises replacing at least one previously displayed selectable control with the plurality of selectable controls associated with editing the selected data object, wherein the plurality of selectable controls comprise;

a first control for retrieving external data,

a second control for exporting database application data to an external database, and

a third control for handling server-based data via electronic transmission.

2. The computer readable storage medium of claim 1, further comprising upon receiving an indication of a selection of one of the plurality of selectable controls, applying functionality associated with the selected one of the plurality of selectable controls to the selected data object.

3. The computer readable storage medium of claim 1, further comprising upon receiving an indication of a selection of a user interface tab, providing in the user interface a plurality of additional selectable controls for selecting a plurality of additional functionalities associated with the selected user interface tab.

4. The computer readable storage medium of claim 1, further comprising:

upon receiving an indication of a focus on a user interface tab, providing in the user interface a plurality of additional selectable controls for selecting a plurality of additional functionalities associated with the selected user interface tab, the plurality of additional selectable controls replacing the plurality of selectable controls displayed prior to receiving the indication of the focus; and

upon cessation of the focus on one of the following;

the user interface tab and a contents of the user interface tab, restoring the plurality of selectable controls displayed prior to receiving the indication of the focus.

5. The computer readable storage medium of claim 4, further comprising:

after providing in the user interface the plurality of additional selectable controls for selecting the plurality of additional functionalities organized under the second task, receiving an indication of a selection of one of the plurality of additional selectable controls;

applying functionality associated with the selected one of the plurality of additional selectable controls to the selected data object; and

when the user interface tab is no longer in focused on for persisting a provision in the user interface of the plurality of additional selectable controls for selecting the plurality of additional functionalities organized under the second task, restoring the plurality of selectable controls displayed prior to receiving the indication of the focus.

6. The computer readable storage medium of claim 1, further comprising providing in the user interface a contextual user interface tab for each of the plurality of tasks that are operative with the functionalities provided by the database application.

7. The computer readable storage medium of claim 6, further comprising upon receiving an indication of a selection of the contextual user interface tab, providing in the user interface the plurality of selectable controls in the user interface for selecting the plurality of functionalities with the plurality of additional selectable controls representing the functionalities provided by the database application.

8. The computer readable storage medium of claim 7, further comprising grouping the plurality of additional selectable controls representing the functionalities provided by the database application operative to edit the selected object into at least one logical grouping of selectable controls, the at least one logical grouping being associated with a subset of the plurality of additional selectable controls representing the functionalities provided by the database application.

9. The computer readable storage medium of claim 1, wherein receiving the indication of the selection of the data object includes receiving an indication of a selection of a database form for editing via the database application.

10. The computer readable storage medium of claim 1, wherein receiving the indication of the selection of the data object includes receiving an indication of a selection of a database report for editing via the database application.

11. The computer readable storage medium of claim 1, wherein receiving the indication of the selection of the data object includes receiving an indication of a selection of a database table for editing via the database application.

12. The computer readable storage medium of claim 1, wherein receiving the indication of the selection of the data object includes receiving an indication of a selection of a database pivot chart for editing via the database application.

13. The computer readable storage medium of claim 1, wherein receiving the indication of the selection of the data object includes receiving an indication of a selection of a database pivot table for editing via the database application.

14. A system for providing an improved user interface operative to provide functionality from a database application, the system comprising:

a memory storage; and

a processing unit coupled to the memory storage, the processing unit being operative to;

dispose a plurality of tabs in an upper row of the user interface, each of the plurality tabs being operative, upon selection, to deploy, in a lower row of the user interface underneath the disposition of the plurality of tabs, a layout of a plurality of selectable functionality controls corresponding to database tools,

receive a selection of a database object for editing,

determine a mode of operation for editing the database object, wherein each mode of operation is associated with a plurality of selectable controls; and

dispose the plurality of selectable functionality controls in the lower row, wherein the processing unit being configured to dispose the plurality of selectable functionality controls comprises the processing unit being configured to replace at least one previously deployed selectable functionality control with the plurality of selectable functionality controls, each of the plurality of selectable functionality controls corresponding to the determined mode of operation associated with the selected database object, the determined mode of operation allowing for the following;

retrieval of external data,

exportation of internal data, and

managing, via electronic transmission, server-based data.

15. A method for providing functionality from a database application via an improved user interface, the method comprising:

providing a plurality of functionalities available from the database application;

organizing the plurality of functionalities according to a plurality of tasks;

providing user interface tabs for each of the plurality of tasks, each of the user interface tabs being operative to deploy, upon selection, layouts of logically grouped functionality controls;

receiving an indication of a selection of a database object; and

upon receiving an indication of the selection of the database object, deploying a layout of logically grouped functionality controls for editing in the selected database object, wherein deploying the layout of the logically grouped functionality controls comprises replacing a previously deployed set of functionality controls, the deployed logically grouped functionality controls being associated with database tools for;

retrieving external data,

exporting database application data to an external database, and

handling server-based data via electronic transmission.

16. The method of claim 15, wherein receiving the indication of the selection of the database object within the database application comprises receiving an indication of a selection of at least one of the following:

a database form, a database report, a database table, database pivot chart, and database pivot table for editing via the database application.

17. The method of claim 15, wherein deploying the layout of the logically grouped functionality controls for editing the selected database objects comprises replacing previously deployed functionality controls.

18. The method of claim 15, wherein retrieving the external data comprises retrieving the external data from at least one of the following:

saved data, data maintained in a shared database, and data that is one of;

maintained and enabled from a different software application.