Question

Write the steps about how the fields along with their datatypes based on the students table

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.

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.

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.