Starting in DesignView
Adding new fields to an existing Access database can be confusing. But, there are simple steps that you can take to make this process easier.
The first thing that you need to do is to open Access. Once the program is open, try following these procedures to add new fields to the database.
1. Hold the Shift key down. This will open Access without having any default forms.
2. Go into your database’s main window.
3. On the left-hand side of the screen, you will see a list of options for you to choose. Click Tables.
4. Right-click on the table name for your database. Select Design View.
In Design View, you can add additional fields to your database. But, you also need to add values to these fields. Before you start adding fields, you want to create a table with your needed list of assessors. Once you do this, you need to change your new field’s data type to Lookup Wizard.