Question

how to create table using data sheets view

Answer 1

If you create a new table in Datasheets review by double clicking the create table by entering Data Shortcut in the Database Window. You will open a blank data sheet with 10 generic field as you enter Data Access will do it's best to determine the appropriate Data Type for each field. You can help excess choose the correct Data Type by entering descriptive characters. For instance if you want to be sure to process your entry with your system's currency symbol such as the $ character. When entering percent values be sure to include the % symbol and Access will assign the number Data Type and percent format. The more information you enter with your data, the more complete your table will be.

Hope this is helpful !!!