Learn How to Add New Fields to An Existing Access Database - Microsoft Access Tutorials

Learn How to Add New Fields to An Existing Access Database - Microsoft Access Tutorials
Page content

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.

Adding Fields

After you have done these steps, Access will then give you an interface (similar to your Excel spreadsheet format), where you can create

AddingField2

and customize the tables that you need. To create your spreadsheet, which will create your table for you, you need to follow the below procedures.

  1. Create an AutoNumber field. Access will open up the ID field. Use this as the primary key for your table.
  2. Once this is created, you need to create more fields for the rest of your data. Double-click on the first cell in one of the columns.
  3. Here, type in the name that you wish to use for the field.
  4. Click Enter on your keyboard.
  5. Modify the field by going into the Ribbon and using either Data Type or Format.
  6. Repeat the previous process until you have all the fields that you need and your table is complete.
  7. Go to the Quick Access toolbar, and click Save.

User-Defined Fields

Once you have created your table, you need to name it. Another way to make a table is to go into the Create dropdown menu in the Access Ribbon, and select the Table icon. Before you go through the above steps, make sure that you have opened a blank database and renamed it.

If you need to run a query and want to add fields to it, you can also create user-defined fields. You can create a user-defined field by writing the code this way nameoffield:definition. Your definitions can be any of the following:

  • Calculations
  • Permanent Value
  • Parameter

The difference between a regular field created in a table and a user-defined field is that a user-defined field’s values cannot be edited when you go to run a query.

Adding Fields Using a Template

Another way to add fields to your database is by using a field template. The only problem with this method is that you will not be able to customize the field. But, if you can use one of the predefined fields, it will save you time.

  1. Open a table in the Datasheet view.
  2. Go to the Datasheet Tab.
  3. Go into Fields & Columns, and select New Field. The Field Templates pane will open up.
  4. Select the fields that you wish to use in the Field Templates pane.
  5. Select and drag these to your table.
  6. As the insertion line comes up, drop the fields where you would like them.

AddingField3

If you’re looking for additional tips and tricks, be sure to browse through the other Microsoft Access tutorials available here at Bright Hub.