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 there 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 vendors make a much more user friendly database module in their Office
Applications.

So here is my suggestion to make Base more user friendly.

* When user start OOo Base dont prompt for a file name.
Just like the way we do in Writer and Calc, open up a blank in memory database
with name "Untitled".

* this in-memory db should contain 3 tables named "table1", "table2", "table3"
(there should be a preference setting to say how many tables need to be created
automatically)

* each new table should by default have 10 string fields named "field1",
"field2"..."field10"

* each new table should by default have 10 blank records

* when exiting OOo Base or saving database, base module should promt for
database name.