Home

How to Add Database Tables to an Access Web App

|
Updated:  
2016-03-26 07:19:53
|
From The Book:  
Access Forms and Reports For Dummies
Explore Book
Buy On Amazon

Access 2016 provides a handy list of table designs for you to choose from if you’re starting your web app from scratch. Here are the simple steps for adding a table:

  1. Click Table from the Create group on the Home tab of the Ribbon if necessary (you’ll be here by default after creating a new web app).

  2. Type a keyword in the search box that represents the type of data to go into your table.

    For example, type contacts for contact-related tables or order for customer- and order-related tables.

  3. Click search (the magnifying glass icon).

    Access displays a list of related tables.

    Access finds tables related to the keyword contacts.
    Access finds tables related to the keyword contacts.
  4. Select a table.

    Access creates the table. The table name appears down the left side of the screen.

Access web apps do not support the OLE Object, and Attachment data types that that Access desktop databases support.

About This Article

This article is from the book: 

About the book author:

Ken Cook built and manages a computer consulting business that has helped users for over 20 years. He's an expert at creating Microsoft Office and Access database solutions and teaches online Access courses.