You can enter data into records by either using a table’s Datasheet view or by using a form. When is it more appropriate to enter data using Datasheet view, and when is it more appropriate to enter data using a form?

What will be an ideal response?

You can enter data into records using a table’s Datasheet view or using a form that includes fields from one or more tables. Datasheet entry is efficient when you need to enter many records at the same time, especially if you routinely work with the same documents. You might also use a datasheet to quickly enter sample data for testing, especially in a table on the “one” side of a one-to-many relationship. The primary table must contain data before you can enter data in the related table, the one on the “many” side of the one-to-many relationship. However, most Access database applications use forms for data entry after the database is released for regular business use. Activities such as taking telephone orders or looking up product or customer information is more efficient and accurate with forms. For example, unlike tables, forms can include calculations so you can provide grand totals and list boxes so you can select correct items. You can also use forms to enhance the appearance of your data, making it easier to find the piece of information you need.