- Creating a Custom Database Template
- Using a Custom Database Template
- Planning Tables
- Creating Tables in a Database
- Creating a Table by Entering Data
- Creating an Application Part Using a Template
- Importing Data into Tables
- Linking to Data in Tables
- Working with Table Records
- Working with a Table in Design View
- Specifying a Primary Key in Design View
- Planning Table Relationships
- Defining Table Relationships
- Creating and Printing a Table Relationship Report
- Ensuring Referential Integrity
- Identifying Object Dependencies
- Modifying Object Dependencies
Working with a Table in Design View
Most Access objects are displayed in Design view, which allows you to work with the underlying structure of your tables, queries, forms, and reports. To create a new table in Design view, you define the fields that will comprise the table before you enter any data. In Design view for tables, each row corresponds to a field. You can edit, insert, and delete fields in your database tables in Design view. You insert a field by adding a row, while you delete a field by removing a row. You can also change field order by dragging a row selector to a new position.
Create or Modify a Table in Design View
- Click the Create tab, and then click the Table Design button, or select the table you want to modify in the Navigation pane, and then click the Design View button.
- Click in a Field Name cell, and then type a modified field name.
- Click in a Data Type cell, click the Data Type list arrow, and then click a data type.
- Click in a Description cell, and then type a description. If the Property Update Options button appears, select an option, if necessary.
- To insert a field, click the row selector below where you want the field, and then click the Insert Rows button on the Ribbon.
- To delete a field, click the row selector for the field you want to delete, and then click the Delete Rows button on the Ribbon.
- Click the Save button on the Quick Access Toolbar, and then if necessary, enter a table name and click OK.
- When you’re done, click the Close button in the Table window.