Modifying Access tables is simple. Use these tips to modify tables in Access to suit your database's needs.
After working with your database, you might find that you need to make some changes to the tables that store your data. Access makes it easy to modify your tables to suit your database's needs.
In this lesson, you'll learn how to create and rearrange table fields. You'll also learn how to ensure your table data is correctly and consistently formatted by setting validation rules, character limits, and data types in your fields. Finally, we will direct you to additional options for performing simple math functions within your tables.
Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2016 sample database. You will need to have Access 2016 installed on your computer in order to open the example.
Watch the video below to learn more about modifying tables.
In addition to making basic modifications to your tables, like adding and moving fields, you can make more advanced modifications that let you set rules for your data. All of these changes can help make your tables even more useful.
Access makes it easy to rearrange existing fields and add new ones. When you add a new field, you can even set the data type, which dictates which type of data can be entered into that field.
There are several types of fields you can add to a table: