Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Creating a Table by Entering Data

Access allows you to display many of its objects in multiple viewing modes. Datasheet view displays the data in your tables, queries, forms, and reports. Design view displays options for designing your Access objects. You can create a new table in both views. When you create a table in Datasheet view, you enter data and Access creates the table as you type. Access determines the data type of each field based on the data you enter. The Click to Add column shows you where to add a new field. You can also paste data from Microsoft Excel tables into a new database and Access recognizes the data types.

Enter Data to Create a Table

  • yellow_1.jpg Click the Create tab.
  • yellow_2.jpg Click the Table button.
  • yellow_3.jpg Enter the data.

    Press Tab to move from field to field or click in a cell.

  • yellow_4.jpg To change a field name, click the Click to Add field name, type the new name, and then press Enter.
  • yellow_5.jpg Click the Save button on the Quick Access Toolbar.
  • yellow_6.jpg Type a table name.
  • yellow_7.jpg Click OK.
  • yellow_8.jpg To have Access set the primary key, click Yes.
  • yellow_9.jpg Click the Close button in the Table window.
  • + Share This
  • 🔖 Save To Your Account