Microsoft Technology Licensing, LLC

Robert Coggins

Michael J McCormack

Christopher Warren Bryant

Scott Timothy Gardner

Andrew Robert Miller

Clinton Dee Covington

Kelly Michael Krout

Theresa Naramore

Daniel Hough

Vijay Mital

Suraj T Poozhiyil

Richard Lee Dickinson

Sumit Chauhan

David Jon Conger

Jason A Bould

Zachary P Woodall

James Rivera

Vitore Selca

Ryan Christopher McMinn

Dan Jacob Hough

Jonathan M Sigler

Adam Russell Kenney

Kerry Westphal

Christopher Deugau

A gallery-set of controls and actions containing pre-built logic is provided for building applications, projects and solutions in a database program. The gallery may include the most commonly used controls that may account for the main logic scenarios in the database program. The controls may be simple, clear and intuitive, such that users with little or no programming experience may be able to develop solutions in the database program using the gallery controls without having to enter any coding environment or having to build complicated logic expressions. The gallery may allow users to build a complete solution by adding the predefined controls from the gallery to the design surface of a solution without opening a code editor, and the code behind the control may be automatically built into the solution. The solution code may also be accessible for later modification by a user in the database program.

Creating logic using pre-built controls

A user interface (UI) includes floating action buttons. Respective hot zones are established for associated respective UI elements. When a focus is targeting (e.g., located at) a given hot zone, one or more floating action buttons that are associated therewith are presented as part of the UI. Activation of a particular action button of the one or more floating action buttons causes an action corresponding to the particular action button to be implemented. In an example implementation, the actions available through the one or more floating action buttons may be context-sensitive such that the actions thereof are tailored to the type of item corresponding to the UI element (e.g., an icon, a graphical element, a text portion, a screen area, etc.).

Floating action buttons

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.

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

Embodiments are provided to merge, manage, create, and reuse database parts in a computer system. Database parts may include database tables, datatypes, field combinations or entire databases. A selection of a database part is received by a database software application executing on a computer system. The application may be configured to check for metadata associated with the database part to identify an action property. If, after checking for the metadata, a merge action property is identified, then the application may check for a metadata property associated with a database table. If a merge action associated with the database table is identified, then the application may merge the database part with the database table in the database. The application may also be configured to generate a user interface for creating database parts using database tables and for creating a database part by saving a database.

Database part creation, merge and reuse

Database interaction is facilitated by graphically presenting database objects in groups that are not necessarily dictated by object types of the database objects. In an example implementation, database navigation is facilitated by determining object dependency groups for a database in which each object dependency group corresponds to a database source object and includes at least those database objects that depend directly or indirectly from the corresponding database source object. When these data source object-based dependency groups are graphically displayed, selecting a database object thereof provides access thereto. In another example implementation, a user can designate an attribute associated with database objects by which the database objects are to be grouped. Thus, the database objects are grouped by various values that the user-designated associated attribute takes. These designated attribute-based value-driven groups may also be graphically displayed to enable navigation of and access to the different database objects assigned to them.

Database interaction

Database interaction is facilitated by graphically presenting database objects in groups that are not necessarily dictated by object types of the database objects. In an example implementation, database navigation is facilitated by determining object dependency groups for a database in which each object dependency group corresponds to a database source object and includes at least those database objects that depend directly or indirectly from the corresponding database source object. When these data source object-based dependency groups are graphically displayed, selecting a database object thereof provides access thereto. In another example implementation, a user can designate an attribute associated with database objects by which the database objects are to be grouped. Thus, the database objects are grouped by various values that the user-designated associated attribute takes. These designated-attribute-based value-driven groups may also be graphically displayed to enable navigation of and access to the different database objects assigned to them.

Database navigation

Growing community of inventors

Bellevue, WA, United States of America

Robert Coggins