Table Datasheet View

Table Datasheet View is like using Microsoft Excel wherein data is entered in row and column format. Each row represents a single record of data. When you create a new table, a blank Table Datasheet view window appears. Table Datasheet View provides a spreadsheet with 20 columns and 30 rows. Each column has a column header or also known as column selector at the top of the column. The column header displays the name of the field that the column represents. The Default field names are Field1, Field2, and so on. Field names should describe the property that will be stored in the field (Last Name, Address, Phone, and so on.)