In Access database tables and database fields are integral elements to pulling together relevant information. Learn how to use them here.
Now that we have a handle on what the database should look like, we need to work on setting up our tables and the fields within these tables.
In this lesson, we'll walk you through the steps of setting up a database in Access 2007. You'll be setting up tables according to the plan for our bookstore scenario. You'll also be setting up the fields for each table, including establishing what data types can be entered in a given field.