O'Reilly logo

Microsoft® Office® Professional 2013 Plain & Simple by Katherine Murray

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Editing a data table

You can easily change the data table you’ve added by modifying the content or the look of the fields. Especially if you’ve used the search tool to locate and open a ready-made table, you might have some tweaking to do.

Edit the table

  1. Click the table that you want to edit.

  2. Click Datasheet.

  3. In the center of the web app window, click Edit.

    Access displays the table in Design view.

  4. Click the field that you want to change.

    A series of three buttons appear, giving you the choice of changing Data, Formatting, or Actions. To change the name, source, or value of the data field (which is called a control in Access web apps), click Data. If you want to add a ToolTip, hide or display the control, or add a caption, click Formatting. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required