How to Edit a Database Table in Access 2016

By Laurie Ulrich Fuller, Ken Cook

When you open Access 2016, the workspace offers you a list of recently opened databases, along with templates you can use to start a new database. To open a database from the Recent Databases list, just point to it and click once.

If you remember where your database is stored, but it isn’t in the Recent list, use either of the following options to use the Open view:

1Click the File tab to the left of the Home tab, and choose Open Other Files from the list of commands.

Either way, the Open view appears onscreen.

2Alternatively, if you’ve just opened Access, click the Open Other Files link at the bottom of the left-hand panel.

By default, the Open view displays your most recently used databases.

3If the database isn’t displayed, click This PC in the series of Open commands.

This displays this view.

4When you find the database, open it by clicking its name.

The database file opens immediately.

If you don’t see your database listed in on the right-hand side of the workspace (after clicking This PC), click the Browse button instead. This opens a dialog box through which you can navigate to the folder that contains your database.

An introductory screen known as a switchboard (or perhaps — utilizing a feature introduced in Access 2010 — a Navigation form) may appear instead of the tabbed dialog box. Access is telling you that your database either contains some custom programming or was created by the Database Wizard. You probably have some special forms that help you interact with the information in your database.

5Within the All Access Objects list on the left side of the workspace, look for the table you want to open.

Each table has its own listing, accompanied by a table icon.

6Double-click the table you want to edit.

The table opens in Datasheet view, and you can begin your maintenance of the data. You can add or remove fields or change the names of your fields.