MS-Access / Getting Started

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.

[Previous] [Contents] [Next]

In this tutorial:

  1. Designing Web Tables
  2. Working with the Web
  3. Creating a New Web Database
  4. Creating a New Empty Web Database
  5. Creating Your First Simple Web Table by Entering Data
  6. Creating a Web Table Using Application Parts
  7. Using Data Type Parts
  8. Creating Web Tables in Datasheet View
  9. Choosing Web Field Names
  10. Understanding Web Field Data Types
  11. Setting Field Properties for Web Databases
  12. Creating Calculated Fields
  13. Defining Field Validation Rules for Web Databases
  14. Defining a Table Validation Rule for Web Databases
  15. Defining a Primary Key for Web Databases
  16. Understanding Other Web Table Properties
  17. Creating Lookup Fields in a Web Database
  18. Creating Relationships Using Lookup Fields
  19. Defining a Restrict Delete Relationship
  20. Defining a Cascade Delete Relationship
  21. Using the Web Compatibility Checker
  22. Analyzing the Web Compatibility Issues Table
  23. Preparing a Client Database for the Web