• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Creating Your Database and Tables > Creating a Table in Design View

Creating a Table in Design View

You could continue to use the Table Wizard to build some of the other tables in the Contact Tracking database to mimic those in LawTrack Contacts. For example, you could use the Customers sample table from the Business samples to build the Companies table or the Products sample table to get a jump-start on the Products table you need. However, you’ll find it very useful to learn the mechanics of building a table from scratch, so now is a good time to explore Design view and learn how to build tables without using the Table Wizard. You’ll also see many additional features that you can use to customize the way your tables (and any queries, forms, or reports built on these tables) work.

To design a new table in a database, go to the Database window (shown in Figure 4-8). Click the Tables button under Objects, and then click the New button. Access shows you the New Table dialog box you saw in Figure 4-9. Select Design View and click OK. You can also double-click the Create table in Design view shortcut in the Database window. Access displays a blank Table window in Design view.

In Design view, the upper part of the Table window displays columns in which you can enter the field names, the data type for each field, and a description of each field. After you select a data type for a field, Access allows you to set field properties in the lower left area of the Table window. In the lower right area of the Table window is a box in which Access displays information about fields or properties. The contents of this box change as you move from one location to another within the Table window.

For details about data type values, see “Understanding Field Data Types” on page 102.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint