Home > Articles

  • Print
  • + Share This
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 (New!). When you finish entering data, Access will prompt you for the name of the table you’ve just created.

Enter Data to Create a Table

yellow_circle_1.gif Click the Create tab.

yellow_circle_2.gif Click the Table button.

yellow_circle_3.gif Enter the data.

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

yellow_circle_4.gif To change a field name, double-click the field name, type the new name, and then press Enter.

yellow_circle_5.gif Click the Save button on the Quick Access Toolbar.

yellow_circle_6.gif Type a table name.

yellow_circle_7.gif Click OK.

yellow_circle_8.gif To have Access set the primary key, click Yes.

yellow_circle_9.gif Click the Close button in the Table window.

  • + Share This
  • 🔖 Save To Your Account