Use a desktop template

  1. Start Access and click any desktop template (they don't have the globe icon). If you have Access open, click File > New.

  2. Enter a name, choose another location for the database if you want to, click Create.

  3. In the yellow message bar, click Enable Content.

  4. If the template has videos, watch them or close that window.

  5. Enter data.

  6. Press Tab or the arrows, or use your mouse to move to another field. Moving saves your data.

Change a template

To change a drop-down list, right-click a field in the list (not a header), click Edit List Items, enter your new items, click OK.

Use an Access App template

  1. Start Access and click any app template (they have the globe icon). If you have Access open, click File > New.

  2. Enter a name, choose a server from the list, or enter a server name, click Create.

  3. Click Home > Launch App. The app opens in your browser.

  4. Enter data, and click Save when done.

Change an Access App

  1. In SharePoint 2013 or Microsoft 365, click Settings > Customize in Access > Open. The database opens in Access, and the ribbon shows only the tools you need.

  2. Change your database and save your changes. That publishes them to your server.

  3. Click Home > Launch App to resume using your database.

See also

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×