Creating Web Tables in Datasheet View

You could continue to use Data Type Parts and Application Parts to build web fields and other web tables. However, you'll find in most cases, you need to create your web schema from scratch to meet your specific application needs. Even if you're already very familiar with creating new client tables in Design View, you'll find it necessary to learn the mechanics of building a web table from scratch in Datasheet view because Design view is not available for web objects. You can only use Datasheet View to design web tables. By learning how to create web tables in Datasheet view, you can also use that knowledge to design client tables in Datasheet view.

To begin creating a new web table in Datasheet view, let's start with a new, empty web database. Click the Blank Web Database button on the New tab of the Backstage view, name your new web database Restaurant Database, and then click Create. Access 2010 displays a blank web Table window in Datasheet view.

When you work in Design view with client tables, the upper part of the Table Design window displays columns in which you can enter the field names, the data type for each field, and a description of each field. Access allows you to set various field properties in the lower-left section of the Table Design window. When you design web tables in Datasheet view, however, all your design elements are in the two contextual ribbon tabs-Fields and Table-under Table Tools.