Home / MS-Access / Getting Started

Designing Web Tables

The process of defining web tables in a Microsoft Access 2010 web database (.accdb file) is similar to designing client tables in a desktop database. In general, you create the fields you need, assign properties to those fields, and create relationships between the tables. The differences in the process of table creation for web databases lie in the design surface options you can use and the available data types and properties for web fields.

In this tutorial, we will show you how to begin creating your first web application by starting with the tables.

In this tutorial:

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