To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=105004
Issue #|105004
Summary|Make OOo Base UI and navigation looks similar to calcu
|.
Component|Database access
Version|OOG680_m2
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|ENHANCEMENT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|bijugc
--- Additional comments from bij...@openoffice.org Sat Sep 12 04:32:36
+ 2009 ---
This a more of an Excel problem than a OOo-Base issue.
But I would like to see this feature first come OOo than a MS-Product.
At work I do a lot of data processing.
User generally sent me data in an MS-Excel or CSV format.
They have MS-Access on their PC, but still they use MS-Excel format.
As Excel never insist to define or use consistent data type on a column, there
are a lot of crap data, which causes lot of problems while processing data.
I wish Office App vendors make layout and navigation of their database module
much similar to a spreadsheet layout.
My Suggestion:-
When user start database module we may present a in memory database with few
tables having blank record as mentioned in Issue 104873
(see attachment below)
Then the opening screen can have an Accordion/Tree control showing like
* Tables
- Table1
- Table2
- Table3
* Queries
- Query1
- Query2
* Forms
- Form1
- Form2
- Form3
* Reports
- Report1
User can double click any object (Table1, Table2 ... or Query) it will open as a
tab on right side.
There should also be a new Object button if user want to create a new database
object. New table object always comes with 10 case-insensitive text fields with
10 to 20 blank rows.
Later user should have an option to rename the table by right clicking on tab
and choosing rename in context menu. Table structure can be modified by
selecting Design from the context menu.
For fields, user should have an option to rename it by right clicking the fields
column header and choosing rename in context menu. Other field properties can be
modified by selecting Design from the context menu.
This Design screen is same as Table Design screen with the chosen field as
currently selected field.
Also both Design screens should NOT be popups.
Instead it will be shown in the same Tab of corresponding
table/view/form/report.
There should be also a button on design screen to switch back to data view.
This functionality (switch back to data view) is same as current OOo Base Query
view.
Once user finished working with a table, query, form or report there showed be
an x button to close the opened tab.
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org
-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
