Question

what are the two ways to create a datasheet in ms access

Answer 1

When you create an Access database, you store your data in tables—subject-based lists that contain rows and columns. For instance, you can create a Contacts table to store a list of names, addresses, and telephone numbers, or a Products table to store information about products.

This article explains how to create a table, how to add fields to a table, and how to set a table's primary key. It also explains how to set field and table properties.

Because other database objects depend so heavily on tables, you should always start your design of a database by creating all of its tables and then creating any other objects. Before you create tables, carefully consider your requirements and determine all the tables that you need. For an introduction to planning and designing a database, see the article Database design basics.