Sign in

Design tables for SharePoint

SharePoint makes it easier to distribute your databases

Web databases take some planning

As a final step in the design process, decide whether you'll publish your database to SharePoint. If you will, then your tables can't use some of the features that Access provides. For example, you can only use Datasheet view to create tables, not the table designer. In addition, the only types of relationships you can create are called Lookup Fields. That's a type of relationship that allows you to select the values that reside in one table from a list in another table.

Access imposes those limits because the publishing process converts your database to Dynamic HTML and ECMAScript, so you need to avoid creating any database components – Access calls them objects – that can't be converted into those languages.

So, as a final step in your plan, note whether you'll publish the database. It's a small detail, but it's critical. The Quick Reference Card has links to information about creating databases for use with SharePoint.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.