Question

what are the two ways of adding fields in datasheet view.?​

Answer 1

Answer:

Creating a table

A simple database, such as a contact list, might use only a single table. Many databases, however, use several tables. When you create a new database, you create a new file on your computer that acts as a container for all of the objects in your database, including your tables.

You can create a table by creating a new database, by inserting a table into an existing database, or by importing or linking to a table from another data source — such as a Microsoft Excel workbook, a Microsoft Word document, a text file, or another database. When you create a new, blank database, a new, empty table is automatically inserted for you. You can then enter data in the table to start defining your fields.

Top of Page

Create a new table in a new database

Click File > New, and then select Blank desktop database.

In the File Name box, type a file name for the new database.

To browse to a different location and save the database, click the folder icon.

Click Create.

The new database opens, and a new table named Table1 is created and opens in Datasheet view.

Top of Page

Create a new table in an existing database

Click File > Open, and click the database if it is listed under Recent. If not, select one of the browse options to locate the database.

In the Open dialog box, select the database that you want to open, and then click Open.

On the Create tab, in the Tables group, click Table.

A new table is inserted in the database and the table opens in Datasheet view.

Answer 2

Answer:

there are actually two kinds of adding fields

Explanation:

FIRST METHOD:-

1- Click the CLICK TO ADD field header

2- select a data type for that field from the drop = down list

3- Type the field heading title

SECOND METHOD:-

1- Click the column header to the right of which you want to add a field with the required data type

2- under table tools click the fields tab

3- select a data type for that field

4- type a field heading title for the new field

5- select the empty cell below the field model and type the text.