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 that 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 toward additional options for performing simple math functions within your tables.
We will be showing you how to modify tables with examples from our sample bakery database. If you would like to follow along, download our example and use it to follow the procedures demonstrated in this lesson.