Jaa

Add New Field

  • Artikkeli

A very nice feature in Access 2007 is the new "Add New Field" column in table datasheet view. You can see it here.

This is a column that is similar to the New Row also featured at the bottom of table datasheets. The difference is that you can use this column to add new columns by simply typing in data. Depending on what data you key in (e.g. 1/1/2005, $10.00, etc), the type of the data will figured out for you.

Of course, as with any guesswork, there is margin for error. Or you may simply want to change the datatype to something more specific. For that matter, we allow you to change the datatype of columns directly from the ribbon, still while in datasheet view. You can see it here on the Datasheet contextual tab, in the "Data Type and Formatting" chunk.

What this means is that the need to go to design mode is greatly reduced and specific around a couple of scenarios (such as setting the index/indices) and such.

Another interesting benefit is that we now have some very good support to pasting data into a datasheet, particularly Excel. We'll try to guess the types and column names.

Comments

  • Anonymous
    June 24, 2006
    The comment has been removed
  • Anonymous
    June 25, 2006
    The comment has been removed
  • Anonymous
    June 27, 2006
    <down to the level of FileMaker>
    clearly that is the intent ... how many reviews do you think MS can tolerate that say FileMaker is better/easier than Access?

    We only deploy runtime to the desktop with data on the server and while giving users permission to the data folder I don't let them even see the folder above. Of course if someone is smart enough thay can work around this but then it is obvious they are cirumventing our formal process for change control and will be in a world of hurt.
  • Anonymous
    June 29, 2006
    The comment has been removed