Eventually in this course, you will learn how to import data from non-Access data sources, such as Word tables or Excel spreadsheets, into Access tables. In order to add data to an Access database you will need a table to hold the data. As you may recall from week 1, an Access database may contain multiple tables. At this point, the Restaurant database has only one table, called Customers. In Session 2.1, you will be creating a second table, the Orders table.
Access provides multiple techniques for creating tables.
You will be creating a table using the Design view which requires that you specify the information needed by Access to create the table structure . For each column, or field , in the table, you will need to define the Field Name, Data Type, Field Size, and possibly the Format properties for that field. Once you have defined a table's structure, you can enter records into the table. Session 2.1 instructs you to enter a few records into the Orders table. You will add more records in Session 2.2.